Typo in first statement STORAGE_ALLOW_LOCATIONS - the value / URL prefix needs to start with 'gcs:' not 'gs:', otherwise Snowflake throws an error.

Parquet file format might not work for a lot of people as Snowflake doesn't allow exporting certain date formats go.gogog