Latest docker build script for zetaSQL 2020.04.1 about zetasql HOT 7 OPEN

@fpopic
Currently, ZetaSQL removes the comments in SQL files. This problem can be fixed officially, but for now you can try my image here.
https://github.com/Matts966/zetasql-formatter

The image formats sql files in specified paths, and returns with exit code 1 if there was any change.

from zetasql.

@fpopic @ebendutoit
FYI: we can check type/schema errors by my tool AlphaSQL.

An example for CI is here.
https://github.com/Matts966/alphasql/tree/master/samples/sample-ci

from zetasql.

I've taken the liberty of solving the issue above by creating the Dockerfiles needed to build and use the latest version of zetaSQL: https://github.com/ebendutoit/zetasql-analyzer-server

Any feedback on using this is most welcome.

from zetasql.

@ebendutoit can you explain how to run docker run to format SQL file? would like to try it.

@fpopic You probably have 2 options depending on what you really need:

1. Use my docker files and create a Cloud Run endpoint in GCP if you need to check syntax
2. Use the formatter of @Matts966 if you need to check formatting

from zetasql.

I totally understand. The Dry Run of BigQuery is just very slow for this (> 2sec and much more), which is probably why you need this option, or perhaps you want to avoid calling a BQ API.

from zetasql.

@ebendutoit can you explain how to run docker run to format SQL file? would like to try it.

Do you google/zetasql guys (@matthewcbrown?) have some ETA for an official docker image? We would like to add zetaSQL format/format-checker option as a part of our CI pipeline for BigQuery/BEAM SQL queries.

from zetasql.

Thanks, will check it out @ebendutoit

At the moment for the bigquery syntax/execution I use bq query --dry_run option.

from zetasql.