Skip to main content

​
Requirements

To follow the steps in this guide, you’ll need:
  • Organization Admin permissions in Omni
  • Permissions in Exasol that allow you to create database users and grant permissions

​
Setup

1

Create an Omni database user

  1. In your Exasol database, run the following command to create a database user for Omni:
    Create Omni user
    CREATE USER OMNI IDENTIFIED BY "<password>";
GRANT ALTER SESSION TO OMNI;
  2. Grant the Omni user access to the system views required for schema, table, and column discovery:
    Grant metadata introspection permissions
    GRANT SELECT ON EXA_ALL_SCHEMAS TO OMNI;
GRANT SELECT ON EXA_ALL_TABLES TO OMNI;
GRANT SELECT ON EXA_ALL_COLUMNS TO OMNI;
  3. Grant SELECT access to the schemas or tables you want to query in Omni:
    Grant data access to the Omni user
    GRANT SELECT ON <tables used by OMNI> TO OMNI;
    You could also grant all privileges:
    Grant all privileges to the Omni user
    GRANT ALL PRIVILEGES ON SCHEMA <YOUR_SCHEMA> TO OMNI;
    Or, run the following to avoid needing to grant access to tables created in the future:
    Grant data access to all existing and future tables
    GRANT SELECT ANY TABLE TO OMNI;
2

Allowlist Omni's IP addresses

If access to the Exasol database is limited by IP address, you’ll need to add Omni’s IPs to the allowlist before you create the database connection.Omni’s IP addresses can be found on an individual connection’s page, accessed by navigating to Settings > Connections and clicking a connection.
3

Create the connection in Omni

  1. In Omni, click Settings > Connections.
  2. Click the Exasol option.
  3. On the connection setup page, fill in the connection details:
    NameRequired?Description
    Display Name YesA user-friendly name for the connection, which will be used throughout Omni
    Host YesThe hostname or IP address of the Exasol server.
    Port YesThe port number for the database connection.
    Include Schemas NoA comma-separated list of schemas to include in the connection
    Offloaded Schemas NoA comma-separated list of schemas to include in the connection, which will only load on demand. This setting is useful for large schemas or dbt dev schemas.
    Default Schema YesThe default schema to use for queries
    Username YesThe username for database authentication
    Password YesThe password for database authentication
    Trust Server Certificate NoWhether to trust the server’s SSL/TLS certificate without validation
    Database Timezone YesThe timezone used by the database
    Query Timezone YesThe timezone to use for Omni queries. If a timezone is specified, data will be converted from the Database timezone to the selected timezone.
    Allow User-Specific Timezones NoWhen enabled, users can override the connection timezone with their own when querying
    Query Timeout NoMaximum time in seconds before a query times out
    Base Access YesSelect the minimum level of access users should have to models in the connection
  4. When finished, click Create connection.

​
What’s next?

Now that your database is set up, you can: