What are the ways to check which query is running in a transformation?

Hi @praveen.ojha12 ,

You should see in the transformations section a column called Enabled, if there's a yes then it's running. You can activate or disable transformations at your liking. From the Data Job then in logs you can see which transformations ran.

Hello @1460067637 ,

I don't mean that.

Let me explain myself with a scenario-

Let's say I have a transformation named "Test", and there are many queries inside the transformation as shown in the screenshot below:

Now if I execute this transformation, I will see below execution log:

But say if we have queries that go on for a long time. Then how to know which query is running from execution log.

Hi @praveen.ojha12 ,

Now I understand, there's no way as far as i know to know which exact query is running from the log.

If you have problems tho with a specific transformation you can run singular query into the transformations and see which one is taking long by selecting the query and running it with CTRL+ENTER.