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.

Workspace data

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_info table lists all your organization’s sites. It uses the following columns:

url (string)

The URL of the site—for example, https://example-site.atlassian.net

workspace_id (string)

An Atlassian identifier that maps data to a site. Use this as the primary key for workspace data.

Account data

The account table lists the managed accounts within your organization. It uses the following columns:

account_id (string)

The unique identifier of the Atlassian account. Use this as the primary key for account data.

email* (string)

The email address of the account holder—for example, charlie@atlassian.com

org_id (string)

The unique identifier of the account holder’s organization

name* (string)

The name of the account holder—for example, Charlie Atlas