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.

👉 Documentation

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 https://github.com/dekart-xyz/dekart/pull/147
• Refresh Button by @delfrrr in https://github.com/dekart-xyz/dekart/pull/153
• Report data updated label by @delfrrr in https://github.com/dekart-xyz/dekart/pull/154
• Shared Connections by @delfrrr in https://github.com/dekart-xyz/dekart/pull/155
• Postgres datasource support by @Tsovak in https://github.com/dekart-xyz/dekart/pull/156
• Allow edit reports by @delfrrr in https://github.com/dekart-xyz/dekart/pull/159
• Acceess error info by @delfrrr in https://github.com/dekart-xyz/dekart/pull/161
• Ux improvements by @delfrrr in https://github.com/dekart-xyz/dekart/pull/162

Dev

• Support dev email for Google OAuth flow by @delfrrr in https://github.com/dekart-xyz/dekart/pull/148
• User refresh token for development with Google OAuth by @delfrrr in https://github.com/dekart-xyz/dekart/pull/149

Fixes

• Fix storage connection test by @delfrrr in https://github.com/dekart-xyz/dekart/pull/150
• Fix auth error infinite loop by @delfrrr in https://github.com/dekart-xyz/dekart/pull/151
• Fix header aligments by @delfrrr in https://github.com/dekart-xyz/dekart/pull/152
• Fix playground 500 by @delfrrr in https://github.com/dekart-xyz/dekart/pull/160

Links

Upgrade from previous version

Documentation

Dekart Cloud ✨

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=1
• DEKART_GOOGLE_OAUTH_CLIENT_ID=Your-Client-ID
• DEKART_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 💜

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 💜

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 🚀

Documentation

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 💜

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.

Documentation

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.

Documentation

Fixes

• Fixed #93 causing rerunning query results in infinite load.

Links

Upgrade from previous version

Documentation

Contribute 💜

This release includes several bug fixes.

Bug Fixes

• Fixed Snowflake job status for long-running queries
• Fixed Snowflake job duration display
• Fixed styles for forked reports
• Show error message when adding data to map fails, partially addresses #93

Features

Snowflake connector ❄️

Snowflake connector is now available with Dekart!

Fetching 1M point from Snowflake ❄️ and rendering on the map

• Documentation
• Configuration example
• docker-compose example

Fixes

• Fixing query cancellation
• #69 Retrieve results from BigQuery Scripts
• Fix missing download size
• Fix re-downloading queries when new query added

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

How to upgrade from previous version

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.

Fixes

#37 Fix stale SQL query jobs

Upgrade from previous version

How to upgrade from previous version

Features

Support Authorization with Amazon OIDC headers #35

Now, you can configure user authorization in Dekart when using Amazon Load Balancer to host Dekart

You can configure Amazon Load Balancer to authenticate users via Amazon Cognito. Dekart parses x-amzn-oidc-data header, validates the JWT token and extracts claims containing user email. When you configure DEKART_REQUIRE_AMAZON_OIDC option, users will be authorized user to:

• list and edit only their own reports
• have read-only access to other users reports

Links:

• Configure Load Balancer and Cognito authentication with Terrraform including Google SSO
• Supported Environment Variables

How to upgrade from previous eversion