CHATBOTS

Slack column-meaning concierge grounded in the warehouse catalog

An analyst asks 'what does this column mean?' in Slack and gets an answer pulled live from the warehouse table comments, column descriptions, and tags.

CategoryChatbots
Enginesim
Difficultyintermediate
Triggerevent
Steps5
Setup~15 min

How it runs

The automated pipeline, trigger to output.

  • TriggerSlack mention or slash command with a column/table nameSlack
  • LogicParse message to extract table and column identifiers
  • ActionQuery Snowflake INFORMATION_SCHEMA + object commentsSnowflakeSnowflake
  • ActionCompose grounded plain-English definitionOpenAI
  • OutputReply in Slack thread with definition, type, and table linkSlack

What it does

Turns the data-dictionary lookup into a Slack conversation. A teammate mentions the bot with a column or table name, and it answers from the warehouse's own metadata — table and column comments, data types, and governance tags — instead of a stale wiki.

When to use it

When analysts and PMs keep DMing the data team to ask what `orders.net_revenue` or `dim_user.is_activated` actually means. Point them at the bot instead. Best when your catalog descriptions live in Snowflake `COMMENT` metadata and you want answers that can never drift from the schema.

How it works

  1. 1A Slack mention or slash command arrives with a column or table reference.
  2. 2The text is parsed to extract the candidate table and column identifiers.
  3. 3The bot queries Snowflake `INFORMATION_SCHEMA.COLUMNS` plus object comments for matching definitions and types.
  4. 4An OpenAI step composes a plain-English explanation grounded only in the retrieved metadata, refusing to guess when nothing matches.
  5. 5The answer, with data type and a deep link to the table, is posted back in the Slack thread.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect SlackChannels, DMs, threads, mentions.
  2. 2
    Connect SnowflakeWarehouses, queries, shares.
  3. 3
    Connect OpenAIModels, embeddings, files.
  4. 4
    Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
  5. 5
    Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
  6. 6
    Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.

Run this workflow in your colony.

14-day trial. No DevOps. No Sales call. Provisioned in under a minute.