How to import modeling templates?
Introduction
Programmers are usually relying on libraries in their daily work. Libraries are collections of prewritten code that users can use to save time and improve the quality of their work. With this idea in mind, we have started working on various modeling templates to save you time. These templates provide you with a basic pipeline so you don't have to re-built data cleaning processes from scratch that other users have done already.
These templates are built with a layer concept that reflects our best-practice approach to data modeling. That means a template does not only consist of one model but potentially 2-3 models which are built on top of each other. The amount of models being built on top of each depends on the complexity of the source data (Shopify, Facebook Ads, Hubspot etc.)
Implementation guide
In order to import one of our templates to your org, please follow the following steps:
- Check out the data lineage of the template in the respective template documentation to understand the sequence of the models.
- Download the templates in form of JSON files.
- Create a new model and name it accordingly to the template documentation.
- Import the first model according to the template documentation by using our IMPORT JSON function.
- To adapt the template to your data source, replace the INPUT node with your actual data source.
- Commit the model and repeat this process for the next model within the template.
- After having imported the JSON file into the next model according to the data lineage, replace the input node by selecting the previous OUTPUT table as input node for your current model and commit the model to save.
- Continue this process until you have committed all template models.
Remarks
Please bear in mind that these templates require a certain selection of source-level columns. That means the first layers of the templates are requiring specific columns from specific tables from specific integrations. Please make sure to add the required integrations, tables, and columns in order to properly use the templates.