Dremio Community

Alteryx Designer

Prerequisites

Dremio Alteryx Designer integration requires:

Updating Dremio DSN Configuration for Alteryx Designer

  1. Run the ODBC Data Sources (both 64-bit or 32-bit) Windows application.

  1. Open the System DSN tab, select ‘Dremio Connector,’ and hit the Configure button.
  1. Add the following to the end of the Advanced Properties in Dremio Connector DSN:
;supportFullyQualifiedProjects=true

Importing Dremio datasets into Alteryx Designer

  1. Open Alteryx Designer and drag a new Input Data component.

  1. Select New ODBC Connection from the Database Connection dropdown.

  1. Select the Dremio Connector DSN you configured, enter your credentials and hit OK.

  1. You can now browse schemas and tables on Dremio. Select tables or write a custom SQL query.

  1. Dremio datasets are now available in Alteryx.