TE
TechEcho
Home24h TopNewestBestAskShowJobs
GitHubTwitter
Home

TechEcho

A tech news platform built with Next.js, providing global tech news and discussions.

GitHubTwitter

Home

HomeNewestBestAskShowJobs

Resources

HackerNews APIOriginal HackerNewsNext.js

© 2025 TechEcho. All rights reserved.

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

3 pointsby nicoritschel7 months ago

1 comment

nicoritschel7 months ago
If you&#x27;re into data in any capacity, you&#x27;ve probably heard about DBT the past few years. SQLMesh is an alternative that with many enhancements like column level lineage.<p>You may or may not be familiar with the DBT semantic layer. It&#x27;s out of reach due to cost for many folks— requires expensive monthly fees.<p>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.