Snowflake Integration Guides
Help articles related to integrating with Snowflake. The Snowflake connector is two-way: read data in with a SQL statement on a Snowflake warehouse, transform it in Nexadata, and write the results back to a Snowflake table. Connect with OAuth, as a person who signs in, or with Key-pair, as a dedicated service user.
Articles
Section titled “Articles”- Setting up a Snowflake Connection: Choose OAuth or Key-pair, run the one-time SQL your Snowflake admin needs, and create the connection in Nexadata.
- Using a Snowflake Connection: Create Datasets from a SQL statement, and write Workflow outputs back to Snowflake tables with Append, Upsert, or Overwrite.
- Use Case: Round Trip Between Snowflake and Nexadata: Read a planning fact table from Snowflake, run it through a Workflow, write it back, and confirm the totals tie to the cent.
- Troubleshooting the Snowflake Connector: Resolve common connection, authorization, Dataset, and write-back errors.