search

fivetran / dbt_marketo

Fivetran's Marketo dbt package
https://fivetran.github.io/dbt_marketo/
Apache License 2.0
8 stars 7 forks source link

Introduce variables to disable "Program" and "Campaign" related models #10

Closed kristin-bagnall closed 3 years ago

kristin-bagnall commented 3 years ago

There are a few tables in Marketo that cause extreme slowness with the connector, and are therefore not recommended for syncing.

Our package was built before this guidance, and therefore makes use of tables that are becoming increasingly unpopular. Let's refactor this package to introduce variables that disable "program" and "campaign." These variables should be disabled as default, and customers will need to opt-in (enable) the variable to get this logic. This will be considered a breaking change.

Screen Shot 2021-05-10 at 8 38 20 AM

rcaddell commented 3 years ago

Thanks Kristin

rcaddell commented 3 years ago

Hello @fivetran-kristin, Expanding on this, according to Marketo, if your Marketo account has native CRM sync enabled, you will not be able to target the Company object, it is blocked with an access denied message.

https://developers.marketo.com/rest-api/lead-database/companies/

edit - disregard, company is not required for the package

kristin-bagnall commented 3 years ago

This work has been completed and now available!

Release is here: https://github.com/fivetran/dbt_marketo/releases/tag/v0.4.0