Processing Requests
      Back to home
      1. Help center
      2. DSR Handling
      3. Processing Requests

      Snowflake DSR Enrichment

      Enrich privacy requests with extra user identifiers from Snowflake

      Before You Start

      1. Make sure you have access to your Snowflake account.
      2. Request access to the MineOS 'Automations' feature, if you don't already have it.

       

      Setting Up

      1. Login to your MineOS account and goto Settings -> Automations.
      2. Select Marketplace and search for "Snowflake DSR Enrichment". Click it and select Configure.
        Screenshot 2024-12-31 at 17.23.58
      3. Skip the initial configuration screen by clicking Next.
      4. Under the Authentication section fill in all the required fields to access to desired Snowflake account: Private key, Pass phrase, Username, Account Identifier, Account Locator, Identifier URL and Role.
        1. For help creating a key pair and attaching it to a Snowflake user, follow this article: https://docs.snowflake.com/en/user-guide/key-pair-auth
        2. For help on finding your account identifiers, follow this article: https://docs.snowflake.com/en/user-guide/admin-account-identifier

        Screenshot 2024-12-31 at 17.37.49
      5. Under the Enrichment Logic section:
        1. Select the target identifier type you are enriching. For example: If you are configuring an enrichment flow from email address to phone number, select $phoneNumber
        2. Set the Warehouse, Database, and schema from which you want to query the identifier.
          Screenshot 2024-12-31 at 17.42.12
        3. Type the SQL Query used to fetch the user's identifier. Note: you should use a positional parameter to represent the user's email address. Example query to lookup phone number by email address: 
          select C_PHONE from MY_DB.TPCH_SF1.CUSTOMERS where address = ? limit 1;
        4. Click Finish. You should see a Green checkmark noting the integration has been configured properly.
        5. Lastly, reach out to your CSM so we can activate the integration for you, and verify its working as expected.

       

      Reconfiguring The Integration

      If you want to change any of the settings, go back to the integration and select "Reconfigure". The setup flow will appear allowing you to change any of the existing config fields.