The Zero-Copy configuration establishes the federated query connection between Treasure Data and your Snowflake instance.
Important
To prevent case-sensitive configuration errors, always use uppercase when naming the Warehouse and Database.
- In the Treasure Console, navigate to Data Workbench > Integrations > Integration Hub.
- Select Zero-Copy > Snowflake.
- Fill in the connection details:
| Parameter | Description | Example |
|---|---|---|
| Account | Your Snowflake account identifier | abc12345.us-east-1 |
| Warehouse | Snowflake warehouse for executing queries | COMPUTE_WH |
| Database | Database containing your Parent Segment tables | CDP_DATABASE |
| Schema | Default schema for your tables | public |
| User | Snowflake user with the assigned public key | TD_SERVICE_USER |
| Authentication | Select Key Pair and paste the private key content | Contents of rsa_key.p8 |
| Role | Snowflake role with SELECT permissions (optional) | TD_READONLY_ROLE |
- Click Test Connection to verify connectivity.
- Save the configuration.
After saving, the configuration is assigned a federatedQueryConfigId (e.g., 167). You need this ID in the next step.
You can find it in the configuration details within the Integration Hub. Use the first three numbers as the federatedQueryConfigId.
Reference
For more details, see Live Connect Zero Copy with Snowflake.