Skip to main content

Dremio

Connection Type

ODBC (64-bit)

Driver Details

You can download the driver from Dremio download page.

Type of Support

Read-only

Validated On

Client Version: Apache Arrow Flight SQL

Authentication Method

No authentication

API token

Alteryx Tools Used to Connect

Standard Workflow Processing

Configure Connection Using a DSN and DCM

  1. Drag an Input Data tool or Output Data tool onto the Designer canvas.

  2. Select the Use Data Connection Manager (DCM) check box.

  3. In the Data Connections window, go to Data Sources and select Dremio ODBC. If Alteryx can't detect an ODBC driver, a pop-up indicates that you need to install a driver.

  4. The Connection Manager window opens. Select +New to add a new data source.

  5. The dropdown pre-selects ODBC by default.

  6. Enter a descriptive Data Source Name for the new data source, for example, "Dremio Server DSN".

  7. Select the ODBC DSN field to see a list of available DSNs and select a DSN to use for the data source.

  8. Select Save.

  9. To link a credential, select + Connect Credential.

    • Select preferred authentication method.

  10. Select Connect to use the Data Source and Credential in an Input Data our Output tool.

Configure DSN-less Connection Using DCM

  1. Drag an Input Data tool or Output Data tool onto the Designer canvas.

  2. Select the Use Data Connection Manager (DCM) check box.

  3. In the Data Connections window, go to Data Sources and select Dremio Quick Connect. If Alteryx cannot detect an ODBC driver, a pop-up prompts you to install a driver.

  4. The Connection Manager window opens. Select +New to add a new data source. If Alteryx can't detect an ODBC driver, a pop-up prompts you to install a driver.

  5. The dropdown pre-selects Dremio ODBC DSN-less.

  6. Enter the information for the connection:

    • Enter a descriptive Data Source Name for the connection, for example, "Dremio DSN-less".

    • Enter the Host name.

    • Select the Driver field to change the driver selection.

    • Enter the Database name.

    • Enter port number.

  7. Select Save to save the new data source.

  8. To link a credential, select + Connect Credential.

    • Select an Authentication Method from the dropdown.

  9. Select Connect to use the Data Source and Credential in an Input Data our Output Data tool.