Gain new insights to your data with fast, responsive graphics and SQL queries.
Install and configure your OmniSci instance, then load data for analysis.
Extend OmniSci with custom charts and interfaces. Contribute
to the OmniSci Core Open Source project.
- Added support for UPDATE via
with a subquery in the WHERE clause.
- Initial support for
TEMPORARY (that is, non-persistent) tables.
- Improved performance for multi-column GROUP BY queries, as
well as single column GROUP BY queries with high cardinality.
Performance improvement varies depending on data volume and
available hardware, but most use cases can expect a 1.5 to 2x
performance increase over OmniSciDB 5.0.
- Improved support for EXISTS and NOT EXISTS subqueries.
- Added support for LINESTRING, POLYGON, and MULTIPOLYGON in
user defined functions.
- Immerse log-ins are fully sessionized and persist across
- Pie chart now supports "All Others"
and percentage labels.
- Cohorts can now be built with
- New filter sets can be created through duplicating existing
- Dashboard URLs now
link to individual filter sets.
- The new filter panel in Immerse enables the ability to toggle
filters on and off, and introduces Filter Sets to provide quick
access to different sets of filters in one dashboard.
- Immerse now supports using global and cross-filters to
interactively build cohorts of interest, and the ability to apply
a cohort as a dashboard filter, either within the existing filter
set or in a new filter set.
- Data Catalog, located within Data Import, is a repository of
datasets that users can use to enhance existing analyses.
- To see these new features in action, please watch this
video from Converge 2019, where Rachel Wang demonstrates how
you can use them.
- Added support for binary dump and restore of database tables.
- Added support for compile-time registered user-defined functions
in C++, and experimental support for runtime user-defined SQL
functions and table functions in Python via the Remote Backend Compiler.
- Support for some forms of correlated subqueries.
- Support for update via subquery, to allow for updating a
table based on calculations performed on another table.
- Multistep queries that generate large, intermediate result
sets now execute up to 2.5x faster by leveraging new JIT code
generator for reductions and optimized columnarization of
intermediate query results.
- Frontend-rendered choropleths now support the selection of
base map layers.
This sitemap link is for the benefit of the search crawler.