Searching for the datasource of tables in a schema

239 Views Asked by At

I've been tasked with trying to find the datasources in one of our system schemas. Is there an SQL statement that can do this? I've tried googling and checking the Exasol User Manual but can't find anything.

1

There are 1 best solutions below

0
On

If you have the auditing enable in your EXASOL database you can use the table EXA_DBA_AUDIT_SQL to find which SQL queries modified your table. The queries are in the SQL_TEXT column.

You can find more information about this table in the Appendix A of the EXASOL manual.