Explanation:
The correct syntax to create a schema if it does not already exist is CREATE SCHEMA IF NOT EXISTS schema_name [ LOCATION schema_directory ]. This ensures the schema is only created if it doesn't already exist, preventing errors. For more details, refer to the Databricks documentation.
How can you create a schema named 'bronze' with the location '/mnt/delta/bronze' and ensure it doesn't already exist before creation?
A
CREATE SCHEMA bronze IF NOT EXISTS LOCATION ‘/mnt/delta/bronze‘
B
if IS_SCHEMA(‘bronze‘): CREATE SCHEMA bronze LOCATION ‘/mnt/delta/bronze‘
C
Schema creation is not available in metastore, it can only be done in Unity catalog UI
D
CREATE SCHEMA IF NOT EXISTS bronze LOCATION ‘/mnt/delta/bronze‘
E
Cannot create schema without a database
No comments yet.