Querying Snowflake Data

Audience: Data Users

Content Summary: This page offers a tutorial on how to query data within the Snowflake integration.

Prerequisites:

• Snowflake integration configured with Immuta
• Snowflake tables registered as Immuta data sources

Query Data with Snowflake Governance Controls

With Snowflake Table Grants

Query the data exactly as you would have before Immuta.

Without Snowflake Table Grants

Prerequisite: Users have been granted SELECT privileges on all or relevant Snowflake tables

Query the data exactly as you would have before Immuta.

Query Data without Snowflake Governance Controls

Prerequisite: REVOKE users' access to backing tables

1. Create a new worksheet.
2. Select the appropriate role/database/schema to query the views:
   1. Role: any or just PUBLIC.
   2. Warehouse: any.
   3. Database: The Immuta database name used when configuring the integration (default is IMMUTA).
   4. Schema: The schema that houses the backing tables of your Immuta data sources.

3. Run the following query in the worksheet (replace IMMUTA with the name of your database and replace TABLE.NAME with the name of the backing Snowflake table):

   SELECT * FROM IMMUTA.TABLE.NAME LIMIT 100