Skip to main content

Good morning everyone,

 

Is there a way for me to extract more than 100 rows of data from the Transformations / Event Collection workspaces?

 

For some context, we don't have access to the SAP environment from where we are extracting the data; we do, however, need to provide a considerable sample of the data we're working with to validate with the team.

 

If I do a regular SELECT * FROM CDPOS for example, I will only be able to get 100 rows of data at a time

 

Thank you in advance!

 

P.S: Apologies if this is not posted in the appropriate place!

Hello Vasco Carona,

 

This is not possible as far as I am aware, but you can add the table to a data model, and then there you can increase the extraction limit, and export it as a table.

 

Paul


Hello Vasco Carona,

 

This is not possible as far as I am aware, but you can add the table to a data model, and then there you can increase the extraction limit, and export it as a table.

 

Paul

Hello Paul,

 

That's what I thought, thank you for the feedback

 

 

Vasco


Hi Vasco

 

You can use pycelonis to get the data you're looking for: https://celonis.github.io/pycelonis/notebooks/01_Pulling_data_from_dm.html

 

Best

Johannes


Reply