Skip to main content
Question

Extract data from Celonis using SQL script and Pycelonis lib

  • May 17, 2024
  • 1 reply
  • 27 views

rui.mende11
Level 0

Hi Everyone, 

I want to ask if exists some way to extract data with PyCelonis lib but based on SQL scripts ( with transformations, for example). I know that we have access to the SQL script by this example: https://github.com/celonis/pycelonis-examples/blob/main/pycelonis1/03_Connectivity/05_Transformation_Download_to_MLW.ipynb

but my idea is to use this SQL and run it and export (.csv files ) or work this data with Python ( pandas data frame ) .

1 reply

Forum|alt.badge.img+8

Would it be possible to do the transformations in SQL to create a new table and just load the new table in the MLWB through the data model?