...
Include Page | ||||
---|---|---|---|---|
|
Configure a snowflake account with RSA Key pair ( Public & Private )
Info |
---|
|
...
|
Login to your snowflake Snowflake account and switch role to
ACCOUNTADMIN
.
...
Click on
Account
tab.
...
Go Navigate to
Users
tab,.
...
Click on
Create
user, InGeneral
section give name & password details, Then clickNext
...
to create a user. In theGeneral
section provide User Name and Password details, then clickNext
.
...
In
Advanced
Section section fill in the details specific to your organization, these are examples only for Zilla. ClickNext
.
...
Info |
---|
Note: |
...
|
...
provided |
...
Email
associate some email from your organization sam@zillasecurit.com
is just for example. Click Next
In next
Preferences
selectACCOUNTADMIN
as default role, Click finish.
...
...
Note down the name Zilla
you can choose any different name but make a note of it, It will be used later.
...
on the |
In
Preferences
section, selectACCOUNTADMIN
as Default Role and clickFinish
.
...
Before proceeding, login with the above user to see if verify the user has been created & and has the default role as ACCOUNTADMIN. Now let us Configuring
Configure Key Pair Authentication for
...
the new created user
...
Step 1: Generate the Private Key
...
Step 3: Store the Private and Public Keys Securely: These are sensitive keys shall be stored , store securely so that no one can access.
Step 4: Assign the Public Key to a Snowflake User
Zilla
we created before, Use the new created Snowflake user with the following SQL query,:
Code Block |
---|
// Execute this query to enable admin previligeprivilege, SOso that we can modify user Zilla USE ROLE ACCOUNTADMIN; |
Then execute the following query replacing {User Name} with the user name created above:
Code Block |
---|
// Make change to user Zilla to associate RSApublic key ALTER USER Zilla{User Name} SET RSA_PUBLIC_KEY='MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKC........; |
Note: To print the contents of the public key type $ cat rsa_key.pub
on the terminal.
Note: The public key we assigned is without the beginning
& end
part of it and end
prefix and post-fix, i.e. -----BEGIN PUBLIC KEY-----
& and -----END PUBLIC KEY-----
respectively.
Now we have all the artifacts we need to configure the Snowflake integration.
Configure A Snowflake integration on Zilla Dashboard
Login to Zilla with your admin account.
Go to Applications tab and click on `Add
Add Application
.
...
Type
Snowflake
“Snowflake” in the search box, A suggestedSnowflake
library entry shall appear click Add . ClickAdd to Applications
button right next to it, to the right of theSnowflake
entry.
...
Fill in the
Add Application
form in details & and clickAdd to Applications
.
...
The
Snowflake
application entry shall appear in theApplications
tab click on (if not visible, search for it). Click the app name ,link.
...
Next on the App details page to the right side, you will see
Update now
button click it, ClickSync Now
in the upper right of the application details page. You will see configuration box appeared,the configuration dialog. Click the slider below API Configuration to enable it.
...
Here fill Fill in the details as follows,:
RSA Private Key: The PVT RSA key generated in the above step, You can print the key on the terminal using
$cat rsa_key.p8
command, .
Info |
---|
Note that the key |
...
must be copied |
...
WITH |
...
and |
...
sync will fail. |
RSA Private Key Passphrase: If you created an encrypted RSA PVT key then a passphrase to decrypt the key shall must be provided here, . If you have not created an encrypted key leave this blank, ( In the above step we have not created an encrypted key by providing flag
-nocrypt
).Snowflake Account Id: If your snowflake Snowflake URL is
https://unaXXXXX.us-east-1.snowflakecomputing.com/
thenunaXXXXX.us-east-1
is your account id.Account Admin Username: In our case, it’s
Zilla
If you have chosen any custom name provide that name The User Name created above, in our example it’sZilla
.Warehouse name ( Where SNOWFLAKE db & ACCOUNT_USAGE schema is located ): Name of the warehouse which has the SNOWFLAKE database & ACCOUNT_USAGE schema. Use
show warehouses;
command to see available warehoused warehouses in your account,.
After filling in the above details click on
Next
.You will see configuration stored success toast as well as a small dialog saying
In the next step, you will be asked to log in to Snowflake - 1, and then the data sync will start automatically.
ClickNext
...
.
Include Page | ||||
---|---|---|---|---|
|