search

preset-io / backend-sdk

Other
36 stars 26 forks source link

Superset-cli don't support dbt target of type trino. #326

Closed andrewcaoo closed 1 day ago

andrewcaoo commented 1 day ago

I'm trying to sync data asynchronously from dbt-core to Superset using superset-cli. The setup is mostly working, but I run into issues when I try to execute the following command:

superset-cli -u admin -p admin http://localhost:8088 sync dbt-core ./target/manifest.json --profiles=./profiles.yml --target=wh_demo --project=dbt_semantic_layer_demo --import-db

Error message:

"Unable to build a SQLAlchemy URI for a target of type trino.'

For context, my system includes dbt-core, ClickHouse, and Superset. Data flows from dbt-core to ClickHouse, and Superset imports this data, all using a Trino connection.

The issue is that I’m unsure how superset-cli handles asynchronous data sync, so I'm struggling to diagnose or resolve this error. Any guidance on resolving this, or documentation on Superset’s data sync workflow with superset-cli, would be greatly appreciated!

andrewcaoo commented 1 day ago

The solution is manualy database creation on superset. The name of database have to follow by structure $project_name_@$target_name