國立高雄大學圖資館 |

登入

回首頁

Unlocking dbtdesign and deploy transformations in your cloud data warehouse /

紀錄類型:	書目-電子資源 : Monograph/item
正題名/作者:	Unlocking dbtby Cameron Cyr, Dustin Dorsey.
其他題名:	design and deploy transformations in your cloud data warehouse /
作者:	Cyr, Cameron.
其他作者:	Dorsey, Dustin.
出版者:	Berkeley, CA :Apress :2023.
面頁冊數:	xx, 356 p. :ill., digital ;24 cm.
Contained By:	Springer Nature eBook
標題:	Database management.
電子資源:	https://doi.org/10.1007/978-1-4842-9703-2
ISBN:	9781484297032$q(electronic bk.)

Unlocking dbtdesign and deploy transformations in your cloud data warehouse /
Cyr, Cameron.

Unlocking dbtdesign and deploy transformations in your cloud data warehouse /[electronic resource] :by Cameron Cyr, Dustin Dorsey. - Berkeley, CA :Apress :2023. - xx, 356 p. :ill., digital ;24 cm.

1. Introduction to dbt -- 2. Setting up a dbt Project. -3. Sources and Seeds -- 4. Models -- 5. Snapshots -- 6. Jinja, Macros and Packages -- 7. Hooks -- 8. Tests -- 9. Documentation -- 10. dbt in Production.

This book shows how dbt is used to build data transformation pipelines that enable dependency management and allow for version control and automated testing. It explains how dbt is revolutionizing data transformation and the advantages that a command-line tool like dbt provides over and above the use of database stored procedures and other ETL and ELT tools that handle data transformations. You'll see how to create custom-written transformations through simple SQL SELECT statements, eliminating the need for boilerplate code and making it easy to incorporate dbt as the transformation layer in your data warehouse pipelines. Additionally, you will learn how dbt enables data teams to incorporate software engineering best practices such as code reusability, version control, and automated testing into the data transformation process. Unlocking dbt walks you through using dbt to establish a project, build and modularize SQL models, and execute jobs in a way that is easy to maintain and scale as your data ecosystem matures. You'll begin by establishing and configuring a project, a process covered using both dbt Cloud and dbt Core, so that you can confidently stand up a project using either platform. From there, you'll move into building transformations with peace of mind that your project will scale appropriately as you continue to develop it. After learning the basics needed to get started, you'll continue to build on that foundation by looking at the unique ways in which dbt combines SQL with Jinja to take your code beyond what is capable in normal SQL. You will learn about advanced materializations, building lineage in your data flows, the unlimited potential of macros, and so much more. This book also explores supported file types and the building of Python models. Rounding things out, you will learn features of dbt that will assist you in making your transformation layer production ready. These include how to implement automated testing, using dbt to generate documentation, and running CI/CD pipelines. You will: Understand what dbt is and how it is used in the modern data stack Set up a project using both dbt Cloud and dbt Core Connect a dbt project to a cloud data warehouse Build SQL and Python models that are scalable and maintainable Configure development, testing, and production environments Capture reusable logic in the form of Jinja macros Incorporate version control with your data transformation code.

ISBN: 9781484297032$q(electronic bk.)

Standard No.: 10.1007/978-1-4842-9703-2doiSubjects--Topical Terms:

182428
Database management.

LC Class. No.: QA76.9.D3 / C97 2023

Dewey Class. No.: 005.74

Unlocking dbtdesign and deploy transformations in your cloud data warehouse /
LDR:03691nmm a2200325 a 4500 001 651628
003 DE-He213
005 20230925163718.0
006 m d
007 cr nn 008maaau
008 240327s2023 cau s 0 eng d
020 $a 9781484297032$q(electronic bk.)
020 $a 9781484296998$q(paper)
024 7 $a 10.1007/978-1-4842-9703-2 $2 doi
035 $a 978-1-4842-9703-2
040 $a GP $c GP
041 0 $a eng
050 4 $a QA76.9.D3 $b C97 2023
072 7 $a UN $2 bicssc
072 7 $a COM021000 $2 bisacsh
072 7 $a UN $2 thema
082 0 4 $a 005.74 $2 23
090 $a QA76.9.D3 $b C997 2023
100 1 $a Cyr, Cameron. $3 961911
245 1 0 $a Unlocking dbt $h [electronic resource] : $b design and deploy transformations in your cloud data warehouse / $c by Cameron Cyr, Dustin Dorsey.
260 $a Berkeley, CA : $b Apress : $b Imprint: Apress, $c 2023.
300 $a xx, 356 p. : $b ill., digital ; $c 24 cm.
505 0 $a 1. Introduction to dbt -- 2. Setting up a dbt Project. -3. Sources and Seeds -- 4. Models -- 5. Snapshots -- 6. Jinja, Macros and Packages -- 7. Hooks -- 8. Tests -- 9. Documentation -- 10. dbt in Production.
520 $a This book shows how dbt is used to build data transformation pipelines that enable dependency management and allow for version control and automated testing. It explains how dbt is revolutionizing data transformation and the advantages that a command-line tool like dbt provides over and above the use of database stored procedures and other ETL and ELT tools that handle data transformations. You'll see how to create custom-written transformations through simple SQL SELECT statements, eliminating the need for boilerplate code and making it easy to incorporate dbt as the transformation layer in your data warehouse pipelines. Additionally, you will learn how dbt enables data teams to incorporate software engineering best practices such as code reusability, version control, and automated testing into the data transformation process. Unlocking dbt walks you through using dbt to establish a project, build and modularize SQL models, and execute jobs in a way that is easy to maintain and scale as your data ecosystem matures. You'll begin by establishing and configuring a project, a process covered using both dbt Cloud and dbt Core, so that you can confidently stand up a project using either platform. From there, you'll move into building transformations with peace of mind that your project will scale appropriately as you continue to develop it. After learning the basics needed to get started, you'll continue to build on that foundation by looking at the unique ways in which dbt combines SQL with Jinja to take your code beyond what is capable in normal SQL. You will learn about advanced materializations, building lineage in your data flows, the unlimited potential of macros, and so much more. This book also explores supported file types and the building of Python models. Rounding things out, you will learn features of dbt that will assist you in making your transformation layer production ready. These include how to implement automated testing, using dbt to generate documentation, and running CI/CD pipelines. You will: Understand what dbt is and how it is used in the modern data stack Set up a project using both dbt Cloud and dbt Core Connect a dbt project to a cloud data warehouse Build SQL and Python models that are scalable and maintainable Configure development, testing, and production environments Capture reusable logic in the form of Jinja macros Incorporate version control with your data transformation code.
650 0 $a Database management. $3 182428
650 0 $a Cloud computing. $3 378527
650 0 $a Quantitative research. $3 367894
650 1 4 $a Database Management. $3 273994
650 2 4 $a Data Analysis and Big Data. $3 913147
700 1 $a Dorsey, Dustin. $3 961912
710 2 $a SpringerLink (Online service) $3 273601
773 0 $t Springer Nature eBook
856 4 0 $u https://doi.org/10.1007/978-1-4842-9703-2
950 $a Professional and Applied Computing (SpringerNature-12059)