Best Software for 2025 is now live!
View the Winners
  1. Home
  2. ...
  3. Data Warehouse Solutions
  4. Google Cloud BigQuery
  5. Google Cloud BigQuery Discussions
  6. How BQ legacy SQl is different form the standard SQL?
Ankita S.
AS
Content Writer at GadgetsDesk
Expand/Collapse Social Share Options

How BQ legacy SQl is different form the standard SQL?

BQ provides two types of SQL to their user: Standard SQL and Legacy SQL. Why it is so and how both of them are different from each other.
1 comment
Looks like you’re not logged in.
Users need to be logged in to answer questions
Log In
Ole D.
OD
CTO & Co-founder at Dreamdata
0
Legacy SQL is a non-standard SQL only used by BigQuery. Standard SQL is compliant with the SQL 2011. Google recommends using Standard SQL and looking at the documentation and looking at the documentation it looks more and more like Google are deprecating Legacy SQL. There are multiple advantages using Standard SQL. Read more about it here: https://cloud.google.com/bigquery/docs/reference/standard-sql/migrating-from-legacy-sql#advantages_of_standard_sql
deleteedit
Looks like you’re not logged in.
Users need to be logged in to write comments
Log In
Reply
Already have Google Cloud BigQuery?

About Google Cloud BigQuery

BigQuery is a fully managed, AI-ready data analytics platform that helps you maximize value from your data and is designed to be multi-engine, multi-format, and multi-cloud. Store 10 GiB of data and
Discover More