Discover this year's submissions to the Dataiku Frontrunner Awards and give kudos to your favorite use cases and success stories!READ MORE

Accessing system tables

UserBird
Dataiker
Dataiker
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
Clément_Stenac
Dataiker
Dataiker
Hi,

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

?
Labels (3)
A banner prompting to get Dataiku