Skip to main content
Question

Extract data sources tables

  • February 10, 2026
  • 1 reply
  • 13 views

Antoine_Leduc
Level 2
Forum|alt.badge.img

Hey team,

For a migration topic, I would like to know whether it is possible to extract all the source tables used in a data model. I know that it is possible to extract the final tables of the data model via PyCelonis, but I am interested in the source tables. In a old ECC system.

Thanks for the help !

1 reply

manuel.wetze
Level 10
Forum|alt.badge.img+8
  • Level 10
  • February 10, 2026

Hi Antoine,
maybe I am misunderstanding the question, but it surely seems to be achievable with PyCelonis as well.

E.g. you could get all tables of that datapool with get_tables() (https://celonis.github.io/pycelonis/2.4.0/reference/pycelonis/ems/data_integration/data_pool/#pycelonis.ems.data_integration.data_pool.DataPool.get_tables)
Then you could sort trough them to identify the ones you are interested in. Here is where I didn’t get what exactly you are interested in. So the following are just starting points for you:
I saw for example an attribute “data_source” on them, or you could compare them to the ones you found using a second query of a datamodel object with .get_tables().