Connect Snowflake when Roomote needs warehouse context to answer data-heavy
questions or support an investigation.
When to use it
- Inspect schemas or tables related to a task
- Query warehouse data while debugging a product or operations issue
- Connect engineering work to the analytics warehouse your team already uses
How setup works
Admins connect Snowflake from Settings > Integrations with an account
identifier, username, role, and PKCS8 PEM-encoded private key. Add the matching
public key to the Snowflake user first. Supply the private-key passphrase too
when the key is encrypted.
The execute_sql tool can run any statement permitted by the configured
Snowflake role, including statements that change data or schema. Use a
dedicated least-privilege role, preferably read-only when tasks only need
warehouse context.
What to expect
Snowflake provides shared data warehouse context inside Roomote tasks.
Engineering changes and approvals still happen through your normal task and
repository review flow.
Recipes using this
