• Products
  • Documentation
  • Resources

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

  • active

  • inactive

  • closed

Email

The email address of the account holder.

SQL name

email

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

Still need help?

The Atlassian Community is here for you.