UserAgentEntry added to JDBC URL but not visible in Audit logs

Databricks24
New Contributor

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

satishdatagaps
New Contributor II

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>;

satishdatagaps
New Contributor II

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>;