SCALAR UDF with ALTER TABLE Clause

1

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

2

Hi Arnie, can you provide link to this doc?

3

Current documentation is :

In the documentation RETURN is described with its limits.

RETURN { expression | query } String

The body of the function. For a scalar function, it can either be a query or an expression. For a tabular function, it may only be a query. The expression may not contain the following:

  • DML statements such as INSERT, UPDATE, or DELETE.
  • DDL statements such as CREATE and DROP.