You can connect to a Dremio Software database to enable Lightup data quality monitoring of tables and views.

Lightup account setup

  1. In the target Dremio database, add a new user named lightup.
  2. Grant the lightup user SELECT privileges on the dataset you want to monitor using Lightup.

Connect to a Dremio datasource

  1. In the left pane, open a workspace menu and select Datasources.
  2. In the main page select Create Datasource +.
  1. Under Select a connector, enter a Datasource Name and select the Dremio Connector type.
  2. Under Configure connector, provide values for the following:
  • HOST - The hostname for the database (check the browser address bar; you want the string between // and /). Example:
  • USERNAME - Enter lightup (or whatever name you gave the Lightup user).
  • PASSWORD - Enter the password for the Lightup user.
  • If needed, enable Use encryption.
  1. After entering the required settings and any optional settings that apply, below the Configure connector section select Test Connection.
  2. After a successful connection test, select Save.
  3. Your new datasource appears in the list of available datasources. By default, these are listed in alphabetical order, so you might have to scroll or change the sort order to see your new datasource.


Optionally, choose a new Schema Scan Frequency.

Query Governance

Dremio supports all query governance settings.

Date/time data types

These Dremio date/time data types are supported:

  • DATE
  • TIME

Object types

All native Dremio object types are supported.

Supported Versions

  • 24.X hosted