You can use Alteryx Designer to quickly prepare, blend, conform, and analyze data from datasets in Dremio.
Alteryx Designer 10.6+
- Ensure that you are using Dremio v22.0 or later.
- Ensure that your operating system is 64-bit Windows 10 or later.
- Download, install, and configure the ODBC driver for Arrow Flight SQL.
- If you want to authenticate to Dremio by using a personal access token (PAT), rather than by using a password, generate a PAT. See Personal Access Tokens for the steps.
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. Specify the username to use for the connection to Dremio.
c. Specify either a password or a personal access token to use with the username.
d. 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, specify the username to use for connections to Dremio, then specify either a password or a personal access token to use with the username.
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.