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 | | Custom connector builder | Bespoke UI to build custom connectors (private instances only). Missing a connector ? Contact us, our connector team can build a new connector in a few business days. | | Relational model discovery | Detect relational models (FKs) from DB sources and SaaS sources. |

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 (Trino) or as direct queries on the DB or DW.