Explore new tools: Evidence.dev

Stumbled upon this via LinkedIn, describes as:

Johan

— 2 min read
Explore new tools: Evidence.dev

Stumbled upon this via LinkedIn, describes as:

“An open source toolkit for building data products with just SQL and markdown”.

This is the architectural overview:

Steps to get this up&running:

Then, in VSCode:

  1. Open the command palette in VS Code (Cmd/Ctrl + Shift + P)
  2. Select ‘New Evidence project’ or, when you have already defined a project, choose ‘Open Folder’, pointing to the folder where the Evidence project is stored.

The folder contains an example Markdown file:

When pushing the button in VSCode “Start Evidence”, NPM packages are installed to run the Evidence project:

The result is a website hosted on a local webserver (http://localhost:3000/):

The data for this example project is hosted in a local DuckDB file.

A lot of commands are available in VSCode:

So far, so good, just launched the example project. A quick tour around Evidence shows that there are many possibilities to expand:

  • Github integration is available
  • Database connections to various databases are possible: Snowflake, Databricks, Redshift, MSSQL
  • Cloud hosting is available

Will look into those option, more in future Medium stories. Step 1 will probably be to connect to a Snowflake database.

Read more