dbt 实验室：使用 dbt 升级湖屋中的 SQL 转换.pdf

1、Leveling Up SQL Transformations in the Lakehouse with dbtData+AI Summit 2023June 28,2023Agenda1Intro4DemoSee dbt+Databricks in action!2BackgroundQuick overview of dbt and the SQL persona in DatabricksNext StepsConnect with us and find out more!3dbt+DatabricksHow they are better together5IntroAndrew

2、SitzSolutions Architect+Databricks ChampionLovelyticsWe are a team of expert consultants who help the worlds leading companies use data and AI to better their business.People and data are at the heart of everything we do.From the data lakehouse to the CEO dashboardlove your data with Lovelytics.Abou

3、t LovelyticsCustomers of all sizes across industries,located around the world.750+Innovation Partner of the YearRising Star Partner of the Year202220212022Best Places To WorkWhat is dbt?6Why dbt CloudMore user personas developing in the lakehouseMore analyst workloads in DatabricksShorter time to us

4、er productivityUsers focus on using vs.maintaining data infrastructureShared pipelines and control and coordination of code changes Managed spending with complex data architecture at scaleAbility to simplify complex orchestration patternsReduces strain of many requests while increasing confidence in

5、 changesSQL with a software engineering approachDemoMK8DX BenchmarkMK8DX BenchmarkGroundbreaking new benchmark to navigate twists,turns and unexpected challengesTracks complexity for various scenarios commonly encounteredIncludes time trials to easily compare processing times against systemsBased on

6、 years of research into individual workloads and multi-persona engagementsAllows customization for resources and users of different knowledge basesSimulates unexpected circumstances and roadblocksParato EfficiencyDescribes a situation where