topic UserAgentEntry added to JDBC URL but not visible in Audit logs in Administration & Architecture

UserAgentEntry added to JDBC URL but not visible in Audit logs

Databricks24 — Mon, 04 Dec 2023 07:44:08 GMT

Hi,

As part of Databricks Best Practices, I have added 'UserAgentEntry' to JDBC URL that is being created when we are executing SQL statements through the JDBC driver.

Sample url - jdbc:databricks://<host>:443;httpPath=<httpPath>; AuthMech=3;UID=token;PWD=<token>;UserAgentEntry=<ApplicationName/Year>;

We have also enabled 'DatabricksSQL' category logs from the Diagnostic logging to check for the same. No User Agent value is being set.

Kindly help to resolve the issue.

Thanks

Re: UserAgentEntry added to JDBC URL but not visible in Audit logs

satishdatagaps — Sat, 14 Dec 2024 03:01:59 GMT

Maybe you got a resolution by now, just adding it for others' reference. add UserAgent= not UserAgentEntry=

jdbc:databricks://<host>:443;httpPath=<httpPath>; AuthMech=3;UID=token;PWD=<token>;UserAgent=<ApplicationName/Year>;

Re: UserAgentEntry added to JDBC URL but not visible in Audit logs

satishdatagaps — Mon, 16 Dec 2024 07:18:29 GMT

Sorry, I was mistaken. please ignore the previous response. The correct one is

jdbc:databricks://<host>:443;httpPath=<httpPath>; AuthMech=3;UID=token;PWD=<token>;UserAgentEntry=<ApplicationName/Year>;