Can I show the SQL output in the logs?

Applies to

• Liquibase Pro
• Liquibase Open Source (Community)

Conditions

• Liquibase Pro and Open Source 4.6.2+

Question

Can I show the SQL output in the logs?

Answer

Yes, Liquibase provides options to display the SQL output in the logs. This feature is particularly helpful for debugging or reviewing the SQL statements generated by Liquibase before they are applied to the database.

You will need to enable the sql-log-level attribute, which controls how much information from the SQL Liquibase shows in the log. 

Note: The --log-level property is required for --sql-log-level to operate successfully.

Related Article(s)

• sql-log-level
• log-level