'SQL compilation error: Table '"s3://xxxxxxxxxxxx/output/"' does not exist

We are able to load data from s3://xxxxxxxxxxxx/input/ to Snowflake by using Snow-Pipe.

Code for loading data from S3 bucket to Snowflake:

COPY INTO "s3://xxxxxxxxxx/output/" 
FROM @"V_PIPELINE_DB"."V_PIPELINE_SCHEMA"."V_PIPELINE_STAGE"
FILE_FORMAT = ( FORMAT_NAME =  "V_PIPELINE_DB"."V_PIPELINE_SCHEMA"."V_PIPELINE_CSV_FILEFORMAT" )
ON_ERROR = 'continue'
FORCE =TRUE;

But we are facing an compiler error while loading from Snowflake to AWS S3 bucket and below is the error.

SQL compilation error: Table '"s3://xxxxxxxxxxxx/output/"' does not exist

snowflake-cloud-data-platform

Solution 1:^[1]

Firstly, you mentioned that the command you attached is loading data from S3 to Snowflake, but that command looks more like the other way around (unloading data from Snowflake to S3). Therefore I'm not sure which query is causing that error.

To get the correct query structure, please refer to the following manuals:

Loading from S3 to Snowflake

Unloading from Snowflake to S3

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source
Solution 1	Clark Perucho