Skip to content

testing dlt (data load tool) with the eBird API and duckdb

Notifications You must be signed in to change notification settings

Doctacon/bird-finder-app

Repository files navigation

bird-finder-2.0

Description

bird-finder-2.0 is a demo of the dlt (data load tool) package to locate birding hotspots relative to a given location. It leverages the eBird API to fetch recent observations of notable birds in the specified location and supports various destinations like DuckDB.

Requirements

  • Python 3.10
  • dlt 0.3.12
  • duckdb 0.8.0
  • sqlmesh
  • python-dotenv 0.20.0
  • click 8.1.1
  • colorama 0.4.4

Installation

Use the package manager poetry to install bird-finder-2.0.

poetry install

Usage

  1. Activate your poetry shell (or add ~/$ poetry run to every command)
  2. Ingest data from ebirdapi ~/orchestration/assets/ebirdapi$ python3 ebirdapi.py
  3. Create staging layer files ~/$ gen-staging {file-path-to-ebirdapi_source.schema.yaml}
  4. Materialize staging layer ~/transformation$ dbt run
  5. Update staging layer docs ~/transformations$ dbt-osmosis yaml refactor --fqn staging

You can specify the location code using the loc_code parameter. Please refer to the eBird API documentation for valid location codes.

Development

To install development dependencies and set up a development environment, use:

poetry install --dev

Contributions

Feel free to contribute to the project by opening issues or submitting pull requests.

Authors

  • Connor Lough

Roadmap

  1. Containerize assets and orchestrator

Acknowledgements

Special thanks to the eBird API for providing the data.


Feel free to add any additional information, guidelines, or documentation that might be relevant to your project. If you have specific instructions or caveats that are not covered here, be sure to include those as well.

About

testing dlt (data load tool) with the eBird API and duckdb

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages