Changelog

• Themes:
  • You can now completely change the appearance of your Evidence app with just a few lines of configuration
  • Set UI colors, chart color palettes, and custom colors you can reuse across your project in evidence.config.yaml
  • Easily copy-paste and modify themes from other repos - see sample themes we’ve created
  • Themes will be especially helpful for these use cases:
    • Embedded Analytics: Seamlessly embed Evidence into your app by matching its styling
    • Customer Portals: Deliver a white-labeled analytics experience to your customers
    • Internal Reporting: Match company branding and internal tool design to maximize familiarity for your report users
• Dark Mode & Appearance Switcher:
  • Dark mode is now available in all new Evidence projects from this version forward
  • See this migration note to learn how to enable it for projects created before this version
  • Users can select an appearance mode from the appearance switcher in the top right menu
  • You can turn off the appearance switcher or set default appearance mode via the theme config

• Improved ButtonGroup appearance and transitions: smoother selection and aligned styling to dropdown input component
• Improvements to logging: removes unnecessary console messages and always logs server errors
• Query Functions: releasing experimental support for functions that can be applied to query results in your markdown (.where(), .groupBy(), .limit(), .offset(), .agg())
  • e.g., <Value data={sales_data.where(`region = 'West'`)/>
  • These are especially helpful inside loops since a SQL block can’t be placed inside a loop
  • If you still use the Javascript .filter() function anywhere in your markdown, it can be replaced with .where()

Fixes & Docs Additions:

• Fix for SPA mode docs
• Docs: Include example of SQL usage of multi dropdown input
• Fix for DataTable group sorting behaviour
• Fix pagesManifest generation for pre-v18.17 node
• Add official minimum node version in VS Code extension

• Deploy Evidence to Non-Root Path - add a base path which will be used in all links in your project
  • Useful for Github Pages deployments
• NodeJS v22 support

Fixes & Docs Additions:

• New code vs. preview tabs in Evidence Docs
• Add explanation for self-hosting with SPA mode - thanks Frank Boerman!
• Reduce errors from plugin directories during sources runs - thanks @mnahkies!
• Loading improvements for accordion-wrapped charts
• Smoother loading for ReferenceArea, ReferenceLine, and ReferencePoint

• Custom Series Order: Introduced a seriesOrder parameter to allow custom ordering of series
• MSSQL Connector Timeout: Added a requestTimeout option to the MSSQL connector to control connection timeouts
• Extended Env Var Naming: Support for environment variables containing digits 2–9
• Snowflake Token Caching: Authentication token caching has been added to the Snowflake connector for improved performance
• Customizable Homepage Name: Users can now change the name of the homepage in the sidebar
• Map Attribution: Added a feature to include attribution details for maps
• Bsky Platform Support: Bsky integration is now available for header

Bug Fixes:

• DateRange and Slider Fixes: Resolved flickering issues with the DateRange component and stabilized the Slider’s default value behavior
• Remove Columns on Destroy: Optimized resource management by removing columns when the component is destroyed
• Error Component Update: Fixed an issue with the error component layering, improved error handling
• Map Loading Screen Fix: Corrected the layout shift issue that occurred while the map was loading
• Prop Value String Handling: Improved the handling of string values in props for more consistent behavior
• Slider Default Value Fix: Resolved a bug where dynamic default values were not being set correctly in sliders
• Loading Toast Fix → Remove Loading Toasts
• Documentation Source Page Update: Removed unnecessary update warnings from the documentation sources page
• Large Markdown: Prevent Large markdown Queries with a warning
• Windows URL Regularization: Fixed issues with URL handling in pagesManifest for better compatibility on Windows systems

Developer Enhancements:

• Vite Optimization for SDK: Added sdk/utils/evelte to Vite’s optimizeDeps.include to improve build performance

• Significantly improved chart transition animations
• MSSQL connector supports connectionTimeout option (thanks Emanuele Bardelli!)
• MSSQL connector supports more authentication methods, including Active Directory (thanks Michael Hua!)
• DimensionGrid supports the fmt prop

Bug fixes and other updates

• DateRange now correctly calculates “Last x Days”
• Fixed layout shift caused by code block syntax highlighting
• Removed Flowchart component

• DataTable supports sparklines and bars
• DataTable has a sort prop
• Maps now layer Bubbles and Points more consistently
• Maps legends have been significantly improved

• Fix for Windows Cache and Bandwidth issue

• Added VITE_EVIDENCE_DISABLE_WINDOWS_CACHE_SERVICE_WORKER environment variable to disable the fetch rerouting we added in 39.1.4

• Added legends for Categorical and Scalar maps
• Snowflake connector has a new option resultPrefetch that can make sources run faster
• Better behaviors for link rows in DataTable

• New Group component to help with grouping elements within a Grid
• Environment variables can be used in custom components while in dev mode

Bug fixes and other updates

• Reactive DataTable columns now update properly
• Queries that contain $ no longer break when used in other queries
• Index page frontmatter is now properly applied to the sidebar
• Fix some queries not properly prerendering

• Patched a bug that caused an increase in build times

• Datasource config now supports multiline strings
• BigQuery now supports non-US locations

Bug Fixes

• Snowflake private key uses a multiline string
• Better error message when running sources without a sources directory

• Style ButtonGroup as Tabs
• ButtonGroup default value prop

Docs

• Scroll-to prop option links
• Fix dropdown order prop documentation
• SPA rendering mode Docs

Bug Fixes & Updates

• BoxPlot duplicate boxes fixed
• Tabs id prop persists on refresh/shared links
• Column pre-rendering improvement!
• Set proper permissions when writing parquet files
• Fix preprocess tsconfig

New Features

• Smooth Zoom for Maps
• Loading State for Area Map, Bubble Map, and Point Map
• Make AreaMap geoJsonUrl Reactive
• Use Dimension Grid as a Multi Select
• Dropdowns Persist Inputs When Switching Tabs

Docs

• Build Your First App thanks sometimescasey!

Bug Fixes & Updates

• Fix TProtocolException When Loading Parquet Files on Windows
• Fix Breadcrumbs Home
• Removed Scroll to Top and Fixed Esc Close for Fullscreen Mode
• Remove Max Height from Codeblock

• Option to disable downloads / image saving for charts: use the new downloadableData and downloadableImage props in charts to enable/disable the download buttons that appear when hovering over a chart
• Increase default node memory limit: allows for more default memory usage on npm run build in order to reduce out of memory error messages

Bug Fixes

• Eliminate hanging at end of npm run sources command
• Fix for MSSQL connector to remove ‘unofficial plugin’ warning
• Override fast-xml-parser to >=4.4.1

• Value Component colors: Apply custom colors using the color prop, automatically format negative values in red using the redNegatives prop
• Inactive Tab style improvement: Tabs now look more cohesive with inactive tabs appearing in grey, and active tabs appearing in color
• Stacked Bar Charts label control: Show total labels without series labels

Bug Fixes

• Fixed Reference Components data handling
• Update docs for postgres using SSL certificates - Thanks Frank!
• Fixed DataTable search
• Properly handle Windows paths in source query HMR
• Fixed auth in Trino connector - Thanks @jpambrun!
• Fixed issue where page loads multiple times

• Breadcrumb customization: customize your page’s breadcrumbs to be more user friendly using the frontmatter title and breadcrumb options
• Reference styling: customize your reference labels, font, and symbols to more effectively draw attention to your data

Bug Fixes

• Fixed builds for SPA projects
• Dropdown can have an option with a null value/label
• Updated to MSSQL v11 to resolve a security vulnerability
• Fixed datetime column loading for SQLite sources
• Proxy configuration for Snowflake sources

• New Reference Point and Callout Components
• Support for referencing multiple environment variables in source queries

Bug Fixes & Updates

• Standardize options for components that can be turned into links to link
• Support column names with spaces in Dimension Grid
• Improved treatment of default values, and loading performance for pages with multiple dropdowns

• Upgrade duckdb to version 1.0
• Fix for comments and semicolons in queries: having semicolons or comments in your SQL queries will no longer cause errors
• DataTable search improvements for long strings: better accuracy of search for very long strings in DataTable
• Add support for an initialize script in duckdb: advanced feature - can be used to set the search path, inject credentials, etc.
• Weighted mean behaviour improvement: handles null and zero values properly, default calculation changed to return null if no weightCol supplied

• MotherDuck Connector: first class connector for MotherDuck
• Option to specify an aggregate function when defining Value components

Bug Fixes & Updates

• Option to Select Date Range Presets
• Improved Preview Command
• Improved Toast Behaviour
• Better Handle Null Series in LineCharts
• Improved Dropdown Search
• Respect Dropdown Ordering
• Support Mutliselect Select All on Combined DropDown Options and Query Results
• Ensure selectAllByDefault is Respected
• Respect startingZoom in Maps, Allow for Finer Grain Zooming
• Ensure DataTables escape spaces properly thanks Amdy!
• Prevent stale pagination when dataTable is referencing a reactive query thanks Paul!

• Slider Inputs: perfect for calculators, scenario planning, simulations, and other decision support tools
• Download Data: include a nice download button for any query results

Bug Fixes & Updates

• Fix for sorting DropdownOptions
• Optional Title Slot for Accordions
• Respect Casing in Map Tooltips
• Fix Intermittent Prism Errors

• New Maps: create data driven maps which combine points of interest, choropleths, and custom tooltips. Use maps as inputs.
• Checkbox Input: for all your booleans
• Option to select all by default in multi-select dropdowns: default a multiselect to select all options (thanks @Christopher2K)

Bug Fixes & Updates

• Fit dropdowns to small lists of options
• Docs: Correct the reference to supported languages for syntax highlighting (thanks @emmanuel-ferdman)
• Fix BigValue downIsGood option
• Support for DuckDB 10.2

• Compact table option: reduce the padding inside your table to save space on your page with compact=true
• Additional date range presets: adds many preset date ranges to the DateRange component
• Page-level control to show/hide sidebar: adjust the sidebar appearance from your frontmatter (thanks @AyushAgrawal-A2)
• Add syntax highlighting to code blocks

Bug Fixes

• Fix DataTable error triggered by formatting a column of only nulls
• Make Sparklines reactive to changes in data
• Fix reactivity and data handling for ReferenceLine and ReferenceArea
• Fix behaviour of handleMissing when used with multiple y columns
• Fix Details component open option
• Add buttongroup overflow, add no scrollbar class
• DateRange loading state
• Misc Dropdown & Input fixes
• Fix DataTable width issue
• Add bottom margin on LinkButton (thanks @yashhhguptaaa)
• Fix DataTable pagination input box width overflow (thanks @AyushAgrawal-A2)

• Better error handling for DataTable: eliminates page-breaking errors caused by DataTable
• Calendar heatmap off by 1 error: fixes an issue where the calendar heatmap would shift results by one day
• Update deprecated data.query syntax used for stacked charts in example project
• Fix scrollbar appearing when hovering last chart on page

• Conditional formatting based on another column, formatting negatives red, and value formats from another column
• Support for 0 as a sidebar_position (thanks @Ayush Agrawal)
• Reduced package size

Bug Fixes

• Fixes a bug which was causing query errors in v33.0.0

• Dropdown multiple default values and noDefault option: pass an array of options to set multiple defaults for a dropdown
• HTML contentType for DataTable: now you can create fully custom cell content by using a Column with contentType=html, including things like text styling (bold, italic, etc.), custom symbols, or conditional display logic
• Allow JSON columns in postgres and duckdb: these will now return a string rather than an object
• Slugified anchors for TOC links: when you click on a link in the table of contents, the URL will show a “slugified” version of the heading rather than a number

Docs Updates

• The Evidence docs site has been refreshed and is now an Evidence project itself: Refreshed Docs

Bug Fixes

• Fix to allow comments at end of source queries
• Fix echarts options updating
• Fix to standardize results in postgres
• Maintain correct font sizing when applying styles to headers

• Custom Conditional Formats: Control for creating custom scales, and color breakpoints
• Column Groups and Header Wrapping: Adds support for grouping multiple columns, and wrapping headers

Bug Fixes & Other

• Lower Memory Consumption During Build
• New Loading Screen in Dev Mode
• Fix null handling in deltas
• Improved Printing for pages with Grid Components
• Avoid printing scrollbars in windows

• Linked tooltips on charts: Synchronize tooltips between charts
• Table Groups: Adds support for grouping, subtotals, and more colour options
• Standalone Delta Component: Delta component that can be used inline in text like Value
• Navigate months and years in DateRange: Quickly navigate across years and months in DateRange
• New select all option in the DropDown: Button to select in on multi-select DropDown
• Options for Embedded Layouts: Hide the header, sidebar, breadcrumbs, and table of contents. Perfect for embedded layouts.

Bug Fixes

• Fix map image downloads
• Fix scatter plot tooltip focus
• Fix for formatting null values

• Fullscreen DataTable: DataTable now includes a button to open it in fullscreen mode. You can find the button by hovering over a table
• Add default ButtonGroup selected item: Allows you to show a ButtonGroup option selected on page load
• Make query errors copyable: In the query viewer, you can now select error text and copy it. Long errors are also horizontally scrollable
• Upgrade many versions: Upgraded Evidence’s core dependencies, which bring some performance and memory usage improvements
• Small build optimizations: Improvements to project build times
• Move SDK into monorepo: First step in making the Evidence SDK available to the community
• Align inputs to left side of page: Minor spacing adjustment for input components
• Remove right margin from default layout header: Minor spacing adjustment for page header

Docs Updates

• Add plugin install instructions to gsheets docs

Bug Fixes

• Fix null number formatting:
• fix / right align dimension grid labels
• Fix loading process for data on initial page load
• Exclude page source code from pagesManifest
• Fix single row Value and BigValue regressions

• Suite of new input components: multi-select, date range, search in dropdown, and styling improvements to inputs
• Custom layouts and sidebar control: new default layout component with options for page width, custom logo, project name, hide sidebar, and more. You can also now sort pages in your sidebar using sidebar_position in frontmatter
• Dev-mode SQL console: run queries against the data in your app’s cache layer in development mode. Find it in the 3-dot menu at the top right of your project
• More informative dev mode errors: better feedback while developing, eliminating most page-crashing errors
• Improved background fetching and feedback on long running queries: new background loading process and loading notification for queries that take longer than 1 second to execute
• Revamped Accordion component: new design, improved accessibility, ability to open multiple accordion items at once
• Better axis sort control for Heatmap: new xSort and ySort options for Heatmap, plus ability to sort by other columns in your dataset
• Improved support for environment variables: now you can include a .env file in your Evidence project and any variables prefixed with EVIDENCE_ will be read into your project

Breaking Changes

• Reference syntax for Dropdowns
  • The syntax to access values from a Dropdown component has changed from ${inputs.my_query} to ${inputs.my_query.value}
  • This also allows you to access the labels of the Dropdown through ${inputs.my_query.label}

Bug fixes

• Fix bug which prevented searching sorted Datatables
• Correct sorting on numeric heatmap axis
• Fix bug which prevented navigation from the settings page

• Stand-alone Sparkline Component to display small, inline charts as part of a BigValue, or inline in text
• Add weightedMean Option for Row Totals to DataTable
• Upgrade DuckDB to 0.10.0 which brings support for attaching non DuckDB databases, better CSV reading, and improved memory management
• Allow Non-Delta Comparisons in BigValue so you can use the field below to show other comparisons

Bug Fixes

• SQL Console Crashes on Navigation

Docs Updates

• Architecture Diagram for Data Sources
• Chart Renderer and Series Level Customization

• Dimension Grid to display and filter data by multiple dimensions
• Print Format components to specify PDFs and printed page layouts
• Configurable empty state behavior for charts and tables (Thanks @gwenwindflower for the idea)
• Change chart renderer, specify series style by series names for more control over series colors and formatting
• Set dynamic scale on the Y-Axis - so you can change the scale on interactive charts
• Basic theme support with custom Tailwind config - to edit the core Evidence layout colors

Bug Fixes

• Filter interaction not triggering on parquet source
• Fix min and max props for negative values in heatmaps

Docs Updates

• Improve file queries docs (Thanks again @gwenwindflower)
• Improve CSV options docs (Thanks @DaveTomkinson)
• Fix DuckDB and SQLite locations (Thanks @andrejohansson)
• Environment Variables are case sensitive (Thanks @mmr-crexi)

• Heatmap
• CalendarHeatmap

Bug Fixes

• MySQL Closed Connection Issue
• Fix conditional formatting issue in DataTable
• Motherduck connections can specify the database

Docs Updates

• Plugin Authoring Docs
• Docs Note: env vars are case sensitive

• Build-time Variables for Sources so you can pass parameters to source queries to get different deployment data
• Preview Command to preview a build locally with npm run preview
• Multi Axis Support in Line and Bar Chart
• DataTable Total Rows and Custom Conditional Formatting which allows you to specify the colour scale
• Grid Layout brought across from Evidence Labs so you can make more dashboardy layouts
• US Map Enhancements to add Hawaii and Alaska, a legend, and custom color palettes
• More Uses Download Names for data and image downloads

Bug Fixes

• Query Viewer Order when Columns have Numeric Titles
• SSL Config for Postgres in Prod
• Type Information Alignment with USQL
• Better Chart Error Messages
• ChartAreaHeight Issue
• Handle Fully Null Boolean Columns
• Sankey Diagram Updated to add Library Features

Docs Updates

• How to npm run sources on a Subset of Sources
• Clearer Guidance on Chart Sorting
• Typo: ‘buil-in’ to ‘built-in’ (Thanks @srenatus)

• Set X-Range on ScatterPlot (Thanks @ycaffee)
• Explore the Tables and Columns in your Data Sources in dev mode from /explore/schema
• Pass Through read_csv() Options so you can specify how to import CSV data
• SQL File Queries now Rerun Automatically without hard reloading the page after edits

Bug Fixes

• Allow Postgres to Connect using SSL ‘no-verify’
• Prevent MySQL Closing Prematurely
• Combine Duplicated SankeyDiagram and SankeyChart
• Allow Databricks Connector in USQL
• Allow Trino Connector in USQL

Docs and Guides

• Custom Data Source Plugins Template that you can fork to create your own data source

• Button Group: component to give easily selectable options from a short list.
• Text Input: allowing free-text filtering of data
• Dropdown defaultValue option: allowing pre-selecting a specific option on page load.

Bug Fix

• Allow MotherDuck connections to be configured via the UI

This is a large release containing significant Breaking Changes and major new features. If you haven’t seen it already, here’s a recording of our recent community call discussing these changes.

We will continue to support legacy Evidence projects, and publish bug fixes for those earlier versions for some time.

New Features

• Evidence Query Engine: fast query engine powered by DuckDB WASM included in every project
• Inputs and filters in pure SQL: using query parameters, e.g. where month='${input.selected_month}'
• Dropdown component: allowing end users to pick parameters - the first input component with more coming soon
• Multiple data sources: query and join data from multiple databases, flat files and / or other third party data sources
• Pluggable connectors and components: easily add your own custom sources

Docs & Guides

• New docs site for Universal SQL is live at docs.evidence.dev
• Legacy docs site accessible at legacy.docs.evidence.dev
• Migration guide - to assist with migrating your existing legacy Evidence project, and changing deprecated syntax
• VSCode migration script: to migrate legacy projects to USQL

• Fine-Control of Evidence Charts: using the new echartsOptions property to adjust any eCharts options.
• Fuzzy Search for DataTable: so you can search across multiple fields, and similar keywords
• Long Horizontal Charts: are now denser and more consistent

Docs

• Cube.js is now supported: using their Postgres SQL API

Bugs

• Fix visual regressions in DataTable causing links to not be highlighted
• Templated pages now no longer require an index.md page
• Very long charts render correctly

• Layout Update with a fresh new feel
• Latest DuckDB Support, upgrading to v0.9.1
• Customize the Color Palette of your Evidence charts
• Value Labels for Bar, Line and Area charts
• Dual Axes for Line charts
• Log Axes for Line, Scatter, Bubble, Area and Bar charts
• BoxPlot Chart for showing data distribution
• Funnel Chart Percent labels
• More Readable Query Logs printed to the terminal

Docs

• Snowflake columns are lowercased (thanks @DArtagan)
• Update how to add filter syntax
• Add docs on multi-layer sankey data format (thanks @nattaylor)
• Mac-friendly VSCode install instructions

Bugs

• Render null labels in DataTable link columns correctly
• Fix VSCode Browser Links

• New Trino Connector which, among other things, allows multiple db connections (thanks @maxstreese)
• New Databricks Connector

Bugs

• Fix y-axis labels being truncated on horizontal bar charts

Custom SvelteKit Configs: are now enabled, and will overwrite the Evidence defaults.

Bugs

• Fix Bar Chart issue that caused pages to lock

Docs

• Added missing SQL Server env vars

• Markdown partials to reuse markdown fragments in different pages
• Table delta content type for DataTables
• Conditional formatting for DataTables
• Stepped Line Chart & Area Chart property (Thanks @commitsovercoffee)
• Alias for Value component’s column property, value to match other components
• Improved Details component with new styling and open prop
• Improved Tabs component styling (Thanks @commitsovercoffee)
• Column component reactivity to prop changes (Thanks @jdimmerman)

Bugs

• Sankey chart animation duration (Thanks @commitsovercoffee)
• Format Reference Line value based on axis
• Templated pages not built for long Data Tables

Docs

• Add helper note for connection panel
• Update environment variables in deployment panel

• MotherDuck: Connect to MotherDuck with Evidence
• Details: Component to display collapsible content which is hidden by default

Bug Fixes

• BigValue format tag error on data update
• Table sort for NaN, null and undefined values

Docs

• Netlify templated pages issues
• MotherDuck service token guide

• DuckDB 0.8.1: Evidence now supports DuckDB v0.8.1
• Modal: Popup component to display content on top of the page (Thanks @nidhi-kala)
• Accordion: Component to display collapsible content (Thanks @nidhi-kala)

Evidence Labs

• Leaflet Map: Experimental map component that uses Leaflet.js to render a map with a set of points

• Number and date formatting now available within components
  • Use format props like fmt in Value and xFmt/yFmt in charts
  • Accepts Excel-style format codes, Evidence built-in format tags, or custom format tags
  • Full list of built-in formats here
• fmt function now accepts the same formats as format props. Example: { fmt(value, #,##0€) }
• VS Code Slash Commands: type / in VS Code to see a list of available components and markdown syntax you can insert into your page (Evidence VS Code extension v1.3.4)
• Auto-import custom components: you no longer need to use a script tag to import custom components
• Reduce size of builds for template pages: removes redundant data files during build for templated pages, which should significantly speed builds up
• Upgraded & standardized icons: makes icons more consistent across Evidence and makes it easier for contributors to find and use icons

Bug Fixes

• Code block spacing fix - 🙏🏼 @lorinaX!
• Grouped bar chart fix
• Fix for hot module reloading
• Breadcrumb and BigValue visual fixes
• Fix for sources folder in template

Evidence Labs

• New experimental components added
  • WorldMap
  • Cohort Analysis
  • Summarizer
  • GitHub Stars
  • Google Sheet Embed
  • PDF Embed
  • Footnote
  • Grid

• Specify Schema and Role in Snowflake: Allows you to add optional role and schema fields for all queries.
• VSCode Extension Updates (v1.2.0)
  • Install and use Evidence from VSCode: without touching the command line
  • Keyboard Shortcuts: Ctrl+(Shift)+R to start (stop) Evidence
  • Prompt to Install Node: if you don’t have it installed
  • Evidence Opens to the Side: by default
  • Extension Walkthrough: to show you around

Bug Fixes

• UI issues with Breadcrumbs and Big Value
• Multiple Queries Running on Startup

• Component Plugins: allow you to add third party components to your Evidence project.
• Evidence Labs: is a demo plugin we’ve created to show how plugins work, and includes a new France Map component.
• New ways to Connect to BigQuery & Snowflake: including key-pair, OAuth, External Browser connections and the gCloud CLI.
• Deprecated Environment Variables: to prevent name collisions between certain variables. You might notice warnings with your existing configurations, check the settings page of your Evidence app for the updated environment variable options.
• Customise Area Chart Line Color: with the lineColor prop to help make your lines pop.
• Wrap Text in DataTable: for when your fields are extra long.

The latest version of the Evidence VS Code extension includes:

• Lightning Fast New Evidence project Command: to create a project
• Auto-Connect: to the included DuckDB packaged with the extension
• Detects and Activates the Extension: when you open an Evidence project
• Auto-Boot: Evidence in the browser when you open an Evidence (or turn this off in the settings)
• Configure Default Port: for Evidence to run on

and more! (🙏🏼 @RandomFractals)

• Upgraded VSCode Extension: Adding in-built commands to create a new project, start/stop the dev server, run builds, clear the query cache and more (🙏🏼 @RandomFractals)

• Support for DuckDB 0.8.0: if you get an error about your DuckDB database being outdated, follow the instructions in the error message to upgrade.

A lot of new functionality coming out today!

• Annotations: using the new ReferenceLine and ReferenceArea components add custom highlighting, show targets and thresholds.
• Format function: to format numbers used outside of Evidence components.
• Adjust Chart Heights: using chartAreaHeight prop on Bar, Line, Area, Scatter, and Bubble charts.
• SQL Server connector: awaited by the Microsoft users out there.
• Click handler for Echarts: to allow custom actions on chart click. (Thanks @jjagielka)

Bug Fixes

• Error icon in value component (Thanks @nidhi-kala)
• Chart width on PDF export
• Collapsible section dropdown’s transition animation
• Component copy-paste in Firefox
• Update DataTable paginated property when dataset size changes (Thanks @jdimmerman)

We’ve released a few fixes the community identified recently with the latest release

• CSV connector: should now work without any hacks.
• BigQuery Wide Numeric Type: columns should appear properly in Evidence now
• Design and Styles:
  • Added back some list styling which got dropped in the last version
  • Windows bugs with the query viewer have been resolved
    • Horizontal Scroll bars when queries are hidden
    • Data disappearing when scrolling horizontally in query viewer
  • Funnel Chart tweaked to be more legible

• Standalone .sql Files: great for when you need the same query in multiple pages in your app
• Markdown Frontmatter Support: which allows you to specify page metadata (for social previews and unfurls), as well as which queries to import
• Alert Component: for when you need a reader to really pay attention.
• Tabs Component: allows you to show different information in user-selectable panels

Bug Fixes

• Visual regressions with sizing and positioning
• Auto close settings menu when you click outside it

This release includes breaking changes, as we upgrade to SvelteKit 1.0. Node 14 is no longer supported, use Node >= 16.

• Upgrade DuckDB to 0.7.1: The most recent DuckDB file format is now supported (🙏 @gregwdata)
• Display Non-SQL Code Blocks: (Non-executable) code blocks will now display if you use the name of the language for the code fence.
• Sankey Diagram: Added (🙏 @nidhi-kala)
• Upgrade SvelteKit to 1.0: This unlocks lots of cool new features for the future, stay tuned! (🙏 @csjh)
  • Custom SvelteKit syntax and custom layout files may need to be renamed if you use them.

• Fix for sources directory (CSV connector): eliminates an error and unexpected behaviour that occurs when a sources directory is added to a project
• Fix breadcrumb capitalization: some words were not being capitalized in breadcrumbs

• CSV Support: new connector that lets you query CSV files directly in your SQL (using duckdb under the hood!)

• Fixes for DataTable:

  • Value formatting: fixes unit summaries in DataTable (e.g., 12,000 ---> 12k)
  • Download button fixes: download button was not appearing in tables without pagination; downloadable prop now works in all scenarios (turn on or off download ability for your users)

• Testing & dev process improvements in our core open source repo:

  • Playwright implemented in the core Evidence repo: the start of our UI test suite for our open source repo
  • “Next” package: new features and fixes now get released under a “next” package before they’re released to everyone

• Fail builds on error: new option to fail builds when there are errors in components or queries -️ US state map + Map links: choropleth map component for US states, includes feature to click on a state and have it follow a link
• Minimal Venn diagram: 3-circle venn diagram with ability to label each dataset/overlaps -️ Column error handling in DataTable: gives an inline error when column references are missing -️ Funnel chart upgrades: adds legend, labels, and modifies the height of funnel charts (🙏 @nidhi-kala)
• Bug Fixes
  • Enable various MySQL SSL options (🙏 @hooopo)
  • Fix table of contents links for parameterized pages

• Table Images & Links: Include images and clickable links in your tables, for both internal navigation and to external sites.
• Table Sort, Search and Customization Options: as well as better control of how data is displayed in your table
• Project Styles & Themes: Edit the colors, fonts, and page layout of your Evidence project with the app.css and __layout.svelte files.
• Bug Fixes
  • Fix null labels in chart legends and tooltips
  • Remove header bar from print view
  • CSS leaking from settings page to other pages

• Revamped DataTable: with better defaults, and more customization options.
• Bug Fixes:
  • Redundant queries executed when building parameterized pages

• Improved Visual Hierarchy: of H1-H6 and lists to separate content more clearly -️ Multi Environment Support: so you can use dev data when developing reports in Evidence. -️ Funnel Chart: component added (🙏🏼 @dhrjarun)
• Scroll Support on Query Viewer (🙏🏼 @afzalsayed96) -️ Improved Accessibility: of our UI components (🙏🏼 @yukseltron) -️ Download Data from Charts: so users can export chart data to wherever they need it (🙏🏼 @yukseltron)
• Optional Postgres Schema Field: which makes using data environments separated by schema easier
• Turn Off Default Chart Sort: which users were finding confusing (Bar, Line, Area)
• Bug Fixes
  • Reactivity for 100% stacked charts

• DuckDB Connector: so you can use the “SQLite for Analytics”. (🙏🏼 @jwills, @mause)
• Bug Fixes:
  • Hardcoded number of rows in DataTable
  • Erroneous console logs

• Styled Blockquotes: so you can add emphasis to quotes and text.
• Faster Install on Mac Silicon: with an upgrade to SQLite. -️ Better Contributor Experience: with automated testing, a clearer contributing guide, and simpler install experience.
• Docs Updates
  • How to reference queries (🙏🏼 @roveo)
  • Using parameterized pages
  • Inserting images and static files
• Bug Fixes
  • Unclickable Breadcrumbs
  • Charts stretching too wide (🙏🏼 @afzalsayed96)
  • Parameterized pages showing up in sidebar (🙏🏼 @quoid)

• Custom chart examples: showing how to create custom charts outside the core Evidence library.
• More intuitive custom components: organized in /components/, with better docs.
• Better date parsing and handling in components: so you can always get the date format just right. -️ Redshift connector in UI: no more guessing using Postgres settings.
• Bug Fixes: To Remove breadcrumb links to non-existent pages, Stop format tags applying to strings and Ensure charts copy nicely.

• Native markdown table formatting: to make your tables look slick. Plus a VSCode shortcut to speed up markdown tables - try typing table. -️ Updated Evidence diagram: explaining more clearly what Evidence does.
• Titles for tooltips: for Scatter Plots and Bubble Charts.
• Tutorial in new projects: which shows when run for the first time - it’s optional and less than 5 mins.
• Bug fixes: For time-based bar charts and boolean appearance in tables.

A lot of users have styled some version of this into their projects using CSS, but the new <BigValue/> offers a lot more than just styling.

• BigValue includes support for colour coded comparison, and a sparkline. They look great on their own, or arranged in a set.

Users told us our mobile experience could be improved, so we’ve reworked it.

• Top-right hamburger menu: Access all the pages in your Evidence project on mobile using the hamburger
• Fewer bugs: We’ve introduced end-to-end tests which means we catch bugs before we release them!

-️ Format tags: covering a wide range of dates / times, many major currencies, numbers and percentages

• Auto formats tags: which infer the number of decimal places and units (k, M, B) to display based on the input numbers
• Custom formats: if you can’t find what you need in our standard tags, you can make any format supported by excel format strings eg ”$” ##0,000, “k”
• Static folder: so you can add images and other static files to your project

• Improved chart tooltips: cleaner-looking tooltips with formatted titles and numbers
• Type system: all data types from our supported data warehouses now map cleanly to Evidence’s 4 data types: string, number, date, and boolean
• See column types in query viewer table: below each column name, you can now see the data type for each column in your query -️ Formatted data in query viewer tables: when looking at your data in a query viewer, you’ll now see formatted data based on the format tags you include in your query (e.g., _usd)
• Bug Fixes: Changing names of queries caused errors, Missing .gitignore file caused errors when setting up SQLite

• More intuitive query data syntax: before {data.my_query} , after {my_query}
  -️ Updated Snowflake connector: so everything you need is now in the settings menu
• Copy-Paste “just works”: just Ctrl-C, Ctrl-V to get Evidence images and text to documents and emails
• No false untitled query warnings: squashing a bug where ghost queries were being detected

• Fixed sorting issues: queries results now always sort as specified in your SQL
• Auto-open a browser tab: when you npm run dev
  -️ VSCode Extension shortcuts improved: cmd-shift-V/cmd-K V to open Markdown Preview mode
• Evidence has a new demo project! Check out how business is going for Needful Things Inc.

This release makes it easier to share your Evidence project outside Evidence.

• Component download options: Download DataTables and query results as CSVs, save charts to PNG
• Export to PDF: Save reports to PDF from each Evidence page
• Telemetry opt-out: We record anonymous data to help us figure out when things are broken, and count the number of Evidence projects. If you’d rather we didn’t, you can now easily turn this off in the settings menu

• Deploy to Vercel: Added to settings panel
• Persistent show/hide of SQL and query results: Rather than expanding queries after each page refresh - Evidence will now remember the state before reload.
  -️ Pass Evidence command line arguments to Svelte-kit: Allows configuring Svelte-kit options from the command line. E.g. to change the port Evidence runs on, use npm run dev -- --port 4000

Users told us they wanted a simpler project structure and easier options to connect to their databases and deploy.

This release revamps the UI, strips back the project structure, adds UI options for connection and deployment. Read the PR in Github.

• Simplified Evidence project structure - fewer confusing files cluttering your project directory
• UI refresh - auto-generated sidebar nav, better errors and breadcrumbs
• Slick database connections - now just use the settings menu in your Evidence project
• Deploy straight from Evidence - get your Evidence project online from the settings menu
• Updated, easier tutorial - a faster, funner start to using Evidence