Welcome to Zuora Product Documentation

Explore our rich library of product information

Mount AWS S3 Delta Lake to DuckDB/MotherDuck

Learn how to mount AWS S3 Delta Lake to DuckDB/MotherDuck

Column Mapping: DuckDB requires delta lake tables use column mapping mode NONE.
Note:

Secrets Manager: DuckDB has a secrets manager which can be used in order for the access key or role information to not need to be included in the CREATE TABLE... syntax.

  1. Install the DuckDB Delta extension.
  2. Open a DuckDB SQL session.
  3. Execute the following SQL:
    CREATE VIEW schema.table_name AS
    SELECT
       *
    FROM deltaLake(
       's3://bucket-name/<configured_path>/<table_name>',
       '<AWS_ACCESS_ID>',
       '<AWS_SECRET_KEY>'
    );