Hello everyone!! Hi can I corretly preform a trans...
# troubleshooting
m
Hello everyone!! Hi can I corretly preform a transformation on mysql table? I have try dbt-mysql, but i'm getting erros. this is my meltano.yml: transformers: - name: dbt variant: dbt-labs pip_url: dbt-core~=1.3.0 and this is my profiles.yml config: send_anonymous_usage_stats: False use_colors: True meltano: target: "{{ env_var('DBT_TARGET') }}" outputs: mysql: type: mysql threads: 2 host: "{{ env_var('TARGET_MYSQL_HOST') }}" port: "{{ env_var('TARGET_MYSQL_PORT') | int }}" user: "{{ env_var('TARGET_MYSQL_USER') }}" pass: "{{ env_var('TARGET_MYSQL_PASSWORD') }}" dbname: "{{ env_var('TARGET_MYSQL_DBNAME') }}" schema: "{{ env_var('DBT_TARGET_SCHEMA') }}" this is the model with pessoas_iag as ( select * from localizapessoa p ), select * from pessoas_iag ps where ps.codundclg = 14
e
can you try enabling debug, i.e.
meltano --log-level debug <your command>
, and retry? I suspect there's some badly indented yaml in
meltano.yml
.
m
Im getting this error after install dbt-mysql: ImportError: cannot import name 'SelfDescribing' from 'snowplow_tracker'
e
Oh, you're gonna need a more recent dbt-core (see dbt-core#8409)