Error Querying Shallow Clones: Couldn't Initialize File System for Path

[schluca]

Hi,

We are offering data products through a central catalog for our users. To minimize data duplication and to display relationships between tables, we use shallow clones to provide access to the data.

However, since implementing this approach, we occasionally encounter the following error when querying a shallow clone:

Couldn't initialize file system for path abfss://<path>.snappy.parquet

Has anyone else experienced this issue? If so, do you know how to prevent or resolve it?

Thank you!

[Takuya-Omi]

Hi @schluca ,
I’ve encountered an issue where an error occurred when trying to reference a table after deleting and recreating the source table for a Shallow Clone, and then performing the Shallow Clone again. As a solution, try deleting the destination table of the Shallow Clone and then running the Shallow Clone process again.

%sql
DROP TABLE shallowclone_test.testschema.clonned_table;

CREATE OR REPLACE TABLE shallowclone_test.testschema.clonned_table 
SHALLOW CLONE shallowclone_test.testschema.original_table;