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

CREATE TABLE table1 (
    col1 STRING 
) 
LOCATION '/tmp/test/';

Snowflake

CREATE TABLE table1 (
    col1 STRING 
) 
----** MSC-ERROR - MSC-HVXXXX - THE CREATE TABLE LOCATION CLAUSE IS NOT SUPPORTED IN SNOWFLAKE.. **
--LOCATION '/tmp/test/';

Known Issues

  1. 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

  1. MSC-HVXXXX: THE CREATE TABLE LOCATION CLAUSE IS NOT SUPPORTED IN SNOWFLAKE.

Last updated