search

dbeatty10 / dbt-mysql

dbt-mysql contains all of the code enabling dbt to work with MySQL and MariaDB
Apache License 2.0
75 stars 52 forks source link

Document MySQL protocol databases #79

Open dbeatty10 opened 2 years ago

dbeatty10 commented 2 years ago

Describe the feature

There are mutliple databases that are described as using the MySQL wire protocol and/or syntax including [1]:

There are probably others too. As we learn of them, it would be nice to document if any compatability testing has done against this adapter. Where applicable, redirect them to the specific adapter for the database.

Additional context

Some databases might not support crucial functionality. An example is TiDB's support for create table as ... select statements (CTAS) (#3839, #4754).

zhangyangyu commented 2 years ago

Hello @dbeatty10, FYI, we've developed a dbt-tidb adapter based on dbt-mysql. We've tested it against several TiDB versions and document the compatibility issues.

Thanks for your excellent work!