Extract data from Celonis using SQL script and Pycelonis lib

Question

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 ) .

Page 1 / 1

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?

natanael.wijay11 · Answer

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?

Sign up