Tag Archives: query history in netezza

Every once and a while, it happens that a SQL needs to be reused, but for whatever reason it was not saved. If it wasn’t too far back in time, you can recover the SQL from the User Query History. This is a fairly straight forward process, if not exactly obvious.

The basic process is:

Connect to the database

Navigate to View > User Query History

Aginity View User Query History

Select the SQL Statement you want to retrieve

note: you want to select a databases and or user to narrow you rows returned.