Open diego-escobedo opened 1 year ago
Is storing the queries as a string the best idea? Have no way of linting/formatting/checking the queries easily.
Borrowing an idea from analytics warehouses, typically queries themselves are stored in separate files (if in SQL, then .sql), then imported. This makes them easier to keep track of and see changes just to the queries over time, and makes possible linting just the queries and enforcing style formats.
Currently, we have all the queries that power our metric aggregation stored in
backend/metering_billing/aggregation
. Though they are functionally working, there are some things worth considering and possibly fixing:If anyone wants to tackle one of these 4 / look into them and come up with a plan of action, might be a good idea to spin them out into their own issue.