DECLARE -- In the code below, $$ is the multiline string delimiter. -- $$ lets us include newlines, single and double quotes -- without needing to escape them. -- The script uses || to concatenate literal strings with -- the result of the query to build the table definition. -- ...
my_aurora_stage and assign some default options: create or replace stage my_aurora_stage copy_options = (on_error='skip_file') file_format = (type = 'CSV' field_delimiter = '|' skip_header = 1); PUT is the command used to stage files to an internal Snowflake stage. The syntax of...
formatTypeOptions ::= -- If FILE_FORMAT = ( TYPE = CSV ... ) COMPRESSION = AUTO | GZIP | BZ2 | BROTLI | ZSTD | DEFLATE | RAW_DEFLATE | NONE RECORD_DELIMITER = '<string>' | NONE FIELD_DELIMITER = '<string>' | NONE MULTI_LINE = TRUE | FALSE SKIP_HEADER = <integer> SKIP_BL...