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 support@alteryx.com for assistance.

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.

Error: "Failed to upload file" when trying to use the Snowflake Bulk feature in an Output data tool

gtorres8
Alteryx
Alteryx
Created

Issue


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.

 

Environment Details

 
  • Alteryx Designer
    • All version
  • Snowflake DSII ODBC Drivers
    • 2.21.07+
  • Simba Snowflake ODBC Drivers
    • 2.21.07+
  • Snowflake Native Bulk


Cause 1


A firewall-related issue prevented the bulk process to put the file in the local staging file system.
 

Cause 2


The proxy is blocking the traffic or we do not trust the certificate.

Resolution 1


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.
 

Resolution 2


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.


image.png


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:
 

no_proxy=.snowflakecomputing.com,.amazonaws.com



image.png



Note

 
  • 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.

 

Additional Resources

 
No ratings