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; } } }

Join data from a third party source

piotr.x.zyrek

Hi guys,

I was able to connect a third-party data source (azure sql db) to improve our analyses. However, I came across an obstacle. When I want to join data from the data lake with data from the third-party source it is not possible because I have to select from the dropdown which data source I want to query.

Can you advise on how to join tables from two different sources?

Accepted answers

Kevin Minnick

Hi @piotr.x.zyrek

You will need to add a second query and then do the join after the first and second queries complete. See this help document: https://support.atlassian.com/analytics/docs/merge-queries/

All comments

Kevin Minnick

Hi @piotr.x.zyrek

You will need to add a second query and then do the join after the first and second queries complete. See this help document: https://support.atlassian.com/analytics/docs/merge-queries/

piotr.x.zyrek

Indeed, thanks!

Does the custom table query allow CTEs (nested queries) in the code?

I'm getting the "Your data source returned: Incorrect syntax near the keyword 'with'" error

The same query worked fine when creating the table however I cannot run any queries on this later on.

Kevin Minnick

Yes, it should work. Feel free to start a support ticket to get help on the details.