$status
in this parameterized filtered metric:
SET
command.VIEW
, parameters can be set using the Snowflake SET
statement:
world
, and a parameter called param
, set it as:
world
with 12 as the value of parameter param
.
world
with parameter param
set to the result of UDF my_udf(12)
.
This approach allows complex computation of parameters, using other functions or data in Snowflake.
For example, a user parameter can be used to extract value from a lookup table:
name
: Name of parameter (global)value
: SQL constant expression (i.e. a number or a string)display_name
, owner
, description
, labels
, folder
, hidden
: Metadata