3 weeks ago - last edited 3 weeks ago
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) ?
Monday
Hi @GeKo ,
GET /api/2.1/unity-catalog/tables
) API for now. That API response's payload has the following field:3 weeks ago
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
2 weeks ago
Hello,
Linking the documentation - https://docs.databricks.com/en/sql/language-manual/information-schema/tables.html#definition
|
|
Yes |
No |
Deprecated. Always |
2 weeks ago
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 ??
a week ago
any news on that @NandiniN ?
where has this info gone...?!?!
Monday
Hi @GeKo ,
GET /api/2.1/unity-catalog/tables
) API for now. That API response's payload has the following field:Tuesday
Many thanks for the update @NandiniN