Releases: dekart-xyz/dekart
v0.17.0
License Update
Open source project was changed to AGPL-3.0.
If you need modify Dekart without publishing your changes open-source (as required by AGPL-3.0), commercial license is available. Please contact us at support@dekart.xyz
Feature Highlights
New logo and header refresh
New report sharing dialog
Breaking change: From now, private reports will not be visible to other users by default. View permission must be explicitly set.
Snowflake temp query result storage support
Now you can set DEKART_STORAGE=SNOWFLAKE. Data will be cached in Snowflake temp query storage for 24 hours. After cache expires, query will re-run on next map visit.
Other features
- BigQuery connection project selector
- Dekart works correctly when user is logged into multiple Google Accounts
- Security updates by @delfrrr in #197
Fixes
Contributors
Assets 2
v0.16.0
Feature Highlights
Collaborate better on Reports
Empower teamwork with our new editing and refresh features for shared reports. Now, every user can refresh data with a simple click, ensuring everyone has the latest insights at their fingertips. Plus, grant editing access to trusted colleagues to foster a truly collaborative environment.
Query data from Postgres database
Thanks to @Tsovak contribution you now can configure Dekart to query PostgreSQL! PostgreSQL, when paired with the PostGIS extension, becomes an incredibly powerful database for managing and querying geospatial data due to its ability to efficiently store, index, and perform complex spatial queries.
Manage connections (BigQuery)
Dekart now introduces dedicated space, which allows you to seamlessly configure and manage connections, streamlining your workflow and enhancing your data interaction experience.
What's Changed
Features
- User icon with logout and switch user buttons (Google OAuth only) by @delfrrr #147
- Refresh Button by @delfrrr in #153
- Report data updated label by @delfrrr in #154
- Shared Connections by @delfrrr in #155
- Postgres datasource support by @Tsovak in #156
- Allow edit reports by @delfrrr in #159
- Acceess error info by @delfrrr in #161
- Ux improvements by @delfrrr in #162
Dev
- Support dev email for Google OAuth flow by @delfrrr in #148
- User refresh token for development with Google OAuth by @delfrrr in #149
Fixes
- Fix storage connection test by @delfrrr in #150
- Fix auth error infinite loop by @delfrrr in #151
- Fix header aligments by @delfrrr in #152
- Fix playground 500 by @delfrrr in #160
Links
Upgrade from previous version
Documentation
Dekart Cloud ✨
Contributors
Assets 2
v0.15.0
Features
Pass-through authentication with Google OAuth 2.0 Flow
No Google Service account required any more!
This feature allows Dekart to authorize users via Google OAuth 2.0 and pass user-specific tokens to access BigQuery and Cloud Storage. No more need for a universal service account or setting GOOGLE_APPLICATION_CREDENTIALS! Plus, all tokens are stored only in your browser memory, offering an additional layer of security.
Required User Permissions:
- BigQuery Data Viewer
- BigQuery Job User
- BigQuery Read Session User
- Storage Object User
Note: This feature is currently only supported for BigQuery and Cloud Storage data sources.
How to enable?
Set these environment variables to get started:
DEKART_REQUIRE_GOOGLE_OAUTH=1DEKART_GOOGLE_OAUTH_CLIENT_ID=Your-Client-IDDEKART_GOOGLE_OAUTH_CLIENT_SECRET=Your-Client-Secret
Create Data Connections directly through the UI
Now Dekart users can create Data Connections directly through the UI, stepping away from the single configuration approach facilitated by environment variables. Coupled with the recently implemented pass-through authentication, this upgrade empowers users and admins with unparalleled control over the data stored and cached.
Currently, only BigQuery supported DEKART_DATASOURCE=BQ.
To enable the feature, leave empty DEKART_BIGQUERY_PROJECT_ID= and/or DEKART_CLOUD_STORAGE_BUCKET=
Links
Upgrade from previous version
Documentation
Contribute 💜
v0.14.1
This is a hotfix for release v0.14.0
Fixes
- Fix Amazon OIDC integration (#134)
How to upgrade
The following images have been updated: dekartxyz/dekart:0.14.1, dekartxyz/dekart:0.14, dekartxyz/dekart:latest
Upgrade from previous versions
Links
Documentation
Contribute 💜
v0.14.0
Features
Rename queries and tabs
Now you can rename dataset tabs. Before they had automatic names assigned like Query 1, Query 2. Dataset layer in visualization panel will also pick up the new name.
OAuth Scopes Configuration for BigQuery
Added a mechanism to configure extra OAuth scopes for BigQuery. Extra OAuth scopes can be supplied via the DEKART_GCP_EXTRA_OAUTH_SCOPES environment variable as a comma-delimited list. (#122).
This allows querying a BigQuery table backed by a Google Sheet residing in Google Drive. In this case, it is necessary to set DEKART_GCP_EXTRA_OAUTH_SCOPES=https://www.googleapis.com/auth/drive.
This feature is the first contribution made by @hnicke 🚀
Fixes
- A security vulnerability was patched by fixing server security issues and resolving the problem with Golang dependencies (#129).
- Fixed the issue with Snowflake returning an empty result for better data fetching and representation (#123).
- Resolved an issue related to the concurrent map read causing backend to crash (#126).
- A bug that was causing issues with the popover positioning when clicking on geometry was fixed (#128).
Links
Upgrade from previous version
Documentation
Contribute 💜
Contributors
Assets 2
v0.13.0
Features
Export Dialogs
Added the ability for users to export their maps as HTML, images and data (#106). This can also be useful for printing maps or exporting to PDF. Thank you, @pooriaPoorsarvi, for the support and contribution!
AWS Athena Workgroup
Added the ability to specify an AWS Athena workgroup via an environment variable. This gives you the option to segment your query execution history for better governance, management, and isolation of queries (#102). Thank you, @seanlane, for the contribution.
Postgres Configuration
Added an option to configure Postgres using a connection string (#97). It allows specifying sslmode and use Dekart with wider range of managed Postgres services. Thank you, @christippett, for the contribution.
Fixes
- Fixed #93 causing rerunning query results in infinite load.
Links
Upgrade from previous version
Documentation
Contribute 💜
v0.12.1
v0.12.0
Features
Snowflake connector ❄️
Snowflake connector is now available with Dekart!
Fetching 1M point from Snowflake ❄️ and rendering on the map
Fixes
- Fixing query cancellation
- #69 Retrieve results from BigQuery Scripts
- Fix missing download size
- Fix re-downloading queries when new query added
v0.11.0
Features
Support GeoJSON in file upload
Additionally to the existing CSV format, you can now also upload GeoJSON files to be used as datasets for your visualizations. As per the previous release, files are stored in the same storage as the SQL query cache. Both Amazon S3 and Google Cloud Storage are supported.
Share Reports
As a step towards better collaboration within an organization, we now introduce the feature allowing to make your own reports discoverable to other users. When sharing a report, you will allow other users of the same organization/website domain to see it in Shared Reports with only view access. Simply uncheck this setting and your report will not be visible anymore.
While this feature enhances discoverability, you can still see reports of other users from your organization if they share their link with you directly.
Resize SQL editor
You can now resize the query editor, allowing each user to define how big they want the map/editor for certain use cases. Simply drag the bar left and right to find your perfect configuration!
Copy geometry coordinates
With the upgrade to the latest version of kepler.gl, you can now leverage their Copy Geometry feature to extract the coordinates of vertices from a manually drawn polygon on the map. Simply paste in the query editor and there you go!
Control usage stats collection over configuration
As we all love data, Dekart appends some anonymized statistics to the referrer of external links related to the usage of the tool.
You have full control on if you allow this or not. Simply configure the variable DEKART_DISABLE_USAGE_STATS in your deployment environment.
See details in user experience configuration
Fixes
- #48 fix panic during error returning
- #28 fix the panic when no destination table exists
- Fix stale queries which cannot be cancelled
- Fix server crash/restart when cancelling query
Upgrade from previous version
v0.10.0
Features
#41 File upload
You can now upload enable file upload by setting DEKART_ALLOW_FILE_UPLOAD=1 in environment variables. Once enabled, you can upload .csv files to Dekart backend and add them to your report. Files are stored in the same storage as SQL query cache. Both Amazon S3 and Google Cloud Storage are supported.
#44 Introducing secure CORS headers
New environment configuration DEKART_CORS_ORIGIN= is strongly recommended to secure your deployment from CORS attacks. CORS attack allow 3rd party to delete, edit and run queries on behalf of the user visiting malicious web page.