CODEWITHSUNDEEP
snowflake-cloud-data-platformpipelinestage
SGA
SGA

Reputation: 1

not able to create stage in snowflake

create or replace stage AWS_OWNER1
url = 's3 url' 
credentials = (aws_key_id = 'aws_key_name' 
               aws_secret_key = 'aws_secret_key')
file_format = CSV;

when i run above query i will get error as "SQL compilation error: File format 'CSV' does not exist or not authorized."

please send valied answer to solve this issue.

Thank You

Upvotes: 0

Views: 414

Answers (1)

NickW
NickW

Reputation: 9798

the syntax is:

file_format = (type = 'CSV')

However, as CSV is the default, you can leave this out entirely

Upvotes: 0

Related Questions