Data Science Dojo delivers data science education, consulting, and technical services to harvest the power of data.

Trademarks: This software listing is packaged by Data Science Dojo. The respective trademarks mentioned in the offering are owned by the respective companies, and use of them does not imply any affiliation or endorsement.

Data Build Tool is a partially open-source platform for transforming and modeling data obtained from your data warehouses all in one place. It allows the usage of simple SQL to manipulate data acquired from different sources. Users can document their files and can generate DAG diagrams thereby identifying the lineage of workflow using dbt docs. Automated tests can be run to detect the flaws and missing entries in the data models as well. Ultimately, you can deploy the transformed data model to any other warehouse. DBT serves pleasantly in the cutting-edge information stack and is considered cloud agnostic meaning it operates with several significant cloud environments.

Following can benefit from DBT:

• DevOps Engineers
• Data Analysts
• Data Engineers
• Data Scientists
• Organizations facilitating data-driven culture
• And anyone else interested in data science tools

• Ubuntu VM having DBT Core installed to be used from Command Line Interface (CLI)
• Database: PostgreSQL
• Support for BigQuery
• Support for Redshift
• Support for Snowflake
• Robust integrations
• A web interface at port 8080 is spun up by dbt docs to visualize the documentation and DAG workflow
• Several data models as samples are provided after initiating a new project

This DBT offer is compatible with the following cloud providers:

• GCP
• Snowflake
• AWS

DBT throughput improves with more CPU cores, more RAM, and faster disks

• Minimum memory: 8GB RAM
• Minimum vCPU: 2 vCPUs
• Operating System: Ubuntu 20.04

The supported base operating systems include:

• Ubuntu 16.04, Ubuntu 18.04 (Recommended)
• RHEL 7.4, 7.5, 7.6, 7.7
• CentOS 7.4, 7.5, 7.6, 7.7

You can now take in-time copies of data by the Snapshot feature to keep track of the changes or timestamps !

Execute the following command in your terminal to create a new project: dbt init

Disclaimer: The service in consideration is the free open source version which operates from CLI. The paid features as enunciated officially by DBT are not endorsed in this offer.

The compilation of the software and images provided in this offer is the exclusive property of dbt™. The software and content provided are strictly prohibited to be put to any other use than it is intended.