Setting up dbt for Shopify tap and redshift target but facing the issue after extract and load is completed

dbt       | Database Error in model shopify_refund_line_items (models/base/shopify_refund_line_items.sql)

dbt       |  relation "test_gunnar.order_refunds" does not exist dbt       |  compiled SQL at ../.meltano/transformers/dbt/target/run/tap_shopify/models/base/shopify_refund_line_items.sql dbt       |  dbt       | Database Error in model shopify_refund_order_adjustments (models/base/shopify_refund_order_adjustments.sql) dbt       |  relation "test_gunnar.order_refunds" does not exist dbt       |  compiled SQL at ../.meltano/transformers/dbt/target/run/tap_shopify/models/base/shopify_refund_order_adjustments.sql dbt       |  dbt       | Done. PASS=2 WARN=0 ERROR=12 SKIP=4 TOTAL=18 meltano     | Transformation failed (1): Done. PASS=2 WARN=0 ERROR=12 SKIP=4 TOTAL=18 meltano     | ELT could not be completed:

dbt run

failed ELT could not be completed:

dbt run

failed Basically i am running a transformation for a stream product and it's looking for all streams data in redshift database. is that any way that transform can only transform single stream of pipeline. Adding Screenshot for more details

Hey Monika! Are you using the dbt-tap-shopify module? I just wrote to someone else last week (see here for more detail) about how the out of the box DBT transformation plugins are not maintained anymore for multiple reasons. You can use them as a starting point for the transformations you're doing though! Just edit them directly in your

/transforms/models

directory

Hey @pat_nadolny, Thank you for the detailed response , it was very helpful.