Connect Database – QuantumLayers

Connect Dataset

Dataset Name *

Give this connection a memorable name

Database Type *

Host *

Port

Default: 3306 (MySQL), 5432 (PostgreSQL)

Database Name *

Username

Password

Service (Optional)

Query Template (Optional)

SQL Query *

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.

Privacy Setting

Private – Only you can accessPublic – Anyone with link can view

Dataset Name *

API Endpoint URL *

The API must return JSON data

API Key (Optional)

If your API requires authentication

Example response format:
{
  “data”: [
    {“id”: 1, “name”: “John”, “value”: 100},
    {“id”: 2, “name”: “Jane”, “value”: 200}
  ]
}

Privacy Setting

Private – Only you can accessPublic – Anyone with link can view

Dataset Name *

Name for the dataset created from this file

SFTP Host *

Port

Default: 22

Username *

Authentication Method *

PasswordSSH Private Key

Password *

SSH Private Key *

Paste your SSH private key here (typically from ~/.ssh/id_rsa)

Remote Directory Path *

The directory path on the SFTP server

CSV Filename *

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.

Privacy Setting

Private – Only you can accessPublic – Anyone with link can view

If you haven’t done so already, you need to authenticate with your Google account to access your spreadsheets.

Dataset Name *

A friendly name for this dataset

Spreadsheet ID or URL *

You can paste the full URL or just the spreadsheet ID.
Example URL: https://docs.google.com/spreadsheets/d/SPREADSHEET_ID/edit

Sheet Name

The name of the specific sheet/tab to import (default: Sheet1)

Range

Specify a range to import (e.g., A1:Z1000). Leave empty to import entire sheet.

Privacy Setting

Private – Only you can accessPublic – Anyone with link can view

How to find your Spreadsheet ID:

Open your Google Sheet in a web browser
Look at the URL in the address bar
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