google / google/googlesql

Creating a simple catalog with tables and columns using local service

Open
#120 0 comments 3 reactions 0 assignees View on GitHub
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

Open the contributing 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.