You have confluent Snowflake connections that simply provide the JSON data; implementing a Snowflake stored procedure to create the tables or merging the tables is a possibility, and the materialized views are often built on the JSON structure.