user avatar
lloyd tabb
@lloydtabb
Looker Founder, makes things with bits. Trying to make a better SQL with Malloy linkedin.com/in/lloydtabb/
malloydata.dev
Joined February 2009
409
Following
3,169
Followers
Posts
  • Pinned
    user avatar
    lloyd tabb
    @lloydtabb
    Aug 17, 2022
    A SQL based Semantic Data Model describes calculations and relationships in data so you don't have to repeat yourself. Querying a semantic model is much the same as querying a table but without the complexity of the calculations. Here is an example in #Malloy
  • user avatar
    lloyd tabb
    @lloydtabb
    Oct 19, 2021
    We've been working on, Malloy, a new experimental data language. If you work in SQL, we'd love your feedback. github.com/looker-open-so…
  • user avatar
    lloyd tabb
    @lloydtabb
    May 4, 2024
    “Necessity is the mother of invention”.   This coming week I’m starting a new job at Meta to work on Malloy and to bring Malloy into Meta’s internal data tooling.
    67K
  • user avatar
    lloyd tabb
    @lloydtabb
    Sep 8, 2022
    Curious about the Malloy Language? Want to try it out with no install? Check out our new Malloy Fiddle. Malloy Fiddle runs entirely in the browser using #DuckDB and WASM. Malloy Fiddle queries semantic data models. See results as tables, JSON or SQL. looker-open-source.github.io/malloy/fiddle/…
  • user avatar
    lloyd tabb
    @lloydtabb
    May 2, 2022
    I'm excited to share Malloy Composer, a demo of a data exploration tool built on top of the Malloy Language. I don't think you have seen anything like it.
    docs.google.com
    Malloy Composer
    Malloy
  • user avatar
    lloyd tabb
    @lloydtabb
    Aug 3, 2022
    It’s an exciting time for Malloy. It's easy to start with the VSCode plugin (thanks to DuckDB), you can use Malloy to explore data in local CSV or Parquet files in addition to Postgres and BigQuery. You only need VSCode to work with data, Try it! (1/3) github.com/looker-open-so…
  • user avatar
    lloyd tabb
    @lloydtabb
    Nov 29, 2022
    If you work with data, we'd like you to try something new. Malloy Composer lets you explore data in a way you have not experienced before. Read the post, clicking "Try It!" as you go. To really understand innovation, you have to touch it.
    Composing with Queries
    From lloydtabb.substack.com
  • user avatar
    lloyd tabb
    @lloydtabb
    May 6, 2023
    If you are bored this weekend, maybe watch my *awkward* talk on Malloy at Datacouncil.ai. It starts with limitations of SQL that you didn't think were possible to avoid and then shows how Malloy frees you from relational/dimensional tyranny. datacouncil.ai/talks/malloy-a…
    AI Council 2026 · May 12–14 · San Francisco
    From aicouncil.com
    20K
  • user avatar
    lloyd tabb
    @lloydtabb
    Jan 3, 2024
    Many of the best programmers I know are terrible at querying with SQL. I tried and failed to write a blog post about this. Given SQL's value, I always find this surprising. Any theories as to why?
    16K
  • user avatar
    lloyd tabb
    @lloydtabb
    Jan 18, 2023
    That SQL forces everything through rectangles limits how we think about data and shapes our tooling. It doesn't have to be this way.
    lloydtabb.substack.com
    Data is Rectangular and other Limiting Misconceptions
    Malloy breaks data's rectangular strangle hold.
    12K
  • user avatar
    lloyd tabb
    @lloydtabb
    Aug 4, 2022
    Why Malloy is interesting? Let me show you. Malloy allows you to define a semantic model of your data. The model includes all the joins and reusable calculations. This data comes from the IMDB. The following queries use this model. imdb.com/interfaces/
  • user avatar
    lloyd tabb
    @lloydtabb
    Dec 6, 2018
    I'm so humbled by team of people I get to work with everyday, who our customers and partners are and by how far we've come. What excites me is how far we will go. #lovelookerlove
  • user avatar
    lloyd tabb
    @lloydtabb
    Aug 23, 2022
    Google makes political ads spend data publicly available in BigQuery. The data include advertiser, spend, media type and links to the actual advertisements. There are 944K rows in the table. In 50 lines of Malloy code, we can get a current and historical overview of this data.
  • user avatar
    lloyd tabb
    @lloydtabb
    Feb 24, 2023
    This is an amazing piece of work by @carlineng . The TPC-DS benchmark is 100 very complex decision support SQL queries. Carlin converted them all to Malloy and wrote about the experience. A long valuable read.
    carlineng.com
    Carlin Eng
    Homepage of Carlin Eng
    14K