topic Re: Error Querying Shallow Clones: Couldn't Initialize File System for Path in Data Engineering

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

schluca — Mon, 02 Dec 2024 09:43:24 GMT

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!

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

Takuya-Omi — Tue, 03 Dec 2024 01:46:11 GMT

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;