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) ?
3 weeks ago
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 ??
3 weeks ago
any news on that @NandiniN ?
where has this info gone...?!?!
3 weeks ago
Hi @GeKo ,
GET /api/2.1/unity-catalog/tables
) API for now. That API response's payload has the following field:3 weeks ago
Many thanks for the update @NandiniN