Alberto_Umana
Databricks Employee
Databricks Employee

‎12-02-2024 05:40 AM

Hello @techg,

Could you try with below query?

SELECT * FROM table
WHERE (:country IS NULL OR country = :country)
AND (:period IS NULL OR period = :period)
AND (:Document IS NULL OR Doc = :Document)