databricks_system Table

A pseudo-table called databricks_system can be used to query for Databricks cluster system environment information. The pseudo-table is under the pseudo-schema called databricks_system. The table has two STRING type columns, envkey and envvalue. Standard SQL can be executed against the databricks_system table. For example:

SELECT * FROM DATABRICKS.databricks_system.databricks_system WHERE envkey LIKE '%databricks%'

The above query returns all of the Databricks system environment entries whose key contains the word "databricks". A special query, set -v, is executed to fetch system environment information. Some versions of Databricks do not support this query. For versions of Databricks that do not support querying system environment information, the connector returns an empty result set.