[Question] how to attach MySQL Extension in dbt

Question

[Question] how to attach MySQL Extension in dbt

l1xnan opened this issue 7 months ago · 2 comments

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

Answer 1 · 2024-03-21T17:14:51.000Z

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

Answer 2 · 2024-05-24T02:34:05.000Z

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.