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 [email protected]/'
Any thoughts
I check the access, path, storage, and URL. everything is accessible accept creating the table
Please try to remove the single quotes from the url and retry.