Schema for organization data
Data for your groups, teams, user accounts, and workspaces are available in the Atlassian Data Lake. Merge this data with your product data to get richer insights into your product usage.
Columns with an asterisk (*) are only available when you include all data for your products in a Data Lake connection. Learn more about how to set the scope of data for Atlassian Data Lake connections.
Table for account data
Account
The account table lists the Atlassian accounts within your organization.
The table uses the following columns:
Account ID
The unique identifier of the Atlassian account. Use this as the primary key for account data.
SQL name | account_id |
---|---|
Data type | String |
Account status
The status of the account.
SQL name | account_status |
---|---|
Data type | String |
Example values |
|
Email*
The email address of the account holder.
SQL name | |
---|---|
Data type | String |
Example values | charlie@atlassian.com |
Is managed
Indicates if the account is managed by the account holder’s organization.
SQL name | is_managed |
---|---|
Data type | Boolean |
Organization ID
The unique identifier of the account holder’s organization.
SQL name | org_id |
---|---|
Data type | String |
Name*
The name of the account holder.
SQL name | name |
---|---|
Data type | String |
Example value | Charlie Atlas |
Table for group data
Group
The atlassian_group table lists the Atlassian groups within your organization.
Group ID
The unique identifier of the group. Use this as the primary key for the table.
SQL name | group_id |
---|---|
Data type | String |
Name
The name of the group.
SQL name | name |
---|---|
Data type | String |
Organization ID
The unique identifier of the Atlassian organization that contains the group.
SQL name | org_id |
---|---|
Data type | String |
Row refreshed at
The last refresh time (UTC time zone) for this record.
SQL name | row_refreshed_at |
---|---|
Data type | Datetime |
Tables for team data
Team
The atlassian_team table lists the Atlassian teams within your organization.
Description
A description of the team.
SQL name | description |
---|---|
Data type | String |
Membership setting
The membership setting of the team.
SQL name | membership_setting |
---|---|
Data type | String |
Example values |
|
Name
The name of the team.
SQL name | name |
---|---|
Data type | String |
Organization ID
The unique identifier of the Atlassian organization that contains the team.
SQL name | org_id |
---|---|
Data type | String |
Row refreshed at
The last refresh time (UTC time zone) for this record.
SQL name | row_refreshed_at |
---|---|
Data type | Datetime |
Scope mode
The scope mode of the team, which can be either organization or site-scoped.
SQL name | scope_mode |
---|---|
Data type | String |
Example values |
|
Status
The status of the team.
SQL name | status |
---|---|
Data type | String |
Example values |
|
Team ID
The unique identifier of the team. Use this as the primary key for the table.
SQL name | team_id |
---|---|
Data type | String |
Team member
The atlassian_team_member table lists the Atlassian team members that belong to each Atlassian team.
Account ID
The unique identifier of the Atlassian account of the member.
SQL name | account_id |
---|---|
Data type | String |
Foreign key | Links to a record in the account table. |
Organization ID
The unique identifier of the organization the team member is part of.
SQL name | org_id |
---|---|
Data type | String |
Role
The role of the member.
SQL name | role |
---|---|
Data type | String |
Example values |
|
Row refreshed at
The last refresh time (UTC time zone) for this record.
SQL name | row_refreshed_at |
---|---|
Data type | Datetime |
Status
The status of the member.
SQL name | status |
---|---|
Data type | String |
Example values |
|
Team ID
The unique identifier of the team in which the member belongs to.
SQL name | team_id |
---|---|
Data type | String |
Foreign key | Links to a record in the atlassian_team table. |
Team member ID
The unique identifier of the member. Use this as the primary key for the table.
SQL name | team_member_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. |
Table for workspace data
Workspace
All tables in the schema have a workspace_id column. If you have multiple instances of Jira Cloud in your organization, you can use this column to distinguish between them.
The workspace table lists all your organization’s sites.
The table uses the following columns:
URL
The URL of the site.
SQL name | url |
---|---|
Data type | String |
Example value | https://example-site.atlassian.net |
Workspace ID
An Atlassian identifier that maps data to a site. Use this as the primary key for workspace data.
SQL name | workspace_id |
---|---|
Data type | String |
Was this helpful?