MySQL Data Source Template

  • Published on May 7, 2026
  • 1 minute(s) read
Prev Next

Overview

The MySQL data source template is a marketplace SQL template for MySQL and MariaDB connections. It provides metadata ingestion scripts that query MySQL's information_schema views, data type mappings including MySQL-specific types, and standard profiling definitions using MySQL-compatible SQL expressions.

Platform: MySQL (5.7+) / MariaDB (10.2+)
Connection Category: Database
Template Category: Marketplace

What's Included

Connection Configuration

  • Supports MySQL native and ODBC connections
  • Identifier delimiters: none (unquoted identifiers)

Data Type Mappings

Includes mappings for MySQL data types including platform-specific types:

  • String types: varchar, char, text, MEDIUMTEXT, LONGTEXT, LONGBLOB
  • Numeric types: int, bigint, smallint, tinyint, MEDIUMINT, decimal, numeric, float, double, real, SIGNED, UNSIGNED
  • Date/time types: date, datetime, timestamp, time, year
  • Boolean: boolean, bit
  • Binary/Other: binary, varbinary, MEDIUMBLOB, bytea
  • Enum/Set: ENUM, SET
  • Other: json, uuid

Metadata Ingestion

Schema Level

Queries information_schema.schemata, excluding the information_schema system schema.

Table Level

Queries information_schema.tables joined with information_schema.views to discover base tables and views with view definitions.

Column Level

Queries information_schema.columns to discover columns with data types, ordinal position, nullability, numeric precision/scale, datetime precision, and column comments.

Profiling

Includes the standard set of ~35 profile definitions using MySQL-compatible SQL expressions, including:

  • CHAR_LENGTH() for string length calculations
  • REGEXP for numeric string detection
  • YEAR() for date year extraction
  • row_number() OVER for top/bottom value ranking

Note: Median, standard deviation, lower quartile, and upper quartile profiles are disabled by default because MySQL does not natively support percentile_cont() or STDDEV_POP() as window functions. Enable these if using MariaDB 10.3+ or MySQL 8.0+ with appropriate workarounds.

Installation

Import from the Validatar Marketplace. Navigate to Settings > Data Source Templates > Import and select the MySQL template file.

Customization

Common customizations:

  • Schema filters — Exclude MySQL system databases (mysql, performance_schema, sys)
  • Character set handling — Adjust length calculations for multi-byte character sets
  • Storage engine awareness — Add engine-specific metadata from information_schema.tables
  • Partitioned tables — Extend ingestion to include partition metadata from information_schema.partitions
  • Custom types — Add data type mappings for application-specific column types

Related Articles