Name: Madrid dbt Meetup #5 (in-person)
Start: 2024-11-21T17:45:00.000Z
End: 2024-11-21T21:00:00.000Z
Location: Utopicus Paseo de la Habana

A dbt Meetup is a networking event open to all folks working with data! Talks predominantly focus on community members' experience with dbt, however, you'll catch presentations on broader topics such as analytics engineering, data stacks, data ops, modeling, testing, and team structures. Data practionners, amateur hackers & students are all welcome!

**🤝Organizer:** Esther Fraser & Saadat Qadri
**🏠Venue Host:** CoWork Halifax

To attend, please read the Health and Safety Policy and Terms of Participation: [https://www.getdbt.com/legal/health-and-safety-policy](https://www.getdbt.com/legal/health-and-safety-policy)

**📝Agenda**

* 12h00 \- 12h15 \| Welcome & Introductions
* 12h15 \- 12h45\| **Data on Autopilot**: An Overview of Devops with dbt by Adam Duval
* 12h45 \- 13h30 \| Open Workshop
* 13h30 \- 13h55 \| Networking & Snacking
* 13h55 \- 14h00 \| Closing Remarks

**Data on Autopilot:** An Overview of Devops with dbt
Explore how DevOps, particularly CI/CD, pipelines with dbt can enhance your data workflows. By automating data transformations, testing, and deployments, organizations can achieve faster, more reliable insights while minimizing manual errors. This discussion will highlight the importance of integrating DevOps practices into analytics engineering. It will cover the fundamental concepts of DevOps and CI/CD with dbt, before delving into some more advanced workflow examples and finishing with the latest advanced CI features announced at Coalesce 2024. The goal is to empower attendees to streamline data processes and make their pipelines work for them, on autopilot.

**Open Workshop**
After the success exploring unit tests in last quarter's **Open Workshop** segment, we're making it a permanent feature! Got a thorny dbt problem that giving you some trouble? Or did you just solve one and want to brag? Bring your laptop and let your community lend a hand.

➡️ Join the dbt Slack community: https://www.getdbt.com/community/
🤝For the best Meetup experience, make sure to join the #local-eastern-canada channel in dbt Slack ([https://slack.getdbt.com/](https://slack.getdbt.com/)).
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-

dbt is the standard in data transformation, used by over 30,000 organizations worldwide. Through the application of software engineering best practices like modularity, version control, testing, and documentation, dbt’s analytics engineering workflow helps teams work more efficiently to produce data the entire organization can trust. Learn more: [https://www.getdbt.com/](https://www.getdbt.com/)

Halifax dbt Meetup

Saadat Qadri

Amada Echeverría (dbt Labs)

Esther Fraser

Halifax dbt Meetup Q4

CoWork Halifax

What are dbt meetups? dbt Meetups are networking events open to all folks working with data! Talks predominantly focus on community members' experience with dbt, however, you'll catch presentations on broader topics such as analytics engineering, data stacks, data ops, modeling, testing, and team structures.
**🤝Organizers:** Chitra Sundaram (Cleartelligence) & Riddhima Shukla (Cleartelligence)
**🏠Venue Host:** **Venue Host:** **One Kenmore Square, Boston 02215**
(The entrance to the office is on Deerfield Street and the sign above the entrance says “ONE”. As a part of the check-in process you’d be asked to sign a basic NDA upon arrival by Whoop)
**🍕Catering: TBD**
**To attend, please read the Health and Safety Policy and Terms of Participation: [https://www.getdbt.com/legal/health-and-safety-policy](https://www.getdbt.com/legal/health-and-safety-policy "https://www.getdbt.com/legal/health-and-safety-policy")**
**📝Agenda**

* 6:00 \- 7:00 \| Check in/Registration/ Networking \(60 min\)
* 7:00 \- 7:05 \| Welcome Remarks by Meetup Host \(5 min\)
* 7:05 \- 7:25 \| Presentation 1: Advanced SQL Tricks and Patterns \- \(15\-20 min\)
* 7:25 \- 7:30 \| Presentation 1 Q&A \(5 min\)
* 7:30 \- 7:50 \| Presentation 2: TBD \- \(15\-20 min\)
* 7:50 \- 7:55 \| Presentation 2 Q&A \(5 min\)
* 7:55 \- 8:00 \| Closing Remarks by Meetup Host \(5 min\)

🗣️**Presentation #1**: Advanced SQL Tricks and Patterns
**Speaker**: Daniel Reeves, Data Architect at Battery Ventures
**\-\-\-**
**🗣️Presentation #2** TBD
**Speaker:** TBD

**➡️** Join the dbt Slack community: https://www.getdbt.com/community/
🤝For the best Meetup experience, make sure to join the #local-boston channel in dbt Slack ([https://slack.getdbt.com/](https://slack.getdbt.com/)).
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-

dbt is the standard in data transformation, used by over 40,000 organizations worldwide. Through the application of software engineering best practices like modularity, version control, testing, and documentation, dbt’s analytics engineering workflow helps teams work more efficiently to produce data the entire organization can trust. Learn more: [https://www.getdbt.com/](https://www.getdbt.com/)

* dbt Meetups are gatherings dedicated to helping you own your analytics engineering workflow. Events will focus on the impact of dbt in the data community and professional development tools for analytics engineers.
* Expect big-picture conversations related to the data stacks, data operations, data teams, modeling, testing, dashboards, etc.If you work with data, this group is for you! We welcome data analysts, scientists, engineers, architects, and more!!

Boston dbt Meetup

Chitra Sundaram

Riddhima Shukla

Antonio Venturim

dbt Boston Meetup - Nov 2024

Kenmore Sq. BOSTON

😎It's here! Our next dbt meetup is coming up and will be hosted at the **Materialize** office:

* 436 Lafayette St floor 6
* New York, NY 10003

We are looking forward to socializing and seeing all of the new and familiar faces!

💡dbt Meetups are networking events open to all folks working with data! Talks predominantly focus on community members' experience with dbt, however, you'll catch presentations on broader topics such as analytics engineering, data stacks, data ops, modeling, testing, and team structures.

**Our venue has capacity limits, so please only RSVP if you intend to come** and reach out to *kayla.dolloff@brooklyndata.co* if you need to cancel last minute. At anytime, you may update your RSVP status on the Meetup to "Not Going."

➡️ Join the dbt Slack community: [https://www.getdbt.com/community/](https://www.getdbt.com/community/)
🤝For the best Meetup experience, make sure to join the **#local-nyc** channel in dbt Slack ([https://slack.getdbt.com/](https://slack.getdbt.com/))

dbt is the standard in data transformation, used by over 40,000 organizations worldwide. Through the application of software engineering best practices like modularity, version control, testing, and documentation, dbt’s analytics engineering workflow helps teams work more efficiently to produce data the entire organization can trust. Learn more: [https://www.getdbt.com/](https://www.getdbt.com/)
\*\*\*
🏠**Venue Host**: Materialize
🍕**Catering**: TBD
🤝**Organizer**: Brooklyn Data

📣 Agenda and additional details below:

* 6:30pm Intro remarks \| Refreshments & Conversation
* 7:00-7:25 Kevin Cheung + Q&A (see topic below)
* 7:25-7:50 Nico Hein + Q&A (see topic below)
* 7:50-8:00pm Closing remarks
* 8:00-9:00 Reception & Networking

✨Speakers and Topics:

* Kevin Cheung, Sr. Analytics Engineer at GameChanger, will be serving up ***Lineage Lasagna: Using Layers to Organize Your dbt Models***
* Nico Hein, Data Architect at BMG, will dive into ***Streamlined Integration of dbt and Airflow***

🎤 Interested in speaking at a future meetup? Submit your interest using [this form](https://forms.office.com/r/hAb6NqeH4X), and we'll be in touch!

To attend, please read the Required Participation Language for In-Person Events with dbt Labs: [https://www.getdbt.com/legal/health-and-safety-policy](https://www.getdbt.com/legal/health-and-safety-policy)

*All participants are welcome. For questions regarding access and accommodation, please contact kaya.dolloff@brooklyndata.co in advance.*

New York dbt Meetup

Brooklyn Data Co.

Mikkel Dengsøe

436 Lafayette St

Our friends at Miele X are hosting us at their offices next to the Zuid Station.

17:30 – 🍕 Welcome

18:00 – 🎤 Paul Goddard (Omni) - How Omni is using DuckDB to revolutionise BI tools

18:30 – 🎤 Sander van Lidth de Jeude (MieleX) - dbt Core at Miele - Databricks bundles for a consistent dev environment

19:00 – 🎤 Jochem van Dooren (Picnic) - introducing dbt-score, a linter for dbt metadata

19:30 –🥤 Drinks & Snacks

\-\-\-

Location:
**Miele X**
The Valley, Beethovenstraat 517, 1083 HK Amsterdam
5 min walk from station Amsterdam Zuid. Take the elevators on the opposite side of the reception to the 3rd floor.

\-\-\-
Join the dbt Slack community: [https://community.getdbt.com/](https://community.getdbt.com/)
Join the conversation in the #local-netherlands channel in dbt Slack to connect with other data practitioners locally.
**To attend, please read the Required Participation Language for In-Person Events with dbt Labs:** [https://www.getdbt.com/legal/health-and-safety-policy](https://www.getdbt.com/legal/health-and-safety-policy)

Netherlands dbt Meetup

Thomas in't Veld

Juan Manuel Perafán

Francesco Angileri

NL dbt meetup: 9th Edition

Miele X

dbt Meetups are networking events open to all folks working with data! Talks predominantly focus on community members’ experience with dbt, however, you’ll catch presentations on broader topics such as analytics engineering, data stacks, DataOps, modeling, testing, and team structures.

📍 **Venue Host**: Utopicus Habana (P.º de La Habana, 9, 11, 28036 Madrid)
🍕 **Catering**: Drinks & Pizza at the place of the event
🤝 **Organizer**: [Astrafy](https://astrafy.io/) is organizing this event, enabled by the community team at dbt Labs

\**To attend, please read the Health and Safety Policy and Terms of Participation*: \*\*\*[https://www.getdbt.com/legal/health-and-safety-policy](https://www.getdbt.com/legal/health-and-safety-policy)

🗓️Agenda:

* 18:45 \- 19:00 \| Welcome
* 19:00 \- 19:20 \| Data validation with dbt: Going beyond testing \([Alejandro de la Cruz Lopez](https://www.linkedin.com/in/acrulopez/) - **Astrafy**)
* 19:25 \- 19:45 \| How Airflow \+ dbt Work Together at Okta \([Miquel Angel Andreu Febrer](https://www.linkedin.com/in/miquelangelandreu/) - **Okta**)
* 19:50 \- 20:10 \| Leveraging column\-level lineage to scale your dbt projects \([Benoit Perigaud](https://www.linkedin.com/in/ACoAAATnj4cBJQJkkLuNrAveD-GXLzG_mD4-osU) - **dbt**)
* 20:15 \- 22h00 \| Networking with drinks & pizzas [🍺](https://emojipedia.org/beer-mug/) [🍕](https://emojipedia.org/pizza/)

**🗣️Presentation #1**:
dbt can be leveraged for more than just basic testing. We will dive into advanced data validation techniques that ensure data quality beyond conventional testing in dbt. We will use Recce as a new emerging tool that allows validation checks and improved approval requests.

**Speaker bio**: Alejandro de la Cruz López is an experienced Data Engineer with a strong background in Data Science and Artificial Intelligence. He has led various data projects, optimizing systems and improving infrastructure for several organizations. Alejandro holds multiple professional certifications and has authored articles on data engineering practices. His work focuses on delivering efficient, scalable data solutions in the cloud.

\-\-\-

**🗣️Presentation #2**:
In this presentation, Miquel Angel will show how Okta dynamically builds all dbt DAGs from upstream to downstream based on tags and the dbt project structure, automates tests inside the dags, and uses the same warehouse configuration for both dbt runs and tests.

**Speaker bio:** Data Engineer specialized in ETL, BigData processes, and DevOps

**🗣️Presentation #3**:
Today, we have tools to enforce quality checks on projects, at the model level, like dbt_project_evaluator. Those tools are indispensable to allow teams to scale their dbt transformation. But while we've been focusing on rules at the model level. Could we leverage CLL to also define rules at the column level now? The idea of this talk would be to build an open-source tool and present what problems it can solve.

**Speaker bio:** Staff Analytics Engineer at *dbt* Labs

➡️ Join the dbt Slack community: https://www.getdbt.com/community/
🤝For the best Meetup experience, make sure to join the #local-\ channel in dbt Slack ([https://slack.getdbt.com/](https://slack.getdbt.com/)).
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-
dbt is the standard in data transformation, used by over 40,000 organizations worldwide. Through the application of software engineering best practices like modularity, version control, testing, and documentation, dbt’s analytics engineering workflow helps teams work more efficiently to produce data the entire organization can trust. Learn more: [https://www.getdbt.com/](https://www.getdbt.com/)

Madrid dbt Meetup

Alex De La Cruz

Shay Begun

Miguel Martín

Madrid dbt Meetup #5 (in-person)

Utopicus Paseo de la Habana

dbt Community Meetup

Search {networkName}

Groups

{PRO_NETWORK_NAME} is on Meetup Pro with more than {PRO_MEMBER_COUNT} members across {PRO_GROUP_COUNT} Meetups worldwide. Meetup Pro is the professional tool for organizing and communicating a network of users, partners, contributors and members.

We're the makers of dbt (www.getdbt.com) and we’re on a mission to empower data practitioners to create and disseminate organizational knowledge. 

dbt allows teams to ship trusted data products, faster. dbt Meetups are a way for people to connect over their experiences with dbt, as well as discuss topics related to the data industry, team dynamics, best practices, and much more.

dbt Community Meetup

dbt Community Meetup

Who we are

Search dbt Community Meetup

Upcoming events

Groups