Snowpark Migration Accelerator : Utilisation¶

Description¶

The USING command in Spark specifies which file format should be used when creating a table. Common formats include CSV, JSON, and AVRO. For more detailed information about the Create Table USING command, refer to the Databricks documentation.

Syntaxe¶

CREATE TABLE [IF NOT EXISTS] [db_name.]table_name
  [(col_name1 col_type1 [COMMENT col_comment1], ...)]
  USING data_source
  [OPTIONS (key1 [ = ] val1, key2 [ = ] val2, ...)]
  [PARTITIONED BY (col_name1, col_name2, ...)]
  [CLUSTERED BY (col_name3, col_name4, ...) INTO num_buckets BUCKETS]
  [LOCATION path]
  [COMMENT table_comment]
  [TBLPROPERTIES (key1 [ = ] val1, key2 [ = ] val2, ...)]
  [AS select_statement]

Modèles d’échantillons de sources¶

The USING data source statement is not supported in Snowflake. During migration, this statement will be commented out and marked with an Error, Warning, and Issue (EWI) message indicating that it is unsupported.

Données d’échantillon¶

CREATE TABLE table1
(
id INTEGER
) USING DELTA;

CREATE TABLE table1
(
id INTEGER
) /*** MSC-WARNING - MSCEWI# - SNOWFLAKE DOES NOT SUPPORT USING STATEMENT ***/
-- USING DELTA;

Problèmes connus¶

Snowflake ne prend pas en charge la clause de la source de données USING dans les instructions SQL.