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	`created_at`
Data type	Datetime

Description*

The description of the goal.

SQL name	`description`
Data type	String

Goal ID

The unique identifier of the goal.

SQL name	`goal_id`
Data type	String

Is archived*

Indicates whether or not the goal is archived.

SQL name	`is_archived`
Data type	Boolean

Key*

The key of the goal.

SQL name	`key`
Data type	String
Example value	TITAN-123456

Name*

The name of the goal.

SQL name	`name`
Data type	String

Owner ID

The unique identifier of the owner of the goal.

SQL name	`owner_id`
Data type	String
Foreign key	Links to a record in the `account` table in the schema for organization data.

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	`parent_goal_id`
Data type	String
Foreign key	Links to a record in the `goal` table.

Phase

The current phase of the goal.

SQL name	`phase`
Data type	String
Example values	pending in_progress done paused cancelled

Row refreshed at

The last refresh time (UTC time zone) for this record.

SQL name	`row_refreshed_at`
Data type	Datetime

Started at

The date and time (UTC time zone) when the goal started.

SQL name	`started_at`
Data type	Datetime

Status

The current status of the goal.

SQL name	`status`
Data type	String
Example values	on_track off_track at_risk

Target date type*

The type of target date for the goal.

SQL name	`target_date_type`
Data type	String
Example values	day month quarter

Targeted at*

The target date of the goal.

SQL name	`targeted_at`
Data type	Datetime

Type ID

The unique identifier for the type of goal.

SQL name	`type_id`
Data type	String
Foreign key	Links to a record in the `goal_type` table.

Workspace ID

An Atlassian identifier that maps data to a site in the workspace table

SQL name	`workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

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	`body`
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	`comment_id`
Data type	String

Created at

The date and time (UTC time zone) when the comment on the goal was created.

SQL name	`created_at`
Data type	Datetime

Created by

The unique identifier of the person who created the comment on the goal.

SQL name	`created_by`
Data type	String
Foreign key	Links to a record in the `account` table in the schema for organization data.

Goal ID

The unique identifier of the goal associated with the comment.

SQL name	`goal_id`
Data type	String
Foreign key	Links to a record in the `goal` table.

Row refreshed at

The last refresh time (UTC time zone) for this record.

SQL name	`row_refreshed_at`
Data type	Datetime

Updated at

The date and time (UTC time zone) when the comment was last updated.

SQL name	`updated_at`
Data type	Datetime

Workspace ID

An Atlassian identifier that maps data to a site in the workspace table

SQL name	`workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

Goal hierarchy

The goal_hierarchy table contains the hierarchical relationships across goals in your organization.

The table uses the following columns:

Associated goal ID

The unique identifier of the goal that’s hierarchically related to goal_id.

SQL name	`associated_goal_id`
Data type	String

Goal ID

The unique identifier of the goal at the bottom of the hierarchy. Note that it may not the be the bottommost goal in the overall hierarchy.

SQL name	`goal_id`
Data type	String

Level

The hierarchy level between associated_goal_id and goal_id.

SQL name	`level`
Data type	String
Example values	1 = one level above the goal 2 = two levels above the goal etc.

Topmost goal ID

The goal at the top of the hierarchy.

SQL name	`topmost_goal_id`
Data type	String

Workspace ID

An Atlassian identifier that maps data to a site in the workspace table

SQL name	`workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

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	`created_by`
Data type	String
Foreign key	Links to a record in the `account` table in the schema for organization data.

Current value*

The current value of the goal metric.

SQL name	`current_value`
Data type	String

Goal ID

The unique identifier of the goal associated with the goal metric.

SQL name	`goal_id`
Data type	String
Foreign key	Links to a record in the `goal` table.

Name*

The name of the goal metric.

SQL name	`name`
Data type	String

Row refreshed at

The last refresh time (UTC time zone) for this record.

SQL name	`row_refreshed_at`
Data type	Datetime

Start value*

The start value of the goal metric.

SQL name	`start_value`
Data type	String

Sub-type*

The secondary type of the goal metric.

SQL name	`sub_type`
Data type	String
Example value	For metrics of type “currency”: AUD EUR USD

SQL name

sub_type

Data type

String

Example value

For metrics of type “currency”:

Target value*

The target value of the goal metric.

SQL name	`target_value`
Data type	String

Type*

The type of goal metric.

SQL name	`type`
Data type	String
Example values	currency numeric percentage

Workspace ID

An Atlassian identifier that maps data to a site in the workspace table

SQL name	`workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

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	`goal_id`
Data type	String
Foreign key	Links to a record in the `goal` table.

