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

Anonymous — Sat, 16 Nov 2024 06:06:11 GMT

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.

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

Anonymous — Fri, 12 Apr 2019 09:43:17 GMT

Hello,

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

Best regards

Sabrina

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

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

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