Snowflake Connector

1Connect

2Select Tables

3Process

4Download

<\!-- Step 1 -->

Connect to Snowflake

Enter your Snowflake account details. Supports username/password and key-pair authentication.

Account URL

Your full Snowflake account identifier URL

Warehouse

Virtual warehouse to run queries against

Database

Schema

Role (optional)

Leave blank to use default role

Authentication method

Username

Password

Setup checklist

Create a dedicated service user:
CREATE USER ADAM_SVC PASSWORD='...' DEFAULT_ROLE=READONLY;

Create a read-only role and grant it:
GRANT ROLE READONLY TO USER ADAM_SVC;

Grant SELECT on your schema:
GRANT SELECT ON ALL TABLES IN SCHEMA db.schema TO ROLE READONLY;

Grant warehouse usage:
GRANT USAGE ON WAREHOUSE COMPUTE_WH TO ROLE READONLY;

Find your account URL in Snowsight → Admin → Accounts

<\!-- Step 2 -->

Select tables to process

Connected to myorg-myaccount · ANALYTICS.PUBLIC — 6 tables found

Select Snowflake tables to anonymise.

CUSTOMER_DATA1.2M rows · 16 colsTABLE ORDER_HISTORY8.4M rows · 11 colsTABLE SESSION_EVENTS42M rows · 9 cols · clusteredTABLE PRODUCT_CATALOGUE12,000 rows · 20 colsTABLE REVENUE_SUMMARY84,000 rows · 7 colsVIEW ML_FEATURES2.1M rows · 34 colsTABLE

Schema preview — CUSTOMER_DATA

ANALYTICS.PUBLIC.CUSTOMER_DATA · TABLE

Column	Data Type	Nullable	Default
CUSTOMER_ID	VARCHAR(36)	N
EMAIL	VARCHAR(255)	Y
FIRST_NAME	VARCHAR(80)	Y
LAST_NAME	VARCHAR(80)	Y
DATE_OF_BIRTH	DATE	Y
CREATED_AT	TIMESTAMP_NTZ	N	CURRENT_TIMESTAMP

<\!-- Step 3 -->

Processing tables

Pulling data from Snowflake via JDBC, running PII detection, and applying anonymisation.

[14:22:01] Connected to myorg-myaccount.snowflakecomputing.com

[14:22:01] Warehouse: COMPUTE_WH · Database: ANALYTICS · Schema: PUBLIC

[14:22:02] Starting processing run for 2 tables

<\!-- Step 4 -->

Download anonymised data

Processing complete. Your anonymised Snowflake exports are ready.

CUSTOMER_DATA_anon

1.2M rows · Parquet · 94 MB

ORDER_HISTORY_anon

8.4M rows · Parquet · 410 MB

Provenance Report

PII detection + anonymisation audit

Explore Data →