Snowflake

Version:
2019.3
Last modified: September 26, 2019
Driver Configuration Requirements

For In-database processing, and to avoid errors when writing data with the Output Data Tool, you must specify a Warehouse, Schema, and Database in the driver.

Driver Details

    
The ODBC driver can be downloaded from Snowflake.

Snowflake Bulk write support is available for standard workflows. Bulk write support is available for in-database workflows.

In-Database processing requires 64-bit database drivers.

Type of Support

Read & Write; In-Database

Validated On

Database version 2.2.1
ODBC client version 2.13.06.00

Alteryx tools used to connect

Standard workflow processing

In-database workflow processing

Link
Blue icon with database being plugged in.

Connect In-DB Tool

Link
Blue icon with a stream-like object flowing into a database.

Data Stream In Tool

Configure an ODBC connection

Configure an ODBC connection

  1. In the ODBC Data Source Administrator, select the Snowflake driver and click Configure.
  2. Enter your Connection Settings and credentials.
  3. In Additional Options, select Retrieve Entire Results Into Memory.
  4. Click OK to save the connection.

To fully support the reading and writing of camel case tables and columns, you must set the Alteryx Designer Table/Fieldname SQL style option to quoted.

Configure a Snowflake Bulk connection for writing data

Review the following before configuring a Snowflake Bulk connection.

  • You can only write data with the Snowflake Bulk loader.
  • After writing data to the new output, the Snowflake Bulk loader removes the written data from the S3 bucket.
  • Currently, Snowflake Bulk can only write data in CSV format.

Configure a Snowflake Bulk connection for writing data

  1. From the Output Data - Configuration window, click Write to File or Database and select Other Databases > Snowflake Bulk to display the Snowflake Bulk Connection window.
  2. Select a Data Source Name, or click ODBC Admin to create one. See ODBC and OLEDB Database Connections.
  3. Enter a User Name and Password, as necessary.
  4. In Amazon S3, enter your AWS Access Key and your AWS Secret Key.
  5. From Secret Key Encryption, select an encryption option:
    • Hide: Hides the password using minimal encryption.
    • Encrypt for Machine: Any user on the computer has full access to the connection.
    • Encrypt for User: The logged in user can has full access to the connection on any computer.
  6. From Endpoint, select one of the following options:
    • Default: Amazon determines the endpoint based on the selected bucket.
    • Specific endpoint: To specify an S3 region in which the bucket reside, specify a custom endpoint or select from previously entered endpoints.
      • The S3 bucket must be in the specified S3 region. Otherwise, the following error displays: The bucket you are attempting to access must be addressed using the specified endpoint. Please send all future requests to this endpoint.
      • Click Default to close the error window.
  7. (Optional) Select Use Signature V4 for Authentication to increase security beyond the default Signature Version 2. This option is automatically enabled for regions requiring Signature Version 4.
    • Regions created after January 30, 2014 support only Signature Version 4. The following regions require Signature Version 4 authentication:
      • US East (Ohio) Region
      • Canada (Central) Region
      • Asia Pacific (Mumbai) Region
      • Asia Pacific (Seoul) Region
      • EU (Frankfurt) Region
      • EU (London) Region
      • China (Beijing) Region
  8. Select a Server-Side Encryption method for uploading to an encrypted Amazon S3 bucket. See Amazon Simple Storage Service Developer Guide.
    • None (Default): An encryption method is not used.
    • SSE-KMS: Use server-side encryption with AWS KMS-managed keys. You can also provide a KMS Key ID. When you select this method, Use Signature V4 for Authentication is enabled by default.
  9. Enter the Bucket Name of the AWS bucket in which the data objects are stored.
  10. Configure additional file format Options in the Output data - Configuration window. See File Format Options.
Was This Helpful?

Need something else? Visit the Alteryx Community or contact support.