Netherlands User Group: Using Snowflake + DBT for automated CI/CD of complex data models (Virtual)

Netherlands
Tue, Oct 27, 2020, 3:00 PM (CET)

About this event

The Snowflake User Group in the Netherlands is getting together virtually on October 27th at 3pm! Join us for an opportunity to hear from other Snowflake users in the area, grow your professional network, ask questions, and get details on our next meeting. During this meeting you will learn how TripActions, a leading corporate travel management and payments platform, has implemented an automated data structure that allows them to test and deploy and dynamic data model using DBT and Snowflake. There will be opportunities for networking, questions and answers, and details on our next user group event. Register to participate!

TripActions has to maintain a data environment which meets a number of requirements including multi-regional deployment of the same data model with differing privacy requirements per region, high degrees of automation and testing to allow business users to directly contribute to their data model, and dynamic and adaptable data structure to meet the changing nature of their business. To support these needs, TripActions has implemented an automated data structure that allows them to test and deploy and dynamic data model using DBT and Snowflake. In this talk we’ll cover infrastructure and tooling used to create our CI/CD pipeline, implementing an adaptive framework to allow dynamic creation of dev and prod models in independent namespaces using the same SQL, tooling to empower analysts and business users in managing a data model, and the challenges overcome in creating their toolset.


AGENDA

3:00 PM | Introductions

3:10 PM | How TripActions Uses Snowflake + DBT

4:00 PM | Data Engineering & DevOps

4:50 PM | Closing Remarks

Speakers