---
title: Snowflake DSR Enrichment
description: Enrich privacy requests with extra user identifiers from Snowflake
---

[Skip to content](https://docs.mineos.ai/knowledge/snowflake-dsr-enrichment#main-content)

[![Mine](https://docs.mineos.ai/hs-fs/hubfs/Frame%201948756858.png?width=62&height=40&name=Frame%201948756858.png)](https://docs.mineos.ai/knowledge)

Open main navigation

Close main navigation

 Hello! How can we help you?

- There are no suggestions because the search field is empty.

1. [Help center](https://docs.mineos.ai/knowledge)
2. [DSR Handling](https://docs.mineos.ai/knowledge/dsr-handling)
3. [Setting Up Rights & Workflows](https://docs.mineos.ai/knowledge/dsr-handling#setting-up-rights-workflows)

# 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](https://docs.mineos.ai/hs-fs/hubfs/Screenshot%202024-12-31%20at%2017.23.58.png?width=670&height=524&name=Screenshot%202024-12-31%20at%2017.23.58.png)
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](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](https://docs.snowflake.com/en/user-guide/admin-account-identifier)
     
   ![Screenshot 2024-12-31 at 17.37.49](https://docs.mineos.ai/hs-fs/hubfs/Screenshot%202024-12-31%20at%2017.37.49.png?width=670&height=513&name=Screenshot%202024-12-31%20at%2017.37.49.png)
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](https://docs.mineos.ai/hs-fs/hubfs/Screenshot%202024-12-31%20at%2017.42.12.png?width=670&height=532&name=Screenshot%202024-12-31%20at%2017.42.12.png)
     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.

- [Data Inventory](https://docs.mineos.ai/knowledge/data-inventory#main-content)

    - [Systems](https://docs.mineos.ai/knowledge/data-inventory#systems)
    - [Data types](https://docs.mineos.ai/knowledge/data-inventory#data-types)
    - [Activities](https://docs.mineos.ai/knowledge/data-inventory#activities)
- [Compliance Operations](https://docs.mineos.ai/knowledge/compliance-operations#main-content)

    - [Compliance reports](https://docs.mineos.ai/knowledge/compliance-operations#compliance-reports)
    - [Policies & alerts](https://docs.mineos.ai/knowledge/compliance-operations#policies-alerts)
    - [Risk assessments](https://docs.mineos.ai/knowledge/compliance-operations#risk-assessments)
- [DSR Handling](https://docs.mineos.ai/knowledge/dsr-handling#main-content)

    - [Setting Up Channels](https://docs.mineos.ai/knowledge/dsr-handling#setting-up-channels)
    - [Configuring Responses](https://docs.mineos.ai/knowledge/dsr-handling#configuring-responses)
    - [Processing Requests](https://docs.mineos.ai/knowledge/dsr-handling#processing-requests)
    - [Audit & Reporting](https://docs.mineos.ai/knowledge/dsr-handling#audit-reporting)
    - [Setting Up Rights & Workflows](https://docs.mineos.ai/knowledge/dsr-handling#setting-up-rights-workflows)
- [Integrations](https://docs.mineos.ai/knowledge/integrations#main-content)

    - [General information](https://docs.mineos.ai/knowledge/integrations#general-information)
- [Settings & Security](https://docs.mineos.ai/knowledge/settings-security#main-content)

    - [Security](https://docs.mineos.ai/knowledge/settings-security#security)
    - [Your Account](https://docs.mineos.ai/knowledge/settings-security#your-account)
- [Developers Documentation](https://docs.mineos.ai/knowledge/developers-documentation#main-content)

    - [Portal for developers](https://docs.mineos.ai/knowledge/developers-documentation#portal-for-developers)
    - [Webhook](https://docs.mineos.ai/knowledge/developers-documentation#webhook)
    - [Other](https://docs.mineos.ai/knowledge/developers-documentation#other)
- [Release Notes](https://docs.mineos.ai/knowledge/release-notes)
- [Consent Management](https://docs.mineos.ai/knowledge/consent-management)

[![Frame 1948756858](https://docs.mineos.ai/hs-fs/hubfs/Frame%201948756858.png?width=62&height=40&name=Frame%201948756858.png "Frame 1948756858")](https://mineos.ai/)

Copyright © 2026, "MineOS" (Saymine Technologies Inc)