dbt Jumpstart

Very short intro

This project helps jump start any dbt project. You can simply collect all the information regarding your tables and their schema and upload here, and the service generates the dbt models for you. The following instructions will guide you through the process.

Preparation

You need to create two .xlsx spreadsheets - one that contains all the table configurations and another that contains the details about all the columns in the tables. The files must be named exactly as shown below:

tables.xlsx

Create tables.xlsx with the following format. You definitely need to have the column headers as is, but you are free to leave them empty.

columns.xlsx

Create a .xlsx spreadsheet in the below format. You definitely need to have the column headers as is, but you are free to leave them empty.

Note that you need to name the sheets with the exact table names that you used in the tables.xlsx

Upload and Convert

Upload your columns.xlsx and tables.xlsx files and hit the "Upload and Convert" button.


"You have saved some time in your life now, do amazing things with it"
- Meow, the Thunder Cat.