I primarily use Matillion Data Productivity Cloud for ingest functions. In one client's case, we switched from typical AWS tools and changed all of the blueprints and architecture to use Matillion Data Productivity Cloud for ingesting information from GCP and reading SQL data.

Matillion Data Productivity Cloud is effective for ingest functions, particularly when moving information to Snowflake and performing many transformations. Its integration with existing environments, utilizing security measures like VPN and VPCs, makes it a secure choice. However, its features are not notably different from other products in the market.

There are problems with GCP connectivity. Specifically, connections to BigQuery for extracting information are complex, and the optimization of the extraction process requires improvements. I raised this issue with Matillion's support, but the solution is pending with their research team.

I have been working with Matillion Data Productivity Cloud for two years.

Matillion Data Productivity Cloud is stable and functions reliably as a product.

The autoscale process works well, allowing the system to start another node automatically if the first machine reaches 80% capacity. However, the limitation is the number of parallel jobs due to the direct relation to the cores on the machine.

Matillion's technical support is excellent. They communicate effectively and respond quickly to all inquiries.

The initial setup is straightforward. We completed the foundations process using Infrastructure as Code (IaC), which standardizes and simplifies the deployment process.

In terms of ROI, one client found that using Snowflake tasks was more cost-effective than Matillion's credits cost. Consequently, we adjusted our processes to use Matillion Data Productivity Cloud only for extraction and ingestion, while Snowflake handled all transformations and jobs.

While pricing can be an issue compared to other solutions, Matillion Data Productivity Cloud offers discounts and special deals, especially when dealing with high-volume clients or fewer existing clients in specific regions, like Spain.

In many cases, clients consider buying a product from the same hyperscaler for an end-to-end solution, such as Microsoft Fabric.

While Matillion Data Productivity Cloud can be valuable, it is challenging to recommend due to its pricing and limited clientele in regions like Spain. Overall, I would rate Matillion as a six out of ten.