(TIL) Snowflake: Show file formats

less than 1 minute read

To list the file formats for which you have access privileges, use:

SHOW FILE FORMATS [ LIKE '<pattern>' ] [ IN <scope> ]

where:

<scope> ::=  { ACCOUNT | [ DATABASE ] <db_name> | [ SCHEMA ] <schema_name> }

Via snowflake.net.

Comments