Hi @parvathi.choud - I think you can try using Query data to get the table and convert it into CSV and use Push API to Data pool

https://docs.celonis.com/en/create-and-push-csv-to-data-integration.html

Or

Use Query data and Write Data to Table Process automation skill to update the table ( if your data size is small)

For the pushing part I would agree to utilize Push API.

For the reading however I would suggest the Get Rows Module over the Query data module. As this supports knowledge models as well and is likely to be the preferred solution in the long run

I initially tried Get rows but some of the KPIs that i defined in the KM are not showing that is the reason i switch back to Query data.

Yeah initially created KPI's will appear only when u will publish.

Okay.

Thank you @manuel.wetze