Manage the Dremio Connector

The Composer Dremio connector lets you access the data available in Dremio from supported versions of MySQL and MS SQL Server data stores using the Composer client. The Composer Dremio connector supports Dremio Community and Enterprise Editions version 4.1 through 4.8.

Before you can establish a connection from Composer to Dremio storage, a connector server needs to be installed and configured. See Manage Connectors and Connector Servers for general instructions and Connect to Dremio for details specific to the Dremio connector.

After the connector has been set up, you can create data source configurations that specify the necessary connection information and identify the data you want to use. See Manage Data Source Configurations for more information. After data sources are configured, they can be used to create dashboards and visuals from your data. See Create Dashboards.

Composer Feature Support

Dremio connector support for specific Composer features is shown in the following table.

Key: P - Supported; O - Not Supported; N/A - not applicable

Feature Supported?
Admin-Defined Functions O
Box Plots P
Custom SQL Queries P
Derived Fields (Row-Level Expressions) O
Distinct Counts P
Fast Distinct Values N/A
Group By Multiple Fields P
Group By Time P
Group By UNIX Time P
Histogram Floating Point Values P
Histograms P
Kerberos Authentication O
Last Value P
Live Mode and Playback P
Multivalued Fields N/A
Nested Fields N/A
Partitions N/A
Pushdown Joins for Fusion Data Sources O
Schemas P
Text Search N/A
TLS O
User Delegation O
Wild Card Filters P
Wild Card Filters, Case-Insensitive Mode P
Wild Card Filters, Case-Sensitive Mode O

Connect to Dremio

The Dremio JDBC driver 3.0.6 is used by and included in the Dremio connector. Driver drop-in is supported, so you can replace this JDBC driver if you want. By default, the Dremio connector uses port 8142.

To create a Dremio connector, you must provide three parameters:

  • The JDBC URL in a format supported by Dremio:

     jdbc:dremio:direct=<DREMIO_COORDINATOR>:<JDBC_PORT>[;schema=<OPTIONAL_SCHMEMA>]

    or

    jdbc:dremio:zk=<ZOOKEEPER_QUORUM>:<ZK_PORT>[;schema=<OPTIONAL_SCHEMA>]
  • A valid user name

  • A valid password.

Live Mode and Playback Considerations

Dremio supports reflections instead of indices. For more information about Dremio reflections, see https://docs.dremio.com/acceleration/. Because Dremio does not support indices, Composer cannot accurately determine which date and integer fields are playable, so it treats all date and time fields as playable, by default. Consequently, use livemode and playback judiciously when you are working with large data sets. Switch playback and live mode on only for visuals you know that the corresponding SQL queries are covered by a reflection and can be accelerated.

If you don't use Dremio reflections and are concerned that the default playability of all date and integer fields might be misused and impact performance, you can switch this feature off using the connector configuration property: metadata.detection.mark-all-date-and-int-fields-playable. Valid values are true (on) and false (off). The default setting for this property is true.