Solved

Query timed out after running transaformation

  • 21 April 2023
  • 6 replies
  • 45 views

Userlevel 2
Badge

Could you please suggest how to limit source?

icon

Best answer by Dilini Fernando 4 May 2023, 19:13

View original

6 replies

Userlevel 3

Hey Sonali, if you’re trying to run a preview, then there is a limit in the list:

When you run a transformation itself, there will not be that limit.

Userlevel 2
Badge

Here I want to run it for All…

If I run it for All its throwing an error.

Userlevel 3

That’s a limitation of the Preview mode, it’s only meant to give you a view of the data, and then you can run the transformation. But you can use transformation from RAW to RAW, then you will not be limited by 240 seconds, and you can inspect results in the separate RAW table after the completion of the transformation job.

Userlevel 2
Badge

Could you please brief on “how  one can use transformation from RAW to RAW”?

appreciate if any example shared.
It would be helpful :)

Userlevel 3

Sure, you can create a RAW table in Manage staged data menu, and then you can use that table as a target in your transformation:

You can change the target afterwards or create a separate transformation that will not be scheduled for debugging purposes.

Hope that answers your question.

Userlevel 4
Badge +2

Hi @Sonali Vishal Patil,

I hope you are able to help solve the issue. As of now, I will close this thread. Please let us know if you have any question. 

Best regards,
Dilini 

 

Reply