Docker Compose setup

Prerequisites

1. Download the latest version of the Snowflake Profiler from the Delphix download page.

2. Ensure that the host running the profiler has Docker and Docker Compose installed.

3. Set up the Hyperscale Snowflake Connector and add the required ConnectorInfo details.

4. For accessing Snowflake warehouse, we will require a service account user with key pair authentication for enhanced authentication security as an alternative to basic authentication.

   1. To configure key-pair authentication for a Snowflake service account, follow the steps provided in the Snowflake’s configuring key-pair authentication.

   2.  Use the following commands to generate base64 encoded value of encrypted private key and passphrase.
      To generate base64 encoded value of encrypted private key:

      CODE

      echo -n `cat /home/delphix/keys/MKK_TEST_SFHSC_ADMIN_key.p8 | base64`

      To generate base64 encode value of passphrase:

      CODE

      echo -n <passphrase> | base64 -w 0

5. Similarly, the profiler needs the Controller API Key to authenticate to the controller which also needs to be provided in base64 encoded format. To generate base64 encode value of Controller API key:

   CODE

   echo –n “<controller_api_key>” | base64 –w 0

Procedure

1. Untar the profiler downloaded from Delphix download page. It should contain the Docker images for the profiler and the snowflake-profiler-compose.tar

   CODE

   tar -xf snowflake-profler.tar.gz

2. Load the delphix-snowflake-profiler.tar Docker image:

   CODE

   cd snowflake-profiler
   docker load --input delphix-snowflake-profiler.tar

3. Untar the snowflake-profiler-compose.tar.gz

   CODE

   tar –xf snowflake-profiler-compose.tar.gz
   cd snowflake-profiler-compose

4. Edit the .env file:

   1. Configure the ‘CONTROLLER_URL’ with the controller URL, IP or hostname:

      CODE

      CONTROLLER_URL= delphix-controller.com

   2. Configure the credentials required to connect to Snowflake instance:

      CODE

      SNOWFLAKE_PRIVATE_KEY=user_encrypted_private_key_base64_encoded
      SNOWFLAKE_PASSPHRASE=passhrase_base64_encoded
      CONTROLLER_API_KEY=controller_api_key_base64_encoded

   3. Optionally, see additional configurations for further details.

5. Start the Snowflake profiler service:

   CODE

   docker-compose –f profiler-docker-compose.yaml up -d

6. Access the profiler Swagger UI at http://<host-ip>:8080/profiler