Suresh - ELMO
04/20/2026, 2:47 AMAnswer Overflow
04/20/2026, 2:47 AMspotter-code
04/20/2026, 2:48 AMaccountName, user, password, role, warehouse (for service-account style auth). I could not find documentation indicating a Snowflake private_key field in that connection metadata format. So if you put a PEM private key block into a variable mapped to password, ThoughtSpot/Snowflake auth can fail and surface a generic backend error (like your 10041 + Not Found).
## What to change
1. Keep DW_USER for user (good).
2. For Snowflake service-account connection, map DW_PASSWORD to an actual Snowflake password (not PEM key).
3. If your org requires key-pair auth, use the Snowflake auth mode/connection type that explicitly supports it (rather than forcing key text into password). In the tool results I got, that exact key-pair parameterization path is not documented for the standard Snowflake configuration block, so I can’t confirm it exists in this flow.
4. Validate by updating only the connection first (without publish), then test table access, then publish.
## About your hybrid objective (existing duplicated + new published)
Your approach is conceptually correct:
- Existing content can remain duplicated per tenant.
- New content can be rolled out via publish/share.
- The key is: published objects must resolve dependencies (connection + model/table access) cleanly in target orgs.
So first stabilize connection credentials format, then proceed with publish/share.
## Why this is likely step 3 specifically
You reported failure when parameterizing existing connection with:
- DW_USER = username
- DW_PASSWORD = private key PEMspotter-code
04/20/2026, 2:48 AMpassword expects a password string, not PEM key content. That aligns exactly with your observed failure pattern.
---
If you want, I can help you with a safe migration sequence (no disruption) for moving from duplicate-only to hybrid publish, including dependency checks before each publish wave.Suresh - ELMO
04/20/2026, 3:12 AMSuresh - ELMO
04/20/2026, 5:49 AMSwarnika
04/23/2026, 3:47 AM