"Closed, proprietary data format, vendor lock-in, limited support for semi-structured data, limited to BI, SQL applications and decision support"

Snowflake suffers from NONE OF THESE issues. Not one. You must be describing some "other" DW platform.