DBT Error, I was moving data from postgres to mysql , i created a dbt transformation and i am facing below error

Connector Questions & Issues
, ,
1

2023-06-02 08:59:41 dbt > Running from /data/10/2/transform/git_repo
2023-06-02 08:59:41 dbt > detected no config file for ssh, assuming ssh is off.
2023-06-02 08:59:41 dbt > Running: dbt run --profiles-dir=/data/10/2/transform --project-dir=/data/10/2/transform/git_repo
2023-06-02 08:59:46 dbt > 08:59:46 Error importing adapter: No module named ‘dbt.adapters.mysql’
2023-06-02 08:59:46 dbt > 08:59:46 Encountered an error while reading profiles:
2023-06-02 08:59:46 dbt > 08:59:46 ERROR: Runtime Error
2023-06-02 08:59:46 dbt > Credentials in profile “normalize”, target “prod” invalid: Runtime Error
2023-06-02 08:59:46 dbt > Could not find adapter type mysql!
2023-06-02 08:59:46 dbt > 08:59:46 Defined profiles:
2023-06-02 08:59:46 dbt > 08:59:46 - normalize
2023-06-02 08:59:46 dbt > 08:59:46
2023-06-02 08:59:46 dbt > For more information on configuring profiles, please consult the dbt docs:
2023-06-02 08:59:46 dbt >

image
image1696×665 65.6 KB

2023-06-02 08:59:46 dbt > Connection profiles | dbt Developer Hub
2023-06-02 08:59:46 dbt >
2023-06-02 08:59:46 dbt > 08:59:46 Encountered an error:
2023-06-02 08:59:46 dbt > Runtime Error
2023-06-02 08:59:46 dbt > Could not run dbt
3a7a0f51_7094_4897_ab57_0669e7841dd9_logs_10_txt.txt (233.7 KB)

2

Could you show how did you setup the dbt transformations (Airbyte’s transformation tab)? Do you run dbt deps step?

3

image
image1387×468 33.7 KB

i ran olny dbt run

4

latest log files after running dbt deps and dbt run
3a7a0f51_7094_4897_ab57_0669e7841dd9_logs_12_txt.txt (233.8 KB)