Data EngineeringADA Asia2022 – 2024Production
Smart Filter Parser & SQL Generation
Metadata-driven SQL generation system translating user-defined filter configurations into executable BigQuery queries.
The Problem
Customer dashboard filters needed to dynamically generate different SQL queries based on user configuration — building this with hard-coded SQL per filter was unmaintainable.
What Was Built
Built a metadata-driven parser that reads filter configuration (field, operator, value, data type) and generates valid BigQuery SQL. Supports complex filter combinations, nested conditions, and data type–aware comparisons.
Business Impact
Enabled dynamic, user-configurable dashboard filtering without code changes, supporting diverse enterprise customer analytics requirements.
Tech Stack
PythonSQLBigQueryJSON
Domain Tags
SQL GenerationMetadata-DrivenAnalytics EngineeringBigQuery
Details
- Role
- Primary Owner
- Status
- Production
- Tier
- Tier 2
- Period
- 2022 – 2024
- Employment
- ADA Asia