{"type":"doc","content":[{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"Snowflake","type":"text","marks":[{"type":"textColor","attrs":{"color":"#403294"}},{"type":"strong"}]},{"text":" is cloud-based data storage and analytics service. This guide explains how to add Snowflake integration to Cloudaware.","type":"text"}]}]},{"type":"paragraph","content":[{"type":"mediaInline","attrs":{"width":424,"alt":"Snowflake - CA_logo_black.png","id":"fa34d954-d977-4b1a-bd21-d02bd7603674","collection":"contentId-2942795777","type":"image","height":445},"marks":[{"type":"link","attrs":{"href":"https://cloudaware.com/schedule-demo/"}}]},{"text":" To see how Cloudaware seamlessly integrates with Snowflake in action, ","type":"text"},{"text":"request a demo","type":"text","marks":[{"type":"link","attrs":{"href":"https://cloudaware.com/schedule-demo/"}}]},{"text":".","type":"text"}]},{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"toc","parameters":{"macroParams":{"minLevel":{"value":"1"},"maxLevel":{"value":"7"}},"macroMetadata":{"macroId":{"value":"69168facde69ac60bbcdc3277345c78c"},"schemaVersion":{"value":"1"},"title":"Table of Contents"}},"localId":"1a2735f3-f4c5-4cd2-8899-b749084b56e1"}},{"type":"heading","attrs":{"level":2},"content":[{"text":"Prerequsites","type":"text"}]},{"type":"paragraph"},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Create a custom role","type":"text","marks":[{"type":"link","attrs":{"href":"https://docs.snowflake.com/en/sql-reference/sql/create-role"}}]},{"text":", e.g. ","type":"text"},{"text":"READ_ONLY","type":"text","marks":[{"type":"em"}]},{"text":".","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Create a user","type":"text","marks":[{"type":"link","attrs":{"href":"https://docs.snowflake.com/en/sql-reference/sql/create-user"}}]},{"text":", e.g. ","type":"text"},{"text":"CLOUDAWARE","type":"text","marks":[{"type":"em"}]},{"text":", and assign the role ","type":"text"},{"text":"READ_ONLY","type":"text","marks":[{"type":"em"}]},{"text":".","type":"text"}]},{"type":"codeBlock","content":[{"text":"create user CLOUDAWARE default_role=READ_ONLY","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Provide the role with access to Warehouse*:","type":"text"}]},{"type":"codeBlock","content":[{"text":"grant usage on warehouse to role READ_ONLY","type":"text"}]}]}]},{"type":"panel","attrs":{"panelType":"note"},"content":[{"type":"paragraph","content":[{"text":"*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:","type":"text"}]}]},{"type":"paragraph","content":[{"text":"Basic Access","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"GRANT IMPORTED PRIVILEGES ON DATABASE SNOWFLAKE TO ROLE READ_ONLY","type":"text","marks":[{"type":"code"}]}]},{"type":"paragraph","content":[{"text":"Detailed Access","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Snowflake Integration: ","type":"text"},{"text":"GRANT USAGE ON INTEGRATION TO READ_ONLY","type":"text","marks":[{"type":"code"}]}]},{"type":"paragraph","content":[{"text":"Snowflake Database: ","type":"text"},{"text":"GRANT USAGE ON DATABASE TO READ_ONLY","type":"text","marks":[{"type":"code"}]}]},{"type":"paragraph","content":[{"text":" Snowflake Schema: ","type":"text"}]},{"type":"paragraph","content":[{"text":" ","type":"text"},{"text":"GRANT USAGE ON ALL SCHEMAS IN DATABASE TO READ_ONLY","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":" ","type":"text"},{"text":"GRANT USAGE ON FUTURE SCHEMAS IN DATABASE TO READ_ONLY","type":"text","marks":[{"type":"code"}]}]},{"type":"paragraph","content":[{"text":" Snowflake Stage:","type":"text"}]},{"type":"paragraph","content":[{"text":" ","type":"text"},{"text":"GRANT USAGE ON ALL STAGES IN DATABASE TO READ_ONLY","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":" ","type":"text"},{"text":"GRANT USAGE ON FUTURE STAGES IN DATABASE TO READ_ONLY","type":"text","marks":[{"type":"code"}]}]},{"type":"paragraph","content":[{"text":" Snowflake Table:","type":"text"}]},{"type":"paragraph","content":[{"text":" ","type":"text"},{"text":"GRANT REFERENCES ON ALL EXTERNAL TABLES IN DATABASE TO READ_ONLY","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":" ","type":"text"},{"text":"GRANT REFERENCES ON FUTURE EXTERNAL TABLES IN DATABASE TO READ_ONLY","type":"text","marks":[{"type":"code"}]}]},{"type":"paragraph","content":[{"text":" Snowflake Pipe:","type":"text"}]},{"type":"paragraph","content":[{"text":" ","type":"text"},{"text":"GRANT MONITOR ON PIPE .. TO READ_ONLY","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":" ","type":"text"},{"text":"GRANT MONITOR ON FUTURE PIPES IN DATABASE TO READ_ONLY","type":"text","marks":[{"type":"code"}]}]},{"type":"paragraph"},{"type":"heading","attrs":{"level":2},"content":[{"text":"Add Snowflake account","type":"text"}]},{"type":"paragraph"},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Log in to Cloudaware account → ","type":"text"},{"text":"Admin","type":"text","marks":[{"type":"strong"}]},{"text":".","type":"text"},{"type":"hardBreak"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":1181,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1425,"alt":"Snowflake - admin.png","id":"9f99ed29-17c9-4b61-96f3-a1c23ebe16b8","collection":"contentId-2942795777","type":"file","height":449},"marks":[{"type":"border","attrs":{"size":2,"color":"#091e4224"}}]}]},{"type":"paragraph","content":[{"text":" ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Find Snowflake in the list of cloud integrations. Click ","type":"text"},{"text":"+Add","type":"text","marks":[{"type":"strong"}]},{"text":". ","type":"text"},{"type":"hardBreak"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":861,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":861,"alt":"Snowflake - admin - add Snowflake integration.png","id":"d4cc8478-2d27-4f9f-a68b-8496fb1fc139","collection":"contentId-2942795777","type":"file","height":88},"marks":[{"type":"border","attrs":{"size":2,"color":"#091e4224"}}]}]},{"type":"paragraph","content":[{"text":" ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Fill out the form:","type":"text"},{"type":"hardBreak"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":583,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":583,"alt":"Snowflake - Snowflake integration details.png","id":"13827010-6bec-425b-a823-09c14f08d4fa","collection":"contentId-2942795777","type":"file","height":627},"marks":[{"type":"border","attrs":{"size":2,"color":"#091e4224"}}]}]},{"type":"paragraph","content":[{"text":"WHERE","type":"text","marks":[{"type":"em"}]},{"type":"hardBreak"},{"text":"1","type":"text","marks":[{"type":"subsup","attrs":{"type":"sup"}}]},{"text":" ","type":"text"},{"text":"Account ID ","type":"text","marks":[{"type":"em"}]},{"text":"- Snowflake account ID (check how to find account ID ","type":"text"},{"text":"here","type":"text","marks":[{"type":"link","attrs":{"href":"https://docs.snowflake.com/en/user-guide/admin-account-identifier"}}]},{"text":")","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"},{"text":"Username ","type":"text","marks":[{"type":"em"}]},{"text":"- name of the user created for this integration, e.g. ","type":"text"},{"text":"CLOUDAWARE","type":"text","marks":[{"type":"em"}]},{"type":"hardBreak"},{"text":"2","type":"text","marks":[{"type":"subsup","attrs":{"type":"sup"}}]},{"text":" In 'Select Certificate': click +CREATE NEW. Enter a meaningful name and click +GENERATE to add a new Key Pair.","type":"text"},{"type":"hardBreak"},{"text":"3","type":"text","marks":[{"type":"subsup","attrs":{"type":"sup"}}]},{"text":" In 'Next Step': copy the command. Run the command in Snowflake to change the user's ","type":"text"},{"text":"rsa_public_key","type":"text","marks":[{"type":"em"}]},{"text":".","type":"text"},{"type":"hardBreak"},{"text":"4","type":"text","marks":[{"type":"subsup","attrs":{"type":"sup"}}]},{"text":" In 'Warehouse': click GET WAREHOUSES. ","type":"text"},{"text":"S","type":"text","marks":[{"type":"em"}]},{"text":"elect a warehouse from the list.","type":"text"},{"type":"hardBreak"},{"type":"hardBreak"},{"text":"Click ","type":"text"},{"text":"Save","type":"text","marks":[{"type":"strong"}]},{"text":".","type":"text"},{"type":"hardBreak"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"The green light in 'Status' means that Snowflake integration has been successfully configured. If there is a red light, please contact ","type":"text"},{"text":"support@cloudaware.com","type":"text","marks":[{"type":"link","attrs":{"href":"mailto:support@cloudaware.com"}}]},{"text":".","type":"text"},{"type":"hardBreak"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":1163,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1163,"alt":"Snowflake - integration status.png","id":"907e67b3-85b1-48fd-827a-f1209aaa4a83","collection":"contentId-2942795777","type":"file","height":280},"marks":[{"type":"border","attrs":{"size":2,"color":"#091e4224"}}]}]},{"type":"paragraph","content":[{"text":" ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"To view Snowflake-related data, go to Cloudaware CMDB Navigator. Select SNOWFLAKE in the menu on the left:","type":"text"},{"type":"hardBreak"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":1181,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1425,"alt":"Snowflake - Snowflake objects in CMDB.png","id":"d81ccaed-f9d3-485e-bebc-890bba1c5330","collection":"contentId-2942795777","type":"file","height":729},"marks":[{"type":"border","attrs":{"size":2,"color":"#091e4224"}}]}]},{"type":"paragraph"}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"List of Snowflake objects","type":"text"}]},{"type":"paragraph"},{"type":"paragraph","content":[{"text":"Cloudaware supports the following Snowflake objects:","type":"text"}]},{"type":"paragraph","content":[{"text":"Snowflake Account","type":"text","marks":[{"type":"em"}]},{"type":"hardBreak"},{"text":"Snowflake Database\t","type":"text","marks":[{"type":"em"}]},{"type":"hardBreak"},{"text":"Snowflake Integration","type":"text","marks":[{"type":"em"}]},{"type":"hardBreak"},{"text":"Snowflake Integration Location","type":"text","marks":[{"type":"em"}]},{"type":"hardBreak"},{"text":"Snowflake Pipe\t","type":"text","marks":[{"type":"em"}]},{"type":"hardBreak"},{"text":"Snowflake Role\t","type":"text","marks":[{"type":"em"}]},{"type":"hardBreak"},{"text":"Snowflake Schema","type":"text","marks":[{"type":"em"}]},{"type":"hardBreak"},{"text":"Snowflake Stage\t","type":"text","marks":[{"type":"em"}]},{"type":"hardBreak"},{"text":"Snowflake Table\t","type":"text","marks":[{"type":"em"}]},{"type":"hardBreak"},{"text":"Snowflake User\t","type":"text","marks":[{"type":"em"}]},{"type":"hardBreak"},{"text":"Snowflake User Role Link","type":"text","marks":[{"type":"em"}]},{"type":"hardBreak"},{"text":"Snowflake View\t","type":"text","marks":[{"type":"em"}]},{"type":"hardBreak"},{"text":"Snowflake Warehouse","type":"text","marks":[{"type":"em"}]}]}],"version":1}

Browser not supported