LinkedIn Ads Airbyte dbt Package

---

• This package contains dbt models to work with Airbyte LinkedIn Ads connector.
• The package is compatible with latest version of Airbyte LinkedIn Ads connector.
• Currently, it is limited to creating transformations compatible with Fivetran's modeling dbt package.
• In the future, specific models will be applied directly to Airbyte connector output. If you have an idea or want to propose an analytical model for this source, please refer to the contributing guide, which explains how to propose a new transformation model.
• This package was tested with BigQuery, Snowflake, and Postgres data warehouses.

---

🎯 Intructions how to use

Airbyte dbt Package

For now Airbyte dbt packages aren't versioned. You must configure using git and subdirectory. For now there isn't any transformation model directly applied to this package. But you can generate docs and tests with dbt.

Create the following files:

dbt_project.yml

vars:
  using_fivetran_model: False
  airbyte_database: "airbyte_db_default"
  airbyte_schema: "airbyte_dbt_linkedin_ads"

packages.yml

packages:
  - git: "https://github.com/airbytehq/airbyte-dbt-models.git"
    subdirectory: "connectors/source_linkedin_ads"

After you can run dbt tests or dbt docs generate to have a preview of Airbyte output data.

Fivetran LinkedIn Ads Modeling dbt package

This package transforms Airbyte connector output data, making it compatible with Fivetran's LinkedIn Ads dbt package. You can check the analytical models Fivetran creates here. The link also provides information about how the package works and what is configurable.

Create the require files to use Airbyte and Fivetran dbt packages:

packages.yml

packages:
  - git: "https://github.com/airbytehq/airbyte-dbt-models.git"
    subdirectory: "connectors/source_linkedin_ads"

  - package: fivetran/linkedin
    version: [">=0.5.0", "<0.6.0"]

This is a default variable definition you must configure to have the models created.

dbt_project.yml

vars:
  # Required by Airbyte dbt model
  using_fivetran_model: True
  airbyte_database: "airbyte_db_default"
  airbyte_schema: "airbyte_dbt_linkedin_ads"

  # Required by Fivetran dbt model
  linkedin_database: "airbyte_db_default"
  linkedin_schema: "dbt_source_linkedin"

  linkedin_ads__account_history_identifier: "account_history"
  linkedin_ads__ad_analytics_by_campaign_identifier: "analytics_campaign"
  linkedin_ads__ad_analytics_by_creative_identifier: "analytics_by_creative"
  linkedin_ads__campaign_group_history_identifier: "campaign_group_history"
  linkedin_ads__campaign_history_identifier: "campaign_history"
  linkedin_ads__creative_history_identifier: "creative_history"

After run dbt run, you can see the models being created.

---

📦 Package Maintenance

• This package is maintained by the Airbyte Community.
• You can contribute any time please read the Contributing Guidelines or enter the Airbyte Slack Channel #airbyte-dbt-packages