Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Info

Snowflake is cloud-based data storage and analytics service.

Table of Contents
minLevel1
maxLevel7

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
Snowflake Database
Snowflake Integration
Snowflake Integration Location
Snowflake Pipe
Snowflake Role
Snowflake Schema
Snowflake Stage
Snowflake Table
Snowflake User
Snowflake User Role Link
Snowflake View
Snowflake Warehouse