Hi,
I have a requirement to do a truncate and load from SQL Server data base into Snowflake. How can we achieve this.
Regards,
Poulose
Best answer by poulose
View originalHi,
I have a requirement to do a truncate and load from SQL Server data base into Snowflake. How can we achieve this.
Regards,
Poulose
Best answer by poulose
View originalHi
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
Hi,
I achieved this by using Start Event JDBC Query Executor.
Thanks a lot.
Regards,
Poulose
Did the stage jdbc query with snowflake work for you? Could you share how to configure it?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.