I work at an Insurance company with 5000+ employees and I'm interested in the collective view here.
Does anyone have a view on how Matillion ETL functionality compares to ADF for Snowflake integration, when ADF and Snowflake are hosted on Azure?
Note: Azure hosting is important, as this appears to offer better integration options than when using ADF on AWS (for example).
I am using Snowflake for JSON data and we have almost 700 million JSON rows.
Is it possible to achieve a sub-second performance in Snowflake? I am OK to cluster and flatten the JSON data into structured tables if necessary.
PeerSpot’s crowdsourced user review platform helps technology decision-makers around the world to better connect with peers and other independent experts who provide advice without vendor bias.
Our users have ranked these solutions according to their valuable features, and discuss which features they like most and why.
You can read user reviews for the Top 5 Data Warehouse Tools to help you d...