Skip to main content

If a transformation has many Insert statement in the table. How can we know which insert query is running in the execution log if the transformation is running as a job.

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:

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

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


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:

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

imageBut 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.


Reply