Querying Snowflake Data
Audience: Data Users
Content Summary: This page offers a tutorial on how to query data within the Snowflake integration.
Query Data with Snowflake Governance Controls
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
REVOKE users' access to backing tables
- Create a new worksheet.
- Select the appropriate role/database/schema to query the views:
- Role: any or just PUBLIC.
- Warehouse: any.
- Database: The Immuta database name used when configuring the integration (default is IMMUTA).
- Schema: The schema that houses the backing tables of your Immuta data sources.
Run the following query in the worksheet (replace
IMMUTAwith the name of your database and replace
TABLE.NAMEwith the name of the backing Snowflake table):
SELECT * FROM IMMUTA.TABLE.NAME LIMIT 100