Feature list
Feature | Description |
Federated query engine | Realtime & federated queries |
Spreadsheet UI | “Spreadsheet” interface to work with data: view, sort, filter etc. |
Database & data warehouse connectors | Connectivity to relational and non-relational databases and data warehouses. |
SaaS connectors | Connectivity to a wide range of business applications (using API connections) |
Schema discovery | Automatic schema discovery for each source |
Edit data as virtual copy | Read-only access to source, personal editable copy that remains up to date with the source |
Query editor
SQL on anything | Write custom SQL queries, combine data from multiple sources (joins), share the result as new tables |
Build data apps (low-code) | Build data apps using low-code Python scripting:
* Interactive dashboards
* Writebacks (reverse ETL)
* Machine learning (predictions, outliers etc.)
* Data monitoring with Slack alerts
* Etc. |
BI | Connect any BI tool (Power BI, Tableau, Qlik, Looker, Metabase…) or deploy Metabase from Peliqan Market Place |
Built-in data warehouse | Set up ETL flows, materialize tables and make them available for access by external BI-tools |
Bring your own data warehouse | Connect your existing data warehouse (Snowflake, BigQuery, Redshoft, Microsoft Fabric etc.) and combine with Peliqan’s built-in data warehouse |
Writeback (reverse ETL) | Write back data updates using low-code Python scripts (implement reverse ETL flows). |
Connector builder | Build your own ETL and writeback connectors or rely on Peliqan connector services to build them our for you. |
On-prem connectivity | Connect to your on premise data sources using a secure VPN tunnel. |
Lineage | Show provenance of data and to impact analysis |
Publish data APIs | Share data products (built in Peliqan) with other teams as consumable APIs |
Data masking (PII) | Obfuscate sensitive data using transformations in SQL queries. |
Import & export data from and to files | Import & export CSV, JSON, Excel, Google Sheet etc. |
Market place | One click install of Metabase, Airflow, Apache SuperSet, SuperAgent (build private LLMs), Qdrant vector database etc. |
Incoming webhook events | Capture incoming webhooks events |
Roadmap
This roadmap is non-binding and will be updated based on customer feedback and strategic choices.
Feature | Description | General release |
Relational model discovery | Detect relational models (FKs) from DB sources and SaaS sources | Q3 2024 |
Custom connector builder | Bespoke UI to build custom connectors | Q4 2024 |
Governance | Improvements to Peliqan’s permission model | Q4 2024 |
Visual Transformations | Visually apply transformations on data (cleaning, dedupe, normalize etc). Note: can already be done with SQL | Q1 2025 |
Data Catalog improvements | Pull in data models and metadata from catalogs and/or edit in Peliqan directly | Q1 2025 |
Architecture
Peliqan’s all-in-one data platform architecture consists of multiple layers, deployed as micro-services in a cloud-agnostic Kubernetes environment:
The UI layer converts all data access to SQL queries that are executed in real-time using Peliqan’s federated query engine (Trino) or as direct queries on the DB or DW.