Location
Create table option
Description
the LOCATION
clause is used to specify the Hadoop Distributed File System (HDFS) directory where the table data is stored. It allows you to explicitly specify the location of the table data in HDFS.
CREATE TABLE LOCATION
clause is not supported by Snowflake.
Sample Source
Hive
Snowflake
Known Issues
In Snowflake, the
LOCATION
option is used to specify the external stage or storage location for external tables. External tables in Snowflake are tables that reference data stored externally, typically in cloud storage services like Amazon S3 or Azure Blob Storage. For more information please refer to Create Table Using Template
Related EWIs
MSC-HVXXXX: THE CREATE TABLE LOCATION CLAUSE IS NOT SUPPORTED IN SNOWFLAKE.
Last updated