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.
Got it. Let's do this.
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