Skip to main content
Use Peliqan’s low code Python scripting environment to implement a wide range of use cases with just a few lines of code, ranging from building interactive apps to implementing “writeback” to SaaS applications (reverse ETL). These scripts are called Data Apps in Peliqan, they can use Streamlit for interactive apps with a UI and they can run in the background. You can write, test and run (host) your Python scripts inside Peliqan using the built-in IDE and built-in runtime, or you can use your own IDE such as Visual Studio. When you want to develop locally outside of Peliqan, make sure to pip install Peliqan first (see below).

​
Topics

Basics of data apps

Learn how to create and run your first data app

Reading data from tables

Load data from any table into your Python code

Writing data to tables

Write, upsert, and sync data back to tables

Running apps (manual, schedule etc.)

Configure manual, scheduled, and API runs

Publish & Embed apps

Share apps publicly or embed them in portals

Adding a login to your app

Add authentication and SSO to your apps

Flows

Build visual workflows with code blocks

Local development

Develop outside Peliqan with the Python client

Available Python modules

See which modules are pre-installed

Reference

API reference for Peliqan Python functions

​
Topics by use case

Data Visualization (Streamlit)

Build charts and dashboards

Interactive apps (Streamlit)

Create UIs with buttons, forms, and inputs

Writeback to SaaS APIs

Sync data back to SaaS tools

Alerting & messaging

Send alerts to Slack, Teams, and more

Data enrichment

Enrich your data with external APIs

Reporting

Generate and distribute reports

Working with files

Read and write files in your apps

ETL custom pipelines

Build custom data pipelines

Custom data syncs

Import and sync data between systems

Predictions, Machine Learning templates

Run ML models and predictions

Data quality, monitoring & contracts

Monitor and validate data quality

Working with metadata in scripts

Access metadata in your scripts

Generating UNION queries

Build dynamic UNION queries

Sync data between parent & sub accounts

Sync across accounts

By protocol (REST, Webhooks, MQTT...)

Build integrations by protocol

Generate Union Query

Generate UNION queries dynamically

Slow changing dimensions (history tables)

Track historical data changes

Data masking / obfuscation

Mask sensitive data in outputs

Build a custom MCP Server on Peliqan

Create remote MCP servers