Snowflake is a cloud-based data warehouse storage technology with automatic usage-based scaling of compute and storage resources. Additionally, Snowflake offers multi-cloud compatibility, allowing for greater flexibility in data management across different platforms.
Snowflake Storage is only available on the Premium Tier
The following functionality is currently supported when using Snowflake storage:
- ODX using Azure Data Lake Storage with SAS authentication
- Data Warehouse Tables in Simple Mode with Data Extraction set to Full Load
Create a Snowflake Database
- Log into the snowflake portal app.snowflake.com, click your name> Switch Role > select the SYSADMIN role
- Click Data > Databases
- Click + Database
- Give your Database a name and click Create
Get Snowflake Instance Details
Log into the snowflake portal app.snowflake.com
Find the Snowflake Account Identifier
- The Snowflake Account Identifier should look like this: <OrganzationID>-<AccountID>
- To find the Account Identifier in the snowflake portal click
- Admin >
- Accounts >
- Next to your account ID, click the link
- Copy the subdomain of the URL, the portion between “https://” and the first “.”
Find the Snowflake Warehouse Name
- Admin > Warehouses
- Copy the name of the Warehouse you wish to use
Configure Data Warehouse Instance Storage
- In the Server Storage Type, Select Snowflake
- Enter your Account Identifier
- Enter your Warehouse Name
- Enter your Database Name
- Enter your Port (Default is 443)
- Enter Username: Created when you signed up for Snowflake
- Enter Password: Created when you signed up for Snowflake
- Connection Timeout: number of seconds to wait before terminating the attempt to connect to the server. Set it to 0 to wait indefinitely
- Command Timeout: number of seconds to wait before terminating a command. Set it to 0 to wait indefinitely
Configure SAS token for ODX ADLS storage
- In the Azure Portal portal.azure.com> go to your ADLS resource, go to Shared access signature
- Check mark Service, Container and Object boxes
- Specify an expiry date
- Generate & Copy the SAS token
- Go to TimeXtender portal > Data estate > instances > Edit ODX instance > Azure Data Lake Storage
- Enter the full SAS token in the Azure SAS Token box
Connecting to Tabular, Tableau and Power BI Endpoints from a Snowflake MDW
- Download and install the Snowflake ODBC driver https://developers.snowflake.com/odbc/
- Open the ODBC Data Source Administrator Application and go to the System DSN tab
- Press Add and select SnowflakeDSIIDriver. Click Finish.
- In the Snowflake Configuration Dialog, provide a name for the data source, and enter the user and password that were created when you signed up for Snowflake. Specify the database, schema, warehouse and set Tracing to 0. Click Test to ensure the connection to the data source is successful. Press OK.
- Select the MDW instance with Snowflake storage in the TimeXtender Portal in order to edit its details.
- Type the Data Source name, that was entered into the Snowflake Configuration Dialog, into the DSN field. Press Save to confirm.
- If using the Power BI endpoint, the ODBC Data source credentials must also be updated. After deploying the Power BI endpoint within TimeXtender Desktop. Navigate to the dataset in app.powerbi.com, and click on the three dots, and select Settings.
- Expand the gateway connection menu and press the action button.
- Click Add to gateway on the ODBC data source.
- Provide a name for the gateway and the data source. Select basic authentication method and enter the Snowflake username and password. Press Create.
- Expand the Gateway connection again and map the ODBC connection. Click Apply.
Unable to Connect
Error: Snowflake Internal Error: Unable to connect
Cause: The account name is incorrect.
Solution: Edit your Data Warehouse instance in TimeXtender Portal to review and correct the account name, as described above.
Failed to authenticate request
Error: Server failed to authenticate the request
Cause: Snowflake is unable to access the ODX Storage
Solution: Verify you using Azure Data Lake ODX Storage and the SAS token is configured with access to the folder in Azure Data Lake that you're pulling the data from.
Execution Fails on ODX Transfer
Error: SQL compilation error:
syntax error line 1 at position 7 unexpected 'R'.
syntax error line 3 at position 18 unexpected '('.
Cause: This error occurs if Incremental Load is used.
Solution: Set Table Settings to Full Load or Disable Incremental Rules on ODX Data source and Synchronize objects on ODX.
Error: ‘User temporarily locked’
Cause: This error may occur if the user is testing the connection 5 or more times with an incorrect password