Hi all,
I'd like to know how to fetch data from data in data pool via pycelonis. Usually I'm using read_excel or read_csv module in my local python but don't know how to read database column from pycelonis. Does anybody know how to do that or sample code in git-hub?
Thanks
Hi Jumbo Szk,
what database you are talking about? data from data model(Query Engine) or raw tables from data storage
Go through these
data Export - https://celonis.github.io/pycelonis/2.3.0/tutorials/executed/02_data_integration/03_data_pull/
Querying across data model tables - https://celonis.github.io/pycelonis/2.3.0/tutorials/executed/02_data_integration/04_data_model_advanced/#33-querying-across-multiple-data-model-tables
Caveat: if you retrieve data from the data Ingestion (i.e. from Data pools tables, using SQL) you will retrieve only 100 lines.
If you want all the data you need to add the table to a temporary data model, upload it, then query it using PQL
Use this sample code link
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
