Gonna try to wrap up and release #DataNotebookPro 📓 @code / #SQLTools extension this month for our #ProDataTools 🛠️ sponsors on GitHub ...

📰 https://github.com/RandomFractals/pro-data-tools#data-notebook-pro-tools

#DataNotebooks 📚 / #DataTools 🧙‍♂️ ...

A few remaining #ObservableJS 📓 to #Qurto doc conversion & docs tickets in our old Observable #DataTools 🛠️ repo to guide data analysts and data scientists exploring that space and tools ecosystem on how to use them in @code IDE ...

📰 https://github.com/RandomFractals/observable-data-tools/issues

#DataNotebooks 📚

I hosted the PipeRider Community Office Hours yesterday and one cool feature we demoed was this online dbt manifest viewer.

Generate a Lineage Diff from just your dbt project's manifest files.

Try it out for yourself here:

https://staging.cloud.piperider.io/online-viewer#/?utm_source=mstdn

Watch it in action on Youtube:

https://www.youtube.com/watch?v=LHuTb3e_4O8

#DataEngineering #DataViz #dbt #DataTools #AnalyticsEngineering #OpenSource #PipeRider

Our #DataPreview 🈸 for #VSCode IDE now has over 456+K installs. We'll break 500K by the end of the year for sure!

📥 https://marketplace.visualstudio.com/items?itemName=RandomFractalsInc.vscode-data-preview

#DataTools 🛠️ FTW 🤗

We can attest that #Quarto #VisualEditor is much more aesthetically pleasing to view and edit markdown docs interleaved with code blocks, and provides a unique document view experience.

Brief demo of our #DuckDB #ObservableJS 📓 converted to .qmd doc using it. ⬇

Quarto Visual Editing docs:

📰 https://quarto.org/docs/visual-editor/vscode/

Our Observable #DataTools 🛠️ and #JSNotebooks 📚 repository:

📥 https://github.com/RandomFractals/observable-data-tools

DuckDB #DataTables Quarto doc:

📝 https://github.com/RandomFractals/observable-data-tools/blob/main/notebooks/quarto/duckdb-data-tables.qmd

#QuartoPub #DuckDBTools 🧙‍♂️ ...

This is how many installs per hour our public #dataTools 🛠️ extensions get in #VSCode marketplace today. Let us know if you can top that 😉

#RandomFractalsInc #dataWorks ...

📥 https://marketplace.visualstudio.com/publishers/RandomFractalsInc

We've enabled GitHub discussions for our public #DataTools & new #ProDataTools 🛠️ users to ask questions, request new features, and share ideas on how to improve them for the data scientists and devs using #VSCode, #VSCodium and #AzureDataStudio.

📣 https://github.com/RandomFractals/pro-data-tools/discussions/10

Our #ProDataTools 🛠️ 🧙‍♂️ docs repo for all the brave #DataTools in #VSCode & #AzureDataStudio explorers out there 🤗

https://github.com/RandomFractals/pro-data-tools

We took the latest #AzureDataStudio for a spin today and can confirm that all of our old custom #VSCode #dataViz extensions work in that IDE, including new #DuckDB #SQLTools, #PRQLCodeLens, new #MarkdownSQLTools, and soon to be released #DataNotebookProTools.

We'll post some walkthroughs on how to install and use some of our new #ProDataTools in Azure Data Studio IDE soon.

Let us know if any of these #DataTools would be of interest to your #DataTeams and your users.

🛠️ https://randomfractals.github.io/pro-data-tools/

This weekend, I came up with the thought that we need another 2 hashtags: #MessyWeekends and #MedianData. Here's why:

The inspiration for #MessyWeekends came from seeing some folks regularly having fun with #TidyTuesday. However, since my Tuesdays usually are pretty tight, I will have to find some time on the weekends to play with #Data, #Python, #pandas, #PyData, #DataScience, etc. With a 4.75YO at home, weekends tend to be messy anyway. So that's that.

As for #MedianData, it is literally between #SmallData and #BigData, and I think a lot can be learned by pouring over it and trying out different kinds of #DataTools.

