Snowflake

Snowflake is a cloud data warehouse reached over HTTPS at your account host. Fill the connection form with your account URL and credentials to start querying.

Overview

TableR connects to Snowflake through its HTTPS endpoint, so the connection is always encrypted. It works with any Snowflake account; queries run on the warehouse you select, and your role controls what you can see.

• Cloud warehouse — reached at account.region.snowflakecomputing.com over HTTPS (port 443).
• Compute — a warehouse must be available; set one when the session has no default.
• Access — the role determines the databases, schemas, and objects you can query.

Before you start

• Your Snowflake account host (account.region.snowflakecomputing.com).
• A username and its password or token.
• A warehouse name, if your user has no default warehouse.
• Optionally, a default role, database, and schema.

Connection fields

These fields match TableR's Snowflake connection form. The connection uses HTTPS, and secrets are written to the operating system keyring, never to plain configuration files.

Connect with the form

1. 1
   Choose Snowflake

   Open the launcher and pick the Snowflake card.

2. 2
   Enter the account host

   Use your account URL, account.region.snowflakecomputing.com.

3. 3
   Add your credential

   Type the username and password or token; it is saved to the OS keyring.

4. 4
   Set a warehouse (if needed)

   Provide a warehouse when your user has no default.

5. 5
   Pick role, database, schema (optional)

   Leave these blank to use your account defaults.

6. 6
   Save and connect

   Save the profile so it reappears in the launcher, then connect.

Verify the connection

Once connected, open a SQL tab and run a quick check:

SELECT CURRENT_VERSION();
SELECT CURRENT_ACCOUNT(), CURRENT_USER(), CURRENT_WAREHOUSE();

If both statements return rows, the connection and credentials are working.

Troubleshooting

Next steps