# Step 3: Configure Zero-Copy in Data Workbench

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.

## Steps

1. In the Treasure Console, navigate to **Data Workbench** > **Integrations** > **Integration Hub**.
2. Select **Zero-Copy** > **Snowflake**.
3. 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` |


1. Click **Test Connection** to verify connectivity.
2. Save the configuration.


## Record the Federated Query Config ID

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](/products/customer-data-platform/integration-hub/zero-copy/live-connect-zero-copy-with-snowflake).