Platform
- - - ETL
    - 100+ sources, one-click data pipelines
    - Data warehouse
    - Built-in or bring your own: Snowflake, Bigquery, SQL Server, Redshift
    - Data syncs
    - Sync data from any source to any destination, Reverse ETL
    - Magical SQL
    - SQL on any data source, ephemeral & materialized
  - - Low-code Python
    - IDE & Runtime, Streamlit, data apps, custom pipelines
    - Federated query engine
    - Built-in Trino, write SQL queries across sources
    - One-click deploy
    - Hosted Metabase, Superset, Airflow, Vector DBs
    - Whitelabel & Embedding
    - For SaaS and consultancy companies
Solutions
- - - DATA INTEGRATION
    - Any data source, any destination
  - - Data to BI
    - Real-time data in any BI tool and spreadsheet
    - Data to DWH
    - One-click ETL pipelines, 100+ sources
  - - Data to SaaS
    - Sync data into your SaaS apps
    - Data to API
    - Send data to any API
- - - DATA ACTIVATION
    - Combine magical SQL and low-code Python
  - - Human interactions
    - Data Cockpit
    - Alerting
    - Reporting
    - Data apps
  - - Automation & integration
    - Publish Data APIs
    - File automation & distribution
    - Data Syncs
    - Low-code automations
- - - EMBEDDED DATA CLOUD
    - For SaaS companies, ISVs and consultancy businesses
Connectors
Docs
Pricing

Analyze email campaign performance

SQL query for Klaviyo

Get email campaign performance data from Klaviyo tables.

SELECT campaign_name, SUM(delivered) as total_delivered, SUM(opened) as total_opened, SUM(clicked) as total_clicked FROM email_campaign_performance_table GROUP BY campaign_name;

Klaviyo data model

Data model coming soon !

Magical SQL for Klaviyo with Peliqan.io

Explore data in a rich spreadsheet UI. Use Magical SQL to combine and transform data. SQL queries become new tables that can be shared with business users and used in any BI tool such as Microsoft Power BI, Tableau or Metabase.

Let AI do the work for you

Peliqan’s AI assistant helps you to write SQL queries to get to insights fast. Ask your question in plain English and immediately see the result in Peliqan’s rich spreadsheet viewer.