A open-source Looker/Data Studio alternative, supporting Bigquery/Snowflake/DuckDB. Has a custom SQL dialect with embedded semantic layer to make reusable and interactive visuals easier. Can be self-hosted, but a public version is available. Still very WIP!
https://trilogydata.dev/trilogy-studio-core/