Delta Lake - ParadeDB

Overview

This code block demonstrates how to query a Delta table.

CREATE FOREIGN DATA WRAPPER <wrapper_name>
HANDLER delta_fdw_handler
VALIDATOR delta_fdw_validator;

CREATE SERVER <server_name>
FOREIGN DATA WRAPPER <wrapper_name>;

CREATE FOREIGN TABLE <table_name> ()
SERVER <server_name>
OPTIONS (files '<files>');

CREATE FOREIGN DATA WRAPPER delta_wrapper
HANDLER delta_fdw_handler
VALIDATOR delta_fdw_validator;

CREATE SERVER delta_server
FOREIGN DATA WRAPPER delta_wrapper;

CREATE FOREIGN TABLE delta_table ()
SERVER delta_server
OPTIONS (files 's3://bucket/folder');

wrapper_name

required

Foreign data wrapper name. Can be any string.

server_name

required

Foreign server name. Can be any string.

table_name

required

Foreign table name. Can be any string.

files

required

The path to the Delta table directory. For instance, s3://bucket/folder if the Delta table is in Amazon S3 or /path/to/folder if the Delta table is on the local file system.

Cloud Object Stores

The object stores documentation explains how to provide secrets and other credentials for Delta tables stored in object stores like S3.

Integrations

​Overview

​Cloud Object Stores

Overview

Cloud Object Stores