Troubleshooting

Common issues

Common issues found when running these scripts can include the following:

• Role Access Denied. Contact your Snowflake administrator to ensure you have access to samooha_app_role.
• Warehouse Not Found. Verify the warehouse name and your permissions to use it.
• Clean room Not Found Confirm your clean room name with your Instacart representative.
• Template Errors. Verify your clean room name and ensure all parameters are properly formatted.

Issues when running Overlap Analysis

If you encounter issues when running the Overlap Analysis script, try the following:

• Verify identifier hashing algorithms match expected format.
• Check data quality and recency of identifier sources.
• Ensure proper formatting of identifier types.
• Confirm consumer table has required columns (IDENTIFIER_TYPE, IDENTIFIER_VALUE).
• Validate identifier type values are HEM or HASHED_IP_ADDRESS.
• Check for null values in required fields.

Getting help

If you encounter issues during setup, contact data-hub@instacart.com with:

• Your Snowflake account identifier
• Error messages received
• Steps you’ve already tried