Extend SQL Result to more than 100 rows?

Hi Rahul,

Unfortunately I didn't find a way to do so. Also using Machine Learning, the export of a transformation is limited to 100 rows.

A workaround that we use is creating a table and store it in a dummy data model. Then, using Machine Learning Workbench and PyCelonis, you can retrieve the complete table by using the 'get_data_frame' function. Note that it is not possible to extract directly from the data pool (e.g. the dummy data model step is really neccessary).

An example script to extract data from the data model can be found at the PyCelonis documentation: https://celonis.github.io/pycelonis/notebooks/01_Pulling_data_from_dm.html . Here you can skip the PQL-query part if you want to extract the complete table.

Hope that this helps.

Kind regards,

Jan-peter

Hi Jan,

Thanks a lot for your reply.

This helps a lot when we are trying to debug some data and there was no way to access whole dataset.

This will solve it.

Will try this.

Thanks again

Rahul Bhat

Glad that I could help!