MariaDB

Supported versions

MariaDB Server from 5.1 to 11.x

Some versions of MariaDB Columnstore may cause issues - we have tested and version 1.1.2-1 works properly.

If you do run into any issues please post here.

Dataedo reads the following metadata from MariaDB databases.

Tables
- Columns
  - Data type with length
  - Nullable
  - Default value
  - Data lineage*
- Primary keys
  - Columns
- Unique indexes
  - Columns
- Foreign keys
  - Columns
- Triggers
  - When triggered
  - Script
Views
- Columns (see tables)
- Script
Procedures
- Script
- Parameters (may not work on older versions of MariaDB)
Functions
- Script
- Parameters (may not work on MariaDB 5.1)
- Returned value (may not work on MariaDB 5.1)

* Column-level data lineage is retrieved using Dataedo SQL parser. Read more about the capabilities of the MySQL SQL parser.

Dataedo reads MariaDB comments from the following objects:

Dataedo does not write comments back to MariaDB.

Dataedo supports the following data profiling in MariaDB:

Tables
- Rows count
Column distribution
- Distinct values
- Non-distinct values
- Empty
- NULL
Numeric columns profile
- Minimum value
- Maximum value
- Average of values
- Variance of values
- Standard deviation
- Span as the difference between min and max value
- Number of distinct values
String columns profile
- Min value as the first string in alphabetical order
- Max value as the last string in alphabetical order
- Number of distinct values
Date columns profile
- Min value as the earliest date
- Max value as the latest date
- Span as the difference between min and max dates
- Number of distinct dates
Top N values
- Top 10/100/1000 popular values
- All values if less than 1000 distinct
- 10 Random values

Read more about profiling in the Data Profiling documentation.

The following schema/metadata elements currently are not supported: