Schema for Atlassian Projects
Atlassian projects help bring work into one place and provide just the right amount of context so that anyone at your company can understand what is being worked on, why it is happening, who is responsible for it, and how it is going. Read more about Atlassian projects.
If you add Atlassian Projects 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.
Project
The atlassian_project
table holds the latest information about Atlassian projects. Read more about Projects.
The table uses the following columns:
Created at
The date and time (UTC time zone) when the project was created.
SQL name |
|
---|---|
Data type | Datetime |
Is archived*
Indicates whether or not the project is archived.
SQL name |
|
---|---|
Data type | Boolean |
Key*
The key of the project.
SQL name |
|
---|---|
Data type | String |
Example value | GLOBE-1234 |
Name*
The name of the project.
SQL name |
|
---|---|
Data type | String |
Owner ID
The unique identifier of the owner of the project.
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Phase*
The state of the project.
SQL name |
|
---|---|
Data type | String |
Example values |
|
Project ID
The unique identifier of the project. Use this as the primary key for project data.
SQL name |
|
---|---|
Data type | String |
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 project started.
SQL name |
|
---|---|
Data type | Datetime |
Status*
The status of the project.
SQL name |
|
---|---|
Data type | String |
Example values |
|
Target date type*
The confidence of the target date.
SQL name |
|
---|---|
Data type | String |
Example values |
|
Targeted at*
The date and time (UTC time zone) of the project’s target date.
SQL name |
|
---|---|
Data type | Datetime |
The measurement*
Describes how the success of the project will be measured. It corresponds to the “What will success look like?” field in the “About” tab of the project.
SQL name |
|
---|---|
Data type | String |
The what*
Describes what’s being done in the project. It corresponds to the “What are we doing” field in the “About” tab of the project.
SQL name |
|
---|---|
Data type | String |
The why*
Describes why the project exists. It corresponds to the “Why are we doing it?” field in the “About” tab of the project.
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 |
Project comment
The atlassian_project_comment
table contains information about the comments on Atlassian projects.
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 project.
SQL name |
|
---|---|
Data type | String |
Created at
The date and time (UTC time zone) when the comment was created.
SQL name |
|
---|---|
Data type | Datetime |
Created by
The unique identifier of the person who created the comment.
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Project ID
The unique identifier of the project that the comment was made 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 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 |
Project member mapping
The atlassian_project_member_mapping
table holds associations between projects and members who are contributing to the project.
The table uses the following columns:
Account ID
The unique identifier of the project member.
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Project ID
The unique identifier of the 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 |
Project milestone
The atlassian_project_milestone
table contains the latest information on the specific milestones of an Atlassian project.
The table uses the following columns:
Completed at*
The date and time (UTC time zone) when the milestone was completed.
SQL name |
|
---|---|
Data type | Datetime |
Completed in project update ID
The unique identifier of the project update in which the milestone was completed.
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Created at
The date and time (UTC time zone) when the milestone was created.
SQL name |
|
---|---|
Data type | Datetime |
Milestone ID
The unique identifier of the milestone. Use this as the primary key for project milestone data.
SQL name |
|
---|---|
Data type | String |
Project ID
The unique identifier of the project associated with the milestone.
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 |
Status*
The status of the milestone.
SQL name |
|
---|---|
Data type | String |
Example values |
|
Target date type*
The confidence of the target date of the milestone.
SQL name |
|
---|---|
Data type | String |
Example values |
|
Targeted at*
The date and time (UTC time zone) that the milestone is targeted to be completed.
SQL name |
|
---|---|
Data type | Datetime |
Title*
The title of the milestone.
SQL name |
|
---|---|
Data type | String |
Updated at
The date and time (UTC time zone) when the milestone 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 |
Project related project
The atlassian_project_related_project
table contains information about the Atlassian projects that are related to a particular Atlassian project.
The table uses the following columns:
Created at
The date and time (UTC time zone) when the relationship between the projects was created.
SQL name |
|
---|---|
Data type | Datetime |
Project ID
The unique identifier of the project.
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Related project ID
The unique identifier of the related project.
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Relationship type*
The type of relationships between the two projects.
SQL name |
|
---|---|
Data type | String |
Example values |
|
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 |
Project team mapping
The atlassian_project_team_mapping
table holds associations between projects and teams that are contributing to the project.
The table uses the following columns:
Project ID
The unique identifier of the 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 |
Team ID
The unique identifier of the team contributing to the project.
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 |
Project update
The atlassian_project_update
table contains information about updates to Atlassian projects.
The table uses the following columns:
Created at
The date and time (UTC time zone) when the updated was created.
SQL name |
|
---|---|
Data type | Datetime |
Created by
The unique identifier of the person who created the update.
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Is missed update
Indicates whether or not the update was missed.
SQL name |
|
---|---|
Data type | Boolean |
New phase*
The state of the project after the update.
SQL name |
|
---|---|
Data type | String |
Example values |
|
New status*
The status of the project after the update.
SQL name |
|
---|---|
Data type | String |
Example values |
|
New targeted at*
The date and time (UTC time zone) of the target date of the project after the update.
SQL name |
|
---|---|
Data type | Datetime |
New targeted confidence*
The confidence of the target date after the update.
SQL name |
|
---|---|
Data type | Number |
Old phase*
The state of the project before the update.
SQL name |
|
---|---|
Data type | String |
Example values |
|
Old status*
The status of the project before the update.
SQL name |
|
---|---|
Data type | String |
Example values |
|
Old targeted at*
The date and time (UTC time zone) of the target date of the project before the update.
SQL name |
|
---|---|
Data type | Datetime |
Old targeted confidence*
The confidence of the target date before the update.
SQL name |
|
---|---|
Data type | String |
Project ID
The unique identifier of the project associated with the update.
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Project update ID
The unique identifier of the project update. Use this as the primary key for project update data.
SQL name |
|
---|---|
Data type | String |
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 update was last edited.
SQL name |
|
---|---|
Data type | Datetime |
Updated by
The unique identifier of the person who last edited the 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 |
Project update comment
The atlassian_project_update_comment
table contains information about comments made to project 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. Use this as the primary key for project update comment data.
SQL name |
|
---|---|
Data type | String |
Created at
The date and time (UTC time zone) when the comment was created.
SQL name |
|
---|---|
Data type | Datetime |
Created by
The unique identifier of the person who created the comment.
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Project ID
The unique identifier of the project that the comment is part of.
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Project update ID
The unique identifier of the project update that the comment was made 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 comment was last edited.
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 |
Project update note
The atlassian_project_update_note
table contains information about notes attached to project updates.
The table uses the following columns:
Created at
The date and time (UTC time zone) when the note was created.
SQL name |
|
---|---|
Data type | Datetime |
Created by
The unique identifier of the person who created the note.
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Is archived*
Indicates whether or not the project associated with the update note is archived.
SQL name |
|
---|---|
Data type | Boolean |
Project update ID
The unique identifier of the project update associated with the note.
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 |
Summary*
The text 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 |
Project watcher mapping
The atlassian_project_watcher_mapping
table holds associations between projects and people watching those projects.
The table uses the following columns:
Account ID
The unique identifier of the person watching the project.
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Project ID
The unique identifier of the 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 |
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.
Atlassian project Jira work item mapping
The atlassian_project_jira_issue_mapping
table holds associations between Atlassian projects and Jira work items.
The table uses the following columns:
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 |
Project ID
The unique identifier of an Atlassian project.
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Project workspace ID
An Atlassian identifier that maps to the Atlassian Projects instance that the project 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 Atlassian project 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 |
Focus area Atlassian project mapping
The focus_area_atlassian_project_mapping
table holds associations between focus areas from the Focus app and Atlassian projects.
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 |
Project ID
The unique identifier of an Atlassian project.
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Project workspace ID
An Atlassian identifier that maps to the Atlassian Projects instance that the project 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 Atlassian 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 |
Was this helpful?