Comment
Databricks Employee
Databricks Employee

First for background: Are you looking for  CURRENT TEMPORAL SYSTEM_TIME (Db2) ?

What Spark is missing to get a variable reference  to work in a view is to persist the variable definition in catalog (HMS or UC). That has been on by wishlist for a loooong time.

The best I can offer you is to perhaps look at secrets. They tend to be (ab)used for this purpose.