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.
Data share schema for organization data
Data for your user accounts are available in the Atlassian Data Lake. Merge this data with your product data to get richer insights into your product usage.
Table for account data
Atlassian account
The atlassian_account table holds information for each Atlassian account in your organization.
The table contains 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 |
|
The email address of the account holder.
SQL name | |
|---|---|
Data type | String |
Is managed
Indicates if the account is managed by the account holder’s organization.
SQL name | is_managed |
|---|---|
Data type | Boolean |
Name
The name of the account holder.
SQL name | name |
|---|---|
Data type | String |
Org ID
The unique identifier of the account holder’s organization.
SQL name | org_id |
|---|---|
Data type | String |
Was this helpful?
Still need help?
The Atlassian Community is here for you.