Hi there,

I have a Data Model and a Data Pool containing two tables: "REQUESTS" and "ACTIVITIES".

I want to access "REQUESTS" in the Workbench via PyCelonis, select several columns and transfer them into a DataFrame.

The connection could be established successfully:

data_pool = celonis.data_integration.get_data_pools().find('Process-Block')

data_model = data_pool.get_data_models().find('Data Model')

If I now try to output the individual tables with

data_model.get_tables

(source: https://celonis.github.io/pycelonis/1.6.0/tutorials/api_tutorial/04_PQL_and_Python_2/#4-interaction-with-the-celonis-resource-object)

I get as output ID and name of the datamodel, but not the individual tables, as described in the documentation. Also the commands are outdated. Instead of .tables .get_tables must be used in the current version.

Since I can't display the tables, I also can't proceed with the following function according to the doc:

List all the columns of a Data Model Table

datamodel.tables.find('ACTIVITIES').columns

Questions:

How can I specifically extract data from a specific table / columns of the Data Model and transfer it to a dataframe (Inside the Wokbench / PyCelonis)?

Is there an actual doc for pushing data from / to the Data Model?

I am looking forward to your advice.