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.
Please 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
Hello Simon,
Please find below the screenshot.
Yes i am passing the data_source_id as a part of the parameter
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
Hello simon,
I am using 2.0.0
I will upgrade to the next version and check
Thank you
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
