← Todos os guias
Guia do Playbook · Grátis

Ask Your Snowflake Data Questions Through Your Muse

Verificado 2026-11-13

Through a custom connector, your muse can ask questions of data held in Snowflake, using the governed tools your admin set up.

What it does

The connector bridges to a Snowflake managed server inside your own Snowflake account. That server holds the tools your admin defines, up to 50 per server. The tool types are a Cortex Agent for governed business questions, a Cortex Analyst semantic view that turns a question into SQL and shows that SQL, a Cortex Search service for unstructured text, direct SQL execution, and your own functions or stored procedures. Access is governed by Snowflake roles, so the muse sees only what that role can see. Agent answers can include reasoning steps and citations.

How to use it

  1. Have a Snowflake admin create the server object in the database and schema that should hold it, with the tools your team wants.
  2. Create a limited role and grant it use of the server and each tool, plus a default warehouse.
  3. Create a programmatic access token for that user, restricted to that role and set to expire, and copy the secret shown once.
  4. Allow the network address AnythingMCP calls from in the Snowflake network policy.
  5. Start an AnythingMCP account and add the Snowflake connector with the account host, database, schema, server, and token.
  6. In Muse, open Settings, then Connectors, and add a custom connector with the address AnythingMCP gives you. Sign in, approve, and ask a plain business question.

What you need

  • A Muse account that can add custom connectors
  • An AnythingMCP account with the Snowflake connector added
  • A Snowflake account with a managed server object set up by an admin
  • A programmatic access token restricted to a limited role

What to watch for

  • Setup takes about 15 minutes and needs an admin. The tools are the ones your admin defines, so a question outside those tools cannot be answered this way.
  • The role is the real boundary. Prefer a Cortex Agent or Cortex Analyst tool over raw SQL, and keep any SQL tool on its own server with its own limited role.
  • The SQL execution tool starts switched off. If it is turned on, keep it set to read only unless changes are truly needed.
  • Tools run on your warehouse and Cortex calls use credits. Large answers are cut at 250 KB, so ask for fewer columns or rows.
  • This is a custom connector, and Meta does not review custom connectors. You can disconnect it in Settings at any time. The muse prepares, you decide.

Experimentou este guia?

Conte para a comunidade como foi, ou peça ajuda para fazer funcionar.

Fale sobre isso no MuseFM →

Playbook Pro

Quer pular as lições?

Ajude o seu agente a aprender tudo de uma vez. 1,015 habilidades, um passe, $49 por 90 dias.

Obtenha o Pro Pass
Mais guias →