Schema for organization data

Data for your groups, teams, user accounts, and workspaces are available in the Atlassian Data Lake. Merge this data with your app data to get richer insights into your app usage.

Columns with an asterisk (*) are only available when you include all data for your app in a Data Lake connection. Read more about how to set the scope of data for Atlassian Data Lake connections.

Table for account data

Account

The account table lists the Atlassian 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

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
Example values	`charlie@atlassian.com`

Is managed

Indicates if the account is managed by the account holder’s organization.

SQL name	`is_managed`
Data type	Boolean

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 group data

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

Organization ID

The unique identifier of the Atlassian organization that contains the group.

SQL name	`org_id`
Data type	String

Row refreshed at

The last refresh time (UTC time zone) for this record.

SQL name	`row_refreshed_at`
Data type	Datetime

Tables for team data

Team

The atlassian_team table lists the Atlassian teams within your organization.

Description

A description of the team.

SQL name	`description`
Data type	String

SQL name	`directory`
Data type	String

External reference group ID

The group ARI from where the team is managed.

SQL name	`external_reference_group_id`
Data type	String

External reference HRIS organization ID

The HRIS organization ARI from where the team is managed.

SQL name	`external_reference_HRIS_org_id`
Data type	String

Membership setting

The membership setting of the team.

SQL name	`membership_setting`
Data type	String
Example values	MEMBER_INVITE OPEN

Name

The name of the team.

SQL name	`name`
Data type	String

Organization ID

The unique identifier of the Atlassian organization that contains the team.

SQL name	`org_id`
Data type	String

Row refreshed at

The last refresh time (UTC time zone) for this record.

SQL name	`row_refreshed_at`
Data type	Datetime

Scope mode

The scope mode of the team, which can be either organization or site-scoped.

SQL name	`scope_mode`
Data type	String
Example values	ORG_SCOPE_MODE SITE_SCOPE_MODE

Status

The status of the team.

SQL name	`status`
Data type	String
Example values	ACTIVE DISBANDED

Team ID

The unique identifier of the team. Use this as the primary key for the table.

SQL name	`team_id`
Data type	String

Team type ID

The unique identifier of the team type

SQL name	`team_type_id`
Data type	String
Foreign key	Links to a record in the `atlassian_team_type` table.

Team member

The atlassian_team_member table lists the Atlassian team members that belong to each Atlassian team.

Account ID

The unique identifier of the Atlassian account of the member.

SQL name	`account_id`
Data type	String
Foreign key	Links to a record in the `account` table.

Organization ID

The unique identifier of the organization the team member is part of.

SQL name	`org_id`
Data type	String

Role

The role of the member.

SQL name	`role`
Data type	String
Example values	ADMIN = The creator of the team REGULAR

Row refreshed at

The last refresh time (UTC time zone) for this record.

SQL name	`row_refreshed_at`
Data type	Datetime

Status

The status of the member.

SQL name	`status`
Data type	String
Example values	FULL_MEMBER = The default state of the member after they join the team INVITED = The legacy state where the member was invited to an organization. REQUESTING_TO_JOIN = For invite-only teams; the state when they have requested to join the team.

Team ID

The unique identifier of the team in which the member belongs to.

SQL name	`team_id`
Data type	String
Foreign key	Links to a record in the `atlassian_team` table.

Team member ID

The unique identifier of the member. Use this as the primary key for the table.

SQL name	`team_member_id`
Data type	String

Workspace ID

An Atlassian identifier that maps data to a site in the workspace table.

SQL name	`workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table.

Team type

The atlassian_team_type table lists the team types within your organization.

Default type

Determines the default behavior and categorization of teams of this type.

SQL name	`default_type`
Data type	String

Description

The description of the team type.

SQL name	`description`
Data type	String

Directory ID

The identifier of the directory within which the team type is available.

SQL name	`directory_id`
Data type	String

Is verified

Determines whether the type is a verified type or not.

SQL name	`is_verified`
Data type	Boolean

Name

The name of the team type.

SQL name	`name`
Data type	String

Organization ID

The unique identifier of the Atlassian organization that contains the team type.

SQL name	`organization_id`
Data type	String

Row refreshed at

The last refresh time (UTC time zone) for this record.

SQL name	`row_refreshed_at`
Data type	Datetime

Team type ID

The unique identifier of the team type. Use this as the primary key for team type data.

SQL name	`team_type_id`
Data type	String

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?

It wasn't accurateIt wasn't clearIt wasn't relevant

Still need help?

The Atlassian Community is here for you.

Ask the Community