Strategy One

Dremio Client Credentials Authentication

Starting in Strategy One (June 2026), client credential authentication is supported by the Strategy shipped Arrow Flight SQL driver.

Prerequisites

  1. Go to https://{hostname}:{WebUIPort}/settings/users, replacing hostname and WebUIPort with your Dremio information.

  2. In Settings, click User Management in the left pane.

  3. Click the Service users tab and click Add Service User.

  4. Type a Username and Description.

  5. Click Add.

  6. Click your newly created service user and click the Credentials tab.

  7. Click Add and Generate OAuth secret.

  8. Type a Label and choose a Lifetime.

  9. Click Configure.

  10. Next to OAuth Secret, click Copy.

Create a Data Source Using Client Credentials

  1. In Library, choose Create New and Dashboard.

  2. Choose a project from the Create Dashboard in drop-down list.

  3. Click Blank Dashboard.

  4. In the Datasets panel, click New Data.

  5. Click next to Data Catalog.

  6. Find and select Dremio.

  7. Type a Name.

  8. Expand the Default Database Connection drop-down list and click Add New Database Connection.

  9. Choose the Flight SQL driver, org.apache.arrow.driver.jdbc.ArrowFlightJdbcDriver.

  10. Type your Host Name and Port Number.

  11. Expand Authentication Mode and choose Client Credentials.

  12. Expand the Default Database Login drop-down list and click Add New Database Login.

  13. Type your Client ID and Client Secret.

  14. Click Save.

  15. In Token URI, type your token URI using the following template: https://{hostname}:{WebUIPort}/oauth/token

  16. Click the Security tab and toggle on Use TLS Encryption.

  17. Expand the Verification Method drop-down list and choose an option.

  18. Click Save and Save.