dbt-duckdb icon indicating copy to clipboard operation
dbt-duckdb copied to clipboard

Published 20 hours ago • verified publisher icon duckdb

[Question] how to attach MySQL Extension in dbt

Open l1xnan opened this issue 1 year ago • 2 comments

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

l1xnan avatar Mar 04 '24 11:03 l1xnan

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

jwills avatar Mar 21 '24 17:03 jwills

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.

peleusj avatar May 24 '24 02:05 peleusj