MySQL
Ingest tables from a MySQL database with a SQL query.
The MySQL connector ingests data from a MySQL database. You give it a query, and the rows it returns become a table in Gaur.
Create a secret
The MySQL connector needs a MySQL secret to connect to your database. Create one with connector type MySQL and these fields:
| Field | Required | Description |
|---|---|---|
host | Yes | Database host. |
port | Yes | Database port. |
database | Yes | Database name. |
user | Yes | Database user. |
password | Yes | Password for the user. |
ssl_mode | No | SSL mode for the connection. Defaults to disabled. |
Give Gaur a read-only database user where you can. The credentials are encrypted and reused for every ingestion and refresh from this database.
Ingest a table
Choose the MySQL connector
In the Ingestion area, pick MySQL and select the MySQL secret you created.
Write the query
Provide a SELECT query for the data you want. Its result set becomes the
table, so pick columns, join, and filter in the query.
Name the table and ingest
Name the resulting table. Gaur runs the ingestion as a background job, infers the schema, and creates the table.
Refreshing
MySQL tables support full, append, and incremental refreshes, on demand or on a schedule. Incremental refresh pulls only rows that changed since the last run, tracked by a cursor column. See Refreshes.