Row refreshed at

The last refresh time (UTC time zone) for this record.

SQL name	`row_refreshed_at`
Data type	Datetime

Team ID

The unique identifier of the team.

SQL name	`team_id`
Data type	String
Foreign key	Links to a record in the `atlassian_team` table in the schema for organization data.

Workspace ID

An Atlassian identifier that maps data to a site in the workspace table

SQL name	`workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

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	`is_enabled`
Data type	Boolean

Name*

The name of the goal type.

SQL name	`name`
Data type	String

Row refreshed at

The last refresh time (UTC time zone) for this record.

SQL name	`row_refreshed_at`
Data type	Datetime

Type ID

The unique identifier of the goal type. Use this as the primary key for goal type data.

SQL name	`type_id`
Data type	String

Workspace ID

An Atlassian identifier that maps data to a site in the workspace table

SQL name	`workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

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	`created_at`
Data type	Datetime

Created by

The unique identifier of the person who created the goal update.

SQL name	`created_by`
Data type	String
Foreign key	Links to a record in the `account` table in the schema for organization data.

Goal ID

The unique identifier of the goal associated with the update.

SQL name	`goal_id`
Data type	String
Foreign key	Links to a record in the `goal` table.

Goal update ID

The unique identifier of the goal update. Use this as the primary key for goal update data.

SQL name	`goal_update_id`
Data type	String

Is missed update

Indicates whether or not the update was missed.

SQL name	`is_missed_update`
Data type	Boolean

New phase*

The goal’s phase after the update.

SQL name	`new_phase`
Data type	String
Example values	pending in_progress done paused cancelled

New score*

The goal’s score after the update.

SQL name	`new_score`
Data type	Number

New status*

The goal’s status after the update.

SQL name	`new_status`
Data type	String
Example values	on_track off_track at_risk

New target date at*

The goal’s target date after the update.

SQL name	`new_target_date_at`
Data type	Datetime

New targeted confidence*

The goal’s target date confidence after the update.

SQL name	`new_targeted_confidence`
Data type	Number

Old phase*

The goal’s phase before the update.

SQL name	`old_phase`
Data type	String
Example values	pending in_progress done paused cancelled

Old score*

The goal’s score before the update.

SQL name	`old_score`
Data type	Number

Old status*

The goal’s status after the update.

SQL name	`old_status`
Data type	String
Example values	on_track off_track at_risk

Old target date at*

The goal’s target date before the update.

SQL name	`old_target_date_at`
Data type	Datetime

Old targeted confidence*

The goal’s target date confidence before the update.

SQL name	`old_targeted_confidence`
Data type	Number

Row refreshed at

The last refresh time (UTC time zone) for this record.

SQL name	`row_refreshed_at`
Data type	Datetime

Summary*

The summary of the update.

SQL name	`summary`
Data type	String

Updated at

The date and time (UTC time zone) when the goal update was last updated.

SQL name	`updated_at`
Data type	Datetime

Updated by

The unique identifier of the person who last updated the goal update.

SQL name	`updated_by`
Data type	String
Foreign key	Links to a record in the `account` table in the schema for organization data.

Workspace ID

An Atlassian identifier that maps data to a site in the workspace table

SQL name	`workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

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	`body`
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	`comment_id`
Data type	String

Created at

The date and time (UTC time zone) when the comment on the goal update was created.

SQL name	`created_at`
Data type	Datetime

Created by

The unique identifier of the person who created the comment on the goal update.

SQL name	`created_by`
Data type	String
Foreign key	Links to a record in the `account` table in the schema for organization data.

Goal ID

The unique identifier of the goal associated with the comment on the goal update.

SQL name	`goal_id`
Data type	String
Foreign key	Links to a record in the `goal` table.

Goal update ID

The unique identifier of the goal update associated with the comment.

SQL name	`goal_update_id`
Data type	String
Foreign key	Links to a record in the `goal_update` table.

Row refreshed at

The last refresh time (UTC time zone) for this record.

SQL name	`row_refreshed_at`
Data type	Datetime

Updated at

The date and time (UTC time zone) when the comment on the goal update was last updated.

SQL name	`updated_at`
Data type	Datetime

Workspace ID

An Atlassian identifier that maps data to a site in the workspace table

SQL name	`workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

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	`created_at`
Data type	Datetime

