Loading...

MariaDB

Run read-only SQL queries against your MariaDB database and bring the results into the sheet.

The MariaDB connector runs a SQL query of your choice, read-only, against a MariaDB database you manage: no OAuth required, it uses the host, port, database name, username and password you enter when connecting. MariaDB uses the same network protocol as MySQL, so the connection and query logic work identically.

Only SELECT queries are allowed (optionally preceded by WITH): no INSERT, UPDATE, DELETE or statements that change the schema, checked before every run.

Tip for daily updates: to automatically pull only new data every day (e.g. with a schedule and "Append new results to old" enabled), no special mechanism is needed: write a condition directly in the query using MariaDB's own date functions, evaluated by the database on every run, e.g. WHERE DATE(data_inserimento) = CURDATE() or WHERE data_inserimento >= CURDATE() - INTERVAL 1 DAY. The saved query text never changes, but the result changes every day because these functions are evaluated by the database at execution time, not when you write the query once.

Available metrics

There are no fixed metrics or dimensions: the report columns are exactly the columns your SQL query returns (the column names or aliases used in the SELECT).

Known limits

  • SELECT-only queries (or WITH)
    One statement per query, no INSERT/UPDATE/DELETE or schema changes: checked before every run. A query that fails this check shows an error instead of running.
  • No test when you connect
    The connection page saves what you enter without testing it: the real test happens the first time you select that connection to configure a report, not when you create it.
  • The server must be reachable from the internet
    Does not work with local networks or behind a VPN. The server firewall must allow the IP ranges Google publishes at gstatic.com/ipranges/goog.json, and the port must be 1025 or higher (standard 3306 is fine).
  • SSL/TLS enabled by default, with an opt-out
    By default the connection uses SSL/TLS. If it fails, a checkbox on the connection page lets you disable it — needed either because the server itself doesn't support TLS, or because of a known Google Apps Script limitation with some TLS-enforcing managed servers. Always use a dedicated user with read-only (SELECT) permissions, regardless of this setting.