Querying Snowflake Data
Prerequisites:
Query data with Snowflake table grants
Execute the
USE SECONDARY ROLES ALL
command or change your role to the table grants role.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;
Last updated
Was this helpful?