Snowflake
Connect your Symon.AI and Snowflake accounts to import your data.
Connect your Symon.AI and Snowflake accounts to import your data.
Before you begin
Before you can create a connection between Symon.AI to import data from Snowflake, you will need a Snowflake account.
Supported data sources
This connector can import data from the Databases you define within your Snowflake role under the Snowflake account.
Import
With the correct permissions in place, you can now import your data into Symon.AI.
In Symon.AI, go to the Data tab.
Click Import data.
In the Third party sources section, click Snowflake.
Click New connection.
On the Connect to your Database page, enter the following information to connect:
Table 19. SnowflakeField
Description
Connector name
The name of the connection.
Snowflake URL
The URL to connect to Snowflake. You can use the account URL copied from the Snowflake app, or you can use
https://<org_name>-<account_name>.snowflakecomputing.com
.Note
The
org_name
is the name of your Snowflake organization.The
account_name
is the unique name of your account within your organization.Snowflake role
The role in Snowflake, such as
<user>_role
.Note
The Snowflake role is an optional parameter. If you don't provide the role, the connection uses the default role.
Warehouse
The name of the Snowflake warehouse your data runs out of.
Database name
The name of the Snowflake database.
Username
The Snowflake user name, such as
admin
.Password
The Snowflake password.
Click Next.
On the Select data page, in the Directory field, select the directory for the data set. Click Next.
For data imports with high performance, switch the toggle on to import using S3 unload.
Note
Using the S3 unload to import data with high performance may incur data transfer costs. To review the costs, see the Data Transfer section of the Snowflake pricing guide.
On the Import data page, review your data and select the data to obfuscate (if any). Click Next.
On the Filter data page, optionally click Filter data to refine your data, or click Import data to continue.
Filter the rows in your data by selecting the column to filter, the filter category and the value or text.
Click Import data to continue.
Note
For more information about how to configure data filters, see: Filter data.
On the Review page, review the data sets that you are importing.
Click Import data.
The data is available on the My Data page.
Usage examples
After creating the connection, you can view a list of available tables under your database based on the role. You can search for and select the specific table data that you want to analyze, complete the configuration steps, and start the import.
When your data is available in Symon.AI, where you can view and start analyzing it in a pipe.
Security and privacy
We use standard username and password authentication practices to connect with Snowflake, and securely store encrypted passwords.
Error handling
The following errors may appear during the import process:
Error | Description | Solution |
---|---|---|
| There is an incorrect warehouse name. | To fix this error, enter the correct warehouse name. |
| There is an incorrect database name. | To fix this error, enter the correct database name. |
| There is an incorrect database name. | To fix this error, enter the correct database name. |
| This error occurs if a | To fix this error, see your Snowflake account and make the appropriate updates. |
| This error occurs during Snowflake SQL compilation, when the SQL script is trying to access tables that don't exist or doesn't have access to. | To fix this error, see your Snowflake account and make the appropriate updates. |
| This error occurs when the imported data has too many columns. This is not a performance issue on the Symon.AI side, but is caused by the Snowflake python connector (maintained by Snowflake) pulling in too much data in parallel which results in a memory issue. Based on the testing results, Symon.AI sets a limitation of 150 columns. | To fix this error, see your Snowflake account and make the appropriate updates. |