Databricks Community

JDL · 11-27-2023

Hello folks,Is there a way with sql query to get count from delta table metadata without doing count(*) on each of table? Wondering, if this information is stored in any of INFORMATION_SCHEMA tables.I have a use-case to get counts from 1000's of delt...

JDL · 11-15-2023

Hello All,I have databricks delta table with files residing in Azure Data Lake. I understand, when I load create table and load data from databricks, it creates respective folder and files for table in ADLS. I am wondering if there is reverse way to ...

JDL · 12-01-2023

Thanks @SSundaram for the link. I need this information via sql query only.

JDL · 12-01-2023

Thanks @Retired_mod for detailed information but I am still not clear on resolution.Table type is shown as MANAGED. Does this mean I can't get count of this table without count(*)?2. I am using path starting with abfss://. Copying the exact path of t...

JDL · 11-28-2023

Thanks @Retired_mod for your response. I tried the sql query but gives error about the path.I tried different version of path.If I specify full path of table, which I retrieve from catalog explorer starting with abfss:// getting below error: [Request...

JDL · 11-27-2023

Thanks @Retired_mod this is helpful

Databricks Community

User Stats

User Activity

Get number of rows in delta lake table from metadata without count(*)

Tie Parquet files in Azure ADLS to Databricks table

Re: Get number of rows in delta lake table from metadata without count(*)

Re: Get number of rows in delta lake table from metadata without count(*)

Re: Get number of rows in delta lake table from metadata without count(*)

Re: Tie Parquet files in Azure ADLS to Databricks table