SHOW DATABASES command returns unexpected column name


You are using the SHOW DATABASES command and it returns an unexpected column name.


The column name returned by the SHOW DATABASES command changed in Databricks Runtime 7.0.

  • Databricks Runtime 6.4 Extended Support and below: SHOW DATABASES returns namespace as the column name.
  • Databricks Runtime 7.0 and above: SHOW DATABASES returns databaseName as the column name.


You can enable legacy column naming by setting the property spark.sql.legacy.keepCommandOutputSchema to false in the cluster’s Spark Config.