Integrations / Databases
Connect Snowflake Basic to WhatsApp: tables by chat
Flann is an AI agent your business talks to on WhatsApp. Connect Snowflake Basic once, then ask Flann to look things up in it or get work done in it, by text or voice note. Analytics tools answer questions well, provided you know where to click. Flann does the clicking. You ask in plain words on WhatsApp, it queries Snowflake Basic and replies with the figure and a sentence on what it means.
6 actions in Snowflake Basic. 5 only look things up, and 1 create, update, send or delete. You connect with your API key.
What Flann can work with in Snowflake Basic
Snowflake Basic gives Flann 6 actions across 2 kinds of record. These are the ones you are most likely to use.
| Record | What Flann can do | Actions |
|---|---|---|
| Tables | look up | 2 |
There are three ways to get tables work done in Snowflake Basic. Side by side:
| Compare | Snowflake Basic on its ownEvery step is yours | A rules toolRuns the steps you wired up | With FlannThe work comes to your chat |
|---|---|---|---|
| How you ask | Open the app and find the right page | Only what was wired up in advance | A WhatsApp message, typed or spoken |
| Finding answers about tables | Filters and searches you run yourself | Only the look-ups someone built | 5 look-ups, answered straight away |
| Making changes | Typed in by hand | Run unchecked once built | 1 change, made from a message |
| Getting connected | Nothing new to set up | Someone builds and maintains each flow | Your Snowflake Basic API key, once |
YesPartlyNo
Step by step: Snowflake Basic jobs you can hand to Flann
Each step below names the Snowflake Basic action Flann actually runs.
Get answers about your tables
- You message Flann on WhatsApp: “What is the latest on our tables in Snowflake Basic?”
- Flann runs
Show TablesandDescribe tablein Snowflake Basic and shows you what it found. - Nothing in Snowflake Basic is changed: these are look-ups, so they run straight away.
Check your databases from WhatsApp
- You message Flann on WhatsApp: “Show me where our databases in Snowflake Basic stand.”
- Flann runs
Show databasesin Snowflake Basic and shows you what it found. - Nothing in Snowflake Basic is changed: these are look-ups, so they run straight away.
Repetitive Snowflake Basic work Flann takes off your plate
These are the jobs that come back every day or every week. Message Flann instead, and keep the decisions for yourself.
Seeing where visitors came from
Today
You put an offer out last week and want to know whether it brought people to the website. The answer is in Snowflake Basic, several menus deep.
With Flann
“Where did website visitors come from this week, and how did the offer page do?”
Traffic sources and page visits are read from Snowflake Basic and explained plainly: which channels sent people, how the offer page compared with your usual pages, and whether visitors booked or bought. No talk of sessions or bounce rates unless you ask. Nothing is changed.
What you stop doing: Clicking through analytics menus to judge an offer is behind you.
Building the monthly report
Today
Your accountant, partner or investor wants a monthly summary. You copy figures out of Snowflake Basic into a document and format them, and it is always later than you promised.
With Flann
“Draft the monthly summary for my business partner from Snowflake Basic.”
The month’s key figures come out of Snowflake Basic, set against the previous month and the same month last year, with a short sentence on each change. You read the draft in the chat and ask for edits.
What you stop doing: Copying figures into a document every month is no longer your job.
More on this: how to hand repetitive tasks to an AI agent on WhatsApp.
How Flann connects to Snowflake Basic
- Open Connectors in Flann and choose Snowflake Basic.
- Paste your Snowflake Basic API key into the secure form Flann opens. You will find the key in your Snowflake Basic account settings.
- Ask Flann for what you need on WhatsApp, by text or voice note. It picks the right Snowflake Basic action itself.
Look-ups run as soon as you ask and change nothing in Snowflake Basic. You can disconnect Snowflake Basic from Connectors at any time.
Ways to use Snowflake Basic with Flann
Ask, do not dig
Ask how this week compares to last. Flann pulls the numbers from Snowflake Basic and answers in plain words.
Check before you decide
Before a big call, ask Flann for the figure that matters. It looks it up in Snowflake Basic first.
A weekly summary on demand
Ask Flann for the week in brief. It reads Snowflake Basic and sends the few numbers worth knowing.
Everything Flann can do in Snowflake Basic
The full list of Snowflake Basic actions available to Flann once you connect it.
Looks up 5
- Describe table
- Explore Columns
- Show databases
- Show schemas
- Show Tables
Changes 1
- Run Query
More Databases apps Flann works with
Common questions
What can Flann do with tables in Snowflake Basic?
Flann can look up tables in Snowflake Basic, using 2 actions (Describe table, Show Tables). All of them only look things up, so they run straight away.
How does Flann connect to Snowflake Basic?
Open Connectors in Flann, choose Snowflake Basic and paste your Snowflake Basic API key into a secure form. You will find the key in your Snowflake Basic account settings. Once it is connected, Flann can use 6 actions in Snowflake Basic.
Can I use Snowflake Basic from WhatsApp?
Yes. You talk to Flann on WhatsApp or in the Flann app, by text or voice note, and Flann works in Snowflake Basic for you. You do not need to open Snowflake Basic.
Does connecting Snowflake Basic cost extra?
No. Snowflake Basic is included in every Flann plan, along with every other app Flann connects to.