Connecting to Snowflake

This guide will walk you through how to connect to Snowflake. You may need to contact the administrator of your Snowflake account if you lack some of the credentials discussed below.

Never connected to a database in PopSQL before? This article may be helpful to read first.

  1. Click New Connection in the Manage Connections modal in PopSQL Screenshot of creating a New Database Connection in PopSQL

  2. Create a Nickname for this connection (for your own internal reference)

  3. For Type, choose Snowflake.

  4. Your Snowflake Account is whatever comes before snowflakecomputing.com when you sign into Snowflake directly. Screenshot of finding your Snowflake Account Screenshot of finding your Snowflake Account

  5. For Snowflake Warehouse, in your Snowflake account, click Warehouses, and choose your desired warehouse under the column Warehouse Name. Screenshot of finding your Snowflake Warehouse

  6. To find your Database, in your Snowflake account, click Databases, and look in the Database column. Screenshot of finding your Snowflake Database

  7. For Username and Password, enter the same credentials as you would enter when logging into your Snowflake account. Screenshot of Snowflake admin sign in portal

Happy querying! 🍭