28 Jan 21 ·  Cpaul in Guides ·        Bookmark ·  Report ·  More actions.. Lock comments ·  Pin thread

Google BigQuery vs Teradata Comparison

Google BigQueryTeradata
Fully Managed Cloud Data warehouseHybrid 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: GoogleTeradata
Initial Release: 20101984
SQL Support: YesYes
Primary Keys: No

BigQuery offers Partition & Cluster keys instead
Yes
Foreign Keys: NoYes
Stored Procedures: YesYes
Triggers: NoYes
User defined functions: YesYes
Transaction Concepts: NoYes
Time Travel: YesNo
Scalability: YesOnly on Cloud version
License: CommercialCommercial

Database limits comparison

LimitTeradataBigQuery
Tables per database 
UnlimitedUnlimited
Columns per table 
204810000
Maximum row size1 MB100 MB
Column and table name length128 unicode characters16384 Unicode characters
Max SQL request length1 MB1 MB
Maximum number of concurrent sessions120 per parsing engine100 concurrent queries
Maximum number of concurrent loads30No 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