Created by

The unique identifier of the person who created the update note.

SQL name	`created_by`
Data type	String
Foreign key	Links to a record in the `account` table in the schema for organization data.

Goal update ID

The unique identifier of the goal update that the note is associated with.

SQL name	`goal_update_id`
Data type	String
Foreign key	Links to a record in the `goal_update` table.

Is archived*

Indicates whether or not the goal is archived.

SQL name	`is_archived`
Data type	Boolean

Row refreshed at

The last refresh time (UTC time zone) for this record.

SQL name	`row_refreshed_at`
Data type	Datetime

Summary*

The summary of the update note.

SQL name	`summary`
Data type	String

Title*

The name of the update note.

SQL name	`title`
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	`update_note_id`
Data type	String

Workspace ID

An Atlassian identifier that maps data to a site in the workspace table

SQL name	`workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

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	`account_id`
Data type	String
Foreign key	Links to a record in the `account` table in the schema for organization data.

Goal ID

The unique identifier of the goal.

SQL name	`goal_id`
Data type	String
Foreign key	Links to a record in the `goal` table.

Row refreshed at

The last refresh time (UTC time zone) for this record.

SQL name	`row_refreshed_at`
Data type	Datetime

Workspace ID

An Atlassian identifier that maps data to a site in the workspace table

SQL name	`workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

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	`focus_area_id`
Data type	String
Foreign key	Links to a record in the `focus_area` table in the schema for Focus.

Focus workspace ID

An Atlassian identifier that maps to the Focus instance that the focus area belongs to.

SQL name	`focus_workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

Goal ID

The unique identifier of a goal.

SQL name	`goal_id`
Data type	String
Foreign key	Links to a record in the `goal` table in the schema for Goals.

Goal workspace ID

An Atlassian identifier that maps to the Goals instance that the goal belongs to.

SQL name	`goal_workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

Row refreshed at

The last refresh time (UTC time zone) for this record.

SQL name	`row_refreshed_at`
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	`updated_at`
Data type	Datetime

Workspace ID

An Atlassian identifier that maps data to a site in the workspace table

SQL name	`workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

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	`align_project_id`
Data type	String
Foreign key	Links to a record in the `align_project` table in the schema for Focus.

Align workspace ID

An Atlassian identifier that maps to the Align instance that the project belongs to.

SQL name	`align_workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

Goal ID

The unique identifier of a goal.

SQL name	`goal_id`
Data type	String
Foreign key	Links to a record in the `goal` table in the schema for Goals.

Goal workspace ID

An Atlassian identifier that maps to the Goals instance that the goal belongs to.

SQL name	`goal_workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

Row refreshed at

The last refresh time (UTC time zone) for this record.

SQL name	`row_refreshed_at`
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	`updated_at`
Data type	Datetime

Workspace ID

An Atlassian identifier that maps data to a site in the workspace table

SQL name	`workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

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	`goal_id`
Data type	String
Foreign key	Links to a record in the `goal` table in the schema for Goals.

Project ID

The unique identifier of an Atlassian project.

SQL name	`project_id`
Data type	String
Foreign key	Links to a record in the `atlassian_project` table in the schema for Atlassian Projects.

Row refreshed at

The last refresh time (UTC time zone) for this record.

SQL name	`row_refreshed_at`
Data type	Datetime

Workspace ID

An Atlassian identifier that maps data to a site in the workspace table

SQL name	`workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

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	`goal_id`
Data type	String
Foreign key	Links to a record in the `atlassian_project` table in the schema for Goals.

Goal workspace ID

An Atlassian identifier that maps to the Goals instance that the goal belongs to.

SQL name	`goal_workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

Jira workspace ID

An Atlassian identifier that maps to the Jira instance that the work item belongs to.

SQL name	`jira_workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

Row refreshed at

The last refresh time (UTC time zone) for this record.

SQL name	`row_refreshed_at`
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	`updated_at`
Data type	Datetime

Work item ID

The unique identifier of a work item.

SQL name	`issue_id`
Data type	String
Foreign key	Links to a record in the `jira_issue` table in the schema for Jira family of products.

Workspace ID

An Atlassian identifier that maps data to a site in the workspace table

SQL name	`workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

Was this helpful?

It wasn't accurateIt wasn't clearIt wasn't relevant

Still need help?

The Atlassian Community is here for you.

Ask the Community