Expand description
§faucet-sink-databricks
Databricks SQL warehouse sink for the
faucet-stream ecosystem. Loads
pages into a Delta table through a SQL warehouse’s Statement Execution API
(plain REST — no JDBC/ODBC driver):
- Load paths — a multi-row
INSERT … FROM VALUESfor small pages, or a staged all-string Parquet file (Unity Catalog volume via the Files API, or S3 / GCS / ADLS behind thestagingfeature) loaded withCOPY INTO. Every value is cast to the column’s declared type on the server. - Write modes —
append,upsert/deletevia oneMERGEper statement (withdelete_marker), andoverwritevia a staging table and an atomicINSERT OVERWRITEswap. - Exactly-once — a
_faucet_commit_tokenwatermark table plus a data write that is idempotent per page token (INSERT … REPLACE WHEREfor append,MERGEfor upsert), so a replayed page never duplicates. - Schema —
current_schemafrominformation_schema.columns,ALTER TABLE ADD COLUMNS/ Delta type widening for drift, and table auto-create from the first page.
Structs§
- Databricks
Sink - Databricks SQL warehouse sink.
- Databricks
Sink Config - Configuration for the Databricks SQL warehouse sink.
- Databricks
Staging Config - Where staged Parquet files are written before the warehouse loads them.
Enums§
- Databricks
Auth - Authentication for the Databricks SQL Statement Execution API.
- Databricks
Load Method - How a page is loaded into the table.
Constants§
- DESCRIPTOR
- The connector’s static descriptor (RFC 0013): its capabilities, answered from config alone.
- STATEMENT_
TEXT_ LIMIT - Hard ceiling on one Statement Execution API request’s statement text.