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 | - | - | - |
Pivot Query | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Count Disctinct | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Attribute Limits | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
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.