Snowflake is cloud-based data storage and analytics service.
Prerequisites
1. Create the role READ_ONLY and assign it to a user …
2. Create the user CLOUDAWARE and assign the READ_ONLY role
CREATE USER CLOUDAWARE DEFAULT_ROLE=READ_ONLY
3. Grand access to the role
GRANT USAGE ON WAREHOUSE <warehouse_name> TO ROLE READ_ONLY
Snowflake Setup
List of Supported Objects
Cloudaware supports the following Snowflake objects:
Snowflake Account |