Allow enabling DEBUG logs for databricks-sql-connector

[susodapop]

resolves #7859

Description

This change allows us to turn on DEBUG level logs for databricks-sql-connector when invoked from dbt.

Regarding documentation updates: I'm going to open a PR for dbt-databricks that includes more fine-grained control over the logs from databricks-sql-connector. The doc update for this PR will be included at that time.

Checklist

• I have read the contributing guide and understand what's expected of me
• I have signed the CLA
• I have run this code in development and it appears to resolve the stated issue
• This PR includes tests, or tests are not required/relevant for this PR
• I have opened an issue to add/update docs, or docs changes are not required/relevant for this PR
• I have run changie new to create a changelog entry

[aranke]

LGTM!

[aranke]

@susodapop We should be good to merge this, just checking if you have signed the CLA?

[dbeatty10]

@aranke would either you or @peterallenwebb (or both!) be willing to take a peek at @JerCo's comment here?

His key question is:

Is there any way to put this logic inside the dbt-databricks adapter instead?

[susodapop]

We should be good to merge this, just checking if you have signed the CLA?

Yes @aranke I've signed the CLA :)

@dbeatty10 I responded to JerCo's comment in that thread. If this makes more sense in dbt-databricks we can move it there. The existing solution is meant to follow the pattern set for the snowflake connector.

[dbeatty10]

@cla-bot check

[cla-bot]

The cla-bot has been summoned, and re-checked this pull request!

[dbeatty10]

@aranke CLA check is passing now. I'll let you either merge this (or not) depending on the outcome of this discussion: #7859 (comment)

[colin-rogers-dbt]

This won't actually work since it only enables the legacy logger that's being deprecated, see #8643 for inclusion in standard dbt logging

[dbeatty10]

I'm going to close this in favor of #8643 (which has been merged).

We can re-visit this (including re-opening this PR) if needed.