Google BigQuery vs Teradata Comparison

Google BigQuery	Teradata
Fully Managed Cloud Data warehouse	Hybrid Data warehouse (Available On-premise and Cloud)
Serverless (No Infra maintenance)	Server
Columnar database (Column level analytical operations are much faster and cheaper)	Row level Relational database
Website: cloud.google.com/bigquery	www.teradata.com
Company: Google	Teradata
Initial Release: 2010	1984
SQL Support: Yes	Yes
Primary Keys: No BigQuery offers Partition & Cluster keys instead	Yes
Foreign Keys: No	Yes
Stored Procedures: Yes	Yes
Triggers: No	Yes
User defined functions: Yes	Yes
Transaction Concepts: No	Yes
Time Travel: Yes	No
Scalability: Yes	Only on Cloud version
License: Commercial	Commercial

Database limits comparison

Limit	Teradata	BigQuery
Tables per database	Unlimited	Unlimited
Columns per table	2048	10000
Maximum row size	1 MB	100 MB
Column and table name length	128 unicode characters	16384 Unicode characters
Max SQL request length	1 MB	1 MB
Maximum number of concurrent sessions	120 per parsing engine	100 concurrent queries
Maximum number of concurrent loads	30	No concurrency limit

What is Google BigQuery ?

Google BigQuery is Fully Managed cloud data warehouse from Google. BigQuery can handle petabyte scale of data in its cloud data warehouse.

Auto-scaling of Storage and Compute
Pay per Use
Serverless
Innovative features like Time-Travel, BQ ML
Robust Security
Streaming Ingestion

What it Teradata ?

Teradata is an established data warehouse platform with its roots in 1984. Predominantly an on-premise solution with offerings on the cloud as well. Several Fortune 100 companies use Teradata for Analytics