| Info |
|---|
Snowflake is cloud-based data storage and analytics service. This guide explains how to add Snowflake integration to Cloudaware. |
...
Create a custom role, e.g. READ_ONLY.
Create a user, e.g. CLOUDAWARE, and assign the role 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
...
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 KeyPairKey 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
...