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?

[Kevin Minnick · Accepted solution]

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.