Matts966/alphasql

Support for `_TABLE_SUFFIX`

Matts966 opened this issue · 1 comments

Support for `_TABLE_SUFFIX`

_TABLE_SUFFIX is BigQuery specific feature and we don't plan to support it in the first class things. However, for BigQuery, it is very easy to support _TABLE_SUFFIX because the official API is great enough.

When we fetch the schema of table whose name ends with * using BigQuery API, they return the intersection type of all the tables specified by the wild card. So only we have to do is add pseudo column _TABLE_SUFFIX to the json schema.

We plan to add support for it in the CI sample script.