🏗 Your entire analytics engineering workflow 🧪 Built by @dbt_labs
Fishtown, Philadelphia
- Tweets 1,102
- Following 69
- Followers 14,849
- Likes 903
Swipe right if you move fast 🔥
It's a match, and it's official. @fivetran and dbt Labs have completed our merger to build the data infrastructure for agents.
Read the full announcement getdbt.com/blog/fivetran-dbt…
7
18
8,481
Peep that new logo...dbt just got a new look! Check out today’s announcement on branding, funding, and the future of dbt.
blog.getdbt.com/of-the-commu…
2
26
136
Big news today for @fishtowndata and the dbt community 🎉
blog.getdbt.com/fishtown-ana…
3
17
132
friends, in the grand scheme of things, the fact that dbt is no longer an acronym doesn't really matter, there are bigger fish to fry, but just for the record -- dbt is NOT an acronym. it's just 3 little letters -- dbt.
pass it on. the marketing team is tired.
22
5
122
dbt now officially supports Python! 🐍
Now you can use Python to take advantage of a broad range of off-the-shelf packages or run advanced statistical analysis, all from the same place you already deploy your SQL code.
👇 More here!
hubs.li/Q01q3Rb90
1
27
121
🕒 5 years
✔️ 5,000 commits
🙏 gratitude to the 150+ contributors
🎉 dbt Core v1.0 is LIVE 🎉
🧗♀️ greater stability
🏎 100x faster parsing speed
👋 goodbye breaking changes
Watch the unboxing live: hubs.li/Q010vfJV0
Read about it here: hubs.li/Q010vdkY0
3
21
103
The official dbt VS Code extension is just around the corner now.
Here’s another time-saving feature we’re stoked about: you’ll soon be able to preview the output of any CTE, without leaving your dbt model.
Join the dbt Launch Showcase on May 28 for more bit.ly/4iHBOho
3
17
97
6,911
Fishtown Analytics announces $12.9M fundraise to accelerate the product development of dbt 🎉
buff.ly/3eDWN4V
Huge thank you to the dbt community 🙏
1
24
92
Good DAG / Bad DAG
ALT base to staging to marts
ALT Marts reference both staging and base tables
7
3
84
Data is not easy, friends.
Most of these jobs are for Dialectical Behavior Therapy.
Search "dbt + SQL" and now we get a more accurate looking list with a (still impressive!) 1,547 jobs
3
2
73
People have been asking if there is a new person running this social media account because it's apparently "more spicy"
The answer is no. This is just what month 6 of a pandemic looks like.
2
71
1800 dbt Cloud customers
9000 companies using dbt
25k data professionals in dbt Community Slack
25 integrations with the dbt Cloud API
Thank you to all you wonderful humans who chose dbt and continue to push the boundaries of analytics engineering 🙏
weird day to be announcing big news, but here we are...
$222m series D, $4.2b valuation
Round led by our existing investor Altimeter with participation from Databricks and Snowflake
blog.getdbt.com/next-layer-o…
3
3
70
Looking for a summer project? 🤓 We've got a suggestion.
✨Introducing:✨The Analytics Engineering Certification exam, the first credential you can earn under the new 🏅 dbt Certification Program.
Registration opens today! More in our announcement: hubs.li/Q01c_qLJ0
1
11
63
Say hello to the newest dbt integration. 💜
hubs.li/H0ZNVyC0
The @_hex_tech + dbt integration surfaces metadata like test status and freshness from dbt right inside Hex. This gives your team confidence that the data they're analyzing is... actually fit for analysis.
6
64
Many thanks to @emilieschario for sharing these 🔥 job description templates (30/60/90d ramp plans included 😍):
getdbt.com/data-teams/analyt…
2
5
60
✨New blog post ✨
@jthandy on the future of dashboards
Read here: blog.getdbt.com/are-dashboar…
Continue the conversation here: bit.ly/3aqgdbK
11
52
There are 50 people on the waitlist for the next dbt Learn 😬
Is this the right time to let you all know that an on-demand version of dbt Learn will be available before the end of the month?
...also...it will be free
2
5
56
dbt Labs 🤝 @databricks
Our partnership is accelerating, with some exciting new developments. Including: dbt Cloud is now available on Databricks Partner Connect, so you can get started with dbt on the lakehouse in just a few clicks. 🎉
Much more here:
hubs.li/Q0186lfF0
3
14
53
It's happening! The dbt Semantic Layer has just officially launched in Public Preview. 🎉
15 total partner integrations include @AtlanHQ, @_Hex_tech, @ModeAnalytics, @Thoughtspot, and many more!
👇 Details here:
hubs.li/Q01q2dkR0
2
16
56
Look, if you want to capitalize dbt, no one can stop you.
But just be aware that there is a "no swag" list...
8
2
51
New (free + on-demand) data modeling course, hot off the press!
Christine Berger + Pat Kearns, analytics engineers @dbt_labs, unpack their process for migrating legacy SQL (as from a stored procedure) to modular data models in dbt: blog.getdbt.com/sql-refactor…
4
11
50
Happy to share a cyber monday drop you may actually enjoy:
The dbt Developer Blog, a platform for the dbt community to share knowledge you can only earn by doing the work.
Dive in at docs.getdbt.com/blog/welcome - some fantastic posts live today in 🧵
3
9
48
With the upcoming dbt VS Code extension, you can navigate through a live, interactive view of your dbt lineage. You can also go straight to the definition of any ref, macro, or column with a single click.
Join the dbt Launch Showcase on May 28 to see more bit.ly/4iHBOho
2
5
50
4,675
someone said they heard about dbt on NPR so naturally the conversation has turned to "if dbt was an NPR show"...
Contenders:
Wait, Wait, Don't Excel Me
How I Built This Data Model
7
5
45
😍😭😍🙏
The results are here from the extensive @DataCouncilAI survey in case you wondered: What are the most popular #OSS data projects of 2021? link.medium.com/ZlIQdMwNffb⠀
⠀
#dbt #airflow #superset #dagster #trino #prefect #Greatexpectations #spark #amundsen #dataengineering #opensource
2
8
46
The data world's hottest training program is now arriving in your living room...
On-demand Learn has EVERYTHING
💅🏽 data models
🧪 tests
🔎 jinja primer
📦 packages
📹 video footage of Kyle's cute dog
🤦♀️lame humor attempts
...and it's FREE!!!
courses.getdbt.com/
3
7
47
normal people: a day, yeah, I get it
analysts:
what do you mean by "day"
what do you mean by "hour"
what do you mean by "seven"
(h/t today's office hours...sorry if you missed it)
1
3
41
Webhooks in dbt Cloud are officially... a thing! 🎣
Now you can automatically notify other apps when certain events take place in dbt. Think: triggering real-time notifications in tools like Slack or PagerDuty based on dbt job status.
👇 More here: hubs.li/Q01D-kCg0
1
8
41
5,339
What's better than a DAG?
An extra vacation day? Ice cream for dinner? A quick question that is actually quick?
How about...
A DAG IN YOUR IDE 😲
blog.getdbt.com/on-dags-hier…
3
39
Big Coalesce drop: @databricks is launching a new dedicated dbt-databricks adapter, now in public preview. What does this mean?
🛠️ Even simpler installation process
✔️ Even better use of key Databricks functionality
📈 Even better performance
Read more: hubs.li/Q010lx2D0
4
10
36
How do data teams (not using dbt) document their data?
(answers from #dbtcoalesce)
Google Sheets
Confluence (this one came up a LOT) 😬
Notion
Pinned Slack messages 😂
Google Docs
Dry erase board & sticky notes 😅
Comments in Snowflake info schema
8
4
38
What if AI and BI didn’t have to be separate worlds? What if there was a way analytics teams could sprinkle in ML without breaking stride?
The new dbt integration from @continual_ai allows anyone who knows SQL to build pipelines featuring operational AI.
hubs.li/Q010XWBW0
8
32
📣 Calling all aspiring writers 📣
dbt Labs is hosting a technical writing mentorship program to transform your ideas into fully-fledged posts 📝 in 6️⃣ weeks.
Learn more about the program and how to apply here!
4
6
34
8,011
For the wonderful people who don't want to deal with...
🛠pip
😅homebrew
🤦hidden files in your home directory
😰coordinating upgrades across large teams
We bring you the dbt IDE: buff.ly/2RjEoiT 🎁
2
6
33
The dbt Fusion Engine public beta is live for BigQuery 🎉
This means:
• 𝗦𝗺𝗮𝗿𝘁𝗲𝗿 𝗦𝗤𝗟
• 𝗙𝗮𝘀𝘁𝗲𝗿 𝘄𝗼𝗿𝗸𝗳𝗹𝗼𝘄𝘀
• 𝗕𝘂𝗶𝗹𝘁-𝗶𝗻 𝗰𝗼𝘀𝘁 𝘀𝗮𝘃𝗶𝗻𝗴𝘀
• 𝗕𝗲𝘁𝘁𝗲𝗿 𝗴𝗼𝘃𝗲𝗿𝗻𝗮𝗻𝗰𝗲 (𝗰𝗼𝗺𝗶𝗻𝗴 𝘀𝗼𝗼𝗻)
Join the beta: bit.ly/44u0SDr
2
33
2,737
SPOTTED! dbt was on TV!!! 😍 🤩
Our head of professional services Jess Williams spotted dbt in an NBC segment featuring Lindsey Gamard.
Watch the full clip segment: today.com/video/some-america…
Lindsey, you have made our week!!! ❤️
2
1
31
🚀 Now in public beta: the dbt VS Code Extension, powered by Fusion.
The fastest way to build locally with:
• Autocomplete
• Inline CTE previews
• Instant renames
Available in the VS Code Marketplace. Fusion engine required.
Learn more: bit.ly/3HwQSRK
5
3
33
2,560
For those of you whole will be catching up on #dbtcoalesce sessions this weekend, here are links to the famous @crai_fish guides:
👋 Day 1: fishtownanalytics-8698602.hs…
🥔 Day 2: fishtownanalytics-8698602.hs…
🏄 Day 3: fishtownanalytics-8698602.hs…
1
4
29
Lagos, Nigeria is officially the fastest growing dbt Community Meetup 🚀
The group opened on September 9th, and already has ~180 members with 100 RSVPs for the first event on October 14th.
dbt Meetups are now happening on 5 out of 7 continents 🗺 👀
meetup.com/lagos-dbt-meetup/
4
1
31
It’s a big day! We've been included on this year's @Forbes #Cloud100 for the first time at #79. ☁️
But that's not all. We were also featured by @SalesforceVC in a conversation exploring what it means to be a values-first business.
👇Read it here: hubs.li/Q01jBcXs0
1
32
dbt Cloud is now available for Microsoft Fabric. What does that mean? Microsoft users can manage data complexity at scale. #MSIgnite #MicrosoftFabric 👇 Read more: getdbt.com/blog/dbt-cloud-is…
@msPartner
3
7
31
8,427
Long-running jobs got you down? 😴
The new model timing tab can help! 😃
1. See your longest-running model
2. Refactor, reschedule, or let it ride
3. Profit
Available to multi-tenant Team and Enterprise users in dbt Cloud. Check out the docs for more. hubs.li/Q010RP-J0
1
1
29
The dbt ecosystem is here...
@fivetran and @getcensus have released native integrations w/ dbt
Fivetran: fivetran.com/blog/fivetran-d…
Census: blog.getcensus.com/making-yo…
@jthandy's take: blog.getdbt.com/the-dbt-ecos…
3
29
Jan 2020 -- Announce Coalesce 🎉
April 2020 -- Cancel Coalesce 😭
September 2020 -- Announce Coalesce Online 😅
Wanna make bets on whether or not this thing will actually happen?
JOKING!
It's happening. For real.
buff.ly/39u2Jd8
1
10
27
dbt v1.3 is here! Spotlight on new 🌈 features in the latest release
... and a happy v1.0 birthday🎂 coming up for dbt-utils!
Learn more ⬇️ hubs.li/Q01pWhK00
10
25
The Coalesce agenda is going live THIS WEEK 👀
Here is just a bit of Day 1.
Excited?
Yeah, same.
Registration open here: crowdcast.io/e/coalesce2020
ALT 1. Taking off with dbt: JetBlue's dbt journey! 2. Using data clinics and dbt to transform your data team into a data platform 3. Analytics on your analytics 4. Getting started with technical blogging 5. Organizational epistemology. Or: How do we know stuff? 6. Auditing model layers and modularity with your DAG
1
1
25
Wow...ya'll are really excited about Kimball, huh.
@__dave's Coalesce session has like 300 people signed up 😂
getdbt.com/coalesce/agenda/k…
2
2
25
dbt Labs recently acquired Transform to improve on the dbt Semantic Layer. Curious about what's next for it? Today we’re sharing our first major update on the integration journey with you.
Included inside: the details on product plans and timelines. 🎯
hubs.li/Q01M-_C90
1
6
26
8,416
Ever wonder what a CTE is and why it's so hard to Google? 🤔
Or what SQL statements are considered DML vs. DDL? ⚖️
And what the heck "idempotent" means? 🤷
Learn about these terms and more in the Analytics Engineering Glossary 📖
hubs.li/Q019kZj00
6
25
Got🎖dbt certification* on your summer to-do list?
📚Now available: a study guide with tips from the dbt Labs team.
(*nope, not that other DBT certification)
Get the goods⬇️
hubs.li/Q01j1YWK0
6
23
Guess what? User-defined metrics can and likely will change over time. But how do you capture a complete version history in dbt if it is idempotent? 😱 Grace Goheen shows you how in her first dbt Developer Blog post 😎
hubs.li/Q01hkxtZ0
4
25
Did you all see the new Coalesce site? 👀
coalesce.getdbt.com/
Wanna talk about how pretty this is? ❤️
2
1
21
On dbt and Python: why it's time for dbt to turn polyglot hubs.li/Q01m3Tcx0
2
8
22
Happy day 1 of Coalesce! 🎉
🤓 shoutout to everyone whose calendar is cleared and notebook is ready
🏗 shoutout to our sponsors and fellow partners in the modern data stack
❤️shoutout to the @dbt_labs team who is ready to HOST all you beautiful people
#dbtcoalesce
2
3
20
🚀 The new dbt Fusion engine is now in public beta
Fusion is faster, smarter, and more efficient:
• Parse times up to 30x faster ⚡️
• Real-time SQL validation (no warehouse hit) 🧠
• Cut rebuilds and save ~10% on compute 💰
More on what’s new: bit.ly/3HwQSRK
5
24
1,853
ok!
Buckle up, let's talk about what's in store for Coalesce, the first analytics engineering conference.
🚀🚀🚀
/a thread
1
3
23
You want to use dbt. It makes your life less hectic. But what if your data is split between multiple warehouses, or even *gasp*... is in a legacy database?
Our own Amy Chen was on with the Trino team to explore Trino + dbt as a possible solution. trino.io/episodes/21.html
3
24
What's a data librarian? What can you do with streaming materialized views?
Exploring these and more in the 🆕 dbt Slack roundup: piped.video/watch?v=T0Z_ibd3…
Special thanks to @foundinblank and @problypicasso of @Netlify for sharing your stories.
2
9
23
✨Announcing ✨
Coalesce
The first analytics engineering conference
New York City
August 20-21
❤️Why we're doing this: buff.ly/2uRAdTE
🎟Get your ticket: buff.ly/2UjQITv
📣Pitch a talk: bit.ly/coalesce-call-for-spe…
5
23
Is deduplication a word? 🤷
Well, it is now!
Lauren Benezra walks you through getting rid of those tricky partial duplicates in your data in the latest dbt Developer Blog post.
A `distinct` command won't save you this time! Only Lauren can 🦸
hubs.li/Q01bqbNc0
1
2
20
🎉Announcing the second dbt Community Spotlight! bit.ly/3qfcSZk
🧑💻Each quarter, we'll keep highlighting community contributors who have gone the extra mile.
🏆This round features @Opiano_1, Jing Yu Lim, Alan Cruickshank, @FaithLierheimer, Owen Prough and @JayPeeDevlin.
2
4
21
6,634
OH MYLANTA dbt Cloud now supports Environment Variables!
Which means you can
🤝Clone private packages
💰Limit data processing in dev
🎨Create tests that behave differently by job
+ way more than I can fit bc I won't delete MYLANTA. How will you use them?
hubs.li/H0-4f3V0
3
21
"Every attribution method is wrong, but it’s important that everyone uses the same version of 'wrong'"
Who said it??
1
23
The ✨magic✨ of dbt is how simple it is to build data dependencies.
A ref function is all you need.
1
4
21
It's about time for a vibe check into analytics eng as a practice is developing...
Join @jasnonaz, @ericalouie and @emilyhawkins__
for a discussion on March 23rd to reflect on the results of the first State of Analytics Engineering Report.
Deets & reg 👇 bit.ly/3YDnWe1
1
4
21
7,481
Congrats to the Census team!!
The modern data stack + @getcensus = 🚀
We raised $16m from @sequoia and @a16z 🎉
What this really means is that we get to keep building the best product for data teams to operationalize their work and drive the business with more than just reports!
hubs.la/H0GS8qJ0
2
1
19
dbt Labs has been recognized as @SnowflakeDB’s Data Integration Partner of the Year! 🎉
It’s a testament to the incredible results that customers like McDonald’s Nordics, Sunrun & JetBlue see from using dbt Cloud with Snowflake.
At #SnowflakeSummit? Stop by our booth, #2720!
1
4
19
17,834
Have you recently...
💼 landed a new role?
🚀 finished a high-impact analytics project?
🏗 dug deep into a data topic?
🔥 found yourself engaged in heated Twitter arguments about SQL?
Then you probably have a great talk in you.
Tell us about it:
coalesce.getdbt.com/call-for…
1
21
❤️🚀
Great news: today at @MaterializeInc we're launching the beta version of our @getdbt adapter. This means you can now use dbt to easily transform your streaming data in real time--all with a single "dbt run"!
materialize.com/introducing-…
20
you love to see it 🚀
@getdbt latest 0.19.1 performance release is about 3x faster on project parsing 🤩 Check out our review where we test it out for ourselves 💥brooklyndata.co/blog/dbt-019…
19
Hey, it's been quite a year.
Did anyone expect a song like WAP?
No.
Did any of expect a rewrite of WAP called Write-Audit-Publish?
Also no.
But thanks to @jillzzy @spbail @tayloramurphy and @honey808sweet -- it exists.
Happy #dbtcoalesce 😅
dbtlearn.wistia.com/medias/a…
ALT write-audit-publish
5
2
18
❓How do you find meaning from failed tests when you have to dig through hundreds? 🙃
💡Noah Kennedy, Software Developer at Tempus, shares how they cut their tests by 80% *while increasing data quality + test accessibility* in this new Developer Blog
hubs.li/Q01z_bnV0
2
19
3,102
The dbt MCP Server is live 🚀
With the dbt MCP Server, your AI systems can finally access structured, governed data—safely and reliably.
Try the dbt MCP Server: bit.ly/4cX3eyr
Read the blog: bit.ly/430HQnw
2
5
21
1,829
Real-time analytics are some of our favorite analytics. That’s why we've teamed up with @MaterializeInc and @redpandadata for a live hack day, in which you get to roll up your sleeves and work on a streaming data project of your very own.
➡️ Sign up here:
hubs.li/Q013wJ5M0
9
21
SQL first
Structured relationships between models
Modularity
De-coupling data location from materialisation
Testing is a first-class citizen
Easy continuous integration
De-coupling business logic from ‘plumbing’
Adding user-specific behaviour through tags
...there's more ❤️
New edition of High Growth Engineering out! This week continues my love letter to @getdbt, and why I think you should use it in your data stack.
Featuring @timrogers, @steve_yegge, @jthandy and others!
highgrowthengineering.substa…
1
2
20
Named the first dbt user conference Coalesce when America's Next Top Models was just RIGHT THERE THE WHOLE TIME! 🤦♀️
2
18
woodworkers 🤝 analytics engineers
strong opinions about table width
(this tweet is in honor of @__dave's very spicy Kimball talk at #dbtcoalesce yesterday)
2
1
18
There’s testing & then there’s *testing*🧪
In her first Developer Blog post, Emily Riederer (Sr Manager of Analytics @ Capital One) intros the concept of group checks to dbt-utils: tests that offer greater granularity @ the group-level.
Check it out here hubs.li/Q01yclTt0
4
17
9,112
The new dbt Fusion engine is fast....maybe too fast? ⚡️
Join the conversation: getdbt.com/resources/webinar…
1
2
20
1,799
suggested clues:
* centralized vs. decentralized data team debate
* dbt capitalized like "Dbt" 😭
* the old dbt logo 😭
* Kimball mention
* "will the recording be available?" question
* "is this playlist available on spotify?" question
1
18
POV: You've just been tasked with improving performance on a 1700+ model dbt Cloud job 😱
Where do you even start?
Check out how Bennie Regenold & Barr Yaron tackled this problem and reduced a job's 1.5hr runtime to <20min in this Developer Blog post!
hubs.li/Q01kvsjG0
2
17
🎉 Announcing the first-ever dbt Community Spotlight! bit.ly/3p0ancq
🧑💻Each quarter, we'll highlight community contributors who have gone above and beyond.
🏆This round features @takimo, @Anyalitica, Bruno Souza de Lima, @david_uforo, Karen Hsieh and @EmilyRiederer.
3
4
19
13,296
How do you enforce rules at scale? 🤔
Benoit Perigaud walks you through how to implement and use pre-commit-dbt package to solve this problem! Check it out in his latest dbt Developer Blog post 📖
hubs.li/Q01jrs130
2
16
Data quality testing used to be much more of an art 🧑🏻🎨
Learn about the 5 core data quality checks (uniqueness, non-nullness, accepted values, referential integrity, freshness) & how dbt is making them a science 🧑🏻🔬
hubs.li/Q01L-mf20
3
18
2,375
We're stoked for the 💫 dbt Developer Hub 💫: a newly built, all-in-one location for community members to learn, engage with peers, and contribute to the craft of analytics engineering. A… hub for dbt developers, if you will!
getdbt.com/blog/introducing-…
Major new dbt Community release: the dbt Developer Hub (hosted on docs.getdbt.com).
This is the new unified home for folks to learn dbt and find ways to engage in the community. This is going to be a long-term platform for everything related to the dbt Community. 🧵
1
15
Much like the actual universe, the dbt universe is expanding ✨
Our partners at Hightouch launched a dbt integration to bring Reverse ETL to more data stacks.
You got a cloud warehouse to help eliminate data silos....you don’t want it to become one!
blog.getdbt.com/dbt-and-high…
5
18
Are we humans? Or are we dimensions? 🤔
In his first Developer Blog post, Ian Fahey draws upon his experience and takes dimensional modeling for a spin to propose a business user-first data modeling approach.
hubs.li/Q01kL5-l0
6
17
"Don't cry because it's over. Smile because it happened" - Dr. Seuss.
And just like that, we are kicking off day 5️⃣ of #dbtcoalesce with 7 excellent sessions you don't want to miss.
Today's sessions will be APAC friendly to ensure everyone gets a piece of the Coalesce pie🥧!
2
14
really excited for the part of the adoption curve when people start actually using the proper lowercase dbt 😭
2
15
READY? SET? LET’S GO! ✨
It’s day 2️⃣ of #dbtCoalesce ! Going to be hard to top day 1️⃣, but we have so much learning and fun to be had!
What are you most excited about today?
1
3
18
❤️❤️❤️
"I wish I would have started using dbt 4 years ago, but I didn’t. Had I used it then, some parts of life, like the hours between 9 and 5 would have been a little more enjoyable."
❤️❤️❤️
justinwagg.com/dbt/
3
18