Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Check if the database with the specified name exists.
Syntax
databaseExists(dbName: str)
Parameters
| Parameter | Type | Description |
|---|---|---|
dbName |
str | Name of the database to check existence. Can be qualified with catalog name. |
Returns
bool
Indicating whether the database exists.
Examples
# Check if 'test_new_database' database exists
spark.catalog.databaseExists("test_new_database")
# False
_ = spark.sql("CREATE DATABASE test_new_database")
spark.catalog.databaseExists("test_new_database")
# True
# Using the fully qualified name with the catalog name.
spark.catalog.databaseExists("spark_catalog.test_new_database")
# True
_ = spark.sql("DROP DATABASE test_new_database")