About dbt (data build tool)
dbt is a SQL-first changeation tool that lets analytics engineers change data in the warehouse using software engineering best practices. It enables version-controlled, tested, and documented data changeations using pure SQL with Jinja templating. dbt has become central to the modern data stack, generating data lineage documentation and enabling modular, reusable data models.
Best for:
Analytics engineers who want to bring software engineering practices to SQL data changeation
Key Features
- SQL-based transformations
- Automated data documentation
- Built-in data testing
- Data lineage DAG
- Jinja templating
Pros & Cons
Pros
- Transforms SQL into production-grade code
- Excellent documentation generation
- Central to the modern data stack
Cons
- Primarily limited to transformation layer
- dbt Cloud pricing can escalate
User Reviews
No reviews yet. Be the first to leave a review!
Log in to leave a review.
AI Glossary
The simulation of human intelligence in machines programmed to think, learn, and problem-solve. AI encompasses machine learning, natural language processing, computer vision, and more.
A deep learning model trained on vast text datasets to understand and generate human-like language. Examples include GPT-4, Claude, and Gemini.
AI systems that create new content - text, images, audio, video, or code - based on patterns learned during training rather than retrieving existing data.
The practice of designing and refining input text (prompts) to guide an AI model toward producing more accurate, relevant, or creative outputs.
A computing architecture inspired by the human brain, consisting of interconnected layers of nodes that learn to recognise patterns in data.
A branch of AI where algorithms improve automatically through experience and exposure to data, without being explicitly programmed for each task.
AI technology that enables computers to understand, interpret, and generate human language - the foundation of chatbots, translation tools, and voice assistants.
The process of further training a pre-trained AI model on a specific, smaller dataset to specialise it for a particular task or domain.
When an AI model generates plausible-sounding but factually incorrect or entirely fabricated information, often presenting it with false confidence.
The units of text (roughly 4 characters or ¾ of a word in English) that LLMs process. Model costs and context limits are measured in tokens.
The maximum amount of text (measured in tokens) an LLM can process in a single interaction - both input and output combined.
A technique that enhances LLM outputs by fetching relevant external documents at query time, grounding responses in up-to-date or proprietary data.
Numerical vector representations of text, images, or other data that capture semantic meaning, enabling AI to measure similarity and retrieve relevant content.
The process of running a trained AI model to produce predictions or outputs from new input data - distinct from the training phase.
An AI system that autonomously plans and executes multi-step tasks by combining reasoning, tool use (web search, code execution, APIs), and memory.
AI models that can process and generate multiple types of data - such as text, images, audio, and video - within a single unified system.
A large-scale AI model trained on broad data that serves as a base for many downstream applications via fine-tuning or prompting.
A pricing model where core features are available for free, with premium features, higher usage limits, or advanced capabilities offered via paid plans.
A set of protocols that allows developers to integrate an AI tool's capabilities directly into their own applications and workflows.
Zero-shot means the model handles a task without any examples; few-shot means it is given a small number of examples in the prompt to guide its response.
Tool Info
Related Tools