Feature list
Feature | Description | General release |
Federated query engine | Realtime & federated queries | Q2 2022 |
Spreadsheet UI | “Spreadsheet” interface to work with data: view, sort, filter etc. | Q2 2022 |
Database & data warehouse connectors | Connectivity to relational and non-relational databases and data warehouses. | Q2 2022 |
SaaS connectors | Connectivity to a wide range of business applications (using API connections) | Q2 2022 |
Schema discovery | Automatic schema discovery for each source | Q2 2022 |
Edit data as virtual copy | Read-only access to source, personal editable copy that remains up to date with the source | Q3 2022 |
Query editor
SQL on anything | Write custom SQL queries, combine data from multiple sources (joins), share the result as new tables | Q3 2022 |
Fuzzy joins | Combine data from different sources based on Fuzzy matching, in case there is no common “key” between the different systems. | Q4 2022 |
Formulas | Add calculated columns with rich formulas (similar to Excel) | Q4 2022 |
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. | Q4 2022 |
Charts | Create charts (e.g. pie, bar, line) from a table | Q4 2022 |
Built-in data warehouse | Set up ETL flows, materialize tables and make them available for access by external BI-tools | Q1 2023 |
Bring your own data warehouse | Connect your existing data warehouse (Snowflake, BigQuery, Azure Synapse etc.) and combine with Peliqan’s built-in data warehouse | Q1 2023 |
Writeback (reverse ETL) | Write back data updates using low-code Python scripts (implement reverse ETL flows). | Q1 2023 |
Connector builder | Build your own ETL and writeback connectors or rely on Peliqan connector services to build them our for you. | Q1 2023 |
On-prem connectivity | Connect to your on premise data sources using a secure VPN tunnel. | Q1 2023 |
Lineage | Show provenance of data | Q2 2023 |
Publish data APIs | Share data products (built in Peliqan) with other teams as consumable APIs | Q3 2023 |
Data masking (PII) | Obfuscate sensitive data using transformations in SQL queries. | Q4 2023 |
Import data from files | Import CSV, JSON, Excel, Google Sheet | Q4 2023 |
Market place | One click install of Metabase etc. | Q4 2023 |
Incoming webhook events | Capture incoming webhooks events | Q4 2023 |
Roadmap
This roadmap is non-binding and will be updated based on customer feedback and strategic choices.
Feature | Description | General release |
Market place new tools | New tools available in the Peliqan Market place with one click install: Airflow, Apache SuperSet, SuperAgent (build private LLMs), Qdrant vector database etc. | Q1 2024 |
Relational model discovery | Detect relational models (ERDs, PKs, FKs) from DB sources and SaaS sources | Q2 2024 |
Governance | Improvements to Peliqan’s permission model | Q2 2024 |
Custom connector builder | Bespoke UI to build custom connectors | Q2 2024 |
Visual Transformations | Visually apply transformations on data (cleaning, dedupe, normalize etc.)
Note: can already be done with SQL | Q2 2024 |
Data Catalog improvements | Pull in data models and metadata from catalogs and/or edit in Peliqan directly | Q3 2024 |
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.
The query engine communicates with data sources directly for databases and data warehouses. For SaaS business applications, Peliqan sets up automated data pipelines behind the scenes to load the data into Peliqan’s built-in data warehouse, or it converts SQL queries to real-time API calls for real-time SaaS data access.