AmanSehgal
Honored Contributor III

You need to provide one of the following value for 'data_source':

  • TEXT
  • AVRO
  • CSV
  • JSON
  • PARQUET
  • ORC
  • DELTA

eg: USING PARQUET

If you skip USING clause, then the default data source is DELTA

https://docs.databricks.com/sql/language-manual/sql-ref-syntax-ddl-create-table-using.html

View solution in original post