Catalog, document, and query live data from Snowflake.
User Credentials & Settings
- Already have a user in Snowflake? You can use your existing Snowflake user to create a connection.
- If you followed our Connect using Snowflake Partner Connect instructions, then you could use the default PC_DATADOTWORLD_USER that was created automatically through that process.
- Don't have a user in Snowflake, or 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 compute that data.world will leverage when collecting metadata and querying data.
Whitelist IP Addresses
- If your Snowflake database has a locked down network policy, add data.world to your whitelist. Whitelist the following IP addresses:
This will guide you on how to create a direct connection from data.world to Snowflake. Contact our demo support team if you would like to inquire about alternative methods of connecting such as an SSH tunnel or bridged connection approach.
- Go to https://data.world/integrations/snowflake and click ‘Manage’ to set up connections.
- Click ‘+ Add new connection’. You can setup one or many connections.
- Enter your desired Snowflake user credentials. data.world needs read-only permissions to query data from Snowflake. Click ‘Test Snowflake configuration’ to make sure it works before you save it by hitting ‘Configure’.
Reminder: 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 on this.
- After entering in all the fields, click "Test Snowflake configuration" to confirm everything is working right. Everything looks solid? Click "Configure" to finalize the connection.
Step One is now complete! Step 2 is Create a Dataset.