Get started with Atlassian Analytics
Learn how to add Atlassian Analytics to a site and understand what you need to query data and create charts.
Schema for organization data
Workspace data and user account data 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 managed 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 |
Email*
The email address of the account holder.
SQL name | |
|---|---|
Data type | String |
Example values | charlie@atlassian.com |
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 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?