Catalog, document, and query live data from Snowflake by configuring a virtual connection. You can also create a connection through Snowflake Partner Connect.
In order to create a virtual connection to a Snowflake database you need to have the following:
User Credentials & Settings
- Host/IP - the url for your database
- Port (optional) - use if you connect through a special port
- Database (optional) - You can specify it here or you can choose from a dropdown list when you create a dataset
- Connection username - Your username for your data source
- Connection password - Your password for your data source
If you don't have a user in Snowflake, or are not allowed to use your own user credentials, ask your admin to create a user (either for you, or a read-only "system user") and grant it permission. The user you connect with must have a DEFAULT_WAREHOUSE set. This is the Snowflake compute instance that data.world will leverage when collecting metadata and querying data.
Whitelist IP Addresses
If your Snowflake data warehouse has a locked down network policy, add data.world to your whitelist with the following IP addresses:
Set up Connection
Go to the Snowflake integration and click Enable integration to set up a connection:
Choose a Display name for your connection. This is the name everyone in your organization will see for the connection. Then enter your Snowflake user credential information into the dialog screen (data.world needs read-only permissions to query data from Snowflake):
The user you enter the username and password here for must have appropriate permissions to query the Snowflake data and have a Default Warehouse set. See the Prerequisites section above for more information
Click Test Snowflake configuration to make sure it works, and then save it by selecting Configure.
After your connection is configured you can use it anytime you select Add data from within a dataset or project:
Choose the connection you want to use from My data sources:
Add or modify a connection
Go to the Snowflake integration page (easily found under My integrations on our Integrations page) and select Manage:
From here you can edit your current connection or add a new one:
You will need your original credentials (password or key file) to make changes to an existing connection.