can I use volume for external table location?

PaulineX · ‎02-20-2024

Hello,

I have a parquet file test.parquet in the volume volume_ext_test. Tried to create an external table as below, it failed and says it "is not a valid URI".

create table catalog_managed.schema_test.tbl_vol as

select * from parquet.`/Volumes/catalog_managed/schema_test/volume_ext_test/test.parquet`

but I have no problem to create a managed table as below:

create table catalog_managed.schema_test.tbl_vol as

select * from parquet.`/Volumes/catalog_managed/schema_test/volume_ext_test/test.parquet`

Am I doing something wrong? Or it is the limitation?

Thanks.