MariaDB
Catalog databases, tables, views, columns, keys and routines through the MariaDB Connector/J and information_schema.
Capabilities
| Capability | Support | Notes |
|---|---|---|
| Tables, views & columns | Supported | |
| Keys, constraints & indexes | Supported | |
| Procedures & functions | Supported | Use the MySQL routines query: MariaDB exposes the same information_schema.ROUTINES and PARAMETERS views. |
| Data lineage | Supported | |
| Lineage from query history | Not available | |
| Business glossary links | Supported | |
| Data quality probes | Supported | |
| Data profiling | Supported | |
| Data classification | Supported | |
| Chat with your data | Supported |
Connection settings
Create the connection on the Blindata Agent from Settings > Agents > Connections with the connection wizard, choosing MariaDB in the technology step.
| Driver class | org.mariadb.jdbc.Driver |
|---|---|
| JDBC URL | jdbc:mariadb://localhost:3306/mysql |
| Authentication |
Service principal (shared technical user) User principal (personal credentials, BYOC) Ephemeral credentials (asked at each run)
|
| Crawling strategy | SQL |
The Blindata Agent does not include this driver: download the vendor JDBC driver and copy the .jar into the agent drivers folder, as described in
Add JDBC drivers.
Driver properties can be added under Advanced settings in the connection wizard.
Prerequisites & permissions
- A Blindata Agent installed with network access to MariaDB.
- The vendor JDBC driver installed on the agent (see Add JDBC drivers).
- A read-only user able to read
information_schemafor the databases to document. SHOW VIEWandSELECTonmysql.procto read view and routine definitions.SELECTon tables for data quality, profiling and Chat with your data.
Set up metadata crawling
- Create the connection to MariaDB on the agent (see Connection settings) and use Test to verify it.
- Create or open the system that represents MariaDB in the catalog and link it to the connection.
- In the CRAWLING tab add a crawling job with strategy SQL and, if needed, replace the default queries with the ones suggested below.
- Run a TEST to check the number of extracted objects, then RUN or schedule the job.
The job options and the column aliases of every extraction query are described in the Generic JDBC reference.
Suggested extraction queries
MariaDB exposes the same information_schema as MySQL: the default SQL strategy queries work out of the box, and the MySQL routines query
can be reused to import routines with their parameters.