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 thecustomer_reviews
tablesentiment
- 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 WarehouseHosted 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.
Last updated