Taking down fully staffed @Google #dataTools in @code team in 2 weeks of coding & 4+ months in marketplace ... @lloydtabb & your #MalloyData crew been pwned in installs in @code:

📥 https://marketplace.visualstudio.com/items?itemName=RandomFractalsInc.duckdb-sql-tools

#ProDataTools 🧙‍♂️ ... 💎💎💎 ... 😎

P.S.: add #duckdb keyword to yours..

#MalloyData team actually beat us to it and added .malloynb support to VSCode IDE in their pre-release version yesterday.

Great to see some new variety and healthy competition in the #DataNotebooks in code space without Py at last!

#QueryDataNotebooks 📚 ...

See GIF: https://twitter.com/TarasNovak/status/1634189001367191554

See supported langs in our new #DataNotebooks 📚 for #VSCode ext. 😎

We'll let you query your data stores in raw #SQL if you prefer that, or using the alternative #PRQL & #MalloyData -> SQL pipelines ...

& Yes! Results will be displayed w/our #DataTableRenderers 🈸! #ProDataTools 🔬 ...

After eval of #MalloyData tools, I am going back to #PRQL. Their repo, tools, docs & api look more mature to me, and should enable adding SQL queries to my data viewers next year.

PRQL playground: https://prql-lang.org/playground/

VSCode extension you can try: https://marketplace.visualstudio.com/items?itemName=prql-lang.prql-vscode

#dataTools 🛠️ ...

Explore more at: https://github.com/prql/prql#explore

Please tag your #dataExplores with Malloy using #MalloyData tag on #github. I'd like to see what other devs & data scientists create with that new #DAX language.

See ours here: https://github.com/topics/malloydata

+ https://github.com/RandomFractals/chicago-crimes#with-malloy-composer

+ https://github.com/RandomFractals/chicago-crimes#with-malloy-fiddle

#dataTools 🛠️ 2022 ...

📢 New 2022 #ChicagoCrimes #MalloyData #Fiddle app you can run in a browser to learn Malloy model and query semantics, nesting, and simple charting 📊📈 options:

📰 https://randomfractals.github.io/chicago-crimes/apps/malloy-fiddle

📓 https://github.com/RandomFractals/chicago-crimes#with-malloy-fiddle

🧐 https://github.com/RandomFractals/chicago-crimes/blob/main/docs/images/chicago-crime-reports-malloy-fiddle-app.gif

#DAX #dataApps #dataTools 🔬 ...

Updated #ChicagoCrimes with #MalloyData tools example & more info in docs:

🧐 https://github.com/RandomFractals/chicago-crimes#with-malloy-data

Clone that data repo & install Malloy #vscode extension to try it out:

📥 https://marketplace.visualstudio.com/items?itemName=malloydata.malloy-vscode

#dataTools 🔬 ...

I've decided to try #MalloyData today.

Here is a quick example of loading #ChicagoCrimes 2022 #parquetData with #DuckDB and Malloy queries for some rough counts and data summaries:

https://github.com/RandomFractals/chicago-crimes/issues/24

#dataTools 🛠️ ...