Can your name reveal where you are from? If you are named: Mckay, Hyrum, Afton or Bridger you are probably from Utah; Perlie, Gussie, Willie or Ola, you are probably from Alabama. Watch how we use Malloy and data to find location iconic names. Let's first start with data from the Social Security administration. The table has name, state, year, gender and number of births in that year.

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… Malloy is an open source language for data which integrates query and semantic modeling. A data scientist can start using Malloy, and in an afternoon be generating complex useful queries which would have been nearly impossible to write in SQL. (2/3)