🦆 Using DuckDB as a Source in Ferry
Ferry allows you to ingest data from a DuckDB database and move it to different destinations like data warehouses, APIs, or other databases.
📌 Prerequisites
Before using DuckDB as a source, ensure:
- DuckDB is installed (
pip install duckdbif using Python). - You have a valid database file (
.duckdb) or an in-memory database. - The required tables exist in your DuckDB database.
source_uri Format
To connect Ferry to a DuckDB database, use the following connection string format:
plaintext
duckdb:///<path-to-database>.duckdbParameters:
<path-to-database>– Path to the DuckDB database file (e.g.,/path/to/database.duckdb).
source_table_name Format
plaintext
main.users