Creating a table with the LOCATION keyword designates it as an external table. The syntax CREATE TABLE table_name (column column_data_type...) USING format LOCATION 'dbfs:/' where format can be DELTA, JSON, CSV, PARQUET, or TEXT, explicitly creates an external table. Omitting the LOCATION keyword would result in a managed table instead.