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 20. 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://<orgname>-<account_name>.snowflakecomputing.com
.Note
The
orgname
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.
On the Obfuscate data page, select the data sets that you want to conceal. Click Next.
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. |