nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Is there a way to bring in parent field or epic link into the datalake?

Luis Crespo

Trying to display the parent field or epic link as a column into my chart but cannot see this as part of my schema.

Accepted answers

Talar Pavlovic

Hey there Luis,

Thanks for writing into the Atlassian Analytics Community, I'm Talar from the Atlassian team, happy to help.

There absolutely is - let me direct you over to our how-to guide here: https://confluence.atlassian.com/analyticskb/query-parent-and-child-issues-from-jira-1206787653.html

Regards,
Talar

All comments

Talar Pavlovic

Hey there Luis,

Thanks for writing into the Atlassian Analytics Community, I'm Talar from the Atlassian team, happy to help.

There absolutely is - let me direct you over to our how-to guide here: https://confluence.atlassian.com/analyticskb/query-parent-and-child-issues-from-jira-1206787653.html

Regards,
Talar

David Green_sfve2e

Talar I followed the above instructions for linking parent and child but I have a issue with the first query. Namely that i can get a PARENT value for stories to Epics but I cannot get one for Epics to Initiatives. I have added the Initiative Project into my Projects drop down filter, and the initiative shows up in my SQL results, and the Epic I'm trying to find a parent for has a parent Initiative in JIRA, so where is that link stored in the Enterprise Data Lake?

Here's my SQL...

SELECT `Issue`.`issue_key` AS `Issue key`,

`Issue field`.`name` AS `Issue field Name`,

`Issue field`.`value` AS `Value`,

`Project`.`name` AS `Project Name`,

`Issue`.`issue_type` AS `Issue type`

FROM `jira_project` AS `Project`

INNER JOIN `jira_issue` AS `Issue`

ON `Issue`.`project_id` = `Project`.`project_id`

LEFT JOIN `jira_issue_field` AS `Issue field`

ON `Issue field`.`issue_id` = `Issue`.`issue_id`

-- AND (`Issue field`.`name` = 'Parent')

WHERE {PROJECT_ID.IN('`Project`.`project_id`')}

AND {ISSUE_TYPE.IN('`Issue`.`issue_type`')}

AND `Issue`.`issue_key` = 'APPGG-999'

ORDER BY `Issue field`.`name` ASC

LIMIT 100000;

Note that if I test this on a story I DO get the Epic parent value.

David Green_sfve2e

actually I just found this - https://support.atlassian.com/jira-software-cloud/docs/upcoming-changes-epic-link-replaced-with-parent/

When will this be done?

Talar Pavlovic

Hey there David,

What you're seeing would be expected - we don’t support parent hierarchy data above Epics just yet, but there should be an update posted in Community in the next week or so on this.

Regards,
Talar

David Green_sfve2e

OK so I managed to get the desired result but there was a lot of jiggery-pokery. I ran it all past ChatGPT and he/she/they/them couldn't help either. We are stymied on a couple of things. The main one being unable to create temporary tables (which solves the problem of non-recursive CTEs).

Is there a reason why we can't CREATE anything in Spark SQL in Analytics?

Talar Pavlovic

Hey David,

Yes indeed - CREATE is one of the restricted SQL commands in Analytics. Take a look here to see the others: https://support.atlassian.com/analytics/docs/restricted-sql-commands/

Regards,
Talar

David Green_sfve2e

OK I can understand the need to prevent users from creating objects and other things in Analytics that would damage the integrity of the data structures and/or the data, but unfortunately that limits the usability of the SQL because we can't use the CREATE TEMPORARY TABLE command, which would be very handy (and also can help with performance.

Although I note that Spark SQL doesn't allow INSERT INTO so that limits the use of temporary tables somewhat.

Is there a way we can run a python script against the Data Lake so I can do something like the following? -

from pyspark.sql import SparkSession # Initialize Spark session spark = SparkSession.builder.appName("RecursiveExample").getOrCreate() # Register the DataFrame as a temporary view initial_df = spark.createDataFrame([("your_target_issue_key",)], ["Issue_key"]) initial_df.createOrReplaceTempView("InitialView")