Snowflake BUG Unknown function JSON_EXTRACT_ARRAY when moving orders data from Shopify

[Tomperez98]

Environment

• Airbyte version: 0.39.20-alpha
• OS Version / Instance: AWS EC2
• Deployment: Docker
• Source Connector and version: Shopify 0.1.37
• Destination Connector and version: Snowflake 0.4.28
• Step where error happened: Normalization

Current Behavior

Moving orders data from Shopify to Snowflake always causes an error.

Expected Behavior

Orders data should be modeled an stored successfully into Snowflake

Logs

SQL compilation error:
Unknown function JSON_EXTRACT_ARRAY
compiled SQL at ../build/run/airbyte_utils/models/generated/airbyte_views/AIRBYTE_SCHEMA_MERCAVIVA/ORDERS_STG.sql

logs-3.txt

Steps to Reproduce

1. Setup Shopify as Source
2. Setup Snowflake as Destination
3. In connection only select orders with Incremental | Deduped + History
4. Run the Sync

Are you willing to submit a PR?

Yes! I'm just not sure where to modify the code base

[Tomperez98]

#13894