Re:DuckDB: Querying JSON files as if they were tables
by amcaskill on Friday March 03, 2023 @08:34PM
(#35017238)
I’m working on an open source BI alternative called Evidence which works nicely with version control and CI/CD.
If that’s of interest, you can read our launch HN here: https://news.ycombinator.com/item?id=28304781
One of our community members has built a pretty cool Duck DB + dbt + evidence data stack that you can run entirely in GitHub codespaces. He’s calling it modern data stack in a box.
You can see that repo here: https://github.com/matsonj/nba-monte-carlo
Re:DuckDB: Querying JSON files as if they were tables
by Jgrubb on Friday March 03, 2023 @11:44PM
(#35018255)
Are you talking about metabase by any chance?
Re:DuckDB: Querying JSON files as if they were tables
by janee on Saturday March 04, 2023 @12:42AM
(#35018524)
Haha indeed! I've started with a very basic Ruby api client that can read and create dashboards.
My plan is to poc a tool that allows you to edit metabase config as files and secondly something that can replicate cloud instances to other environments like local docker image or staging instance
Was looking for something to read json files which will house the config via SQL, i.e. a human readable db as an alternative to what the BI tool is using for it's config persistence.
Will give DuckDB a go, thanks for posting!