Skip to main content

SQL feature lineage extraction and unified vector SQL planning

Project description

feature-sql-tool

Current implementation of feature-sql-tool focused on:

  • recursive column resolution through CTEs and scope aliases
  • computed-vs-passthrough alias classification
  • intermediate feature extraction
  • filter_only_intermediate_features classification through graph reachability
  • multi-feature unified graph building
  • safe SQL optimization by merging features with identical logical query shape

Current scope

This package is a practical implementation scaffold with working core logic for:

  • scope parsing
  • recursive lineage for one feature
  • filter_only classification
  • safe grouping of multiple feature queries into shared aggregate CTEs when their WITH/FROM/JOIN/WHERE/GROUP/HAVING/QUALIFY signatures are identical

Notes

The optimizer intentionally uses safe reuse only. It merges features only when their normalized query shape matches exactly.

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distributions

No source distribution files available for this release.See tutorial on generating distribution archives.

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

feature_sql_tool-1.4.4-py3-none-any.whl (35.8 kB view details)

Uploaded Python 3

File details

Details for the file feature_sql_tool-1.4.4-py3-none-any.whl.

File metadata

File hashes

Hashes for feature_sql_tool-1.4.4-py3-none-any.whl
Algorithm Hash digest
SHA256 e6e597dbcb54ac4c9e0b7b56246c777968dbc77109f868d50502d6ad0ce9a8c8
MD5 a079b57f589de7de3c5fa2857b542773
BLAKE2b-256 420af329568ce454a0794da01be46973e3511d6641d627e8d192c3a7df21b29f

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Depot Continuous Integration Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page