Manually migrating and converting existing SQL queries to BigQuery SQL dialects takes up a lot of effort. In our recent video, Onkar Kumar, Data Engineer at SpringML, demonstrates how the translation of the on-prem Teradata SQL scripts to BigQuery-compliant SQLs can be effortlessly and efficiently done using the Google Cloud BigQuery Batch SQL Translator service. He also walks us through the translation of the unsupported SQL statements using jinja templates by a manual intervention of adding the script and running the query.
