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

Average session duration

SQL query for HubSpot Analytics

Calculate the average duration of visitor sessions.

SELECT AVG(duration) AS average_duration FROM visitor_sessions_daily

HubSpot Analytics data model

Table Pages Daily

Table Sources Daily

Table Sessions Daily

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