Overview Quickstart CLI Commands .sql Models .py Models profiles.yml sources.yml Execution Paths

MARIADB

Community-developed fork of MySQL. Drop-in replacement with enhanced performance and additional storage engines.

PREREQUISITES

Driver: mysqlclient — installed automatically by:

dvt sync

CONFIGURATION FIELDS

FIELD	TYPE	REQUIRED	DEFAULT	DESCRIPTION
type	string	yes	—	Must be `mariadb`
host	string	yes	localhost	Database server hostname
port	integer	no	3306	Database server port
user	string	yes	—	Database username
password	string	yes	—	Database password
schema	string	yes	—	Database/schema name
threads	integer	no	4	Number of parallel threads

PROFILES.YML EXAMPLE

my_project:
  target: maria_dev
  outputs:
    maria_dev:
      type: mariadb
      host: localhost
      port: 3306
      user: analyst
      password: "{{ env_var('MARIA_PASSWORD') }}"
      schema: warehouse

SOURCES.YML EXAMPLE

sources:
  - name: legacy_db
    connection: maria_dev
    schema: erp
    tables:
      - name: invoices
      - name: vendors

INCREMENTAL STRATEGIES

✓ Append✓ Delete+Insert✓ Merge

KNOWN LIMITATIONS

⚠Uses MySQL protocol — same driver as MySQL