Is there a way to make an external table in Snowflake a temporary table?

Question

I have an external table

CREATE OR REPLACE EXTERNAL TABLE MY_TABLE
 LOCATION = @MY_STAGE/2022/08/24
 FILE_FORMAT = MY_FILE_FORMAT
 AUTO_REFRESH = TRUE;

but is there a way that I can create a "temporary external table" so that the table is not saved? I'm using this to write a file loaded from s3 into a table.

user_132438 · Answer

Instead of creating an external table, you can query the stage files directly:

select $1, $2, $3
from @my_stage/2022/08/24/file00000000003
limit 10;

Is there a way to make an external table in Snowflake a temporary table?

1 Answers