MySQL / MariaDB

Async MySQL/MariaDB connector using aiomysql and sqlglot.

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

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	*.*