[Question] how to attach MySQL Extension in dbt

[l1xnan]

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

[jwills]

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]

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.