Like Jitsu? Give us a star on ā­ GitHub!

šŸ“œ Configuration

Configuration UI

šŸ‘©ā€šŸ”¬ Extending Jitsu

Overview
Destination Extensions
Source Extensions
API Specs

Jitsu Internals

SQL debug logs

Jitsu support SQL debug logs: DDL statements as well as CRUD queries. This feature is disabled by default. For enabling it - fill sql_debug_log section in the configuration:

sql_debug_log:
  ddl:
    enabled: true #default value
    path: <sql_debug_log_path_directory> or "global" constant
    rotation_min: 10 # optional, default is 5 minutes. If set 0, 24 hours would be kept
    max_backups: 20 # optional, log files won't be deleted if not set
  queries:
    enabled: false #default value
    path: <sql_debug_log_path_directory> or "global" constant
    rotation_min: 10 # optional, default is 5 minutes. If set 0, 24 hours would be kept
    max_backups: 20 # optional, log files won't be deleted if not set

There are two sections with the same parameters - ddl and queries. Depending on what section is configured, the logger writes only DDL, only CRUD, or both types of queries. If both types of logging are configured to write to the same directory, DDL logs will have *-ddl-debug* name pattern and CRUD logs will have *-sql-debug* names.

FieldDescription
path
(required)

For writing SQL debug logs to global application logs use the constant: global. For writing to separate files use a path to the dir

enabled

Enable or disable logger. SQL Queries log which contains all SQL insert statements can consume a lot of disk space, So it is disabled by default.

rotation_min

How often files should be rotated (will be ignored if global)

max_backups

How many old log files should be kept. By default, all old log files will be kept. (will be ignored if global)