Connecting an outside source — Postgres, MySQL, Google Sheets, a file URL, or a REST API

The Data Lake isn't limited to Turtini data — you can pull in a database, spreadsheet, or file from outside and query it right alongside everything else. Open the Datasets tab at /warehouse and find "Connect a source."

Pick a connector:
• PostgreSQL — read tables straight from a Postgres database.
• MySQL — read tables from a MySQL / MariaDB database.
• Google Sheets — pull a spreadsheet in as a live table.
• CSV / Parquet URL — point at a hosted CSV or Parquet file over HTTPS.
• REST / JSON API — ingest JSON records from an HTTP endpoint.

The guided flow:
1. Click a connector. An inline form opens (not a pop-up).
2. Name the connection and fill in its config (host, database, spreadsheet ID, URL, etc.) and its credentials (user/password, service-account key, token). Credentials are password fields.
3. Click Test connection. Turtini connects and lists the tables it found.
4. Pick the tables you want to sync (they're all pre-selected for you), then click Connect & sync.

Each connected source becomes datasets you can query. The connection is listed with its last-sync time and a Re-sync button to pull fresh data on demand.

Where your credentials live:
Credentials are sent to the backend once and stored securely in Secret Manager, server-side — never in your browser and never in the database. Turtini's servers own the driver; the form just collects what's needed to connect.