Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
l1xnan opened this issue Mar 4, 2024 · 2 comments
Open

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

l1xnan opened this issue Mar 4, 2024 · 2 comments

Comments

@l1xnan
Copy link

l1xnan commented Mar 4, 2024

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

@jwills
Copy link
Collaborator

jwills commented Mar 21, 2024

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
Copy link

peleusj commented May 24, 2024

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants