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:

peliqan architecture.png

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.