Explanation:
The correct syntax to list the partitions on a Delta table is SHOW PARTITIONS {table_name}. This command directly lists all partitions of the specified Delta table without requiring any additional functions or queries. For more information, refer to the documentation on listing partitions of a Delta table.
Ultimate access to all questions.
What command is used to list the partitions on a Delta table named 'courses'?
A
SELECT partitions() from courses;
B
SHOW PARTITIONS ON courses;
C
SELECT get_partitions from courses;
D
SHOW PARTITIONS courses;
E
SELECT partitions from unity_catalog.courses;
No comments yet.