For the moment, I’m using dbt-core 1.12.0b3 with dbt-postgres 1.11.0.
I’ve a docker container with 1 snapshot (selector is running only this snapshot):
container_name: mycontainer
command: [ "snapshot", "--profile", "myprofile", "--target", "dev", "--select", "selector:myselector" ]
Before running this container, another one is well running for preparing data (int_individu)
My snapshot:
snapshots:
- name: individu_identifiant_unique
relation: ref('int_individu')
description: xxx
config:
database: mydatabase
schema:
alias: individu_identifiant_unique
strategy: check # timestamp or check
unique_key: matricule
check_cols: ["matricule"] #Only if using the check strategy, ["status"]
#updated_at: synchronized_at #Only if using the timestamp strategy
#snapshot_meta_column_names: dictionary
#dbt_valid_to_current: string
hard_deletes: invalidate #ignore | invalidate | new_record
post_hook:
- "ALTER TABLE {{ this }} DROP COLUMN id, DROP COLUMN nom_usuel, DROP COLUMN nom_patronymique, DROP COLUMN prenom, DROP COLUMN pays_naissance, DROP COLUMN date_naissance, DROP COLUMN commune_naissance, DROP COLUMN genre"
- "ALTER TABLE schema.int_individu DROP COLUMN id_sha256"
I’m trying to upgrade version of dbt core. It’s works with rc1 but get an error when trying to go higher:
mycontainer | 08:11:49 [ERROR]: Encountered an error:
mycontainer | Runtime Error
mycontainer | Catalog not found.Received: data_project Expected one of: ?
Container mycontainer Error service "mycontainer" didn't complete successfully: exit 2
service "mycontainer" didn't complete successfully: exit 2
I did not manage to understand and to solve this issue.
Thanks for help.