12-16-2024 10:26 PM
Recently the following error ocurs when running DBT:
Database Error in model un_unternehmen_sat (models/2_un/partner/sats/un_unternehmen_sat.sql)
Couldn't initialize file system for path abfss://dp-ext-fab@stcssdpextfabprd.dfs.core.windows.net/__unitystorage/catalogs/64552de9-4ff0-4c5f-b4a7-0aef0d6c821a/tables/1bd27775-ca51-435a-8c1a-1042391ac471/part-00000-8121312f-d7a0-4a5b-964a-4c2f4ea4f2ec-c000.snappy.parquet
Has anybody an idea how to fix this error or how to further analyze it?
12-16-2024 11:23 PM
Hi @Th0r ,
The error typically occurs due to one of the following reasons:
Could you confirm if the following file exists in your storage:
abfss://dp-ext-fab@stcssdpextfabprd.dfs.core.windows.net/__unitystorage/catalogs/64552de9-4ff0-4c5f-b4a7-0aef0d6c821a/tables/1bd27775-ca51-435a-8c1a-1042391ac471/part-00000-8121312f-d7a0-4a5b-964a-4c2f4ea4f2ec-c000.snappy.parquet
12-17-2024 12:38 AM
The error occured becase this table is a shallow clone from another table. The original table was re-created.
To fix this we dropped the table and made another shallow clone.
12-17-2024 12:40 AM
Yeah the file is not there - but the question is why / how to fix it.
It was due the original source of a shallow clone was re-created.
So we made the shallow clone again to fix it.
Thx for pointing out some hints
12-17-2024 12:52 AM
Hi @Th0r ,
Here is the explanation:
Solutions:
Passionate about hosting events and connecting people? Help us grow a vibrant local community—sign up today to get started!
Sign Up Now