Use data shares to read or export your data from the Atlassian Data Lake

Hi, Atlassian Analytics community!

After an insightful early access program, we’re pleased to announce that our data shares feature is now generally available in Atlassian Analytics. Data shares will enable your organization to read or export your data from the Atlassian Data Lake into your own environments or third-party tools — one of our most highly requested features.

How to get started

Organization admins can create a data share by doing the following:

  1. Select Data from the global navigation.

  2. Select Data shares from the left sidebar.

  3. Select Create data share.

I’ve also recorded a demo video to walk you through how to set up a data share in Atlassian Analytics:

Read our documentation for more details about data shares.

 

Things to note

  • At this time, you can only access Jira data and account data through data shares.

  • The schema for Data Lake connections in Analytics and data shares are different. More about the schema for data shares.

Thank you to our EAP participants

Special shout-out to those who joined our early access program, tested data shares, and provided feedback. We couldn’t have gotten here without you. 🥳

Tell us what you think

We’re excited for you to start using data shares. Leave a comment below or contact support if you have any questions, concerns, or feedback.

 

8 comments

Kevin Paugam
Contributor
June 13, 2024

Hello,

this is great that table "'jira_issue_enhanced_table" was added to the data share.

However, we found that field "Labels" was not available in any of the tables provided through the data share.

Any idea how we could get this field in our external BI tool?

Tracy Chow
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
June 17, 2024

@Kevin Paugam The "labels" column is not currently available in the `jira_issue_enhanced_table` table, but you can query the data from the `jira_issue_field` table.

More details can be found on this suggestion ticket: https://jira.atlassian.com/browse/ANALYTICS-254

Like Abderrahmane Dahani likes this
Dwight Thompson July 23, 2024

It looks like the Team field (customfield_11401) is not available in data shares, is that correct?

I should clarify: The field is there in the "jira_issue_field" table. I can find instances of customfield_11401 within the "field_id" column of that table. But in the same rows, the "value" column has the IDs of the teams, not the names of the teams. I don't know where, or if, the team names are stored anywhere within the data share schema. I can't find them anywhere.

Tracy Chow
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
July 25, 2024

Hi @Dwight Thompson, is the Team field you're using the Atlassian Team field? https://support.atlassian.com/atlassian-account/docs/using-atlassian-teams-in-jira-projects/ 

The data for team names is not available for data shares yet. I have created a feature request on your behalf here: https://jira.atlassian.com/browse/ANALYTICS-290 

Like Dwight Thompson likes this
gomesp5
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
August 5, 2024

Hi, thank for your presentation. Could you demonstrate the conection from jira data lake to power bi?. I can´t to realize this issues.

 

Thank

Tracy Chow
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
August 5, 2024

Hi @gomesp5, after you've created your data share credentials from Atlassian Analytics, you can follow the steps outlined here: https://learn.microsoft.com/en-us/power-query/connectors/delta-sharing to connect it to Power BI using the Delta Sharing connector.

If you have any trouble, feel free to contact our support team.

Ram Rajamani
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
October 29, 2024

@Tracy Chow   can you send the steps for Tableau to connect to Data Lake.  Assuming that we have to create data share credentials and then do something.   Ask is for Tableau to connect to data lake in Production and refresh daily at regular intervals.  Please advise on the steps.  Thanks

 

Tracy Chow
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
October 30, 2024

@Ram Rajamani Here is the documentation for connecting your data share to Tableau with their Delta Sharing connector: https://exchange.tableau.com/en-us/products/1019. Note you have to be on version Tableau 2024.1 and later.

Comment

Log in or Sign up to comment
TAGS
AUG Leaders

Atlassian Community Events