Which statement BEST describes the COPY INTO SQL command in Databricks?
-
A
It copies data between two existing Delta tables within the same catalog
-
B
It is an idempotent SQL command that loads files from cloud storage into a Delta table, automatically skipping already-loaded files
-
C
It copies data from a streaming source into a batch Delta table
-
D
It copies schema definitions and constraints between Unity Catalog objects