DataPilot - AI Teammate for Data Teams. The team behind #dbtpoweruser vscode extension
Sunnyvale, California
Joined February 2024
- Tweets84
- Following10
- Followers30
- Likes29
Click any column in your dbt project and see its column-level lineage in VS Code.
Turn on relationships and it infers primary and foreign keys from your tests, contracts and semantic entities.
marketplace.visualstudio.com…
A Snowflake workload averages 23 minutes. Then one run takes over an hour. Where do you start?
We rule out three causes first: the warehouse, the task count and the code.
The fix was one of two, a larger warehouse size or the query split into smaller chunks. The ticket goes to Jira or Linear and points at one child query, fix attached.
Stored procedure cost disappears into your Snowflake warehouse bill.
Break it out: total cost per procedure, runs, execution time and warehouse. Sort by cost and the expensive ones are at the top.
app.snowflake.com/marketplac…
Hover over a ref() in your dbt model and see:
- the columns it pulls
- how many nodes it sits from the source
No jumping between files. dbt Power User for VS Code:
marketplace.visualstudio.com…
Snowflake has 16 AI service categories now, from Cortex Code to AI inference.
Do you know which one drives your AI bill? See the total, the daily trend and the spend per service in one view.
app.snowflake.com/marketplac…
Does your Snowflake cost review start with storage? It misses the pipeline that loads each table.
One table cost $0.04 a year to store and $204.93K a year to load.
So we check reads against writes too. Another table on the same screen had 0 reads against 186 writes in the last month. Check lineage before you drop one, because whole pipelines can come out this way.
The page shows how Altimate prices each table in full. How do you find the tables that get written every day and never read?
altimate.ai/use-cases/altima…
dbt unit tests are the ones teams skip.
Altimate Code proposes the test scenarios and the YAML. You pick one. Nothing is added until you approve it.
marketplace.visualstudio.com…
"Show me the 10 most expensive Snowflake queries in the last 30 days, grouped by pattern."
Altimate Studio answers in plain English, with the warehouse, the user and a citation link for each query.
app.snowflake.com/marketplac…
One click on a dbt model found 3 issues:
1. A correctness bug in the no-order case
2. A divide by a column that can be zero
3. An aggregation before the join
Profile Query in dbt Power User:
marketplace.visualstudio.com…
Your Snowflake compute cost rose 5% overnight. Would anyone notice before the invoice?
Write the alert as a sentence, switch it to a 5% rise vs the previous day, and send it to email or Slack.
app.snowflake.com/marketplac…
Dashboard revenue doubled after a dbt change. Which CTE broke it?
Profile every CTE and read the row counts. One jumps from 99 to 990 rows. That is your bad join.
dbt Power User for VS Code:
marketplace.visualstudio.com…
Which line on your Databricks bill gets the least attention? For one customer it was model serving.
3 endpoints had zero requests for 30 days and still billed $19,800 a month. Altimate flagged them, and the fix saved $240K a year.
