Querying Snowflake Data

Prerequisites:

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;

Copyright © 2014-2024 Immuta Inc. All rights reserved.