Cloud Data Warehouses

CData Virtuality offers support for various cloud data warehouses—scalable, cloud-based platforms designed to store and analyze large volumes of data from diverse sources. They enable organizations to perform complex queries and analytics efficiently without managing physical infrastructure. These integrations feature federated queries and transformations, support for semi-structured data, and high-throughput parallel querying.

Drivers

For cloud databases like Snowflake, Amazon Redshift, and Google BigQuery, CData provides JDBC and ODBC drivers that connect to CData Virtuality. The connectivity is similar to that of most any on-premises SQL database.

Metadata Discovery and Data Type Conversion

Metadata discovery for cloud databases is straightforward. However, cloud databases have non-standard objects such as stages, in the case of Snowflake, and data lakes, in the case of Databricks. CData Virtuality is able to convert stages to separate schemas, and data lakes to views. CData Virtuality can also map cloud data types to SQL types, such as arrays to JSON or separate linked tables, and struct to flattened columns or JSON. CData Virtuality stores all metadata in its virtual catalog.

Unified Data Querying

Federated queries seamlessly combines live data from multiple cloud applications and databases and presents it as a unified set of results, without the need for ETL tools. The federated query processor breaks down user-defined queries into subqueries executed (“pushed down”) across each data source.

Supported Data Warehouses

The supported cloud data warehouses include the following:

• Amazon Redshift

• Azure Synapse Analytics

• Google BigQuery

• IBM DB2 Warehouse on Cloud

• Snowflake

• Teradata Vantage (Cloud)