Enabling sdv logging causes tests to fail locally

[amontanez24]

Environment Details

Please indicate the following details about the environment in which you found the bug:

• SDV version: 1.15
• Python version: All
• Operating System: All

Error Description

If you enable logging by setting log_registry to 'local' in the sdv_logger_config.yml, the unit tests start to fail. This is because a lot of the unit tests use caplog to test the logs. Caplog adds a new handler to the logger. The first handler (the filehandler we use for sdv logs), modifies the log record here

SDV/sdv/logging/logger.py

Lines 34 to 38 in a0e0a76

	def format(self, record): # noqa: A003
	"""Format the record and write to CSV."""
	row = record.msg
	row['LEVEL'] = record.levelname
	self.writer.writerow(row)

This causes the handler that caplog uses to have a different message than expected and thus the tests fail assertions

Steps to reproduce

1. Set log_registry to 'local' on your config.
2. run invoke unit