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
If your API requires authentication
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