This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Now that it's live, don't forget to accept your certification badge on Credly today! Learn more here.
We are currently experiencing an issue with Email verification at this time and working towards a solution. Should you encounter this issue, please click on the "Send Verification Button" a second time and the request should go through. If the issue still persists for you, please email email@example.com for assistance.
on 01-19-202111:57 AM- edited
3 weeks ago
When running a workflow that uses the Snowflake Bulk write feature, the following error occurs:
Error: Output Data (1): Error message from ODBC connection: [Simba][Snowflake] (40)
Error encountered when executing file transfer: Failed to upload file C:\ProgramData\Alteryx\Engine\Engine_10140_b4da024b6e334f64a6e86eccfbcda45d_\ayx_local_staging_67bd9d15-f34b-41d5-828b-5dc9eeb6a51f\60ed901d-251e-408d-afef-3396aa7d1a15.csv.
Snowflake DSII ODBC Drivers
Simba Snowflake ODBC Drivers
Snowflake Native Bulk
A firewall-related issue prevented the bulk process to put the file in the local staging file system.
The proxy is blocking the traffic or we do not trust the certificate.
As a test, consult with a system administrator to temporarily disable the firewall to confirm if the Bulk completes. Work with IT to address the issue further.
1. In the Windows search bar, type "Internet Options". 2. Select Internet Options from the results list. 3. Click to open the Connections tab. 4. Click the LAN settings button.
5. Notice the Proxy server section. 6. The Proxy server address and port in use for HTTP/HTTPS traffic will be displayed. 7. Select the Advanced option under Proxy server. 8. Add the following variables to the Exceptions:
This will allow all sites ending in those two domains to not pass through the proxy which may be too "wide-open".
If your network blocks communication without the proxy, this will likely fail.
If your company uses PAC scripts (automatic configuration script option above proxy server), it will likely override the manual proxy server setting. In this instance, your IT department needs to set up the exception instead.