Omri Antman
04/16/2024, 9:25 AMprod_db.salesforce.some_table
and in dev it'll be dev_db.omri_salesforce.sometable
In meltano I defined a schema var for my dev_enviorment, but if I define a different schema in my target, it overwrites it instead of appending it (which is expected)
Is there a way to append it?
Example template (that is not working)
environments:
- name: dev
config:
plugins:
loaders:
- name: target-snowflake
config:
database: AIRFLOW_TASKS_DEV
warehouse: dbt_dev_wh
schema: omri_
loaders:
- name: target-snowflake-salesforce
inherit_from: target-snowflake
config:
schema: salesforce
load_method: overwrite
visch
04/17/2024, 1:38 AMEdgar RamÃrez (Arch.dev)
04/17/2024, 3:50 AMnamespace
of the inherited plugin and use
schema: omri_$MELTANO_EXTRACTOR_NAMESPACE