You can build data apps using Peliqan’s low-code Python scripts. You can write, test and run your scripts inside Peliqan, or you can use your own IDE such as Visual Studio.

In Peliqan, go to “Build” and click on Create app. You can now start writing your Python script. Use the right pane to insert code examples and snippets. Click on “Save & Run” to run your Python script:

More info on running scripts:

Running apps (manual, schedule etc.)

Using the pq and st modules

Following two main modules are automatically imported in every Python script in Peliqan:

• pq module: to access built-in Peliqan functions
• st module (Streamlit): to show output, visualise data and to add UI elements such as buttons, input fields etc.

Building a UI

Peliqan uses Streamlit as the front-end for your Python scripts, available as the st module (no import needed). Do not use print() in your scripts, instead use st.write(). Example:

st.write("Hello there")

More examples using Streamlit:

st.title("My title")
st.text("My text")
st.line_chart(data)

dbconn = pq.dbconnect(pq.DW_NAME) 
rows = dbconn.fetch('db_name', 'schema_name', 'table_name')

st.table(rows)
st.json(rows)
st.dataframe(rows)

More info:

Interactive apps (Streamlit)

Reading data from a table

You can load data from any table into your Python code: