Skip to main content

Qlik Replicate

Discussion board for collaboration on Qlik Replicate.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
brunnovb_in
Partner - Creator
Partner - Creator

Qlik Replicate - Target Snowflake - Keep files in internal stage in Snowflake

Hello,

I'm using Qlik Replicate to replicate data to Snowflake. I was seeing the queries made by Qlik Replicate on History Tab on Snowflake and I'd like to know if it is possible to keep files in internal stage in Snowflake?

 

The default behavior is putting file and execute a remove command. Is it possible to change this?

 

Step 1

brunnovb_in_0-1659702502695.png

Step 2

....

brunnovb_in_1-1659702517172.png

 

Thanks,

Brunno.

 

Labels (2)
2 Solutions

Accepted Solutions
SwathiPulagam
Support
Support

Hi @brunnovb_in ,

 

You can keep CSV files in the Replicate server using the internal parameter "keepCSVFiles" on the Snowflake Target endpoint.

 There is no way you can keep the CSV files on Snowflake staging because the same staging will be used by Replicate many times so it gets dropped and created.

 

Thanks,

Swathi

View solution in original post

lyka
Support
Support

Hello,

 

There's an option to keep the csv files in Replicate Server if you want to do it that way.

 

Add the internal parameter called keepCSVFiles  on the target endpoint 

 

Thanks

Lyka

View solution in original post

3 Replies
SwathiPulagam
Support
Support

Hi @brunnovb_in ,

 

You can keep CSV files in the Replicate server using the internal parameter "keepCSVFiles" on the Snowflake Target endpoint.

 There is no way you can keep the CSV files on Snowflake staging because the same staging will be used by Replicate many times so it gets dropped and created.

 

Thanks,

Swathi

lyka
Support
Support

Hello,

 

There's an option to keep the csv files in Replicate Server if you want to do it that way.

 

Add the internal parameter called keepCSVFiles  on the target endpoint 

 

Thanks

Lyka

brunnovb_in
Partner - Creator
Partner - Creator
Author

Hello!

Perfect! I appreciate that.

 

Best,

Brunno.