community Alteryx IO Alteryx.com
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Knowledge Base

Definitive answers from Designer Desktop experts.

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

gtorres8
Alteryx Alumni (Retired)
Created

on ‎01-19-2021 11:57 AM - edited on ‎09-29-2021 02:39 PM by Alteryx

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

 
Contributors
Labels