Skip to main content
INFOColumn-level Lineage is not currently supported for MariaDB.
Steps to complete:
  1. Run SQL script for permissions and create schema for Datafold
  2. Configure your data connection in Datafold

​
Run SQL script and create schema for Datafold

To connect to MariaDB, create a user with read-only access to all tables you wish to diff. Include read and write access to a Datafold-specific dataset: 
-- Create a temporary dataset for Datafold to utilize
CREATE DATABASE IF NOT EXISTS datafold_tmp;

-- Create a Datafold user
CREATE USER 'datafold_user'@'%' IDENTIFIED BY 'SOMESECUREPASSWORD';

-- Grant read access to diff tables in YourSchema
GRANT SELECT ON `YourSchema`.* TO 'datafold_user'@'%';

-- Grant access to all tables in a datafold_tmp database
GRANT ALL ON `datafold_tmp`.* TO 'datafold_user'@'%';

-- Apply the changes
FLUSH PRIVILEGES;
Datafold utilizes a temporary dataset, named datafold_tmp in the above script, to materialize scratch work and keep data processing in the your warehouse.

​
Configure in Datafold

Field NameDescription
Connection nameA name given to the data connection within Datafold
HostThe hostname for your MariaDB instance
PortMariaDB connection port; default value is 3306
UsernameThe user created in our SQL script, named datafold_user
PasswordThe password created in our SQL script
DatabaseThe name of the MariaDB database (schema) you want to connect to, e.g. YourSchema
Dataset for temporary tablesThe datafold_tmp database created in our SQL script
Click Create. Your data connection is ready!