Discover all of the brand-new features and improvements to existing capabilities in the Dataiku 11.3 updateLET'S GO

Accessing system tables

UserBird
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
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