Giter VIP home page Giter VIP logo

granula's Introduction

DataModels SQL naming mask:

## DataMart: model open for customers usage
    {}_{dimension}_{filtering}_{usecase_details}//  filtering and usecase coule be skipped


    ### Names Examples:
        Cubes:
            — meta_ads_daily
            - google_ads_daily
            — google_ads_daily_campaigns 
            - all_ads_monthly_region_roas
            — all_ads_daily // if we going to union all sources/channels

        Entities:
            - meta_ads_campaigns
            — google_ad_sets
            - google_ads_keywords
            - meta_ads_creatives
            - all_ads_channels
            - countries

        Events:
            - ga4_events
            - meta_ads_events_settings_changes
            - shopify_events_sales_order_complited
            — events_crm_order_cancelations
            — events_airbyte_exttaction_log_status


## subject_domains
    - ads platforms domains
        — google_ads_
        — meta_ads_
        — pinterest_

    - analytics tools
        — ga4_
        - amplitude_

    our own domain
        — all_ads_ // models that unite all ads platforms data together

    customer data models
        - by_vbb_
    

## Intermediate DataModel: 
    {intermediate}_{granularity_type}_{filtering}_{dimension}_{usecase}

    ### Names Examples:
        - intermediate_daily_meta_ads_with_campaign_name_fixes
        - intermediate_entity_creatives_with_accomulative_stats_materialized

## Source DataModel: 
    {source}_{granularity_type}_{filtering}_{dimension}_{usecase} // filtering and are not mundatory

     ### Names Examples:
        - source_daily_meta_ads_with_campaign_name_fixes
        - intermediate_entity_creatives_with_accomulative_stats_materialized  

## metric layer on cubes         
    we use group by cube(dimensions) and add postfix _cube

from: https://github.com/kobzevvv/granula

granula's People

Contributors

kobzevvv avatar

Watchers

 avatar

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.