[Question] how to attach MySQL Extension in dbt

duckdb / dbt-duckdb

dbt (http://getdbt.com) adapter for DuckDB (http://duckdb.org)

Apache License 2.0

880 stars 78 forks source link

[Question] how to attach MySQL Extension in dbt #353

Open l1xnan opened 7 months ago

l1xnan commented 7 months ago

see: https://duckdb.org/docs/extensions/mysql#reading-data-from-mysql

jwills commented 6 months ago

Hey, sorry for missing this-- IIRC the regular attach profile setup should work, but the path needs to be the DSN for the mysql connection (and obviously the mysql extension needs to be loaded):

https://github.com/duckdb/dbt-duckdb?tab=readme-ov-file#attaching-additional-databases

peleusj commented 4 months ago

Is there any example of what DSN path should be configured, or is there a complete configuration example? I have been searching through the documents for a long time and don't know how to solve it. Thanks.