Create a datamart

This guide provides a straightforward process for creating a datamart in Databrain, allowing users to efficiently manage and analyze data.

What is a Datamart?

A datamart is a specialized subset of a data warehouse designed to cater to the analytical needs of a specific department. It allows users to efficiently manage and analyze relevant data by providing a more focused and optimized dataset.

Purpose of Datamart

A datamart solves the problem of managing large and complex datasets by delivering fast query performance and simplified access to data, tailored to the needs of specific departments.

1. Initial Access

   • In the Data Studio page of Databrain, navigate to the Datamarts section.
   • Click on the + Data Mart button in the top right corner.

   
2. Configure Datamart

   • Enter a suitable name for your datamart and choose the corresponding datasource from the dropdown list.
   • Choose between:
     • Database: Choose this when your client data is stored at the database level (each client has its own database).
     • Table: Choose this when your client data is stored as rows identified by an ID column in a single table.
   • Click on Next.

   

   Database tenancy refers to organizing and controlling access to data based on specific groups. It ensures that each group can access only their own data, keeping it secure and separate from other.

3. Choose Primary Schema

   • Choose the schema that Databrain will use to build your datamart.
   • Click on Next.

   
4. Select Tables

   • Use the search box to find specific tables or browse available tables in the schema.
   • Select required tables and click Next.

   
5. Configure Columns

   • For each column, you can configure:
     • ALIAS : Create custom names for columns
     • LABEL : Create Custom names for end user
     • HIDE : Hide the column for end user
     • COMMON : Set the column as Common field between databases
     • HIDE TO : Set visibility options
     • TRANSFORM : Apply data transformations
   • Then, click Next.

   
6. Define Relationships

   • Navigate to the Define Relationships tab and describe the relationships between the columns and cardinality between the tables.
   • Then, specify any other relevant information or important constraints.
   • Click on Next.

   
7. Configure Tenancy (Optional)

   • View the tenancy details if required.
   • Finally, click Complete to finish the datamart creation.

   

   Your new datamart will appear in the Data Marts list!