Percona Server for MySQL
Supported versions
From 5.6 to 8.0.33
Supported schema elements and metadata
Dataedo reads the following metadata from Percona databases.
-
Tables
-
Columns
-
Data type with length
-
Nullable
-
Default value
-
Generated column formula
-
-
Primary keys
- Columns
-
Unique indexes
- Columns
-
Foreign keys
- Columns
-
Triggers
-
When triggered
-
Script
-
-
-
Views
-
Columns (see tables)
-
Script
-
-
Procedures
-
Script
-
Parameters
-
-
Functions
-
Script
-
Parameters
-
Returned value
-
Comments
Dataedo reads Percona comments from the following objects:
-
Tables
-
Columns
-
Primary keys
-
Unique indexes
-
-
Views
- Columns
-
Procedures
-
Functions
Dataedo does not write comments back to Percona.
Data lineage
Dataedo builds Percona lineage using MySQL Parser. Check the capabilities of automatic lineage.
Data profiling
Dataedo supports the following data profiling in Percona:
-
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.
Limitations
The following schema/metadata elements currently are not supported:
Connection:
- SSL connection is currently not supported
