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

Top pages by views

SQL query for HubSpot Analytics

Get top pages by number of views in descending order.

SELECT page_id, SUM(views) AS total_views FROM pages_daily GROUP BY page_id ORDER BY total_views DESC

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.