Skip to main content

Hi Team,

I am trying to create a table in a specific data job before which i have done some calculations using pandas and i want to perform SQL using that table in the datajob.

But the tutorial gives the datapool create tables and i am not able to access it in Datajob i need.

Is there any way to do this?

When i force the data_source_id while creating the table in data pool, it gives an error saying it cannot find that table and source id.

imageimagePlease let me know if there is a way.

Thank you

Hi Rahul,

could you share the full code snippet where you create the table? Are you passing the data source id of the connection your job uses to the create_table function?

Hi Rahul,

could you share the full code snippet where you create the table? Are you passing the data source id of the connection your job uses to the create_table function?

Hello Simon,

Please find below the screenshot.

Yes i am passing the data_source_id as a part of the parameter

image

Hello Simon,

Please find below the screenshot.

Yes i am passing the data_source_id as a part of the parameter

image

Which version of PyCelonis are you using? There was a fix in v2.0.1 for creating tables with data source id. Can you upgrade to the latest version?

 

https://celonis.github.io/pycelonis/2.4.1/changelog/#version-201

Hello Simon,

Please find below the screenshot.

Yes i am passing the data_source_id as a part of the parameter

image

Hello simon,

I am using 2.0.0

I will upgrade to the next version and check

Thank you

Reply


Terms & ConditionsCookie settings