API Reference

Platform Overview

Platform Overview

Spartera operates on a two-platform architecture designed to serve both data
providers and consumers in the modern analytics ecosystem.

Architecture Overview

1. Analytics Platform (app.spartera.com)

The Analytics Platform is where data providers create, manage, and publish
their analytics assets. This platform serves as the development and
management hub for:

Key Capabilities

  • Asset Development: Create calculation and visualization assets using SQL
  • Data Connection Management: Securely connect to your data sources
  • Testing & Validation: Preview and test assets before publishing
  • Internal Analytics: Use assets within your organization
  • Marketplace Publishing: Publish assets for external sale

Supported Data Sources

  • Amazon Redshift
  • Google BigQuery
  • Snowflake
  • Microsoft SQL Server
  • Supabase Analytics & PostgreSQL
  • Teradata Vantage

2. Marketplace Platform (marketplace.spartera.com)

The Marketplace is where buyers discover, purchase, and consume analytics
from trusted data providers.

Key Features

  • Insight Discovery: Browse thousands of ready-to-use analytics
  • Instant Purchase: Buy insights using our credit system
  • API Integration: Consume insights via REST APIs
  • Real-time Processing: Get fresh results with minimal latency
  • Quality Assurance: Verified providers and data quality standards

Data Flow Architecture

Data Source → Connection → Asset → Processing Engine → API Response
     ↓              ↓         ↓            ↓              ↓
  Your DB    Secure Link   SQL Logic   Cloud Compute   JSON/CSV

Security Model

  • Data Never Moves: Computation happens at your data source
  • Encrypted Connections: End-to-end encryption for all data access
  • Credential Management: Secure storage of database credentials
  • Access Control: Granular permissions and visibility settings

Processing Model

For Sellers

  1. Connect your data source securely
  2. Write SQL-based analytics logic
  3. Test on 10% sample data
  4. Publish to marketplace or keep internal
  5. Earn revenue from each execution

For Buyers

  1. Browse marketplace for relevant insights
  2. Preview with free samples
  3. Purchase credits for full access
  4. Integrate via API calls
  5. Scale usage as needed

Integration Patterns

  • Dashboard Integration: Power BI, Tableau, Looker
  • Application APIs: Embed in web/mobile apps
  • Data Pipelines: ETL/ELT workflow integration
  • AI/ML Workflows: Feed insights into models
  • Webhook Events: Real-time data streaming