Connecting to BigQuery
Connecting to MySQL
Connecting to Postgres
Connecting to Redshift
Connecting to Snowflake
Creating an Omni Database User
First we need to create a database user to give Omni permissions to query the data warehouse.
See the Security) section for information about using Omni with an IP allow list on your data warehouse.
Adding the database to Omni
We need to add the database credentials to the Omni application, "Add Connection":
We select the database we configured previously:
Each dialect has a slightly different configuration.
- Display Name is how the connection name will appear in Omni, and can be changed later.
- Database Details will be information from your data warehouse.
- Include Schemas will restrict the schemas pulled into Omni, and multiple can be included delimited by commas. If left blank, Omni will model all schemas. This can significantly improve performance by reducing model size.