Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Snowflake components error: File could not be uploaded to remote stage after retrying 6 times

I'm attempting to move data within Snowflake from a tSnowflakeInput to tSnowflakeOutput component. As of 3/26, this job was working perfectly. However, since then I'm getting the below error on ALL Snowflake jobs:

 

Caused by: net.snowflake.client.loader.Loader$ConnectionError: File could not be uploaded to remote stage after retrying 6 times: C:\Users\btaylor\AppData\Local\Temp\snowflake\stage\DIM_BUSINESS_UNIT\UPSERT\20190410_080103_928_FPXB6Q_1\stream_20190410_080103_9280.gz
at net.snowflake.client.loader.FileUploader.run(FileUploader.java:73)
at java.lang.Thread.run(Thread.java:748)

 

When I check the history in Snowflake, I see queries like so:

PUT 'file://C:\\Users\\btaylor\\AppData\\Local\\Temp\\snowflake\\stage\\DIM_BUSINESS_UNIT\\UPSERT\\20190410_080103_928_FPXB6Q_1\\stream_20190410_080103_9280.gz' '@~/DIM_BUSINESS_UNIT/UPSERT/20190410_080103_928_FPXB6Q_1' parallel=10 overwrite=true auto_compress=false SOURCE_COMPRESSION=gzip

 

So I know Talend is communicating with Snowflake, but for whatever reason it cannot upload the files.

 

I see that Snowflake updated their JDBC driver on 3/26, so I assume this is part of the issue. However, when I update the .jar file to the latest JDBC driver, I still get this error. Any help would be appreciated.

Labels (6)
1 Reply
Anonymous
Not applicable
Author

Hello,

Are you using the latest snowflake jdbc driver? Could you please clarify in which Talend version/edition you are?

Best regards

Sabrina