amazon-s3snowflake-schemaexternal-tables

invalid url while creating external table in snowflake

I want to use the external table in the snowflake and i created a table using the sql as show below

CREATE EXTERNAL TABLE test_stage (
    column1 datatype1,
    column2 datatype2,
)
LOCATION = '@abc.def.ghe/'
FILE_FORMAT = (TYPE = 'CSV' COMPRESSION = 'GZIP' FIELD_DELIMITER = ',' SKIP_HEADER = 0);

I have checked the access and everything is write. but it producing an error

'invalid url =@abc.def.ghe/'

Any thoughts

I check the access, path, storage, and URL. everything is accessible accept creating the table

Solution

  • Please try to remove the single quotes from the url and retry.