Querying Snowflake Data

Prerequisites:

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

Query data with Snowflake table grants

1. Execute the USE SECONDARY ROLES ALL command or change your role to the table grants role.

2. Query the data as you normally would in Snowflake.

   SELECT * FROM emp_basic LIMIT 100;
   

Query data without Snowflake table grants

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

Query the data as you normally would in Snowflake:

SELECT * FROM emp_basic LIMIT 100;