Publisher's Synopsis
Explore the capabilities of Fivetran that allow data professionals to centralize data automatically and unlock useful insights
Key Features
- Discover typical use cases for Fivetran and how it works
- Use Fivetran's native functionalities such as transformations, history mode, dbt packages, and the native dbt integration
- Find out how to use Fivetran for managing pipelines and where Fivetran fits in your analytics tech stack
Book Description
Fivetran enables organizations to centralize key data sources to quickly model and obtain meaningful insights from data. As the first book written about Fivetran, Automating Data Integration with Fivetran, will take you through its capabilities that allow you to collect and analyze data any time and maximize ROI on your analytics initiatives. The book will demonstrate how a productionalized analytics infrastructure can be set up in less than 1 hour.
You'll start by exploring managed data pipelines and setting up Fivetran connectors and learn how to create scheduled transformations using dbt. As you advance, you'll configure Fivetran connectors and seamlessly load data into your data warehouse, manage sync frequencies, and troubleshoot disruptions in your data pipelines. You'll then discover how to build custom transformations and deploy pre-built transform packages through Fivetran's native integration with dbt. Throughout the book, you'll learn to create scalable data pipelines to generate insights from production data and automatically integrate data from different applications with the help of practical examples.
By the end of this book, you'll be able to set up, deploy, and land source data in your data warehouse, schedule and execute custom transformations, and have a fully operational data infrastructure to power your analytics.
What you will learn
- Understand how data pipelines are managed and what goes on under the hood for Fivetran connectors
- Install various Fivetran connectors and learn how to troubleshoot issues that may come up in the setup process
- Create, manage, and schedule transformations from within the Fivetran application
- Set up and manage history mode and dbt jobs in Fivetran
- Keep your data safe while connecting, replicating, and loading data using Fivetran
- Find out how Fivetran can be used by different teams
- Cover best practices for data governance, data modeling, and transformations
Who This Book Is For
This book is for analytics leaders and data engineers responsible for managing ETL/ELT data pipelines, extracting data from source systems and landing them in a data warehouse, and creating the data infrastructure needed to run analytics for their organization. Business leaders who want to become data-driven or enhance their data analytics skills will also find this book useful. Basic knowledge of data analysis is assumed.
