Amazon Redshift vs Tencent Cloud TCHouse-D

Amazon Redshift is a cloud data warehouse for SQL analytics across data warehouses and data lakes. It offers provisioned and serverless deployments, with options AWS says can scale to petabytes and support thousands of concurrent users. Redshift runs read-only SQL queries on Apache Iceberg, Apache Hudi, and Delta Lake tables, plus open file formats in Amazon S3. Zero-ETL integrations connect with Amazon Aurora, Amazon RDS, Amazon DynamoDB, and enterprise applications. Streaming ingestion connects with Amazon Kinesis Data Streams and Amazon Managed Streaming for Apache Kafka. Listed integrations include QuickSight, Tableau, Microsoft Power BI, Alteryx, Jupyter Notebook, Informatica, dbt, MicroStrategy, and Looker. The Data API supports AWS SDK languages including Python, Go, Java, Node.js, PHP, Ruby, and C++. Security includes encryption, row- and column-level controls, and dynamic masking. It is paid, has no free plan, offers a free trial, and starts at $0.54 per month for Provisioned or $1.50 per month for Serverless.

Tencent Cloud TCHouse-D is a fully managed, cloud-native OLAP service built on Apache Doris for multidimensional business analysis and user behavior analysis. It supports standard SQL and the MySQL protocol, with separate compute and storage plus data-lake support. A production analytics cluster can be deployed from the console in under 10 minutes. Console controls handle scaling and node CPU or memory changes, while built-in operations, monitoring, and alerting support management. Tencent describes a vectorized execution engine and MPP framework, sub-second latency on petabyte-scale datasets, and 10,000 to 100,000 queries per second. Imports can be streaming or bulk, including Kafka, Cloud Object Storage, and HDFS. JDBC reads can connect to MySQL, PostgreSQL, SQL Server, and Oracle, and Elasticsearch is supported. TencentDB and TDMQ are named Tencent Cloud sources. Reliability features include dual-node redundancy, failover, disaster recovery, and isolated VPC deployment.