Alteryx Designer Knowledge Base

Definitive answers from Designer experts.

Snowflake Local Bulk loader error using Internal Named Stage: Unknown exception thrown by FileTransferAgent


Environment Details

User is getting an error when writing to Snowflake using the local bulk loader option with the Internal Named Stage selected:
Output Data (4) Error message from ODBC connection: [Snowflake][Snowflake] (40) ¶      Error encountered when executing file transfer: Unknown exception thrown by FileTransferAgent.¶
  • Alteryx Designer
    • Version 2020.3 + 
  • Snowflake ODBC connection


There was an error with the Named Stage.


Make sure the Named Stage is configured correctly in Snowflake and referenced correctly in the Bulk Connection configuration in Alteryx. The name must match. 

You can use the SHOW STAGES command in the Snowflake console to see available stages. Check the type column to make sure this is an INTERNAL stage.
No ratings