Hello Florain,
FIrst question: which version of PyCelonis are you using? 2.0.0 is quite unusable and unstable, if so downgrade to newest old version 1.7.4. by running command !PIP INSTALL PYCELONIS==1.7.2. or just run it without ! within the terminal.
Second question: is there need to use that certain function? Can you bring more details from where exactly do you want to get the data? Is that from Analysis component, backend table or other source?
Probably I can assume you're trying to get it from the Data Model table.
Third question: how much data are your try to retrive? I can suggest using chunksize option, it's needed if you're trying to get more then 1gb size table. Timeout mentioned in the error message means that probably the response was to big to tackle :)
df = datamodel.get_data_frame(q, chunksize=10000)
df.head()
Best Regards,
Mateusz Dudek
Hi Mateusz,
Thank you very much for your response,
First question: ML Workbench is running at 1.7.2. I tried multiple versions locally. The issue persists in both environments.
Second question: The data resides in a Celonis data model. I am able to query the model, table and its fields, but unable to pull the data itself. Please find a screenshot attached with the console outputs of the queries as well as the error,
Third question: I tried with and without chunksizing. The issue persists with tables <1k rows. So I assume that is not the underlying issue.
As mentioned I tried this with an APP key as well as my personal admin key. Are there any further settings with regards to API and being able to actually pull data, which I am missing? I assume the admin personal key should already have all those permissions.
Much appreciated and kind regards,
Florian