MySQL / MariaDB

Async MySQL/MariaDB connector using aiomysql and sqlglot.

Property	Value
Key	mysql
Source type	mysql
Implementation	native
Active by default	yes
Default cache strategy	deterministic_first
Capabilities	supports_discovery, supports_field_permissions, supports_ingestion, supports_proxy, supports_query, supports_write

Implementation is how complete the adapter is. It is not a release status: what the project supports and has certified is on Feature status and in the connector support matrix, and nothing is past public beta yet.

Connection configuration

Secret fields should be given as a reference, <field>_ref, such as env://NAME, rather than a literal.

Key	Secret
host	no
port	no
database	no
user	no
password_ref	no
password	yes; prefer password_ref

Default role templates

Offered when a source is created with default roles. Edit them to fit.

blocked

Effect	Action	Resource type	Pattern
deny	*	*	*

maintainer

Effect	Action	Resource type	Pattern
allow	db.schema.list	db.schema	*
allow	db.table.describe	db.table	*.*
allow	db.table.select	db.table	*.*
allow	discovery.search	discovery.asset	*
allow	discovery.asset.read	discovery.asset	*
allow	db.table.insert	db.table	*.*
allow	db.table.update	db.table	*.*
allow	db.table.delete_rows	db.table	*.*

read

Effect	Action	Resource type	Pattern
allow	db.schema.list	db.schema	*
allow	db.table.describe	db.table	*.*
allow	db.table.select	db.table	*.*
allow	discovery.search	discovery.asset	*
allow	discovery.asset.read	discovery.asset	*

schema_owner

Effect	Action	Resource type	Pattern
allow	*	*	*

writer

Effect	Action	Resource type	Pattern
allow	db.schema.list	db.schema	*
allow	db.table.describe	db.table	*.*
allow	db.table.select	db.table	*.*
allow	discovery.search	discovery.asset	*
allow	discovery.asset.read	discovery.asset	*
allow	db.table.insert	db.table	*.*
allow	db.table.update	db.table	*.*