Can we join join Datafactory and Azure Synapse tables for KQL in log Analytics?

Question

Hello Team,
We have requirement that customer want to join Data factory and Azure Synapse table in for KQL in Log Analytics, for example we have ADFActivityRun table and SynapseSQLpoolSqlRequest table, is it possible to join these two tables and get the results.
I have the attached screen images of data factory and Azure synapse.

Answer 1

Hello @Harish Kumar ,

Welcome to the MS Q&A platform.

If your synapse and ADF are connected to the same log analytics workspace, then you can join ADFActivityRun table and SynapseSQLpoolSqlRequest table on common columns.

Please make sure to query from the log analytics solution. If you try to use either synapse or ADF logs directly, you won't see all tables from there.

I hope this helps.

In the below screenshot, you can see the common columns between these two tables.

ex: querying from ADF, you won't see SynapseSQLpoolSqlRequest table.

------------------------------

• Please don't forget to click on and upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
• If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators