Truncate and Load to Snowflake

Hi @poulose,

Could you please check whether Start Event - Snowflake will be helpful to your use-case?

Before starting the pipeline, you can truncate the table using Start Event and after that you can use the actual pipeline for loading the data.

Hi Ranjith,

Thank you for the response. I forgot to mention that we are using Data Collector version 3.22.x. I believe Snowflake Executor is not available for this version. Can you please confirm if this can be achieved using JDBC Query executer? If yes, how do we configure the connection to snowflake using JDBC Query Executor.

Regards,

Poulose

Did the stage jdbc query with snowflake work for you? Could you share how to configure it?

Hi Martin,

Please find the screenshots for the configurations. Let me know if this works for you

1. Select JDBC Query under start event, by default this will be Discard(Library: Basic)
2. Add the JDBC details and Truncate table statements
3. Included additional JDBC Configurations