Skip to main content

Connecting to Hyperproof Snowflake (SSR) using RSA key-pair authentication

If you are looking for instructions on how to connect to your Hyperproof Snowflake data warehouse using RSA key-pair authentication, this guide provides a step-by-step process.

Overview:

These instructions are for IT workers with experience and access to install software needed to generate RSA keys. Consult your IT team for help with generating the RSA keys and before installing any software on your computer.

The best practice for setting up authentication with third-party reporting tools is to use a service account with RSA key-pair authentication. Power BI is known not to support multi-factor authentication, making a service account with RSA key-pair authentication a requirement.

Snowflake supports multiple authentication methods:

  • Person accounts: username, password, and MFA

  • Service accounts: RSA key-pair authentication (recommended for BI tools)

RSA authentication enhances security by removing the need for stored passwords and using cryptographic keys instead.
​

Generate your RSA key pair:

  1. Install OpenSSL or request IT support for installation.

  2. Run the following commands:

    1. Generate a private key :

      • openssl genrsa 2048 | openssl pkcs8 -topk8 -inform PEM -out rsa_key.p8 -nocrypt

    2. Generate a public key :

      • openssl rsa -in rsa_key.p8 -pubout -out rsa_key.pub

        File descriptions:

      1. "rsa_key.p8": Private key to be used in Power BI like tools

      2. "rsa_key.pub": Public key uploaded to Hyperproof
        ​

Did this answer your question?