DBT: Core CLI

DBT (Data Build Tool) Core is an open-source tool and it is designed to help data engineers and analysts manage and transform data in a reliable and scalable manner. Some key features of DBT Core include version control integration, automated testing, documentation generation, and dependency management. These features enable teams to collaborate effectively, ensure the quality of their data transformations, and maintain documentation for their data pipelines. DBT Core simplifies the process of transforming data in a data warehouse environment, providing a structured and scalable approach that helps teams manage their data transformation workflows effectively.

This integration provides an interface to call the DBT Core CLI and enables users to execute DBT Core CLI tasks in Universal Controller. This is particularly useful when UC acts as a data pipeline orchestrator and DBT is a step within a data pipeline Universal Controller workflow.

Key Features:

• Show DBT version and DBT environment variables information as Task Instance STDOUT. Enables users to retrieve Information on the dbt core installation.

• Execute a given DBT command. DBT output is displayed as task instance STDOUT

• Artifacts can be collected, and related information can be published within Universal Controller for subsequent workflow tasks to use.
  

• Ability to safely store and pass UC Credentials as DBT environment variables.