topic Re: Issue with Using Parameters for Table Version Selection in Databricks Dashboards in Data Engineering

Issue with Using Parameters for Table Version Selection in Databricks Dashboards

Barbarossa — Fri, 06 Dec 2024 10:53:50 GMT

Hello Databricks Community,

I have a quick question regarding the dashboarding functionality in Databricks:

I’m utilizing table versioning, but I’m having trouble using a parameter to select a specific version as an input filter for my dashboard. Despite setting up the parameter, it doesn’t seem to work as expected:

However, when using the "Timestamp As Of" feature, everything functions perfectly:

Has anyone encountered a similar issue or have any insights on how to resolve this?

Thanks in advance and have a great day!

Re: Issue with Using Parameters for Table Version Selection in Databricks Dashboards

Walter_C — Fri, 06 Dec 2024 12:17:59 GMT

It seems that indeed there is a restriction with the usage of params and the VERSION AS OF functionality as the same behavior is showed when running it directly in the SQL editor. As per docs it states that only date or timestamp strings are accepted.

Re: Issue with Using Parameters for Table Version Selection in Databricks Dashboards

Barbarossa — Fri, 06 Dec 2024 12:58:07 GMT

Thanks Walter_C !