Stored As
Create table option
Description
STORED AS
clause defines the file format for the table. Available formats include TEXTFILE
, SEQUENCEFILE
among others. For more information refer Storage Formats.
STORED AS clause is not supported by Snowflake.
Sample Source
Hive
Snowflake
Known Issues
In Snowflake, you do not need to explicitly specify a storage format during table creation. Snowflake supports various file formats, including Parquet, Avro, ORC, JSON, CSV, and more, but these formats are handled transparently by Snowflake, and you don't need to specify them explicitly in the
CREATE TABLE
statement.
Related EWIs
MSC-HVXXXX: THE STORED AS CLAUSE IS NOT SUPPORTED IN SNOWFLAKE.
Last updated