Įnter the connection details for your Snowflake database in the Connection tab : Open the Design Studio and go to File > New > Data source > JDBC. In order to assign the public key to a Snowflake user, execute ‘ alter user ’ command as follows:Īlter user set rsa_public_key=' MIIBIjANBgkqh. Step 3: Assign the generated Public Key to a Snowflake User The above command generates the public key in PEM format as follows: Rsa -in rsa_key.p8 -pubout -out rsa_key.pub The following command is used to generate the public key. Note : For an encrypted version, use the above command without “ -nocrypt ” Step 2: Generate a Public Keyįrom the command line, generate the public key by referencing the private key. Pkcs8 -topk8 -inform PEM -outform PEM -nocrypt -in keypair.pem -out rsa_key.p8 Rsa -in keypair.pem -pubout -out publickey.crt To begin, open an OpenSSL terminal window and generate a private key.įor an unencrypted version, use the following command in the openssl: Step 3: Assign the Public Key to a Snowflake User Step 1: Generate the Private KeyĪs a first step, to connect to Snowflake, generate an encrypted or unencrypted private key using OpenSSL. In order to allow Denodo to access the Snowflake using key pair authentication, it is necessary to manually obtain private-public key pairs by following these three steps. Note : For previous versions of the Denodo Platform, instead of uploading the JDBC driver, copy the driver into \lib-external\jdbc-drivers\snowflake-3.12.0 on the machine where the Denodo Virtual DataPort server is installed. This can be done via Design Studio or the Virtual DataPort Administration Tool by navigating to File > Extension Management > Import. Īfter downloading the driver from the Snowflake website, we need to install it. Note : this step is required only for Denodo updates prior to Denodo 8 update 20210715. Install the JDBC Client Driver in the Denodo Platform For versions prior to Denodo 8 update 20210715 you can download the latest snowflake JDBC driver (3.12) from their official website. Starting from Denodo 8 update 20210715, this driver is shipped with the Denodo platform. The Key Pair authentication support for Snowflake is available in their latest Snowflake driver 3.12. Password : Enter the appropriate password.Ĭlick on Test connection to test the data source connection and click on the Save button to save the data source.Ĭonnecting Snowflake from Denodo using key pair authentication.Username : Enter the username to connect to Snowflake.Database URI : use a connection string in the form of: jdbc:snowflake://host/?db=database
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |