| Info |
|---|
Snowflake is cloud-based data storage and analytics service. This guide explains how to add Snowflake integration to Cloudaware. |
...
| Table of Contents | ||||
|---|---|---|---|---|
|
...
Prerequsites
...
Create a custom role, e.g. READ_ONLY.
...
Create a user, e.g. CLOUDAWARE, and assign the READ_ONLY role by default.
Code Block create user CLOUDAWARE default_role=READ_ONLY
...
Provide the role with access to Warehouse*:
Code Block grant usage on warehouse <warehouse_name> to role READ_ONLY
*Note that Cloudaware will only collect the metadata of objects that the to which access has been granted to. Assign the permissions below depending on the preferred level of access:
...
GRANT MONITOR ON PIPE <database_name>.<schema_name>.<pipe_name> TO READ_ONLY
GRANT MONITOR ON FUTURE PIPES IN DATABASE <database_name> TO READ_ONLY
...
Add Snowflake
...
account
...
Log in to
...
Cloudaware account → Admin.
...
Find Snowflake in the list of cloud integrations
...
. Click +Add.
...
Fill out the form:
...
WHERE
...
Account ID - Snowflake account ID (check
...
how to
...
find account
...
ID here)
Username - name of the user created for this integration
...
, e.g. CLOUDAWARE
...
In 'Select Certificate': click +CREATE NEW. Enter a meaningful name and click +GENERATE to add a new KeyPair
...
.
In 'Next Step': copy the command. Run the command in Snowflake to change the user's rsa_public_key.
...
In 'Warehouse': click GET WAREHOUSES. Select
...
a warehouse from the list
...
.
Click Save.
...
The green light in 'Status' means that Snowflake integration has been successfully configured. If there is a red light, please contact support@cloudaware.com.
...
To view Snowflake-related data, go to Cloudaware CMDB Navigator
...
. Select SNOWFLAKE in the menu on the left:
List of Snowflake
...
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