CODE EXAMPLE FOR SQL

snowflake select from stage

select t.$1, t.$2 from @mystage1 (file_format => 'myformat', pattern=>'.*data.*[.]csv.gz') t;