Several minor changes to stop tests from warning (which in turn lead to better cursor hygiene)
Override get_column_schema_from_query so that the cursor used to get the columns gets closed
Update a path that polls for MV/ST pipeline state to close the created cursor. Added a note that eventually this should be rewritten so that we don't even access a cursor, but that is complicated due to the required path using class methods, so holding until I fix polling when we can update the Databricks SDK.
Updated unit tests that were missing column names for Table objects
After these changes, we no longer have warnings from running unit or functional tests
Checklist
[x] I have run this code in development and it appears to resolve the stated issue
[x] This PR includes tests, or tests are not required/relevant for this PR
[x] I have updated the CHANGELOG.md and added information about my change to the "dbt-databricks next" section.
Description
Several minor changes to stop tests from warning (which in turn lead to better cursor hygiene)
After these changes, we no longer have warnings from running unit or functional tests
Checklist
CHANGELOG.mdand added information about my change to the "dbt-databricks next" section.