What do you think? 😎

Set up new username on discord. You can friend and DM us there for quick chats about new #DataTools we are building, etc.

Our combined #ProDataTools 🛠️ changelog, covering prominent features and enhancements added to #DuckDB SQL and #DuckDBPro Tools, #PRQLCodeLens and new #MarkdownSQLPro Tools in 15 releases of the new #DataTools for VS Code ID published this year so far:

🧐 https://randomfractals.github.io/pro-data-tools/CHANGELOG

We created new combined changelog to capture all the #ProDataTools 🛠️ VS Code extensions and versions with detailed features info released to our Pro sponsors on GitHub this year.

📜 https://github.com/RandomFractals/pro-data-tools/blob/main/CHANGELOG.md

You can get access to all of our Pro Data Tools today for a low low price of only $0.66. That's less than the cost of a ☕️ for some great new #DataTools for @code.

💖 https://github.com/sponsors/RandomFractals/sponsorships?tier_id=295482

We'll wrap up our latest #MarkdownSQLPro Tools v1.2.0 docs today and will release that update shortly.

Good to see our free and public #DuckDB #SQLTools Preview #VSCode extension cross 3K installs. We do get about 600 new installs every month now and should hit 6K by the end of 2023.

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

#DataTools 🛠️ ...

Oh, our #dataPreview just crossed 444k installs 👌

➤ https://marketplace.visualstudio.com/items?itemName=RandomFractalsInc.vscode-data-preview

#DataTools 💎 💎 💎...

We took a trip down our old Observable #JSNotebook(s) 📚 and #dataVizPro 📊 tools memory lane today.

See many insightful and working Observable JS examples in our new 𝕏 Highlights 😎

📰 ⤑ https://twitter.com/TarasNovak/highlights

#DataViz 📈 / #GeoSpatial 🗺️/ #DataTools 🛠️ 🧙‍♂️

Observable #JSNotebooks 📚 are a great alternative to Quarto markdown, "polyglot" notebooks from #netInteractive team, and standard Python or R Jupyter notebooks.

📥 ⤑ https://marketplace.visualstudio.com/items?itemName=GordonSmith.observable-js

These JS notebooks are ideal for data scientists who prefer native #VSCode notebook interface and reactive Observable cells.

Quick demo of running and exploring our #DuckDB #JSNotebook 📓 in VS Code IDE from our Observable #DataTools 🛠️ collection:

📚 ⤑ https://github.com/RandomFractals/observable-data-tools

#SQL / #DataNotebooks 🧙‍♂️

Q. What's the best thing about open-source software?

A. You can modify it and add your own features❤️

That's exactly what Alex, a senior data engineer at domain.com.au, did with PipeRider.

Alex added features specific to his data migration use-case of comparing two datasets on the row-level, with tolerance

https://www.youtube.com/watch?v=SSoFyWTAYGw

#OpenSource #DataQuality #DataReliability #DataLineage #DataOps #DataTools #DataViz

Our #VegaViewer 📈 recently crossed 12K installs in VS Code Marketplace.

Vega Viewer was our first VS Code extension we published back in 2019. Since then we published 72 releases, most of them were back in 2019-2020.

📰⤑ https://github.com/RandomFractals/vscode-vega-viewer

#vsCode #dataViz 📈 #dataTools 🛠️ 🧙‍♂️

Our #GeoDataViewer 🗺️ VS Code extension is going to cross 127K installs in marketplace this week.

📥 / 🧐 ⤑ https://marketplace.visualstudio.com/items?itemName=RandomFractalsInc.geo-data-viewer

We should hit 150K installs by the end of 2023 ... We are at ~50K installs/year since we published it back in February 2020 before the pandemic hit us.

Also, this Geo Data VS Code extension already has ~246K total downloads after only a few public releases we pushed since 2020:
https://github.com/RandomFractals/geo-data-viewer/releases

#GIS #geoSpatial #VSCode #DataTools 🛠️ stats ...