{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/b65632fc0ee5404e895e5afdc3e17653\" frameborder=\"0\" width=\"1494\" height=\"1120\" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>","height":1120,"width":1494,"provider_name":"Loom","provider_url":"https://www.loom.com","thumbnail_height":1120,"thumbnail_width":1494,"thumbnail_url":"https://cdn.loom.com/sessions/thumbnails/b65632fc0ee5404e895e5afdc3e17653-00001.gif","duration":114.96603170000003,"title":"Introduction to the dbt Semantic Layer Cell in Hex","description":"In this video, I provide a quick introduction to the dbt semantic layer cell in Hex. I demonstrate how to use the dbt Semantic layer cell to create queries on the fly. I highlight that dbt now supports Snowflake, BigQuery, Databricks, and Redshift, allowing users to define metrics on any of these databases and use them directly in Hex. I showcase how to select specific metrics, set a time grain, and run the query. Finally, I explain how the data is returned as a pandas dataframe, which can be further manipulated and used for downstream needs. Explore and let us know your thoughts!"}