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 |
Table for group data
Atlassian 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 |
Org ID
The unique identifier of the Atlassian organization that contains the group.
SQL name | org_id |
|---|---|
Data type | String |
Was this helpful?