Jira data base

[sirine]

Hey Atlassian Team, 

I'm dumping our Jira cloud DB and I want to get the Stories in our project that have link with critical bugs but unfortunately I can not find any table that contains this information: Link between a story and a bug.

Can someone help me please? I will be very grateful

Thanks in advance 

[Nic Brough -Adaptavist-]

Welcome to the Atlassian Community!

You do not have any access to the Cloud database, so I suspect you mean you are looking at a Server/DC system that is running on cloud "hardware" (like AWS, GCP, or Azure for example)

My advice is to stop doing that.  The database is a complex mess, built to be a datastore, not a database, and certainly not to do any form of reporting.

There are currently three different ways to link issues in Jira DC (four if you really are on Cloud), so you'll want to start by looking at how you are doing these links - is it issue links, epic/story, story/sub-task, or "parent"? 

(Parent is a cloud option at present, server will be adopting the nomenclature for Epic at some point in the future, as will the company-managed projects in Cloud soon)

[sirine]

Thank you for welcoming me.

as I said , I HAVE ACCESS to OUR JIRA CLOUD DB

I understand your concerns BUT I'm not changing or updating anything , just selecting a count so no harm on that . anyways this is not the subject. 

Do you know if there is a table that I can use to have the link between a story and a bug? 

[Nic Brough -Adaptavist-]

I am sorry, but, no, you do not.  Only Atlassian can see the Atlassian Cloud database.

I've already explained what I think you mean in the original answer.

And I can't answer the question until you can tell us what type of link you are talking about, as they're done and stored differently.

[sirine]

Sorry, Even I think this is not related to my question but  I don't know why you are insisting that I do not have access to Jira cloud DB although I said that I have at least to a replicate so I can select from the DB anything. to explain it a bit better, we are using snowflake .

It doesn't matter anyway. the only thing that matters for me is finding the right table. To give you more context: I'm looking on having the link story/bug witch mean issue/issue (is this the type of link that you are asking for?). Unfortunately, I did not find any table that contain this info, although I can select it with the JQL query.

May be I'm missing the big picture.

[Nic Brough -Adaptavist-]

Yes, you are missing the big picture.  You do not know what you are looking at.

You are looking at a database that isn't even a Jira one.  You have no access to an Atlassian-Cloud Jira database, so you're not replicating anything from an Atlassian Cloud Jira (because you can't). 

If it's a Jira server or DC installation, then you're not replicating from the server/DC database - Jira does not work with a snowflake database.  The best you can do is have some process that is extracting data from the MySQL, PostGresql, Oracle or MS-SQL database the Jira is running on, and pushing it into Snowflake, in which case, you are going to need to talk to the people who set that up to find out if they are doing direct copies of tables, or are transforming it in some way.