incubator-xtable icon indicating copy to clipboard operation
incubator-xtable copied to clipboard

Create BigQuery Sink

Open anoopj opened this issue 2 years ago • 2 comments

Build a BigQuery sync will allow customers to incrementally sync from table formats to BigLake Managed Tables (and BQ native tables).

The implementation of the sink will be different than other sinks:

  1. Instead of metadata translation, it will invoke a LOAD statement in BigQuery.
  2. It can only support added files and not removed files.

@the-other-tim-brown: Do you think this will be useful?

anoopj avatar Nov 10 '23 23:11 anoopj

It's an interesting use case and could work with our existing framework. I'm curious if there are other tools that already do this though.

the-other-tim-brown avatar Nov 11 '23 14:11 the-other-tim-brown

I am not aware of any existing tooling. BigQuery LOAD jobs support only file formats (Parquet/ORC/Avro et al) - open table formats are not supported.

anoopj avatar Nov 13 '23 16:11 anoopj