Solved

Truncate and Load to Snowflake

  • 14 February 2022
  • 5 replies
  • 682 views
poulose
Rank

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

icon

Best answer by poulose 15 February 2022, 13:54

View original

5 replies

R
Rank
Userlevel 2
Badge

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.

 

poulose
Rank

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

poulose
Rank

Hi,

I achieved this by using Start Event JDBC Query Executor.

 

Thanks a lot.

Regards,

Poulose

martin_gatto
Rank

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?

poulose
Rank

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
1. Change Start Event
2. JDBC Connection and Truncate tables
3.Additional JDBC Configurations

 

 

Reply


Terms & Conditions