Features

Support AWS Athena as datasource.

Before Dekart was supporting only BigQuery. Now you can configure Dekart to query Athena or BigQuery with DEKART_DATASOURCE environment variable.

AWS Athena is a serverless query engine based on Presto. Athena/Presto includes support of Geospatial Functions and enables querying datasets like OpenStreetMap from AWS Public Dataset.

Make sure to configure Data Limits before using Athena.

See configuration details in https://dekart.xyz/docs/configuration/environment-variables/#main-configuration

Support AWS S3 as backend for storing queries and query results.

Now you can configure Dekart to use AWS S3 or Google Cloud Storage (GCS) to store queries and query results with DEKART_STORAGE environment variable. S3 storage will work with both: Athena and BigQuery datasources. You can deploy Dekart to AWS regardless if you query Athena or BigQuery.

Dekart still requires Postgres to store query meta information.

Acknowledgements

Thank you @tochka and @Tsovak for hacking together Athena and S3 support PoC.

Fixes #25 Dekart stop working with no error messages (deadlock)

See v0.7.0 release notes for details

Fixes kepler.gl dependency to include performance improvements listed in v0.7.0 release notes

See v0.7.0 release notes for details

Features

• Support BigQuery MaxBytesBilled. Now you can set DEKART_BIGQUERY_MAX_BYTES_BILLED to implement Best Practices for Controlling Query Cost. See Environment Variables Documentation for details
• Read BigQuery Job Results in multiple streams via BigQuery Storage Read API. Speeds up loading results ~5x.
• Fixing critical client dependencies vulnerabilities

Bugfixies

• [Kepler.gl] Long Script Blocking in time when adding data with WKT
• [Kepler.gl] #14 coordHasLength4 throws exception for GeometryCollection

Migration from v0.6

No breaking changes, configure DEKART_BIGQUERY_MAX_BYTES_BILLED to avoid warnings (see docs)

Features

• Show banner when new version available
• New Header Style

Bugfixies

• Fix geojson layer update
• Fix #17 Report Fork changes sequence of queries
• Fix #16 query changes lost when switching between tabs
• Fix race condition when loading mapconfig

Features

• Multiple queries per report with tabs
• Explicitly show error message for BigQuery API, grpc Stream, Kepler.gl
• Update Kepler.gl version to 2.5.1

Bug fixes

• #12 Fix pq: integer out of range caused by wrong type for timestamps in db

Features

• #11 View Source of Read-Only Reports
• #9 Allow changing Visualisation settings in Present and Read-Only mode
• Fork Reports
• Copy report URL button
• New Navigation and Report Actions UX

New

• User management with Google IAP
• Support read-only reports
• Configure link to data documentation and add tracker

Documentation

• Documentation website
• Playground with BigQuery public datasets

Bugfixies

• {“level":"fatal","error":"pq: value \"316663395386\" is out of range for type integer"}
• Size was not shown on App Engine when downloading results

See minor version release notes for 0.2.0