Hi all,
I’d like to work with constants in my manifest file however I can’t seem to get it to work. Am I able to use constant in my sql derived table?
My manifest file:
constant: some_date {
value: “2022-06-10”
}
I want this constant so I can use it across different views.
my sql derived table:
sql: some_query from some_table WHERE date = @{some_date}
… I’ve also tried in quotes:
WHERE date = “@{some_date}”
But this isn’t working. I am getting an error of: “2022-06-10” does not exist in some_table. Any one know what;’s going on?
Best answer by Dawid
View original