Supported Data Sources

Spartera connects directly to your existing data infrastructure — no migration, no replication, no data movement. Your data stays where it is. 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

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 support@spartera.com with the subject line "New Connector Request."

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