Schema for Goals
Goals in Atlassian represents the outcomes that multiple projects or streams of work contribute to. Read more about goals.
If you add Goals data to an Atlassian Data Lake connection, you can query data from the following tables:
Columns with an asterisk (*) are only available when you include all data for your app in a Data Lake connection. Read more about how to set the scope of data for Atlassian Data Lake connections.
Goal
The goal
table lists all your goals from the Goals app.
The table uses the following columns:
Created at
The date and time (UTC time zone) when the goal was created.
SQL name |
|
---|---|
Data type | Datetime |
Description*
The description of the goal.
SQL name |
|
---|---|
Data type | String |
Goal ID
The unique identifier of the goal.
SQL name |
|
---|---|
Data type | String |
Is archived*
Indicates whether or not the goal is archived.
SQL name |
|
---|---|
Data type | Boolean |
Key*
The key of the goal.
SQL name |
|
---|---|
Data type | String |
Example value | TITAN-123456 |
Name*
The name of the goal.
SQL name |
|
---|---|
Data type | String |
Owner ID
The unique identifier of the owner of the goal.
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Parent goal ID
The unique identifier of the parent goal. If this column is not null, then the goal is a sub-goal.
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Row refreshed at
The last refresh time (UTC time zone) for this record.
SQL name |
|
---|---|
Data type | Datetime |
Started at
The date and time (UTC time zone) when the goal started.
SQL name |
|
---|---|
Data type | Datetime |
Target date type*
The type of target date for the goal.
SQL name |
|
---|---|
Data type | String |
Example values |
|
Targeted at*
The target date of the goal.
SQL name |
|
---|---|
Data type | Datetime |
Type ID
The unique identifier for the type of goal.
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Workspace ID
An Atlassian identifier that maps data to a site in the workspace
table
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Goal comment
The goal_comment
table lists all the comments made to goals.
The table uses the following columns:
Body*
The text of the comment.
SQL name |
|
---|---|
Data type | String |
Comment ID
The unique identifier of the comment of the goal. Use this as the primary key for goal comment data.
SQL name |
|
---|---|
Data type | String |
Created at
The date and time (UTC time zone) when the comment on the goal was created.
SQL name |
|
---|---|
Data type | Datetime |
Created by
The unique identifier of the person who created the comment on the goal.
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Goal ID
The unique identifier of the goal associated with the comment.
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Row refreshed at
The last refresh time (UTC time zone) for this record.
SQL name |
|
---|---|
Data type | Datetime |
Updated at
The date and time (UTC time zone) when the comment was last updated.
SQL name |
|
---|---|
Data type | Datetime |
Workspace ID
An Atlassian identifier that maps data to a site in the workspace
table
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Goal metric (latest)
The goal_metric_latest
table contains the latest information on goal metrics.
The table uses the following columns:
Created by
The unique identifier of the person who created the goal metric.
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Current value*
The current value of the goal metric.
SQL name |
|
---|---|
Data type | String |
Goal ID
The unique identifier of the goal associated with the goal metric.
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Name*
The name of the goal metric.
SQL name |
|
---|---|
Data type | String |
Row refreshed at
The last refresh time (UTC time zone) for this record.
SQL name |
|
---|---|
Data type | Datetime |
Start value*
The start value of the goal metric.
SQL name |
|
---|---|
Data type | String |
Sub-type*
The secondary type of the goal metric.
SQL name |
|
---|---|
Data type | String |
Example value | For metrics of type “currency”:
|
Target value*
The target value of the goal metric.
SQL name |
|
---|---|
Data type | String |
Type*
The type of goal metric.
SQL name |
|
---|---|
Data type | String |
Example values |
|
Workspace ID
An Atlassian identifier that maps data to a site in the workspace
table
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Goal team mapping
The goal_team_mapping
table holds associations between goals and teams.
The table uses the following columns:
Goal ID
The unique identifier of the goal.
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Row refreshed at
The last refresh time (UTC time zone) for this record.
SQL name |
|
---|---|
Data type | Datetime |
Team ID
The unique identifier of the team.
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Workspace ID
An Atlassian identifier that maps data to a site in the workspace
table
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Goal type
The goal_type
table lists all the goal types.
The table uses the following columns:
Is enabled*
Indicates whether or not the goal type is enabled.
SQL name |
|
---|---|
Data type | Boolean |
Name*
The name of the goal type.
SQL name |
|
---|---|
Data type | String |
Row refreshed at
The last refresh time (UTC time zone) for this record.
SQL name |
|
---|---|
Data type | Datetime |
Type ID
The unique identifier of the goal type. Use this as the primary key for goal type data.
SQL name |
|
---|---|
Data type | String |
Workspace ID
An Atlassian identifier that maps data to a site in the workspace
table
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Goal update
The goal_update
table lists the updates made to each goal.
The table uses the following columns:
Created at
The date and time (UTC time zone) when the goal update was created.
SQL name |
|
---|---|
Data type | Datetime |
Created by
The unique identifier of the person who created the goal update.
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Goal ID
The unique identifier of the goal associated with the update.
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Goal update ID
The unique identifier of the goal update. Use this as the primary key for goal update data.
SQL name |
|
---|---|
Data type | String |
Is missed update
Indicates whether or not the update was missed.
SQL name |
|
---|---|
Data type | Boolean |
New phase*
The goal’s phase after the update.
SQL name |
|
---|---|
Data type | String |
Example values |
|
New score*
The goal’s score after the update.
SQL name |
|
---|---|
Data type | Number |
New status*
The goal’s status after the update.
SQL name |
|
---|---|
Data type | String |
Example values |
|
New target date at*
The goal’s target date after the update.
SQL name |
|
---|---|
Data type | Datetime |
New targeted confidence*
The goal’s target date confidence after the update.
SQL name |
|
---|---|
Data type | Number |
Old phase*
The goal’s phase before the update.
SQL name |
|
---|---|
Data type | String |
Example values |
|
Old score*
The goal’s score before the update.
SQL name |
|
---|---|
Data type | Number |
Old status*
The goal’s status after the update.
SQL name |
|
---|---|
Data type | String |
Example values |
|
Old target date at*
The goal’s target date before the update.
SQL name |
|
---|---|
Data type | Datetime |
Old targeted confidence*
The goal’s target date confidence before the update.
SQL name |
|
---|---|
Data type | Number |
Row refreshed at
The last refresh time (UTC time zone) for this record.
SQL name |
|
---|---|
Data type | Datetime |
Summary*
The summary of the update.
SQL name |
|
---|---|
Data type | String |
Updated at
The date and time (UTC time zone) when the goal update was last updated.
SQL name |
|
---|---|
Data type | Datetime |
Updated by
The unique identifier of the person who last updated the goal update.
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Workspace ID
An Atlassian identifier that maps data to a site in the workspace
table
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Goal update comment
The goal_update_comment
table lists the comments made to goal updates.
The table uses the following columns:
Body*
The text of the comment.
SQL name |
|
---|---|
Data type | String |
Comment ID
The unique identifier of the comment on the goal update. Use this as the primary key for comments on goal updates.
SQL name |
|
---|---|
Data type | String |
Created at
The date and time (UTC time zone) when the comment on the goal update was created.
SQL name |
|
---|---|
Data type | Datetime |
Created by
The unique identifier of the person who created the comment on the goal update.
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Goal ID
The unique identifier of the goal associated with the comment on the goal update.
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Goal update ID
The unique identifier of the goal update associated with the comment.
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Row refreshed at
The last refresh time (UTC time zone) for this record.
SQL name |
|
---|---|
Data type | Datetime |
Updated at
The date and time (UTC time zone) when the comment on the goal update was last updated.
SQL name |
|
---|---|
Data type | Datetime |
Workspace ID
An Atlassian identifier that maps data to a site in the workspace
table
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Goal update note
The goal_update_note
table lists the notes attached to goal updates.
The table uses the following columns:
Created at
The date and time (UTC time zone) when the update note was created.
SQL name |
|
---|---|
Data type | Datetime |
Created by
The unique identifier of the person who created the update note.
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Goal update ID
The unique identifier of the goal update that the note is associated with.
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Is archived*
Indicates whether or not the goal is archived.
SQL name |
|
---|---|
Data type | Boolean |
Row refreshed at
The last refresh time (UTC time zone) for this record.
SQL name |
|
---|---|
Data type | Datetime |
Summary*
The summary of the update note.
SQL name |
|
---|---|
Data type | String |
Title*
The name of the update note.
SQL name |
|
---|---|
Data type | String |
Update note ID
The unique identifier of the update note. Use this as the primary key for update note data.
SQL name |
|
---|---|
Data type | String |
Workspace ID
An Atlassian identifier that maps data to a site in the workspace
table
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Goal watcher mapping
The goal_watcher_mapping
table holds associations between goals and watchers.
The table uses the following columns:
Account ID
The unique identifier of the person watching the goal.
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Goal ID
The unique identifier of the goal.
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Row refreshed at
The last refresh time (UTC time zone) for this record.
SQL name |
|
---|---|
Data type | Datetime |
Workspace ID
An Atlassian identifier that maps data to a site in the workspace
table
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Tables for relationships across apps
These tables help to connect data from this schema to data from other app schemas in the Atlassian Data Lake. You can query these tables if at least one of the apps is included in the Data Lake connection. However, if both apps aren’t included, the relevant tables won’t have data.
Focus area Goal mapping
The focus_area_goal_mapping
table holds associations between focus areas from Focus and goals from the Goals app.
The table uses the following columns:
Focus area ID
The unique identifier of a focus area.
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Focus workspace ID
An Atlassian identifier that maps to the Focus instance that the focus area belongs to.
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Goal ID
The unique identifier of a goal.
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Goal workspace ID
An Atlassian identifier that maps to the Goals instance that the goal belongs to.
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Row refreshed at
The last refresh time (UTC time zone) for this record.
SQL name |
|
---|---|
Data type | Datetime |
Updated at
The date and time (UTC time zone) when the association between the focus area and the goal was last updated.
SQL name |
|
---|---|
Data type | Datetime |
Workspace ID
An Atlassian identifier that maps data to a site in the workspace
table
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Goal Align project mapping
The goal_align_project_mapping
table holds associations between goals from the Goals app and Align projects.
The table uses the following columns:
Align project ID
The unique identifier of an Align project.
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Align workspace ID
An Atlassian identifier that maps to the Align instance that the project belongs to.
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Goal ID
The unique identifier of a goal.
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Goal workspace ID
An Atlassian identifier that maps to the Goals instance that the goal belongs to.
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Row refreshed at
The last refresh time (UTC time zone) for this record.
SQL name |
|
---|---|
Data type | Datetime |
Updated at
The date and time (UTC time zone) when the association between the goal and the Align project was last updated.
SQL name |
|
---|---|
Data type | Datetime |
Workspace ID
An Atlassian identifier that maps data to a site in the workspace
table
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Goal Atlassian project mapping
The goal_atlassian_project_mapping
table holds associations between goals from the Goals app and Atlassian projects.
The table uses the following columns:
Goal ID
The unique identifier of a goal.
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Project ID
The unique identifier of an Atlassian project.
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Row refreshed at
The last refresh time (UTC time zone) for this record.
SQL name |
|
---|---|
Data type | Datetime |
Workspace ID
An Atlassian identifier that maps data to a site in the workspace
table
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Goal Jira work item mapping
The goal_jira_issue_mapping
table holds associations between goals from the Goals app and Jira work items.
The table uses the following columns:
Goal ID
The unique identifier of a goal.
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Goal workspace ID
An Atlassian identifier that maps to the Goals instance that the goal belongs to.
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Jira workspace ID
An Atlassian identifier that maps to the Jira instance that the work item belongs to.
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Row refreshed at
The last refresh time (UTC time zone) for this record.
SQL name |
|
---|---|
Data type | Datetime |
Updated at
The date and time (UTC time zone) when the association between the goal and the Jira work item was last updated.
SQL name |
|
---|---|
Data type | Datetime |
Work item ID
The unique identifier of a work item.
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Workspace ID
An Atlassian identifier that maps data to a site in the workspace
table
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Was this helpful?