Query timed out after running transaformation

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.

Here I want to run it for All…

If I run it for All its throwing an error.

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.

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

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

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.