Create snowflake view for a csv file stored on S3

41 views Asked by At

A csv file test_data.csv has been uploaded to S3. An external stage (S3_data) has been created under database=DEV and schema=helper

I am trying to create a view under database=DEV and schema=testing for the above data

I tried as below:

CREATE VIEW IF NOT EXISTS  DEV.TESTING.external_data_view AS
SELECT * FROM DEV.helper.@S3_data/data/test_data(FILE_FORMAT => csv_semicolon_textqual);

I get the following error: Syntax error: unexpected '@S3_data/data/test_data'.

0

There are 0 answers