Skip to content

Delta Lake

Install

See the Install guide for the full setup, including Windows PowerShell.

curl -fsSL https://install.skippr.io/install.sh | shClick to copy

Reads from a Delta Lake table URI (S3, ADLS, or local).

Configuration

yaml
source:
  kind: delta_lake
  table_uri: "s3://my-bucket/path/to/table"
  storage_options:
    AWS_REGION: us-east-1
  version: 5
FieldDefaultDescription
table_uri(required)Path to the Delta table (e.g. s3://, abfss://, file path)
storage_optionsKey/value options for the object store (credentials, region, etc.)
versionOptional table version to read
filterOptional predicate filter expression

CLI

bash
skippr connect source delta-lake \
  --table-uri s3://bucket/path/to/table \
  --storage-option AWS_REGION=us-east-1 \
  --version 5
FlagDescription
--table-uriTable location URI (e.g. s3://bucket/path)
--storage-option KEY=VALUEStorage backend option; repeat for multiple values
--versionOptional Delta table version to read
--filterOptional filter expression

Authentication

Authentication depends on the storage backend referenced by table_uri. For security best practices, we strongly advise against storing storage credentials in skippr.yaml. Use environment variable interpolation instead: replace the relevant storage_options value with your own ${ENV_VAR} reference.

The relevant part of skippr.yaml looks like this:

yaml
source:
  kind: delta_lake
  table_uri: "s3://bucket/path/to/table"
  storage_options:
    AWS_ACCESS_KEY_ID: ${DELTA_AWS_ACCESS_KEY_ID}
    AWS_SECRET_ACCESS_KEY: ${DELTA_AWS_SECRET_ACCESS_KEY}

Set the env vars before running skippr:

macOS / Linux

bash
export DELTA_AWS_ACCESS_KEY_ID="AKIA..."
export DELTA_AWS_SECRET_ACCESS_KEY="secret"

Windows PowerShell

powershell
$env:DELTA_AWS_ACCESS_KEY_ID = "AKIA..."
$env:DELTA_AWS_SECRET_ACCESS_KEY = "secret"

Windows Command Prompt

cmd
set DELTA_AWS_ACCESS_KEY_ID=AKIA...
set DELTA_AWS_SECRET_ACCESS_KEY=secret

Permissions or Network Requirements

The runner needs read access to the Delta transaction log and data files behind table_uri. Make sure the URI is reachable from the machine running skippr and that the underlying storage credentials allow reads.

Troubleshooting

SymptomFix
table cannot be openedVerify table_uri, backend credentials, and that the Delta log is present at that path.
schema inference looks wrongCheck the selected table version and any optional filter expression.

Next steps

Install

See the Install guide for the full setup, including Windows PowerShell.

curl -fsSL https://install.skippr.io/install.sh | shClick to copy