Authenticating with Snowflake
To authenticate with Snowflake you'll first need to set up a few things.
Generating a key
If you're on Windows, you first need to install openssl. Check the following section on how to do so. If you're on MacOS or Linux then you can skip this part.
Windows
Windows
Install openssl from this page.
Once that's done, locate the openssl/bin folder and copy the folder path.
In the start menu, type in path and open edit the system environment variables.
Click environment variables and under system variables (the bottom part), click on path and then edit.
Click new and then paste the openssl/bin folder path. Then click OK.
Open a terminal, then run the following commands:
openssl genrsa 2048 | openssl pkcs8 -topk8 -inform PEM -out rsa_key.p8 -nocrypt
openssl rsa -in rsa_key.p8 -pubout -out rsa_key.pub
This will have created a rsa_key.p8 file containing your private key and a rsa_key.pub file containing your public key. Open these files in notepad to read them.
Assigning the key
Read the keys and copy their contents, then go to snowflake and run the following command. Make sure you set your public key without the -----BEGIN PUBLIC KEY----- headers and footers, and don't include line breaks. And replace yourapiuser with your username.
ALTER USER yourapiuser SET RSA_PUBLIC_KEY='yourpublickey';
Getting the fingerprint
Next, run this command, but replace yourapiuser with your username:
DESC USER yourapiuser;
Note down the RSA fingerprint value (RSA_PUBLIC_KEY_FP).
Getting the account identifier
Next, run the following command to retrieve your account identifier:
SELECT CURRENT_ORGANIZATION_NAME() || '-' || CURRENT_ACCOUNT_NAME();
Authenticating
Once that's all done, go to the Snowflake integration page by clicking here.
Click Authenticate and fill in your public/private keys without the -----BEGIN PUBLIC KEY----- headers and footers.
Enter the account identifier, fingerprint and your api user's username.
Then click authenticate.
Sync feedback data to Snowflake
Simplesat can automatically sync feedback to Snowflake.
Here's an example of how this will look in Snowlake:
To set this up, visit the Snowflake integration page by clicking here.
Scroll down to sync feedback data to Snowflake and click activate integration.
Once it's successfully activated, scroll down to variables and set the database, schema and table name variables to your desired values.
Click save to save your settings.
The first time you'll receive new feedback a new table will be created and all your historical feedback will be imported into there.
Afterwards, any new feedback will be appended to that table, and updated feedback will update the existing feedback into the table.