Metadata Ingestion issue when Superset using a mariadb backend database

[matthewsullivan44]

trafficstars

Feature Add support for Superset with mariadb database backend

Describe the task When running metadata ingestion the query submitted uses double quoted table names which isn't supported by mariadb. Mariadb quotes identfiers with the backtick character. Also have option to SET SQL_MODE=ANSI_QUOTES; when connecting to mariadb if want to keep sql standard. Here is sample Metadata SQL that fails to run on Mariadb when using superset metadata ingestion.

select s.id from slices s left join "tables" t on s.datasource_id = t.id and s.datasource_type = 'table' left join "dbs" db on db.id = t.database_id LIMIT 1;

[SumanMaharana]

I'll be working on this

[SumanMaharana]

@matthewsullivan44 how did you connect superset with mariadb i looked into the superset docs and i didnt see mariadb in the list of connectors there.

[pmbrull]

hi @matthewsullivan44, according to the superset docs there is no support for MariaDB. Our superset ingestion is based on the supported dbs (MySQL & Postgres) or via API. Thanks