Use 'user_agent_entry' instead of '_user_agent_entry' when connecting to Databricks SQL

[henryhueske]

With the release 4.0.1 of the Databricks SQL connector (https://github.com/databricks/databricks-sql-python), the connection parameter _user_agent_entry was replaced with the parameter user_agent_entry, see https://github.com/databricks/databricks-sql-python/blob/main/CHANGELOG.md. However, this library still uses the old connection parameter while creating the connection to Databricks, see

databricks-sqlalchemy/src/databricks/sqlalchemy/base.py

Line 426 in b8e499b

cparams["_user_agent_entry"] = add_sqla_tag_if_not_present(ua)

As a result, the following error message occurs:

[databricks.sql.client] [WARN] Parameter '_user_agent_entry' is deprecated; use 'user_agent_entry' instead. This parameter will be removed in the upcoming releases.

Please check this issue (and change the parameter name). Thanks!

[gdubya]

Would be nice if this could be fixed (i.e. merge #45). Any plans for a new release? 🙏🏻 😄

[en93]

Would be amazing if we could have that fix merged 🙏