dbt_ad_reporting icon indicating copy to clipboard operation
dbt_ad_reporting copied to clipboard

metricflow_time_spine error on dbt 2024.8.221

Open pestrov opened this issue 6 months ago • 7 comments

Is there an existing issue for this?

  • [X] I have searched the existing issues

Describe the issue

We're running dbt Cloud Versionless in our dev and prod environments, and yesterday we have started getting the metricflow_time_spine related error that does not allow us to run any run/compile/build commands.

We have fivetran ad_reporting package that seems to have a semantic model and generates metricflow_time_spine inside.

We don’t have a spine model in our own project and don’t specify it.

Relevant error log or model output

Running dbt...
22:13:53 Time spines without YAML configuration are in the process of deprecation. Please add YAML configuration for your 'metricflow_time_spine' model. See documentation to configure: https://docs.getdbt.com/docs/build/metricflow-time-spine
22:13:54 Encountered an error:
Object of type date is not JSON serializable

Expected behavior

The models should continue building.

dbt Project configurations

vars: ad_reporting__amazon_ads_enabled: False # by default this is assumed to be True ad_reporting__apple_search_ads_enabled: True # by default this is assumed to be True ad_reporting__pinterest_ads_enabled: False # by default this is assumed to be True ad_reporting__microsoft_ads_enabled: False # by default this is assumed to be True ad_reporting__linkedin_ads_enabled: True # by default this is assumed to be True ad_reporting__google_ads_enabled: True # by default this is assumed to be True ad_reporting__twitter_ads_enabled: False # by default this is assumed to be True ad_reporting__facebook_ads_enabled: False # by default this is assumed to be True ad_reporting__snapchat_ads_enabled: False # by default this is assumed to be True ad_reporting__tiktok_ads_enabled: False # by default this is assumed to be True ad_reporting__reddit_ads_enabled: False vars: 'dbt_date:time_zone': 'America/Chicago'

Package versions

packages:

  • package: fivetran/app_reporting # https://github.com/fivetran/dbt_app_reporting version: 0.3.2

  • package: fivetran/ad_reporting # https://github.com/fivetran/dbt_ad_reporting version: 1.9.0

What database are you using dbt with?

snowflake

dbt Version

2024.8.221

Additional Context

No response

Are you willing to open a PR to help address this issue?

  • [ ] Yes.
  • [X] Yes, but I will need assistance and will schedule time during our office hours for guidance
  • [ ] No.

pestrov avatar Aug 06 '24 00:08 pestrov