Snapshot Configuration in dbt_project.yml and resource configuration yml showing errors

[aamirparkar]

Describe the bug

Failing Snapshot build and getting issues with schema property and resource paths for snapshots
The reference provided in the error suggestions dbt_project-latest.json does not have the schema property in the file.

I also get a warning sometimes that I need strategy and uniqu_key for timestamps. Think the resource yaml interprets the location as snapshots/snapshot_name and not snapshots/target_folder/snapshot_name.

In the end, it results in failure since the target db and target schema are not picked up correctly.

What version of dbt Fusion is this bug in? (find out by running dbt --version)
dbt-fusion 2.0.0-preview.5

Is this a discrepancy between the dbt Fusion Engine and dbt Core? Check one.

Have not used dbt core before. So don't know.

• YES
• NO

To Reproduce

1. Open this workspace
2. Follow the instructions in the README

Or:

dbt project configuration:

snapshots: 
    project_name:
    target_folder:
      +tags:
        - "tag_name"
      +database: target_db_name
      +schema: target_schema_name

yml in my resource>>target_folder>>target_snapshots.yml

snapshots:
  - name: snapshot_name
    description: 
    config:
      strategy: timestamp
      unique_key: key
      updated_at: last_run_timestamp

Expected Behaviour

dbt snapshot should create/update table in target_schema_name from the config file

Operating System and CPU Type (please complete the following information):

Windows

[dbeatty10]

Thanks for reaching out @aamirparkar !

I was able reproduce what you are saying about not using target_schema_name when the snapshot config is located in a subfolder like snapshots/target_folder, and this is a discrepancy vs. the behavior with dbt-core 👍

Here's the syntax for my example:

name: 'fusion_618_reprex'
profile: 'snowflake'

snapshots:
  fusion_618_reprex:
    target_folder:
      +tags:
        - "test_snapshot"
      +database: analytics
      +schema: dbt_dbeatty_snapshots

But when I didn't use a subfolder (like below), then it did use the dbt_dbeatty_snapshots schema:

snapshots:
  fusion_618_reprex:
    +tags:
      - "test_snapshot"
    +database: analytics
    +schema: dbt_dbeatty_snapshots

[fa-assistant]

🧹 Stale Issue Detected

This issue has had no meaningful activity for 182 days.

If this is still relevant, please:

• Comment with an update, or
• Add the cleanup/keep label to exempt it from future cleanup scans.

If no action is taken within 30 days, this issue will be scheduled for auto-close with a 7-day grace period.

---

This notice was posted by the Fusion Issue Cleanup workflow.

[eliasdefaria]

This seems to be an issue with the red hat YML extension, not the Fusion YML parser. If you run dbtf parse and still see this error and it blocks your builds, please re-open this issue. Thanks!