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
    - Share data with partners & teams
- - - 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

Number of transports per signal

SQL query for Veroo

Count the number of transports associated with each signal in the transports table.

SELECT signal_id, COUNT(*) FROM transports GROUP BY signal_id

Veroo data model

Table Transports

Table Signals List

Magical SQL for Veroo 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.