Databricks Exam Databricks-Certified-Data-Analyst-Associate Topic 2 Question 3 Discussion

The commandINSERT INTO stakeholders.suppliers TABLE stakeholders.new_suppliersis not a valid syntax for inserting data into a table in Databricks SQL.According to the documentation12, the correct syntax for inserting data into a table is either:

INSERT { OVERWRITE | INTO } [ TABLE ] table_name [ PARTITION clause ] [ ( column_name [, ...] ) | BY NAME ] query

INSERT INTO [ TABLE ] table_name REPLACE WHERE predicate query

The command in the question is missing theOVERWRITEorINTOkeyword, and thequerypart that specifies the source of the data to be inserted. TheTABLEkeyword is optional and can be omitted. ThePARTITIONclause and the column list are also optional and depend on the table schema and the data source. Therefore, the command in the question will fail with a syntax error.

INSERT | Databricks on AWS

INSERT - Azure Databricks - Databricks SQL | Microsoft Learn