It's never been easier to use dbt and Fivetran together. Follow this guide to learn how to set up dbt on your computer.

In this lesson, we talk about what a query planner is and does in the database. We talk about the difference between declarative and imperative programming languages, and we wrap up with a discussion of some common strategies for database optimization to improve query speed.

In this episode, we learn about a very important technique for making database queries faster: indexes! Indexes are a very powerful technique and are critical to understanding how databases work under the hood. In this lesson we talk about how database indexes make use of the binary search algorithm to speed up queries. We also cover the trade-offs associated with using database indexes, and why it might not be a good idea to use too many indexes.

Fivetran’s mission to to make data as accessible and reliable as electricity. We're focused on providing automated access to data so data analysts and engineers can be empowered to actually analyze their data. For small companies and large enterprises, Fivetran replicates data from 150+ sources to enable business intelligence and data-driven decisions alongside our partner companies. Learn more at Fivetran.com

Consolidate your SQL Server data into your analytics warehouse.

Consolidate your Postgres data into your analytics warehouse!

Understand how your videos are performing to create engaging content.

Consolidate your disparate files from S3 into your analytics warehouse.