For a particular business group, number of concurrent users are large but do not fluctuate. These users run queries on snowflake and expects extremely low latency response. The queries are all standard and same and need to be served from the result cache to meet the low latency requirement. Which of the below option will you choose?
When using the CURRENT_ROLE and CURRENT_USER functions with secure UDFs that will be shared
with Snowflake accounts, Snowflake returns a NULL value for these functions?
Streams record the differences between two offsets. If a row is added and then updated in the cur-rent offset,
what will be the value of METADATA$ISUPDATE Columns in this scenario?