How can I connect my Snowflake
account to Arctica?
To help you analyze Snowflake usage patterns and monitor your costs, Arctica needs some information about the way you use Snowflake. For example: what type of queries do you typically run, at what times and by whom
This is your exists [SNOWFLAKE] database.
This is a new database-used solely for
sharing account data with Arctica
[ARCTICA_SHARE].
No actual data (i.e. from your data tables) is being shared with Arctica. Only information about the use of Snowflake is being shared. For example: query execution times, utilization of warehouses etc.
What does the installation script do?
1
Create a new database for the shared information
Creates a new database called “Arctica Share” in your account
2
Create a process (stored procedure) to keep the information updated
Creates a new stored procedure to regularly sync information into the “Arctica Share” database using SNOWFLAKE PROCEDURE
3
Make sure that the updating process is running regularly (scheduled)
Schedules the stored procedure to run every X hours using SNOWFLAKE TASK
Up Until this point, no information was shared with Arctica.
4
Establish a Snowflake data-sharing
Establish a Snowflake data share between the “Arctica Share” database & Arctica app using Snowshare.
Quick Answer
Not the answers you were looking for? Feel free to send your question from the bottom right help button
Am I sharing my actual data with Arctica?
No! None of data is shared. Only system data from your Snowflake sys database
How the data is transfered to Arctica?
We use Snowshare. A Snowflake service for Data-Sharing. No data is extracting from Snowflake