Accessing system tables

Options
UserBird
UserBird Dataiker, Alpha Tester Posts: 535 Dataiker

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?

Tagged:

Answers

  • Clément_Stenac
    Clément_Stenac Dataiker, Dataiku DSS Core Designer Posts: 753 Dataiker
    Options
    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)
Setup Info
    Tags
      Help me…