Logging for the Data Exchange
Database Logging in the Data Store
Log Table
For data processing within the Data Store for the Data Exchange, the DE_LOG
table can be queried to retrieve important logging information.
SELECT * FROM {schema_name}.DE_LOG;
Logging Levels
The database logging levels for the Data Exchange are:
- DEBUG
- INFO
- WARNING (default setting)
- ERROR
- CRITICAL
Alter Logging Level for Database Pipelines
You can adjust the logging level to control the amount of diagnostic information captured during data pipeline execution. This is particularly useful for testing, troubleshooting, or performance tuning.
While testing a process, you can increase the logging level to INFO
or DEBUG
. To do this, execute the following command in the Oracle Autonomous Database for your Data Store:
EXEC {schema_name}.LOGGING.SET_SESSION_LOGGING_LEVEL_OVERRIDE('INFO');
For example, to sync a Collection for Data Exchange, you can execute the following commands to get more detailed logging information and have it provided to you immediately.
SET SERVEROUTPUT ON
EXEC {your_model_schema}.LOGGING.SET_SESSION_LOGGING_LEVEL_OVERRIDE('INFO');
EXEC {your_model_schema}.DE_COLLECTION.SYNC_COLLECTION;