Breaking News: Grepper is joining You.com. Read the official announcement!

show file format snowflake

Yellowed Yak answered on November 9, 2021 Popularity 9/10 Helpfulness 4/10

answer show file format snowflake

show file format snowflake

Comment

use database testdb;

show file formats;

+---------------------------------+-----------+---------------+-------------+------+--------------+---------+
| created_on                      | name      | database_name | schema_name | type | owner        | comment |
|---------------------------------+-----------+---------------+-------------+------+--------------+---------|
| Wed, 29 Apr 2015 18:59:03 -0700 | MY_FORMAT | TESTDB        | PUBLIC      | CSV  | ACCOUNTADMIN |         |
| Mon, 27 Apr 2015 17:49:12 -0700 | CSV       | TESTDB        | PUBLIC      | CSV  | ACCOUNTADMIN |         |
| Mon, 27 Apr 2015 17:49:12 -0700 | VSV       | TESTDB        | PUBLIC      | CSV  | ACCOUNTADMIN |         |
| Mon, 27 Apr 2015 17:49:12 -0700 | TSV       | TESTDB        | PUBLIC      | CSV  | ACCOUNTADMIN |         |
+---------------------------------+-----------+---------------+-------------+------+--------------+---------+

Popularity 9/10 Helpfulness 4/10 Language shell

Source: docs.snowflake.com

Tags: file-format shell show

Link to this answer
Share Copy Link