Robert shares insights into how data analysis is revolutionizing the industry, emphasizing the critical role of efficient data queries and the tools that manage large volumes of information. He discusses the transition from relying on spreadsheets to adopting more organized and structured data systems. Tools like Snowflake and DBT are driving this shift, enhancing data processes and improving data quality within the oil and gas sector.
Digital Wildcatters brings the energy community together through events, cutting-edge content, and powerful tools. Join our online community at collide.io. Engage with experts, level up your career, and ask Collide AI your toughest technical questions.”
Click here to watch a video of this episode.Click here to view the episode transcript.
00:00 - Intro
01:34 - Distributed Compute Necessity
07:05 - Enverus Role Overview
10:51 - Transitioning from Spreadsheets
17:12 - Data Quality Testing Techniques
19:00 - Understanding DBT (Data Build Tool)
21:15 - DBT Orchestration Explained
24:35 - DBT Documentation Importance
28:03 - Tech Stack Insights
30:17 - Type 2 Slowly Changing Dimensions
33:01 - FiveTran vs. Homegrown Pipelines
36:00 - Rudderstack Overview
38:20 - Snowflake's Semantic Layer
40:40 - Hex Analytics Tool
45:00 - Experience at Parsley
47:43 - Journey from Planning to Engineering
49:28 - Importance of Domain Experience
54:55 - Changing Your Data Stack
1:01:14 - ODBC Usage Today
1:06:00 - Microsoft Power BI Overview
1:07:40 - Lakehouses Explained
1:11:50 - Speed Round
1:14:20 - Exciting Open Source Packages
1:19:41 - Favorite Roadside Stops
1:21:52 - Podcast Wrap-Up
1:22:34 - Where to Find Matt
https://www.instagram.com/digitalwildcatters
https://www.tiktok.com/@digitalwildcatters
https://www.facebook.com/digitalwildcatters
https://twitter.com/DWildcatters