permission denied when try to set up duckdb destination

[Johannes W. S. (johannes-ws)]

i got this error message "Failed to save DuckDB due to the following error: An exception occurred: PermissionError(13, 'Permission denied')", i just fill /local/lakehouse.duckdb, anyone help?

[Airbyte Support Bot (airbyte-support-bot)]

Hi Johannes W. S. (@johannes-ws), thank you for reporting this!

The PermissionError(13, 'Permission denied') typically occurs because the host directory that Docker mounts to /local inside the container does not have write permissions for the Airbyte container user.

Here's how the path mapping works:

• When you set the destination path to /local/lakehouse.duckdb, Airbyte maps /local to the LOCAL_ROOT directory on your host machine.
• By default, LOCAL_ROOT is set to /tmp/airbyte_local in the .env file at the root of your Airbyte deployment.

To resolve this, please try the following steps:

1. Verify the host directory exists and has correct permissions

# Check your LOCAL_ROOT value (default is /tmp/airbyte_local)
grep LOCAL_ROOT .env

# Create the directory if it does not exist
mkdir -p /tmp/airbyte_local

# Ensure the directory is writable
chmod 777 /tmp/airbyte_local

2. Verify Docker has access to the directory

• Docker Desktop (Mac/Windows): Go to Settings → Resources → File Sharing and ensure /tmp (and /private on macOS) is listed. Click "Apply & Restart".
• Linux: Ensure the Docker volume mount in your docker-compose.yml correctly maps LOCAL_ROOT to /local inside the container.

3. Check the Docker Compose volume mount

In your docker-compose.yml, look for the volume mount on the relevant services. It should look something like:

volumes:
  - ${LOCAL_ROOT}:/local

Make sure this mount exists and is not commented out.

Additional information that would help us assist you further:

• Which version of Airbyte are you running (OSS self-hosted)?
• What operating system is your host machine (Linux, macOS, Windows with WSL2)?
• How did you deploy Airbyte (Docker Compose, Kubernetes, etc.)?

For reference, here is the DuckDB destination documentation which explains the local file path mapping in detail.

---

Need more help? Join Airbyte Community Slack for peer support, or if you're a Cloud customer, open a support ticket referencing this URL.

[Johannes W. S. (johannes-ws)]

Version: 2.1.0 (OSS self-hosted)
OS: Ubuntu 24.04 (Linux headless server)
Deploy: Kubernetes via abctl

Airbyte Support Bot (@airbyte-support-bot)

should i change to use docker compose?