Skip to main content
Solved

Query timed out after running transaformation


Forum|alt.badge.img

Could you please suggest how to limit source?

Best answer by Dilini Fernando

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 

 

View original
Did this topic help you find an answer to your question?

6 replies

roman.chesnokov
Seasoned Practitioner

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.


Forum|alt.badge.img

Here I want to run it for All…

If I run it for All its throwing an error.


roman.chesnokov
Seasoned Practitioner

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.


Forum|alt.badge.img

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

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


roman.chesnokov
Seasoned Practitioner

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.


Dilini Fernando
Seasoned Practitioner
Forum|alt.badge.img+2
  • Seasoned Practitioner
  • 670 replies
  • Answer
  • May 4, 2023

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


Cookie Policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings