Skip to main content
You can quickly create a database connection in Omni by pasting a standard connection URI instead of filling out the connection form manually. This method supports most common database types and automatically parses your connection details.

​
Requirements

To use quick connect with a connection string, you’ll need:
  • Organization Admin permissions in Omni
  • A connection string (URI) for your database in the standard format

​
Supported databases

Quick connect supports the following databases:
Oracle connections require manual setup through the connection form to accept the license agreement.

​
Connection string format

Connection strings follow the standard URI format: 
dialect://username:password@host:port/database
For databases that support additional parameters, add them as query parameters: 
dialect://username:password@host:port/database?parameter=value
If your username or password contains special characters, they must be URL-encoded in the connection string.

​
Examples

databricks://token:dapi123abc@workspace.cloud.databricks.com:443/default?http_path=/sql/1.0/warehouses/abc123

​
Using quick connect

1

Prep the database

Before you start, prep your database for the connection. This can include:
  • Creating an Omni database user and granting permissions
  • Setting up a table upload schema (for CSV uploads)
  • Adding Omni’s IP addresses to an allowlist
Refer to the setup guide for your database for more information.
2

Navigate to the new connection page

In Omni, go to Settings > Connections and click New connection.
3

Paste your connection string

If your credentials contain any special characters, be sure to URL-encode them when adding the connection string in Omni.
At the bottom of the page, you’ll see a quick connect input field. Paste your connection string and press Connect:Quick connect input field on the new connection pageOmni will automatically parse the connection details and create the connection.If the connection string format is invalid or missing required fields, an error message will display below the input. Error messages never include passwords for security.If you encounter a server error during connection creation, you’ll be redirected to the connection form where you can review and adjust the settings.

​
Database-specific parameters

Some databases support additional parameters in the connection string:
DatabaseParameterDescriptionExample
SnowflakewarehouseSnowflake warehouse name?warehouse=COMPUTE_WH
SnowflakeaccountSnowflake account identifierAdded automatically from host
Microsoft SQL ServerschemaDefault schema?schema=dbo
Databrickshttp_pathHTTP path to the SQL warehouse?http_path=/sql/1.0/warehouses/abc123

​
Special characters in credentials

If your username or password contains special characters, they must be URL-encoded in the connection string:
CharacterEncoded value
@%40
:%3A
/%2F
?%3F
#%23
&%26
For example, if your password is p@ss:word, use p%40ss%3Aword in the connection string.

​
What’s next?

After creating your connection, you may want to: