Connect Dataset

Give this connection a memorable name
Default: 3306 (MySQL), 5432 (PostgreSQL)
This query will be executed to fetch data for analysis
⚠️ Security Note:

Use a read-only database user with minimal privileges. Never use admin credentials.

The API must return JSON data
Filled automatically after OAuth authorization, or enter manually for static API keys
If provided, the access token will be refreshed automatically when it expires
Example response format:
{
  “data”: [
    {“id”: 1, “name”: “John”, “value”: 100},
    {“id”: 2, “name”: “Jane”, “value”: 200}
  ]
}

Name for the dataset created from this file
Default: 22
The directory path on the SFTP server
The filename of the CSV file to sync. If the filename includes a wildcard (*), the latest file available matching the filename pattern will be synced.

How SFTP Sync Works

  • The system will automatically sync this file every hour
  • Only changed files will be re-imported (based on modification time)
  • The CSV file must have headers in the first row
  • Connection remains active for automatic updates
⚠️ Security Note:

Your SFTP credentials are encrypted and stored securely. We recommend using a read-only SFTP account.

If you haven’t done so already, you need to authenticate with your Google account to access your spreadsheets.
A friendly name for this dataset
You can paste the full URL or just the spreadsheet ID.
Example URL: https://docs.google.com/spreadsheets/d/SPREADSHEET_ID/edit
The name of the specific sheet/tab to import (default: Sheet1)
Specify a range to import (e.g., A1:Z1000). Leave empty to import entire sheet.

How to find your Spreadsheet ID:

  1. Open your Google Sheet in a web browser
  2. Look at the URL in the address bar
  3. Copy the long string of letters and numbers between /d/ and /edit
Example:
URL: https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms/edit
Spreadsheet ID: 1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms

Security & Privacy

  • Credentials are encrypted – All database and SFTP credentials are encrypted at rest
  • Read-only access recommended – Use database users and SFTP accounts with SELECT-only/read-only permissions
  • Data stays external – We don’t import your data, only query results for analysis
  • Secure connections – All connections use encrypted protocols when available
  • Automatic sync – SFTP connections sync hourly to keep your data up-to-date