Setting up database connections
The steps to connect a database to Omni will differ depending on the type of database. Generally, you'll need to:
- Create an Omni database user
- Create the connection in Omni
- Define user access
- Configure schema refresh and environment settings
Requirements
Organization Admin permissions are required to add database connections.
Setup guides
If your database is in a private network, you may need to whitelist Omni's IP addresses or work with support to set up an SSH tunnel.
Refer to the guide for your database type to get up and running.
📄️ Overview
The steps to connect a database to Omni will differ depending on the type of database. Generally, you'll need to:
📄️ BigQuery
In this guide, you'll learn how to connect your Google BigQuery database to Omni.
📄️ ClickHouse
In this guide, you'll learn how to connect your ClickHouse database to Omni.
📄️ Databricks
In this guide, you'll learn how to connect your Databricks database to Omni.
📄️ Microsoft SQL Server
In this guide, you'll learn how to connect your Microsoft SQL Server database to Omni.
📄️ MotherDuck
In this guide, you'll learn how to connect your {frontMatter.sidebar_label} database to Omni.
📄️ MySQL
In this guide, you'll learn how to connect your {frontMatter.sidebar_label} database to Omni.
📄️ Postgres
In this guide, you'll learn how to connect your {frontMatter.sidebar_label} database to Omni.
📄️ Redshift
In this guide, you'll learn how to connect your {frontMatter.sidebar_label} database to Omni.
📄️ Snowflake
In this guide, you'll learn how to connect your {frontMatter.sidebar_label} database to Omni.
📄️ StarRocks
In this guide, you'll learn how to connect your {frontMatter.sidebar_label} database to Omni.