Creating a simple catalog with tables and columns using local service
- Dominant language
- C++
- Stars
- 2.6k
- Forks
- 260
- PR merge metrics
- No merged PRs in 30d
Description
We are using a python client binding for ZetaSQL GRPC local service in our application to analyze statements and extract referenced tables and columns.
However, from what I see [here](https://github.com/google/zetasql/blob/master/zetasql/local_service/local_service.proto), the local service doesn't have the full functionalities of the Java service, mainly creating simple catalog with tables and columns to analyze any SQL statement. Also setting analyzer options doesn't seem to be [possible](https://github.com/google/zetasql/blob/master/zetasql/local_service/local_service.proto#L749).
Can you point out how we can analyze statements using only the local service?
Contributor guide
Research direction
Read zetasql/local_service/local_service.proto first, focusing on the catalog and analyzer-options RPC definitions. Compare the local service API with the Java service capabilities described in the issue, then determine whether the requested catalog creation and options support can be exposed through the Python client. Done means a documented, supported way to analyze arbitrary SQL with local tables, columns, and analyzer options.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- grpc, python, sql
- Domain
- api, databases
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100