Snowflake
| Type of Support: | Read & Write; In-Database |
| Validated On: | Database version 2.2.1 ODBC client version 2.13.06.00 |
| Connection Type: | ODBC (32- and 64-bit) |
| 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. |
| 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. |
Alteryx tools used to connect
- Input Data Tool and Output Data Tool (Standard workflow processing)
- Connect In-DB Tool and Data Stream In Tool (In-database workflow processing)
Additional Details
Configure an ODBC connection
- In the ODBC Data Source Administrator, select the Snowflake driver and click Configure.
- Enter your Connection Settings and credentials.
- In Additional Options, select Retrieve Entire Results Into Memory.
- Click OK to save the connection.
Note
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
Considerations
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.
- 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.
- Select a Data Source Name, or click ODBC Admin to create one. See ODBC and OLEDB Database Connections.
- Enter a User Name and Password, as necessary.
- In Amazon S3, enter your AWS Access Key and your AWS Secret Key.
- 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.
- From Endpoint, select one of the following options:Default
Amazon determines the endpoint based on the selected bucket.
Specific endpointTo 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.
- (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 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
- 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.
- Enter the Bucket Name of the AWS bucket in which the data objects are stored.
- Configure additional file format Options in the Output data - Configuration window. See File Format Options.