Supported Data Sources

Spartera connects directly to your existing data infrastructure — no migration, no replication, no bulk copying. Your data stays in place — only the results and feeds you publish are served. We support all major cloud data warehouses and relational databases.

Amazon Web Services (AWS)

Amazon Redshift

Cloud data warehouse optimized for large-scale analytics and BI workloads.

Auth: AWS Access Keys or IAM roles
Best for: Large-scale analytics, columnar queries, business intelligence

Amazon Redshift Serverless

Same as Redshift but scales automatically with no cluster management.

Auth: AWS Access Keys or IAM roles
Best for: Variable or unpredictable workloads

Amazon Aurora (MySQL-compatible)

High-performance MySQL-compatible relational database.

Auth: Database credentials or IAM database authentication
Best for: Transactional workloads, MySQL migrations

Amazon Aurora (PostgreSQL-compatible)

High-performance PostgreSQL-compatible relational database.

Auth: Database credentials or IAM database authentication
Best for: PostgreSQL migrations, complex queries

Amazon Aurora Serverless

On-demand, auto-scaling Aurora — starts and stops based on usage.

Auth: Database credentials or IAM database authentication
Best for: Intermittent workloads, development environments

Amazon RDS MySQL

Managed MySQL with automated backups, multi-AZ, and read replicas.

Auth: Database credentials or IAM database authentication
Best for: Traditional MySQL workloads

Google Cloud Platform (GCP)

Google BigQuery

Serverless, petabyte-scale analytics warehouse with built-in ML capabilities.

Auth: Service Account JSON key
Best for: Real-time analytics, large dataset queries, ML integration
Note: Spartera is built on GCP — BigQuery connections have the most optimized performance

Cloud SQL (MySQL)

Fully managed MySQL on GCP.

Auth: Built-in database auth or Cloud SQL Proxy
Best for: Web application backends on GCP

Cloud SQL (PostgreSQL)

Fully managed PostgreSQL on GCP.

Auth: Built-in database auth or Cloud SQL Proxy
Best for: PostgreSQL workloads on GCP

Multi-Cloud Platforms

Snowflake

Cloud-native data platform with cross-cloud data sharing and time travel.

Auth: Username/password or key pair authentication
Best for: Multi-cloud environments, data sharing, diverse workloads

Teradata Vantage

Enterprise analytics platform for complex mixed workloads.

Auth: Database credentials or LDAP
Best for: Large enterprise analytics, complex analytical processing

Databricks SQL

Lakehouse SQL warehouse for analytics over Delta Lake tables.

Auth: Personal access token or service principal
Best for: Lakehouse analytics, Delta tables, unified data and ML workloads

Database Platforms

Microsoft SQL Server

Enterprise RDBMS with Integration and Reporting Services.

Auth: SQL Server auth or Windows authentication
Best for: Enterprise applications, existing SQL Server investments

Supabase (PostgreSQL)

Open-source PostgreSQL with real-time capabilities and a built-in API.

Auth: Connection strings or API keys
Best for: Modern application backends, real-time features

Supabase Analytics

Analytics-focused PostgreSQL for user behavior and event tracking.

Auth: Project API keys and service roles
Best for: Application analytics, event tracking

Connection Requirements

Network Access

Your database must allow outbound connections to Spartera's processing endpoints. For databases behind firewalls, you'll need to whitelist Spartera's IPs:

Environment	IP Address
Production	34.70.197.249
Staging	34.57.29.87

Permissions

Spartera requires read-only access only. Never grant write, delete, or admin permissions.

-- Minimum required PostgreSQL permissions
GRANT CONNECT ON DATABASE your_db TO spartera_user;
GRANT USAGE ON SCHEMA your_schema TO spartera_user;
GRANT SELECT ON ALL TABLES IN SCHEMA your_schema TO spartera_user;

-- Minimum required MySQL permissions
GRANT SELECT ON your_database.* TO 'spartera_user'@'%';

For BigQuery, the minimum IAM roles are:

roles/bigquery.dataViewer
roles/bigquery.jobUser

Security Model

All connections are:

Read-only — Spartera cannot modify your data
Encrypted — TLS 1.2+ for all data in transit
Credential-secured — Credentials are encrypted at rest and never exposed in logs
Audited — All connection activity is logged

Requesting a New Data Source

Don't see your database listed? We add new connectors regularly based on demand. Submit a request at [email protected] with the subject line "New Connector Request."

Current most-requested connectors in the pipeline: Clickhouse, MongoDB Atlas.