SQL Observability
To enable SQL observability, configure the following properties using the manager commands:
Property | Description | Default |
|---|---|---|
com.unraveldata.databricks.sql.enabled | Enables SQL pipelines. True to enable and false to disable. | True |
com.unraveldata.databricks.enabled.connectors | Enables or disables dbx_worker connectors like: CLUSTER_CONNECTOR, JOB_CONNECTOR, WAREHOUSE_CONNECTOR, QUERY_HISTORY_CONNECTOR. | CLUSTER_CONNECTOR, JOB_CONNECTOR, WAREHOUSE_CONNECTOR, QUERY_HISTORY_CONNECTOR. |
com.unraveldata.databricks.sql.warehouse.cost.timeout | Determines the timeout for warehouse cost calculation. | 600000 (10 minutes) |
com.unraveldata.databricks.sql.consumers | Determines the number of workers processing Databricks SQL data. | 8 |
com.unraveldata.databricks.sql.queryhistory.lookback.days | Determines the days to look back for query history after a fresh installation or downtime. | 15 |
Enable SQL Observability in Unravel
To enable SQL Observability in Unravel, make sure to select Enable Databricks SQL under Tier while configuring the Workspace.
Note
You can enable SQL Observability only in the Premium or Enterprise tier.
For more details, refer to Workspace Configuration.