Metrics in SQL: querying a semantic layer via DuckDB over the pg protocol

by nicoritschelon 10/29/2024, 2:45 PMwith 1 comments

by nicoritschelon 10/29/2024, 2:45 PM

If you're into data in any capacity, you've probably heard about DBT the past few years. SQLMesh is an alternative that with many enhancements like column level lineage.

You may or may not be familiar with the DBT semantic layer. It's out of reach due to cost for many folks— requires expensive monthly fees.

SQLMesh includes a query rewriter if you have defined any metrics, so I simply added it to the existing buenavista query rewriter and added a sample SQLMesh project. Cheers.