| Info |
|---|
Snowflake is cloud-based data storage and analytics service. This guide explains how to add Snowflake integration to Cloudaware. |
To see how Cloudaware seamlessly integrates with Snowflake in action, request a demo.
| Table of Contents | ||||
|---|---|---|---|---|
|
...
Prerequsites
...
Create a custom role, e.g. READ_ONLY.
...
Create a user, e.g. CLOUDAWARE, and assign the role READ_ONLY
...
.
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 only 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
1
...
Account ID - Snowflake account ID (check
...
how to
...
find account
...
ID here)
Username - name of the user created for this integration
...
, e.g. CLOUDAWARE
...
2
...
In 'Select Certificate': click +CREATE NEW. Enter a meaningful name and click +GENERATE to add a new
...
Key Pair.
3
...
In 'Next Step': copy the command. Run the command in Snowflake to change the user's rsa_public_key.
4
...
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