google / google/googlesql

Support EXTERNAL_QUERY tvf

Open
#145 1 comment 1 reaction 0 assignees View on GitHub
Dominant language
C++
Stars
2.6k
Forks
260
PR merge metrics
No merged PRs in 30d

Description

Hi!

Is it possible to declare [EXTERNAL_QUERY](https://cloud.google.com/bigquery/docs/reference/standard-sql/federated_query_functions#external_query) tvf in ZetaSQL catalog? It is required to declare a return type that is a relation with known column names and types. In the `EXTERNAL_QUERY` we don't have this information and I couldn't find any way to declare tvf that returns table with unknown columns.

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.