Package is failing on Snowflake, connector_type should be connector_type_id

[Martin-Carlsson]

Package is failing on Snowflake

In stg_fivetran_log__connector.sql, the column name connector_type should be connector_type_id.

Schema on Snowflake for fivetran_log:

[fivetran-joemarkiewicz]

Hi @Martin-Carlsson thanks for opening this issue. I am sorry to see that your dbt job is failing due to this bug. It seems this is a result of the fivetran_log connector updating the CONNECTOR table schema to no longer provide the connector_type field and now only include connector_type_id field.

I will investigate a solution for this and respond back here with my proposed solution and then with the details around the timing of a new release to be cut for the package with the bug fix included.

Thank you!

[fivetran-joemarkiewicz]

Hi @Martin-Carlsson I was able to leverage macros that we use within our other packages to fix the bug you are seeing. I have a the above PR opened which incorporates this fix. I will keep you updated on the progress.

[fivetran-joemarkiewicz]

Hi @Martin-Carlsson thank you again for opening this issue and bringing our attention to the bug. We have since released the new v0.3.1 version of the fivetran_log package. You may update your dependency within your packages.yml file to the below:

packages:
  - package: fivetran/fivetran_log
    version: 0.3.1