Resolve Snowflake pipeline configuration and validation issues
Learn how to diagnose and fix validation errors in the Reltio Snowflake staging pipeline for Azure.
This topic helps you identify and fix common failures when setting up or validating the Reltio Data Pipeline for Snowflake on Azure. It combines troubleshooting guidance and required configuration rules in one place.
How to validate your configuration
After configuring the Snowflake connector, you can use the following endpoint to validate it:
POST /api/tenants/{tenantId}/adapters/{adapterName}/validate
Authorization: Bearer <access_token>
Use client_credentials authentication to retrieve the token. The response includes HTTP status and any error details if validation fails.
Common configuration errors and how to fix them
During pipeline setup, your adapter validation may fail with errors. These errors typically indicate a problem with authentication, naming rules, schema mismatch, or Azure network access controls. See the following table for more information.
| Error message | Cause | Fix |
|---|---|---|
| Signature did not match | SAS token or shared key is invalid or expired | Recreate the Azure credential. Enable Azure-Storage-Log-String-To-Sign for debugging. Disable it in production. |
| AuthorizationFailure (403) | Reltio IP not whitelisted in Azure Storage firewall | Add the Reltio IP to your storage account’s allowed IP list. |
| Queue name is invalid | Queue contains hyphens or special characters | Use only alphanumeric characters for queue names. |
| Adapter name too long | Name exceeds 20 characters | Rename the adapter to a shorter identifier. |
| Missing required column: createdBy | Staging table does not include required schema | Ensure your entities table includes createdBy, createdTime, commitTime, and other required fields. |
| Snowflake COPY INTO fails silently | Storage integration name is lowercase | Use all uppercase for Snowflake integration names (e.g., RELTIO_SNOWFLAKE_STORAGE_INT). |
Requirements for connector configuration
Follow these requirements to ensure a successful pipeline setup:
- Adapter name must be 20 characters or fewer
- Queue name must be alphanumeric only (no hyphens)
- Snowflake integration names must be uppercase
- Staging table columns must match exactly in name and data type
- Required fields include
createdBy,commitTime,updatedTime
Diagnosing pipeline errors
To investigate pipeline errors, use the following tools and logs:
- Reltio Adapter Validation API (
/validate) - Snowflake task and pipe history in UI
- Azure Storage diagnostic logs (enable
Log-String-To-Sign) - Reltio Mezmo logs (if available for your environment)