New variable methods
Use case to utilize if-then-else logic, assigning values when expressions evaluate to true –> learn more
CASE
@case
ELSE @defaultValue
END
dynamic (input-dependent)
Name | Type | Allowed values | Required | Placeholder (in UI) |
---|---|---|---|---|
@case | true | - | ||
@defaultValue | true | (Value) |
SAFE_CAST(@expression AS @castType)
dynamic (input-dependent)
@literal
dynamic (input-dependent)
Name | Type | Allowed values | Required | Placeholder (in UI) |
---|---|---|---|---|
@literal | true | - |
Returns an MD5 hash of all values as a base64 encoded string. Non-string values will be first coerced to strings. Note that order of inputs will affect the hash. –> learn more
TO_BASE64(MD5(CONCAT(@expression)))
string
Name | Type | Allowed values | Required | Placeholder (in UI) |
---|---|---|---|---|
@expression | true | (values) |
GENERATE_UUID()
string
CURRENT_DATE([@time_zone])
date
Name | Type | Allowed values | Required | Placeholder (in UI) |
---|---|---|---|---|
@time_zone | any of: ACDT , ACST , ACT , ACT , ACWST , ADT , AEDT , AEST , AFT , AKDT , AKST , AMST , AMT , AMT , ART , AST , AST , AWST , AZOST , AZOT , AZT , BDT , BIOT , BIT , BOT , BRST , BRT , BST , BST , BST , BTT , CAT , CCT , CDT , CDT , CEST , CET , CHADT , CHAST , CHOT , CHOST , CHST , CHUT , CIST , CIT , CKT , CLST , CLT , COST , COT , CST , CST , CST , CT , CVT , CWST , CXT , DAVT , DDUT , DFT , EASST , EAST , EAT , ECT , ECT , EDT , EEST , EET , EGST , EGT , EIT , EST , FET , FJT , FKST , FKT , FNT , GALT , GAMT , GET , GFT , GILT , GIT , GMT , GST , GST , GYT , HDT , HAEC , HST , HKT , HMT , HOVST , HOVT , ICT , IDLW , IDT , IOT , IRDT , IRKT , IRST , IST , IST , IST , JST , KALT , KGT , KOST , KRAT , KST , LHST , LHST , LINT , MAGT , MART , MAWT , MDT , MET , MEST , MHT , MIST , MIT , MMT , MSK , MST , MST , MUT , MVT , MYT , NCT , NDT , NFT , NPT , NST , NT , NUT , NZDT , NZST , OMST , ORAT , PDT , PET , PETT , PGT , PHOT , PHT , PKT , PMDT , PMST , PONT , PST , PST , PYST , PYT , RET , ROTT , SAKT , SAMT , SAST , SBT , SCT , SDT , SGT , SLST , SRET , SRT , SST , SST , SYOT , TAHT , THA , TFT , TJT , TKT , TLT , TMT , TRT , TOT , TVT , ULAST , ULAT , UTC , UYST , UYT , UZT , VET , VLAT , VOLT , VOST , VUT , WAKT , WAST , WAT , WEST , WET , WIT , WST , YAKT , YEKT | false | (UTC (default)) |
DATE(@year, @month, @day)
date
DATE_ADD(@date_expression, INTERVAL @integer_expression @date_part)
date
DATE_DIFF(@date_expression, @date_expression2, @date_part)
integer
DATE_SUB(@date_expression, INTERVAL @integer_expression @date_part)
date
DATE_TRUNC(@date_expression, @date_truncate_part)
date
Name | Type | Allowed values | Required | Placeholder (in UI) |
---|---|---|---|---|
@date_expression | true | (date) | ||
@date_truncate_part | any of: day , month , quarter , year , week(sunday) , week(monday) , week(tuesday) , week(wednesday) , week(thursday) , week(friday) , week(saturday) , ISOquarter , ISOyear | true | (Date part (e.g., month)) |
EXTRACT(@date_part FROM @date_expression)
integer
FORMAT_DATE(@format_string, @date_expression)
string
[@SAFE.]PARSE_DATE(@format_string, @date_string)
date
CURRENT_DATETIME([@time_zone])
dateTime
Name | Type | Allowed values | Required | Placeholder (in UI) |
---|---|---|---|---|
@time_zone | any of: ACDT , ACST , ACT , ACT , ACWST , ADT , AEDT , AEST , AFT , AKDT , AKST , AMST , AMT , AMT , ART , AST , AST , AWST , AZOST , AZOT , AZT , BDT , BIOT , BIT , BOT , BRST , BRT , BST , BST , BST , BTT , CAT , CCT , CDT , CDT , CEST , CET , CHADT , CHAST , CHOT , CHOST , CHST , CHUT , CIST , CIT , CKT , CLST , CLT , COST , COT , CST , CST , CST , CT , CVT , CWST , CXT , DAVT , DDUT , DFT , EASST , EAST , EAT , ECT , ECT , EDT , EEST , EET , EGST , EGT , EIT , EST , FET , FJT , FKST , FKT , FNT , GALT , GAMT , GET , GFT , GILT , GIT , GMT , GST , GST , GYT , HDT , HAEC , HST , HKT , HMT , HOVST , HOVT , ICT , IDLW , IDT , IOT , IRDT , IRKT , IRST , IST , IST , IST , JST , KALT , KGT , KOST , KRAT , KST , LHST , LHST , LINT , MAGT , MART , MAWT , MDT , MET , MEST , MHT , MIST , MIT , MMT , MSK , MST , MST , MUT , MVT , MYT , NCT , NDT , NFT , NPT , NST , NT , NUT , NZDT , NZST , OMST , ORAT , PDT , PET , PETT , PGT , PHOT , PHT , PKT , PMDT , PMST , PONT , PST , PST , PYST , PYT , RET , ROTT , SAKT , SAMT , SAST , SBT , SCT , SDT , SGT , SLST , SRET , SRT , SST , SST , SYOT , TAHT , THA , TFT , TJT , TKT , TLT , TMT , TRT , TOT , TVT , ULAST , ULAT , UTC , UYST , UYT , UZT , VET , VLAT , VOLT , VOST , VUT , WAKT , WAST , WAT , WEST , WET , WIT , WST , YAKT , YEKT | false | (UTC (default)) |
DATETIME(@year, @month, @day, @hour, @minute, @second)
dateTime
Name | Type | Allowed values | Required | Placeholder (in UI) |
---|---|---|---|---|
@day | true | (integer) | ||
@month | true | (integer) | ||
@year | true | (integer) | ||
@hour | true | (integer) | ||
@minute | true | (integer) | ||
@second | true | (integer) |
DATETIME_ADD(@dateTime_expression, INTERVAL @integer_expression @date_part)
dateTime
Name | Type | Allowed values | Required | Placeholder (in UI) |
---|---|---|---|---|
@dateTime_expression | true | (dateTime) | ||
@integer_expression | true | (number) | ||
@date_part | any of: microsecond , millisecond , second , minute , hour , day , week , month , quarter , year | true | (Date part (e.g., days)) |
DATETIME_DIFF(@dateTime_expression, @dateTime_expression2, @date_part)
integer
Name | Type | Allowed values | Required | Placeholder (in UI) |
---|---|---|---|---|
@dateTime_expression | true | (end dateTime) | ||
@dateTime_expression2 | true | (start dateTime) | ||
@date_part | any of: microsecond , millisecond , second , minute , hour , day , week , month , quarter , year | true | (Date part (e.g., days)) |
DATETIME_SUB(@dateTime_expression, INTERVAL @integer_expression @date_part)
dateTime
Name | Type | Allowed values | Required | Placeholder (in UI) |
---|---|---|---|---|
@dateTime_expression | true | (dateTime) | ||
@integer_expression | true | (number) | ||
@date_part | any of: microsecond , millisecond , second , minute , hour , day , week , month , quarter , year | true | (Date part (e.g., days)) |
DATETIME_TRUNC(@dateTime_expression, @date_truncate_part)
dateTime
Name | Type | Allowed values | Required | Placeholder (in UI) |
---|---|---|---|---|
@dateTime_expression | true | (dateTime) | ||
@date_truncate_part | any of: microsecond , millisecond , second , minute , hour , day , month , quarter , year , week(sunday) , week(monday) , week(tuesday) , week(wednesday) , week(thursday) , week(friday) , week(saturday) , ISOquarter , ISOyear | true | (DateTime part (e.g., minutes)) |