Fivetran has created an ad reporting dbt package that aggregates data from our most popular advertising connectors into a unified table. This dbt package allows you to compare how your ad spend converts into clicks and impressions on each advertising platform.
The ad reporting dbt package supports the following connectors:
- Facebook Ads
- Google Ads
- LinkedIn Ads
- Microsoft Ads
- Pinterest Ads
- Twitter Ads
You do not need to have all six advertising connectors to use this package, though you should have at least two.
Learn more in our ad reporting dbt package documentation.
We now support dbt 0.19.0. You can use this version to run your projects. You can upgrade your existing projects by following dbt’s migration guide.
We’ve increased the maximum number of threads that can be used by dbt jobs from 4 to 8.
We no longer support dbt 0.17.2.
You can now customize the name of the dbt target that your dbt jobs use. Add the dbt target in the optional
targetName field in the
deployment.yml file. Learn more about the
deployment.yml file in our dbt setup guide.
We added setup tests in the dbt Transformations setup form. When you click Save & Test, Fivetran checks the credentials and connection to your repository.
Previously, Firetran synced projects immediately after you clicked Save & Test. Now Fivetran syncs your project within a few minutes after the setup tests succeed.
You can now enable email notifications for each of your dbt transformations on your Fivetran dashboard’s Notifications tab. To learn more about email notifications, see our Notifications documentation.
Fivetran now supports flushing dbt transformations event data to supported log services.
Each log service has a unique path for this data:
|Log Service||Path Pattern|
|Azure Log Analytics||
Learn more in our log events documentation.
You can now choose the version of dbt that will run your projects. You can specify it in the deployment.yml file.
We support 3 versions of dbt:
If you don’t specify dbt version in
deployment.yml file, we’ll use the version 0.18.0 to run your projects.