Jira data base

Question

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- · Answer

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.

sirine · Answer

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- · Answer

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.