New teams get free Claude credits for their trial. Learn more

Now you can do analytics without ETL

April 21, 2026•5 min read•Vivek Sah

Hi, this is Vivek, building Contextflo. I share practical notes on getting answers from your data, a couple of times a month.

Now you can do analytics without ETL

Your data lives in five different places. The traditional path to analytics is: build ETL pipelines, load everything into a warehouse, model the data, then query it. That takes weeks. You can start getting answers right now.

ETL pipelines vs direct connections

The ETL tax

Before anyone at your company can ask what revenue by channel looks like this month, somebody has to:

  1. Set up a data warehouse (BigQuery, Snowflake, Redshift)
  2. Build ETL pipelines from every source
  3. Handle schema changes, deduplication, incremental loads
  4. Model the data so the tables make sense together
  5. Connect a BI tool and build dashboards

That is weeks of engineering before a single business question gets answered. For many startups the pipeline is never done. It is always breaking, always behind, always missing the one source somebody needs.

Meanwhile the founder is still asking an engineer to pull Stripe revenue and compare it to what Amplitude shows for paid conversions. The engineer writes two queries, pastes them into a spreadsheet, and joins the data by hand. Every time.

What if you could skip straight to the answers?

Contextflo connects directly to your data sources (your database, Stripe, Amplitude, Google Analytics, HubSpot) and lets you query across all of them in one conversation. No warehouse required for API sources, no pipelines to build first.

How does our Amplitude retention compare to Stripe revenue by monthly cohort?

Which campaigns in GA drove the most revenue in Stripe last quarter?

Show me deal pipeline by stage from our CRM alongside actual revenue from the database.

Each of those crosses two systems that have never been in the same query. That is the class of question a pipeline exists to enable, and the reason it usually takes a quarter to get one.

What connects

DatabasesAPI sources
PostgresStripe
BigQueryAmplitude
SnowflakeGoogle Analytics
ClickHouseHubSpot
Redshift
Databricks

A real example

One of our customers is a private equity fund. Their deal data lives across multiple systems: different databases, different formats, different teams managing each. Before Contextflo, a unified view of the portfolio meant asking someone to pull from each system and stitch it together in a spreadsheet.

Now a director at the fund, who does not write SQL, asks questions across all of it in one conversation. No pipelines were built. No warehouse was provisioned. They connected their sources and started asking.

When you still need ETL

This does not replace ETL for everything, and it is worth being precise about where the line is.

If you are processing millions of events, need deduplication, or have transformations feeding ML models, you want proper pipelines and a warehouse. Querying APIs directly also means you are subject to their rate limits and their idea of how far back history goes, which is fine for a question and bad for a nightly job.

There is a subtler one too. A pipeline is where you fix data: dedupe, conform currencies, resolve one customer across systems. Query it live and that cleanup has not happened, so cross-source answers are only as good as how well the raw sources already agree. Often that is good enough to be useful and worth knowing before you trust a number.

But if your immediate problem is that answers live in five places and nobody has time to build pipelines, you do not need to wait. Connect the sources, start asking, and build the warehouse later when it earns itself.

Start now, optimise later

The best analytics setup is the one your team actually uses. Connect your sources in about ten minutes and let people start asking across all of them today.

Here is a more in-depth look at Contextflo and how it works.

What is Contextflo?

Contextflo is a governed context layer between your data and the AI your team already uses. Connect your warehouse once, and your team asks questions in their own Claude or ChatGPT. The model writes and runs the SQL; Contextflo supplies the definitions, the per-user access control, and the audit that make the answers trustworthy. Your data never moves, and you do not need a data team.

How it works

1
Connect your data
Point Contextflo at your warehouse or database, or upload a CSV. It reaches multiple sources at once, so a single question can span all of them.
2
Generate context automatically
Connect your code repo, Notion docs, or a data dictionary, and Contextflo annotates each table in your data source where it can. You review and correct them. That becomes the foundational context layer: your AI agent does not just see tables, it sees the context around them.
3
Define metrics and save golden queries
Pin the verified SQL behind a metric once. Every question then resolves against the same definitions, so the number is consistent no matter who asks or how they phrase it.
A short walkthrough on a BigQuery warehouse.

Your team queries in their own Claude or ChatGPT over MCP, so you bring any agent rather than a locked-in bot, and every answer comes back with the SQL shown and access enforced per user.