In Warehouse & HostedDB

Break down of Hosted DB and In-Warehouse options

OmniAI has two primary options for running transformations. Data can be written to a Hosted DB or delivered In Warehouse.

In Warehouse

OmniAI reads values from your data source, and writes transformed values back to a new table within that same source. This is our recommended strategy for most organizations. With in warehouse users have a simplified architecture, more access control, and improved query performance.

Example flow: A user selects the customer_reviews table and enables a sentiment transformer. OmniAI creates an omni_customer_reviews table within the user database that contains two columns:

• customer_reviews_id - a foreign key reference to the customer_reviews table

• sentiment - result from the sentiment transformer

Note: In Warehouse is only available for Snowflake, Postgres, MySQL and MongoDB. HTTP Request and CSV Upload are only available with the Hosted DB option.

In Warehouse

Hosted DB

OmniAI provides a cloud hosted PostgreSQL instance with transformed values and a foreign key relation to the source data. The Hosted instance is ideal for standalone data analytics, static data sets (CSV Upload), or data sets without write options (HTTP Request).

Example Flow: A user selects the customer_reviews table and enables a sentiment transformer. OmniAI creates a customer_reviews table within a hosted Postgres instance. The original data from customer_reviews as well as any transformed rows are written to this table. The user is given a Postgres connection string to access this database.

Note: This is a read-only connection.

Hosted DB