4 ms·
It's a lot more. A SQL VIEW is just a saved query, where a semantic layer defines the shared meaning of the data, and helps enforce consistent metrics, joins, a
by CharlesW 1y ago
It's a lot more. A SQL VIEW is just a saved query, where a semantic layer defines the shared meaning of the data, and helps enforce consistent metrics, joins, and logic across tools. You'd be surprised at how many ways "active customer" can be represented as SQL.
- porridgeraisin 1y agoDoesn't a view do that? create view active_cx as select * from customer join audit_events using(...) join ... where -- active condition -- use active_cx wherever select ... from orders join active_cx using(...) where ts > start_of_month() group by active_cx.id
- cryptonector 1y agoIt sounds like "semantic layer" == views/queries created automatically and on the fly.