The output of the snapshot does not look to what I expected

Help
1

I’m creating a snapshot model from Hubspot deal table with the following configuration

snapshots:
  - name: snapshot_hubspot_deals
    relation: ref('ephemeral_hubspot_deals')
    config:
      schema: snapshots
      database: reporting
      unique_key: deal_id
      strategy: check
      check_cols: all
      updated_at: last_modified_date_deal
      hard_deletes: ignore
      dbt_valid_to_current: "to_date('9999-12-31')" # Specifies that current records should have `dbt_valid_to` set to `'9999-12-31'` instead of `NULL`.

I would expect the value of the amount column to remain 1651,5 in all rows because there is no change for the past 12 months. However, found the value became null after 2025-04-03 (see the screenshot showing dbt_valid_from).
Did I miss something in the configuration?

image
image1348×361 39 KB

4

I managed to fix the issue. We can close this topic.