PostgreSQL
Run read-only SQL queries against your PostgreSQL database and bring the results into the sheet.
The PostgreSQL connector runs a SQL query of your choice, read-only, against a PostgreSQL database (including a managed service like Neon or Supabase): no OAuth required, it uses the host, port, database name, username and password you enter when connecting.
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: just like MySQL, to pull only new data every day (with a schedule and "Append new results to old" enabled), write a condition using PostgreSQL's own date functions directly in the query, e.g. WHERE data_inserimento = CURRENT_DATE or WHERE data_inserimento >= CURRENT_DATE - INTERVAL 1 DAY.
Available metrics
There are no fixed metrics or dimensions: the report columns are exactly the columns your SQL query returns.
Known limits
- SELECT-only queries (or WITH)One statement per query, no INSERT/UPDATE/DELETE or schema changes: checked before every run.
- No test when you connectThe connection page saves what you enter without testing it: the real test happens the first time you select that connection to configure a report.
- SSL handled automaticallyThe connection uses the driver's default behavior (SSL if the server requires it, like Neon/Supabase, otherwise plain): nothing to configure.
- The server must be reachable from the internetDoes not work with local networks or behind a VPN. On a self-managed server (not a service like Neon/Supabase) the firewall must allow Google's IPs (gstatic.com/ipranges/goog.json), and the port must be 1025 or higher (standard 5432 is fine).
Filters and sorting
- The sidebar's filters, sorting and limit don't applySame as MySQL: the SQL query decides everything. Write WHERE, ORDER BY and LIMIT directly in the query.