Unable To Find Table Functions In Information_Schema Schema

Question

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

Marcel · Accepted Answer · 2020-12-02T09:45:54.840

0

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.

edited Dec 02 '20 at 09:45

answered Dec 02 '20 at 08:25

Marcel

2,454
1
5
13

Hi Marcel, thanks for your response, but i do not see here the other option how to view table functions . – Aniruddha Shinde Dec 02 '20 at 08:45
This is what I meant. You CANNOT see them there :-) – Marcel Dec 02 '20 at 08:47
Then do you know What is Other UI , to view list of UDFs, UDTFs under particular database/schema – Aniruddha Shinde Dec 02 '20 at 09:41
You can use SHOW FUNCTIONS; – Marcel Dec 02 '20 at 09:45

Unable To Find Table Functions In Information_Schema Schema

1 Answers1