| 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
...
...
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
Snowflake Setup
Log in to your Cloudaware account → Admin.
Find Snowflake in the list of integrations, click +Add.
[screen]
Create or select KeyPair (in Snowflake?)
Copy publicKey and change the RSA_PUBLIC_KEY of the user:
| Code Block |
|---|
alter user <username> set rsa_public_key='MI...' |
Fill out the following fields:
[screen]
Account ID -
Username -
Warehouse - select one of the available warehouse
Click Save.
Levels of Access
Basic
*Note that Cloudaware will only collect the metadata of objects to which access has been granted. Assign the permissions below depending on the preferred level of access:
Basic Access
GRANT IMPORTED PRIVILEGES ON DATABASE SNOWFLAKE TO ROLE READ_ONLY
Detailed Access
Snowflake Integration: GRANT USAGE ON INTEGRATION <integration_name> TO READ_ONLY
...
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