Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hello,
Are you using the latest snowflake jdbc driver? Could you please clarify in which Talend version/edition you are?
Best regards
Sabrina