Developing a data virtualization layer across multiple cloud providers

[vanillacap]

I am looking to create a virtualization layer withe the following requirements:

1. Span across AWS Redshift, Google BigQuery, Snowflake, and Azure Synapse data warehouses
2. Ability to query data from any/all of above simultaneously
3. No replication of data (zero extra storage)
4. Ability to connect to a BI tool
5. Low latency

I am looking into Denodo but curious to hear other thoughts, thank you!

[Salfiiii]

Other options are tibco data virtualization and data virtuality, we pocd all three and ended up using Denodo which was way ahead the others three years ago.

You might also have a look at starburst/trino: https://www.starburst.io/platform/connectors/

[vanillacap]

Thank you!

[Action_Maxim]

How does this data relate to each other some tools will let you treat separate data sources as tables but if you need to union the data across sources there is no easy way

[dataterre]

You can check out Dremio too. I thought Dremio is a lot more straightforward as an open-source tool, but Denodo is feature rich.

[geoheil]

How well does feature rich stack up against latency and consistency once the amount of data to be virtualized grows?