Data share schema for organization data

Data for your user accounts are available in the Atlassian Data Lake. Merge this data with your app data to get richer insights into your app 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

Tables for teams data

Team

The atlassian_team table contains information about your Atlassian teams.

Description

The description of the team.

SQL name	`description`
Data type	String

Is verified

Indicates whether or not the team is verified.

SQL name	`is_verified`
Data type	Boolean

Membership setting

The member setting of the team, which defines whether a team is open or invite-only.

SQL name	`member_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

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 team data.

SQL name	`team_id`
Data type	String

Team member

The atlassian_team_member table contains information about the Atlassian team members that belong to each team.

Account ID

The unique identifier of the Atlassian account of the team member.

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

Organization ID

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

SQL name	`org_id`
Data type	String

Role

The role of the team member.

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

Status

The status of the team 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 that the team 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 team member. Use this as the primary key for team member data.

SQL name	`team_membber_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