CHATBOTS
Slack daily schema-change digest for warehouse columns
Each morning the bot diffs the Snowflake catalog against yesterday's snapshot and posts a Slack digest of new, renamed, dropped, and re-typed columns so the team learns about…
How it runs
The automated pipeline, trigger to output.
- TriggerScheduled morning run
- ActionRead current column inventory from SnowflakeSnowflake
- ActionLoad prior snapshot and diff from PostgresPostgres
- LogicClassify changes; skip if none
- ActionWrite grouped change digest, breaking changes firstOpenAI
- OutputPost digest to Slack and save new snapshot to PostgresSlack
What it does
Proactively reports what changed in the warehouse. On a schedule it compares the current Snowflake schema to a stored snapshot and posts a plain-English digest of added, removed, renamed, and type-changed columns to a Slack channel.
When to use it
When silent schema changes break downstream dashboards and nobody finds out until a metric goes blank. Use it to give analysts a daily heads-up and a paper trail of structural changes across key schemas.
How it works
- 1A scheduled trigger fires each morning.
- 2The bot reads the current column inventory from Snowflake INFORMATION_SCHEMA for the watched schemas.
- 3It loads the prior snapshot from Postgres and diffs the two sets to classify adds, drops, renames, and type changes.
- 4A logic step skips posting entirely when there are no changes.
- 5An OpenAI step writes a concise, grouped digest highlighting breaking changes first.
- 6The digest posts to the data Slack channel, and the new snapshot is written back to Postgres for tomorrow's comparison.
Set it up
What you configure once, before turning it on.
- 1Connect SlackChannels, DMs, threads, mentions.
- 2Connect SnowflakeWarehouses, queries, shares.
- 3Connect PostgresAny Postgres URL — query, write, migrate.
- 4Connect OpenAIModels, embeddings, files.
- 5Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
- 6Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
- 7Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.
More Chatbots workflows
Discord WAF False-Positive Triage from Ray ID
When a user posts a Cloudflare ray ID in a Discord support channel, the bot looks up the blocked request's WAF event, classifies whether it looks like a genuine false positive.
Agentic WAF Investigator with Discord Approval Gate
An autonomous agent investigates a Discord-reported WAF block end to end: pulls Cloudflare logs, correlates with PagerDuty incidents, decides if an allowlist is safe.
Discord Onboarding Completion to CRM Sync
The moment a member finishes Discord onboarding, captures their submitted profile answers, creates or updates a contact in HubSpot.
Draft WAF Allowlist Proposal to Linear from Discord Report
Lets a support engineer confirm a Discord WAF report is a false positive, then auto-drafts a scoped Cloudflare allowlist rule proposal and files it as a Linear ticket…
Discord FAQ Free-Text Answer Grader
When a member submits a free-text answer in their onboarding thread, an agent grades it against the canonical FAQ knowledge base, replies with targeted feedback.
Discord FAQ-Gated Role Concierge
Greets each new Discord member in a private onboarding thread, walks them through required FAQ steps one at a time.
Run it inside a business
This workflow drops into a full company template. Import the org, and this is one of the playbooks its agents run.
Run this workflow in your colony.
14-day trial. No DevOps. No Sales call. Provisioned in under a minute.