CODEWITHSUNDEEP
snowflake-cloud-data-platform
Matthew Thornington
Matthew Thornington

Reputation: 47

Is there a list (or way to generate a list) of all the built-in SQL functions of Snowflake

I'm looking for a list (or way to generate a list) of all the built-in SQL functions of Snowflake, ideally in Backus-Naur Form. e.g.

I see the list on https://docs.snowflake.com/en/sql-reference-functions.html but I don't want to copy and paste from hundreds of pages on the help site.

Upvotes: 1

Views: 261

Answers (2)

Lukasz Szozda
Lukasz Szozda

Reputation: 176214

It is possible to generate list of all built-in functions using SHOW FUNCTIONS:

SHOW FUNCTIONS;

SELECT "name", "arguments", "description"
FROM TABLE(RESULT_SCAN(LAST_QUERY_ID()))
WHERE "is_builtin" = 'Y';

Output:

enter image description here

EDIT:

It is possible to do it using single SHOW command:

SHOW BUILTIN FUNCTIONS;

Upvotes: 2

Sergiu
Sergiu

Reputation: 4608

We don't have as a list outside of docs, but it does make sense to have it and I would recommend you open an idea for it following:

https://community.snowflake.com/s/article/How-to-Search-Create-Vote-Follow-Ideas

The more votes, the higher chance to get it.

Upvotes: 0

Related Questions