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

Issues resolved by assignee

SQL query for Jira

Retrieve the count of issues resolved by each assignee.

SELECT assignee, COUNT(*) AS resolved_issues FROM table_name WHERE status = ‘Resolved’ GROUP BY assignee;

Jira data model

Table Issues

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