google / google/googlesql

BigQuery _TABLE_SUFFIX support

Open
#88 3 comments 0 reactions 0 assignees View on GitHub
Dominant language
C++
Stars
2.6k
Forks
260
PR merge metrics
No merged PRs in 30d

Description

Hi, In BigQuery, tables can be referenced by a wildcard:

```
select * from `dataset.table` where _TABLE_SUFFIX = 'suffix'
```
[Docs](https://cloud.google.com/bigquery/docs/querying-wildcard-tables)

When analyzing a query, that references a wildcard table through `_TABLE_SUFFIX`, I get the error:
```
com.google.zetasql.SqlException: Unrecognized name: _TABLE_SUFFIX
````

Can I add support for this somehow?
Thanks

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.