odp
Project description
odp
Detect unused tables and columns in your SQL database.
Currently supports Snowflake and BigQuery, support for Redshift and other warehouses coming soon.
- Github repository: https://github.com/open-data-products/odp/
- Documentation https://open-data-products.github.io/odp/
Dev Usage
poetry install
poetry run python -m odp detect-unused --schema-file=examples/snowflake/info-schema.csv --queries-file=examples/snowflake/query-history.csv
or, run with snowflake env:
cat <<EOF > .env
ODP_SNOWFLAKE_ACCOUNT=your_account
ODP_SNOWFLAKE_USERNAME=your_user
ODP_SNOWFLAKE_PASSWORD=your_password
ODP_SNOWFLAKE_DATABASE=your_database
ODP_SNOWFLAKE_WAREHOUSE=your_warehouse # optional
ODP_SNOWFLAKE_ROLE=your_role # optional
EOF
poetry run python -m odp detect-unused
or, run with bigquery env:
cat <<EOF > .env
ODP_GOOGLE_APPLICATION_CREDENTIALS=your_credential_file
ODP_GOOGLE_PROJECT=your_project
EOF
poetry run python -m odp detect-unused --dialect=bigquery
Maintainers
Made with :heart: by
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
odp-0.0.9.tar.gz
(8.1 kB
view hashes)
Built Distribution
odp-0.0.9-py3-none-any.whl
(9.1 kB
view hashes)