Providers Capabilities Summary

We've put toghether a list of capabilities or features that we consider important to mention, and that are not consistent between providers. Please note that some of these capabilities are linked into a more detailed explanation in the specific provider page. Also, the table below is wide so please make sure to scroll horizontally if your provider is not in view.

	Databricks	Spark	ElasticSearch	Dremio	Google BigQuery	Redshift PostgreSQL	Snowflake
Version	-	2.2	6.x - 7.x	3.x	-	-	-
Simple multigroup queries	Yes	Yes	Yes	Yes	Yes	Yes	Yes
Top-n and Bottom-n queries	Yes	Yes	Yes *	Yes	Yes	Yes	Yes
Count Disctinct	Yes	Yes	Yes	Yes	Yes	Yes	Yes
Count Disctinct Approx	Yes	Yes	No	No	Yes	No	No
Wildcard source names	No	No	Yes	No	Yes	No	No
Raw data query	Yes	Yes	Yes	Yes	Yes	Yes	Yes
Aggregate-level derived fields	Yes	Yes	Yes	Yes	Yes	Yes	Yes
Row-level derived fields	Yes	Yes	No	Yes	Yes	Yes	Yes
Time zone support	Yes	Yes	Yes	No	Yes	Yes	Yes
GeoHash	No	No	Yes	No	Yes	Yes	No
Geo Bounding Box Filtering	No	No	Yes	No	Yes	Yes	No
Geo Drawing Filtering	No	No	Yes	No	Yes	Yes	No
Custom Queries	Yes	Yes	No	No	Yes	Yes	Yes

Note: The ChartFactor Node data provider supports the same capabilities as the target data provider executing on the server side.