3,016 karma · joined March 16, 2015
Definite is ETL, a data warehouse and BI in one app.
Previously founded SeekWell (https://seekwell.io/), acquired in 2021.
twitter: https://twitter.com/thisritchie
email: mike@definite.app
meet.hn/city/us-Philadelphia
Show HN: I've built a C# IDE, Runtime, and AppStore inside Excel
670 points | 179 comments
One of the main use cases was to analyze Excel data with SQL. I'm the kind of nerd that loves stuff like that, but stuff like that seems completely obsolete now.
we have a custom .yaml spec for data pipelines in our product and the agent follows it as well as anything in the training data.
while I agree you don't need to build a new thing "for agents", you can get them to understand new things, that are not in the training data, very easily.
yep, that's what Definite is for: https://www.definite.app/
All the data infra (datalake + ELT/ETL + dashboards) you need in 5 minutes.
we run datalakes using DuckLake and this sounds really useful. GCP should follow suit quickly.
We run a lakehouse product (https://www.definite.app/) and I still don't get who the user is for cortex. Our users are either:
non-technical: wants to use the agent we have built into our web app
technical: wants to use their own agent (e.g. claude, cursor) and connect via MCP / API.
why does snowflake need it's own agentic CLI?
When I see the title here, I think "BI with an embedded database", which is what we're building at Definite. A lot of people want dashboards / AI analysis without buying Snowflake, Fivetran, BI and stitching them all together.
I'm curious what others are seeing connecting AI tools to Snowflake. Snowflake charges $3 per compute hour and it's pretty easy for an agent to run dozens of queries asynchronously.
As others have mentioned, if you want a notebook, compare this hard against Hex. It's unclear what LiveDocs would give you over Hex (cheaper maybe?).
ps - if you don't have Snowflake / data warehouse yet, we give you a full data platform (data lake + pipelines + dashboards + agent) at https://www.definite.app/.
I guess they mean BI, but for a company of any scale, they aren't paying for a chart, they're paying for a permissions system, query caching, a modeling layer, scheduling, export to excel, etc.
Stand alone BI tools are going to struggle, but not because they can easily be vibe coded. It'll be because data platforms have BI built-in. Snowflake is starting down this direction and we're (https://www.definite.app/) trying to beat them to it.
I ended up building a terminal[0] with Tauri and xterm that works exactly how I want.
0 - screenshot: https://x.com/thisritchie/status/2016861571897606504?s=20
if the bank makes mistakes in fraud, they just eat the cost.
what AI are you using where this still works?
We give you all of this in 5 minutes at https://www.definite.app/.
And I mean all of it. You don't need Spark or Snowflake. We give you a datalake, pipelines to get data in, semantic layer and a data agent in one app.
The agent is kind of the easy / fun part. Getting the data infrastructure right so the agent is useful is the hard part.
i.e. if the agent has low agency (e.g. can only write SQL in Snowflake) and can't add a new data source or update transformation logic, it's not going to be terribly effective. Our agent can obviously write SQL, but it can also manage the underlying infra, which has been a huge unlock for us.
> This replaces about 500 lines of standard Python
isn't really a selling point when an LLM can do it in a few seconds. I think you'd be better off pitching simpler infra and better performance (if that's true).
i.e. why should I use this instead of turbopuffer? The answer of "write a little less code" is not compelling.
It's funny to look back at the tricks that were needed to get gpt3 and 3.5 to write SQL (e.g. "you are a data analyst looking at a SQL database with table [tables]"). It's almost effortless now.
datalake (DuckLake), pipelines (hubspot, stripe, postgres), and dashboards in a single app for $250/mo.
marketing/finance get dashboards, everyone else gets SQL + AI access. one abstraction instead of five, for a fraction of your Snowflake bill.
I have a claude skill `/record` that runs the CLI which starts a new recording. I debug, research, etc., then say "finito" (or choose your own stopword). It outputs a markdown file with your transcribed speech interleaved with screenshots and text that you copied. You can say other keywords like "marco" and it will take a screenshot hands-free.
When the session ends, claude reads the timeline (e.g. looks at screenshots) and gets to work.
I can clean it up and push to github if anyone would get use out of it.