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

database.png
aroooo11.jpg

This is your exists [SNOWFLAKE] database.

This is a new database-used solely for
sharing account data with Arctica
[ARCTICA_SHARE].

222.jpg

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

i-1.png

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

i-2.png

3

Make sure that the updating process is running regularly (scheduled)

Schedules the stored procedure to run every X hours using SNOWFLAKE TASK

i-3.png
333.jpg

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.

Read more about Snowflake Data Sharing.

i-4.png
wk-bg.png

Got it. Let's do this.

Quick Answer

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