Snowflake

Connect to Snowflake so you can browse schemas, build queries, and use spatial columns in map reports.

Goal

Create a working Snowflake connection in Connection Manager and use it as a report Data Source.

Prerequisites

• A Snowflake account identifier
• A username, plus a password or a key-pair private key
• Network access from your workstation

Steps

1. Open Data → Connection Manager….
2. Add a connection and choose Snowflake.
3. Enter the Account Identifier only — for example xy12345, myorg-myaccount, or myaccount.eu-central-1.
4. Enter Username.
5. Choose an Authenticator:
6. Username / Password — enter the password.
7. Key-pair (SNOWFLAKE_JWT) — browse to a PKCS#8 PEM private key. If the key is encrypted, enter the private key passphrase.
8. Enter Database, Schema (default PUBLIC), Warehouse, and Role when you want the connection to open in a specific context.
9. Click Test, then save the connection.
10. On the Data tab, select the connection and open Query Builder.

[ Screenshot: Snowflake connection settings ]

Notes

Note

External browser / SSO and OAuth are not available yet.

Note

Show system schemas is off by default.

Note

Passwords and private-key passphrases are stored in the operating system credential store, not in the report.

Tip

GEOGRAPHY and GEOMETRY columns can be used with the Snowflake Spatial map source. See Maps.

Result

The connection appears in Connection Manager and can be selected for queries and for Snowflake Spatial maps.

See Also

• Data Sources overview
• Query Builder
• Parameters
• Maps