Hello
Current documentation points that DML statements cannot be used with RETURN.
I am testing something following lines and get ‘Encountered “TABLE” at line 3, column 14.’ message. Do you confirm my syntax is not supported ? and do you have any plan to support DML instruction in UDF ?
CREATE OR REPLACE FUNCTION refresh_table(tgt VARCHAR)
RETURNS TABLE (ok VARCHAR, summary VARCHAR)
RETURN ALTER TABLE tgt REFRESH METADATA FORCE UPDATE