Manifolds

Manifolds is a framework designed to streamline the process of generating and managing data infrastructures in Google BigQuery using Terraform. By leveraging Manifolds, teams can efficiently create complex views that join dimensional data with multiple metrics tables, enabling more dynamic data interactions and fewer sandcastles.

At the heart of Manifolds, our philosophy is to simplify the complexity inherent in managing large-scale data architectures. We aim to provide a tool that not only facilitates the easy setup of data structures but also adheres to best practices in scalability, maintainability, and performance. Manifolds is built for data engineers, by data engineers, ensuring that the nuances and common challenges in data management are well-addressed.

• Unified Data Modeling: Manifolds introduces a standardized way to model dimensions and metrics, ensuring consistency and reliability in data reporting and analysis.
• Scalability: Designed to handle large volumes of data, supporting a variety of data types and structures.
• Flexibility: Easily adapt to different kinds of metric groupings such as by device type (e.g., desktop, tablet, mobile) with identical metric structures beneath these segmentations.

• Ruby
• Terraform
• Google Cloud SDK (gcloud)

1. Install the Manifolds Gem: manifolds is distributed as a Ruby gem. To install it, run:

gem install manifolds

2. Setup Terraform: Ensure that Terraform is installed and configured to interact with your Google Cloud Platform account.

3. Configure Your Environment: Set up your environment variables and credentials to access Google BigQuery and other necessary services.

1. Initialize a New Umbrella Project

Set up a new umbrella project directory with the necessary structure for managing multiple data projects.

manifolds init <project_name>

2. Add a New Data Project

Add a new data project under the umbrella. This setup includes creating a directory for the data project and initializing with a template manifold.yml file.

cd <project_name>
manifolds add <data_project_name>

3. Generate BigQuery Resource Definitions

After you fill out the manifold.yml file, this command generates the necessary BigQuery schema files based on the specified dimensions and metrics.

manifolds generate <data_project_name> bq

Dimensions are fields that describe the context of the data. They are typically used to segment and filter data in reports.

dimensions:
  - name: user_id
    type: STRING
  - name: date
    type: DATE

Metrics are fields that contain numerical data that can be aggregated. They are typically used to measure performance or other quantitative data.

metrics:
  - name: Pageviews
    id:
      field: pageId
      type: STRING
    interval:
      type: TIMESTAMP
      expression: TIMESTAMP_TRUNC(timestamp, HOUR)
    aggregations:
      - name: pageviews
        method: count
      - name: sessions
        method: distinct
        field: sessionid
    source:
      type: bigquery
      name: Events.Requests
      breakouts:
        - name: us
          condition: CountryId = 2840

• Name: The name of the metric.
• ID: The field that uniquely identifies the metric, along with its type
• Interval: The time interval over which the metric is aggregated
• Aggregations: The distinct used to aggregate the metric
• Source: The source table from which the metric is derived
• Breakouts: Custom segmentations of the metric

We welcome contributions from the community! Please check out our contribution guidelines for more information on how to get involved.

Distributed under the MIT License. See LICENSE for more information