0
votes

While reading INFORMATION_SCHEMA details on Snowflake documentation site URL Given below ; we can see 2 objects one is views and other is Table Functions. Views provide that database specific objects (Tables, Functions , stages etc ) metadata where as Table Functions can be used to return account level usages. When i browsed though Information Schema in each Databases i found only Views but not Table functions.

Have they moved these Table Functions

https://docs.snowflake.com/en/sql-reference/info-schema.html

enter image description here

1

1 Answers

0
votes

Your screenshot shows the "object browser" in the Snowflake WebGUI. In here you can only see views and tables, no table functions.

More info: https://docs.snowflake.com/en/user-guide/ui-worksheet.html

So... they are still there and you can execute them :-)

Edit: You can use SHOW FUNCTIONS to see all functions in your account.