0.33.0 (2022-03-10)
0.32.4 (2022-03-10)
0.32.3 (2022-03-09)
0.32.2 (2022-03-09)
0.32.1 (2022-03-08)
0.32.0 (2022-03-08)
0.31.6 (2022-03-08)
0.31.5 (2022-03-08)
0.31.4 (2022-03-08)
0.31.3 (2022-03-08)
0.31.2 (2022-03-08)
0.31.1 (2022-03-08)
0.31.0 (2022-03-04)
0.30.4 (2022-03-04)
0.30.3 (2022-03-04)
0.30.2 (2022-03-04)
0.30.1 (2022-03-03)
0.30.0 (2022-03-03)
- add chart value labels (#1485) (d5c3f2b)
- charts: allow all field types to be applied to both axis and pivoting skip ci (ef0a037)
- charts: option to rename chart axes skip ci (13e9633)
0.29.4 (2022-03-03)
0.29.3 (2022-03-02)
0.29.2 (2022-03-02)
0.29.1 (2022-03-01)
0.29.0 (2022-02-28)
0.28.2 (2022-02-28)
- filters: add min value to input instead of 'or' operator (#1462) (fb144a9)
- filters: filter by null [skip ci] (#1459) (64b4a51)
- use dbt target-path value skip ci (8f14534)
0.28.1 (2022-02-25)
0.28.0 (2022-02-25)
0.27.3 (2022-02-23)
0.27.2 (2022-02-23)
0.27.1 (2022-02-22)
0.27.0 (2022-02-22)
- add filter from table cells and headers [skip ci] (#1350) (398bbd2)
- filters: add suggestions for string filters (#1419) (a443a64)
0.26.0 (2022-02-21)
- bump dbt version (#1430) (1698cdf)
- dashboard filter error causing blank page [skip ci] (#1432) (c569fc4)
0.25.0 (2022-02-18)
0.24.1 (2022-02-18)
0.24.0 (2022-02-17)
0.23.0 (2022-02-16)
- add azure devops option for dbt projects (#1404) (3646154)
- add host domain for github enterprise connections (#1402) (9258f7a)
0.22.0 (2022-02-16)
0.21.0 (2022-02-16)
0.20.2 (2022-02-15)
0.20.1 (2022-02-15)
0.20.0 (2022-02-15)
0.19.4 (2022-02-15)
- dashboards: disable dashboard filters when in edit mode (#1382) (42ff26e)
- settings: amend allowed email domains input [skip ci] (#1383) (c3a6289)
0.19.3 (2022-02-15)
0.19.2 (2022-02-14)
0.19.1 (2022-02-14)
0.19.0 (2022-02-14)
0.18.3 (2022-02-14)
0.18.2 (2022-02-14)
0.18.1 (2022-02-11)
0.18.0 (2022-02-10)
0.17.1 (2022-02-10)
0.17.0 (2022-02-10)
0.16.0 (2022-02-10)
0.15.0 (2022-02-09)
- add endpoint to fetch available filters [skip ci] (#1313) (bf100d7)
- add liveness check to api (#1319) (b5caaae)
- completed unit of time in filter (#1304) (0480459)
0.14.0 (2022-02-08)
0.13.0 (2022-02-08)
- fatal error when results are empty (#1302) (10568b2)
- lower case field names (#1298) (cb4130c), closes #1278
- #186: add metric filters (#1271) (df3e5dc), closes #186
- #205: add in the past filter (#1290) (08c97dc), closes #205
- #940: add big number visualisation (#1264) (29765bb), closes #940
- Added new 'table' chart type
- Minor UI changes in the explore view
- Categorical charts now include a new tooltip showing category names
- Fixed bug with generated SQL for string filters
- Filters can now be added from the sidebar (#1260)
- Added auto complete to filters (#1263)
- Added ssl "no-verify" option for postgres and redshift connections (#1253)
- Fixed deployments with local dbt project (#1258)
- The column title within the results table now displays a tooltip with the metric/dimension description (#1136)
- Show message for the user to know that their project most be compatible with dbt v1 (#1043)
- Filtering and search are now available in the tables side bar (#817 #997)
- Use Google SSO to set up initial user (#1149)
- Invited users can create an account with Google SSO (#1148)
- Social authentications can now be revoked (#1152)
- Organisation basic roles and permissions are now available (#1069)
- Option to have email domain validation (#1221)
- Added option to disable password authentication (#1234)
- Allow user to revoke Google auth (#1232)
- Update table icons to avoid confusion (#1182)
- Api request validation not working (#619)
- Removes site url warning in dev mode (#1189)
- Get columns from all snowflake databases and schemas(#1223, #1127)
- Fixed fatal error when trying to connect a project (#1168)
- Adds the
SITE_URLenvironment variable used to configure all links in the app (#1118) - We now have a warning when a user connects via mobile devices (#1110)
- We now collect the user job title (#1120)
- You can now login with your Google account (#1140)
- Users can now reset forgotten passwords (#1119)
- Adds
PGMINCONNECTIONSandPGMAXCONNECTIONSenvironment variable to customize pg pool size (#1157)
- Move save chart buttons to the chart section (#1141)
- Align latest saved chart names (#1137)
- Fixed support for type NUMBER() and VARCHAR() in snowflake (#1144)
- Apply custom labels to time interval dimensions (#1146)
- Charts will resize with the screen (#1142)
- Add field validation to project form (#1145)
- Added support for custom labels for explores/model, metrics and dimensions (#1061)
- Added support for dbt metric label (#1061)
- Replaced dbt-spark[ODBC] adapter with dbt-databricks (#1104)
- Fix redshift connections to work with any ssl mode (#1057)
- Fix connection to databricks during dbt compile (#1104)
- Remove quotation from time interval sql for bigquery (#1063)
- Use datetime_trunc instead of date_trunc for timestamps in bigquery (#1059)
- Stop project from compiling multiple times (#1060)
- Fix docker compose yml version (#1052)
- Be able to turn off the time interval dimensions (#1044)
- Changed the git clone process to only clone the dbt directory (#1038)
- Set time interval dimensions by default (#1044)
- Add support for BitBucket (#1026)
- Improved messages and invalid states in explore page (#1008)
- Temporary script to replace user passwords (#1017)
- Add support widget (#987)
- Replaced timestamp default time interval 'millisecond' for 'raw' (#1036)
- Fix sql join logic to include tables from filtered dimensions (#1036)
- Refresh explore dimensions and metrics after project compiles (#991)
- Fix chart when grouping by boolean dimension (#992)
- Fix dashboard page to be full width again (#993)
- You can edit the saved chart name from the explore page (#978)
- Added footer to all pages (#981)
- Add correct state when sql runner has an error (#974)
- Fix latest saved charts to be full width (#971)
- Docker containers created via the install script can now be restarted via docker (#973)
- Metrics defined under the
metrics:tag in dbt projects are imported to Lightdash (#926)
- Lightdash projects must be compatible with dbt version 1.0.0 (#926)
- Saved charts in homepage are ordered by the most recently updated first (#956)
- Improved loading states throughout the app (#967)
- Added a home page where we display a few onboarding steps and the latest dashboards and saved charts in you organisation (#949)
- Added a logger that provides more detailed logs and stores them in local files (#943)
- Support self hosted gitlab repositories (#931)
- Log unhandled rejections and uncaught exceptions (#930)
- Fix unhandled errors & improve error messages (#919 #923 #925)
- Show how long ago the dashboard data was refreshed (#885)
- You can now configure what date and time intervals you want for your dimensions (#895)
- We now only join tables if the user selected fields from them (#905)
- Fix bug where the user could not pass the login page (#881)
- Fix bug where ran a query without dimensions or metrics (#876)
- Improved performance in the dashboard page (#875)
- Dashboards now have a distinct view and edit mode
- You can now add text and images to your dashboards using markdown tiles
- You can now add loom videos to your dashboards using loom tiles
- Ability to rename a dashboard from the dashboard page
- Ability to add a chart to a dashboard from the explore page
- Show base table at the top of the sidebar (#830)
- Fix bug where tables in the SQL runner page would overflow (#827)
- Fix bug where tables and results wouldn't refresh after updating the project connections (#828)
- Other small UI fixes (#823 #826 #829 #831 #832 #835 #837 #838 #839)
- We now provide example metrics for those tables that you haven't defined any metrics (#794)
- You can pick the dbt models you want to appear as tables in Lightdash (#811)
- Project settings can be access from the explore menu (#774)
- You can now click through from a chart on a dashboard tile to the edit view for that chart (#785)
- Compile times are now faster: (#805)
- Various improvements to developer experience: (#793), (#800)
- Lightdash will now use a dbt profile name of
prodby default (#802)
- Fix chart config where it was possible to remove the only line on a chart (#722)
- Various UI improvements (#778), (#776), (#787), (#788), (#806)
- Fixed a bug where the url would not change when changing explores (#779)
- Fixed a bug where the sidebar would shrink for large sets of results in the explorer (#784), (#795)
- Results tables with many columns are now horizontally scrollable rather than overflowing the display (#783)
lightdash.ymlfiles are now valid without any projects defined (#733)
- Users may no longer specify Lightdash projects in their
lightdash.ymlproject (#792)
- You can now run raw SQL queries using the SQL Runner and visualise the results as a table
- Added support for Databricks
- Fixed bug in time series charts using multiple series
- Projects connecting to dbt cloud are no longer available through the UI
- Charts can now be exported as an eCharts JSON definition
- Fixed error where dbt projects using version 0.21.0 would have missing joins
- Lightdash requires dbt version 0.21.0 or higher
- Time-series charts fixed to show all values at the correct point in time
- Authorising with Google Cloud OAuth is no longer possible with local dbt projects
- Warehouse credentials are now required
- We now fetch the catalog directly from the warehouse instead of dbt
- Small UI/UX improvements
- Fixed error message when dbt cloud IDE is not open
- Fixed postgres adapter reliability by using a pool connection
- Fixed error when fetching null dates from Bigquery
- Added dashboards - users can now create, edit and delete dashboards
- Navigation bar was rearranged. Saved charts and dashboards can be accessed under the "Browse" menu item
- When warehouse credentials are provided, we will run sql queries by connecting directly with warehouse instead via rpc server
- Fixed a bug where references in table calculations were not wrapped in quotes
- Fixed a bug where pressing "enter" in the login form would not submit form
- Lightdash projects that connect to a remote dbt rpc server are no longer supported
- Add "does not include" in stringfilter
- Sort data immediately when clicking on column header
- Fixed a bug where we had the local dbt option when connecting a project in Cloud and Heroku deployments
- Fixed the snowflake connection form
- show warning message for postgres or redshift users
- filter dimensions and metrics by active fields in table calculation
- exclude test files from build
- show name of the saved chart in the explorer
- Add ability to filter fields of boolean type
- Data will be sorted by default. Priority: date/time dimension -> first metric`` -> first dimension
- Table calculation names no longer support special characters
- Fixed a bug where chart config would reset after running a query
- Fixed a bug in the chart where we could only select 1 metric when we were grouping by dimension
- Added an installation script
- Fixed a bug where creating projects in the UI would fail for local/github/gitlab projects
- We now redirect the user to the login page after cookie expires
- Added a welcome page
- Your dbt connection settings can now be updated in the Lightdash UI
- Onboarding flow asks for a project with a valid dbt & warehouse connection instead of relying on lightdash.yml and profiles.yml
- Fixed request that shows the sql query
- Fixed a bug where the chart wouldn't clear when leaving the explore page
- Fixed a bug where the explore menu button wasn't redirecting
- Fix seed data for our demo page
- Users can see the dbt connection details and edit the warehouse connection in the UI
- Explores are compiled individually. If an error happens in a single explores, all other explores will still be available in the UI
- Explores will not compile if the type of a dimension cannot be determined (uses target warehouse schema). Previously they defaulted to string types.
- Fixed a bug in the query builder that affected all target databases not using double quotes.
- Gitlab connector is now available. Connect your Lightdash project to a dbt project hosted on gitlab.
- Fixed a bug with missing quotes in order by clause (fixed errors with snowflake)
- Fixed bug with wrong quote strings for dbt's athena adapter
- Fixed bug where optional project configs set via env where not recognised
- Add local state to track and update query parameters changes without affecting the current query data
- Url Parameters are now updated only when the query is run
- Users can reorder the result table columns
- Add dbt profile target option in lightdash project config
- Add table calculations to your results table. Table calculations allow you to combine columns together in your results. For example, adding together two metrics to make a third or compute a running total. Table calculations are written using raw sql.
- Fixed error drawer from opening on each query change
- Fixed issue where chart label would be partially cut off
- Fixed issue where saving a chart would run the query and expand the chart section
- Users can create and revoke invite links
- Users can create new accounts using invite link
- Show list of users in the organization
- Allow deleting users in the organization
- Fixed boolean value formatter to show yes/no values correctly.
- Fixed chart dimensions formatting issues, should format date and boolean correctly now
- Fixed sort behaviour where removing a field would not remove it from the list of sort fields
- Fixed bug where tables, metrics, and dimensions were ordered randomly (now alphabetical)
- Fixed bugs with filters when selecting multiple filters on the same column
- dbt errors now show in a permanent error inbox making it easier to search through long error messages
- Fix bug where errors messages would disappear quickly
- Fix bug where sidebar and errors would not update after a dbt refresh
- Fix bug where links in error messages were not clickable
- Projects can now connect to github. Pull your dbt project files straight from a public or private github repository.
- Fix bug where models with missing schema.yml entries would stop Lightdash projects from compiling
- Allow user to save queries
- Can specify database connection using a URI (including unix sockets or
postgresql://schemes)
- Environment variables for database connections have changed names
- Filter date value doesn't match the date value in the url
- Add login and register pages
- Allow user to edit their profile, password and organization name
- Save user sessions in DB instead of memory
- Allow configuration for secure self-deploys
- Fix bug where refresh would not detect file changes in local deployments
- Fix bug where database errors would not show in the UI
- Add date filters
- Integration with dbt cloud IDE. Lightdash can now connect to your development environment on https://cloud.getdbt.com
- Add help button in footer
- Lightdash requires your dbt project to use dbt version 0.20.0 or higher
- Allow users to download the chart as JPEG, PNG, SVG, PDF
- Fix bug where environment variables for lightdash.yml where ignored
- Fix error where quote characters in generated sql strings were incorrectly determined for some unofficial dbt adapters
- Fix bug where the dbt child process handler couldn't handle event with multiple logs
- Add options menu for each table/dimension/metric
- Add dialog with the relative file path and code relevant for each table/dimension/metric
- Add footer with Lightdash version
- Add Lightdash about dialog
- Warn user when there is a new version available
- Add non-aggregate metric types and support metric references in sql
- Moved lightdash configuration to a
lightdash.yml, replacing environment variables
- UI bug where the search box in the sidebar was cutoff
- UI bug input fields overlapping at filterblock if used more than one
- UI Intraction sidebar menu hierarchy makes it hard to read
- UI bug where small scroll flicker happens while configure charts
- UI bug where the metric description was concatenating the dimension description instead of the dimension name
- Show specific error when GCP credentials are missing instead of timeout
- lineage graph can now be toggled to show the entire lineage of a table or just it's direct dependencies
- improve table tree to show join details
- dimension and metrics are compiled on "dbt refresh" surfacing errors in the UI
- bug where we could group the only dimension available making the chart inaccessible
- only show scroll bar in sidebar when content is scrollable
- Stick sidebar on top left
- The stuck problem with scrollbar that shows only limited content on overflow
- Errors in
metatags (such as invalid references to other dimensions) no longer crash the server and errors are shown in the UI
- bug where long lists of table were not scrollable in the side bar
- improved chart UI when there isn't enough data to create a chart
- table lineage visualisation showing the source and dependent tables for each table in the UI
- documentation to deploy Lightdash to production (GCP Cloud Run)
- added rudderstack analytics, which is off by default, allowing you to send analytics data to any rudderstack server of your choice
- bug where rudderstack analytics was active by default for the documentation site
- plot multiple metrics
- select which dimension to show on x-axis or group by
- fixed problem where charts would change when preparing a new query
- bug in the UI where the refresh button was disabled
- improved error messages in the UI when dbt fails
- improved docs for dbt failures, most common are profile and project misconfigurations
- error where the server would crash when dbt fails
- increased timeouts while waiting for larger dbt projects to compile
- CSV export feature for table of results
- app url is shareable and can be used to share your current work (active table, columns, sorts, filters, limit)
- user is prompted to confirm before losing work (starting to explore a new table)
- dbt refreshes happen in the background whenever possible
- better messages when query results are empty or haven't been run
- all api routes have been prefixed with
/api/v1 - updated site metadata and favicon
- currently active fields aren't removed on changing tables
- currently active fields aren't removed on refreshing tables
- renamed "Measures" to "Metrics" everywhere
- navigating the sidebar won't discard your current table explore
- multisort not supported (using shift click on column titles)
- fixed problem where error messages wouldn't appear
- fixed problem where app would be stuck in loading state
- fix issue with postgres backends where fields were quoted with backticks
- fix issue where failed sql queries didn't show details in the UI
- fix queries using models with 2 or more joined tables
- fix production docker container
- metric and dimension definitions in dbt
- automatic dimension creation
- sql generation
- simple charts
- multi-dimension sorts in table view