Reddit

How are results generated each time a Databricks SQL dashboard updates when it's configured to monitor the total record count in a set of Delta Lake tables using the following query pattern?

SELECT COUNT(*) FROM table_name
```*_

SELECT COUNT(*) FROM table_name
```*_

Exam-Like

The total count of rows is calculated by scanning all data files

14.4%

The total count of rows will be returned from cached results unless REFRESH is run

12.6%

The total count of records is calculated from the Delta transaction logs

59.5%

The total count of records is calculated from the parquet file metadata

13.5%

Databricks Certified Data Engineer - Professional

Get started today

Comments

How are results generated each time a Databricks SQL dashboard updates when it's configured to monitor the total record count in a set of Delta Lake tables using the following query pattern?

SELECT COUNT() FROM table_name ```_
SELECT COUNT() FROM table_name ```_

Databricks Certified Data Engineer - Professional

Get started today

Comments

How are results generated each time a Databricks SQL dashboard updates when it's configured to monitor the total record count in a set of Delta Lake tables using the following query pattern? SELECT COUNT(*) FROM table_name ```*_ SELECT COUNT(*) FROM table_name ```*_

How are results generated each time a Databricks SQL dashboard updates when it's configured to monitor the total record count in a set of Delta Lake tables using the following query pattern?

SELECT COUNT() FROM table_name ```_
SELECT COUNT() FROM table_name ```_