Supported versions
5.1, 5.5, 5.6, 5.7, 8.0
Supported schema elements and metadata
Dataedo reads following metadata from MySQL databases.
- Tables
- Columns
- Data type with length
- Nullable
- Default value
- Generated column formula
- Data lineage*
- Primary keys
- Columns
- Unique indexes
- Column
- Foreign keys
- Columns
- Triggers
- When triggered
- Script
- Columns
- Views
- Columns (see tables)
- Script
- Procedures
- Script
- Parameters (not available on MySQL 5.1)
- Functions
- Script
- Parameters (not available on MySQL 5.1)
- Returned value (not available on MySQL 5.1)
* Column-level data lineage is retived using Dataedo SQL parser. Read more about capabilities of MySQL SQL parser
Comments
Dataedo reads MySQL comments from following objects:
- Tables
- Columns
- Primary keys
- Unique indexes
- Procedures
- Functions
Dataedo does not write comments back to MySQL.
Data profiling
Datedo supports following data profiling in MySQL:
- 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 difference between min and max value
- Number of distinct values
- String columns profile
- Min value as first string in alphabetical order
- Max value as last string in alphabetical order
- Number of distinct values
- Date columns profile
- Min value as earliest date
- Max value as latest date
- Span as 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 a Data Profliling documentation.
Limitations
Following schema/metadata elements currently are not supported:
Connection:
- SSL connection is currently supported only for MySQL 8.0
Supported cloud databases
Dataedo should work with all cloud instances of MySQL database. We have tested it with the following services: