Submit your use case or success story to the 2023 edition of the Dataiku Frontrunner Awards ENTER YOUR SUBMISSION

Accessing system tables

Accessing system tables

Hi, we are trying to do a SELECT statement on a system table from a Python recipe. We also tried it using an SQL recipe. However, we are getting the following error from Dataiku:

declare cursor statement may not reference system tables

Is there a way to work around this?

0 Kudos
1 Reply

Unfortunately, there isn't. You might be able to copy information from the system table to a regular table and then query the regular table.

(Note that Aster DB is not officially supported)
0 Kudos


Labels (3)
A banner prompting to get Dataiku