The linkedin_ads__url_report Model Isn’t Generating Data in the Destination Schema Table

Issue

The linkedin_ads__url_report model isn’t generating data in the destination schema table.

Environment

• Connector: LinkedIn Ad Analytics
• Quickstart Data Models

Resolution

To resolve this issue, do the following:

1. Ensure dbt is installed on your local machine.
2. Initialize a new dbt project by running the following command: dbt init <project_name>
3. Follow the installation steps provided in the dbt package documentation to install the required dbt package into your project.
4. In your dbt_project.yml file, set the dbt variable ad_reporting__url_report__using_null_filter to FALSE, and adjust any additional Boolean flags that may prevent you from modifying the code.
5. Push the project to your Git repository.
6. Link your Git repository to Fivetran. See our Transformations for dbt Core documentation for more information.