โ04-24-2024 04:51 AM - edited โ04-24-2024 04:53 AM
Hello,
I am running a job that depends on the information provided in column storage_sub_directory in system.information_schema.tables .... and it worked until 1-2 weeks ago.
Now I discovered in the doc that this column is deprecated and always null , was there an announcement about that change (and if yes, where) ?
โ05-13-2024 08:51 PM
Hi @GeKo ,
GET /api/2.1/unity-catalog/tables
) API for now. That API response's payload has the following field:โ04-29-2024 07:31 AM
Same issue here - we were using this to join to our S3 inventory files to determine the top tables to optimize and vacuum. Started failing about 2 weeks ago
โ04-30-2024 11:58 PM
Hello,
Linking the documentation - https://docs.databricks.com/en/sql/language-manual/information-schema/tables.html#definition
|
|
Yes |
No |
Deprecated. Always |
โ05-01-2024 04:24 AM
Hello @NandiniN ,
many thanks for your reply.
The official doc I already know and I am aware that *suddenly* the storage_sub_directory is always NULL.
But now I need a solution from where I can get this information ? is the storage_sub_directory in another system.information_schema table/view ... or from where to extract this information now ??
โ05-10-2024 02:37 AM
any news on that @NandiniN ?
where has this info gone...?!?!
โ05-13-2024 08:51 PM
Hi @GeKo ,
GET /api/2.1/unity-catalog/tables
) API for now. That API response's payload has the following field:โ05-14-2024 02:36 AM
Many thanks for the update @NandiniN
Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you wonโt want to miss the chance to attend and share knowledge.
If there isnโt a group near you, start one and help create a community that brings people together.
Request a New Group