Home » Data Mart

Data Mart

We use this term to describe how we employ the Snowflake component of our service offering. Often we need to index, modify and possibly transform data for reporting purposes so we employ Snowflake, a lightweight low cost secure database “in the sky,” to maintain certain indexes and tables, allowing our OxFlow task automation service to do better work more efficient work.

Part of our Data Mart model is to build “Mirror” automations where/when needed. This is where we pull an index from one or severl systems to allow for advanced data transformation in Snowflake – and significantly enhance the ability of a task automation service to provide reporting and math in ways no single system can.

When we setup a Snowflake Data Mart for a client, we guide the client through provisioning a Snowflake instance directly (client owns the account and is invoiced directly) then we install our Data Mart “footprint” which includes: databases, schemas, roles, security model and security policies.

Please check out this Wikipedia entry for more details.