You can use Alteryx Designer to quickly prepare, blend, conform, and analyze data from datasets in Dremio.
Alteryx Designer 10.6+
Download, install, and configure the ODBC driver for Arrow Flight SQL.
The driver supports 64-bit Windows 10 or later.
The personal access token (PAT) that you add to the DSN that you configure for the driver determines the Dremio Cloud project that the driver connects you to. Ensure that you create your PAT in the correct project.
Selecting Dremio as a Data Source
In Alteryx Designer, select File > New Workflow.
Drag the Input Data tool from the tool palette on to the workflow canvas.
In the configuration properties for Input Data, click the arrow on the right side of the Connect a File or Database field.
In the Data connections dialog, follow these steps:
a. Select Recent and click Clear List in the top-right corner if there are any entries on the page.
b. Select Data Sources.
c. Scroll down to the option Generic connection.
d. Click either ODBC or OleDB.
If you clicked ODBC, follow these steps in the ODBC Connection dialog:
a. In the Data Source Name field, select the data source name for the ODBC driver for Arrow Flight SQL.
b. Leave the User name and Password field blank. The authentication credentials for connecting to Dremio Cloud are already present in the user DSN.
c. Click OK.
If you clicked OleDB, follow these steps in the Data Link Properties dialog:
a. On the Provider tab, select Microsoft OLE DB Provider for ODBC Drivers.
b. Click Next».
c. For step 1 on the Connection tab, select Use data source name, and then select the data source name for the ODBC driver for Arrow Flight SQL.
d. For step 2 on the Connection tab, leave the User name and Password fields blank. The authentication credentials for connecting to Dremio Cloud are already present in the user DSN.
e. (Optional) Click Test Connection to find out whether the info you specified on this tab is correct.
f. Click OK.
You can now browse and query datasets that are in Dremio.