# dbt Developer Hub > End user documentation, guides and technical reference for dbt - [The dbt Developer Hub](https://docs.getdbt.com/index.md) ## API Reference - [About the Discovery API](https://docs.getdbt.com/docs/dbt-apis/discovery-api.md): Every time runs a project, it generates and stores information about the project. The metadata includes details about your project’s models, sources, and other nodes along with their execution results. With the Discovery API, you can query this comprehensive information to gain a better understanding of your DAG and the data it produces. - [About the Discovery API schema](https://docs.getdbt.com/docs/dbt-apis/discovery-schema-about.md): With the Discovery API, you can query the metadata in dbt to learn more about your dbt deployments and the data they generate. You can analyze the data to make improvements. If you are new to the API, refer to About the Discovery API for an introduction. You might also find the use cases and examples helpful. - [Account-scoped personal access tokens](https://docs.getdbt.com/docs/dbt-apis/user-tokens.md): User API tokens have been deprecated and will no longer work. Migrate to personal access tokens to resume services. - [API rate limits](https://docs.getdbt.com/docs/dbt-apis/rate-limits.md): Learn how request limits apply when you use the dbt platform Administrative API, Discovery (GraphQL) API, SCIM provisioning, and remote MCP. - [APIs overview](https://docs.getdbt.com/docs/dbt-apis/overview.md): Learn how dbt accounts on the Enterprise-tier plans can query the dbt APIs. - [Applied object schema](https://docs.getdbt.com/docs/dbt-apis/discovery-schema-environment-applied.md): The applied object allows you to query information about a particular model based on environmentId. - [Authentication tokens](https://docs.getdbt.com/docs/dbt-apis/authentication.md): Learn how to authenticate with user tokens and service account tokens - [dbt Administrative API](https://docs.getdbt.com/docs/dbt-apis/admin-api.md): The Administrative API is enabled by default for Starter, Enterprise, and Enterprise+ plans. It can be used to: - [Definition object schema](https://docs.getdbt.com/docs/dbt-apis/discovery-schema-environment-definition.md): The definition object allows you to query the logical state of a given project node given its most recent manifest generated models. - [Environment object schema](https://docs.getdbt.com/docs/dbt-apis/discovery-schema-environment.md): You can use the environment object to query and compare definition (intended) and applied (actual) states for nodes (models, seeds, snapshots, models, and more) in your dbt project. For example, you specify an environmentId to learn more about a particular model (or other node type) in that environment. - [Exposure object schema](https://docs.getdbt.com/docs/dbt-apis/discovery-schema-job-exposure.md): The exposure object allows you to query information about a particular exposure. To learn more, refer to Add Exposures to your DAG. - [Exposure tile object schema](https://docs.getdbt.com/docs/dbt-apis/discovery-schema-environment-applied-exposure-tile.md): Exposure health tiles distill data health signals for data consumers and can be embedded in downstream tools. You can query information on these tiles from the Discovery API. - [Exposures object schema](https://docs.getdbt.com/docs/dbt-apis/discovery-schema-environment-applied-exposures.md): Exposures are dbt resources that represent downstream uses of your project, such as dashboards, applications, or data science pipelines. You can query exposures through the Discovery API to understand which assets depend on your models. - [Exposures object schema](https://docs.getdbt.com/docs/dbt-apis/discovery-schema-job-exposures.md): The exposures object allows you to query information about all exposures in a given job. To learn more, refer to Add Exposures to your DAG. - [GraphQL](https://docs.getdbt.com/docs/dbt-apis/sl-graphql.md): Integrate and use the GraphQL API to query your metrics. - [JDBC API](https://docs.getdbt.com/docs/dbt-apis/sl-jdbc.md): Integrate and use the JDBC API to query your metrics. - [Job object schema](https://docs.getdbt.com/docs/dbt-apis/discovery-schema-job.md): The job object allows you to query information about a particular model based on jobId and, optionally, a runId. - [Lineage object schema](https://docs.getdbt.com/docs/dbt-apis/discovery-schema-environment-applied-lineage.md): The lineage object allows you to query lineage across your resources. - [Model Historical Runs object schema](https://docs.getdbt.com/docs/dbt-apis/discovery-schema-environment-applied-modelHistoricalRuns.md): The model historical runs object allows you to query information about a model's run history. - [Model object schema](https://docs.getdbt.com/docs/dbt-apis/discovery-schema-job-model.md): The model object allows you to query information about a particular model in a given job. - [Models object schema](https://docs.getdbt.com/docs/dbt-apis/discovery-schema-environment-applied-models.md): Models are the foundational dbt resource that transform raw data into curated datasets using SQL (or Python). Each model represents a single SELECT statement, typically materialized as a table or view in your warehouse. You can query information about models through the Discovery API. - [Models object schema](https://docs.getdbt.com/docs/dbt-apis/discovery-schema-job-models.md): The models object allows you to query information about all models in a given job. - [Owners object schema](https://docs.getdbt.com/docs/dbt-apis/discovery-schema-environment-applied-owners.md): Owners help you identify the user or domain responsible for a dbt asset. For most assets, owners are defined in your project code using groups. Exposures are an exception: for downstream exposures that represent BI assets, owners are automatically pulled from the downstream tool based on who owns that asset. You can query ownership information through the Discovery API. - [Packages object schema](https://docs.getdbt.com/docs/dbt-apis/discovery-schema-environment-applied-packages.md): dbt packages are libraries with models, macros, and other resources that tackle a specific problem area utilized by dbt projects. You can query project packages through the Discovery API. - [Project state in dbt](https://docs.getdbt.com/docs/dbt-apis/project-state.md): provides a stateful way of deploying dbt. Artifacts are accessible programmatically via the Discovery API in the metadata platform. - [Python SDK](https://docs.getdbt.com/docs/dbt-apis/sl-python.md): Learn how to use the dbt Semantic Layer Python SDK library to interact with the dbt Semantic Layer. - [Query the Discovery API](https://docs.getdbt.com/docs/dbt-apis/discovery-querying.md): The Discovery API supports ad-hoc queries and integrations. If you are new to the API, refer to About the Discovery API for an introduction. - [Resources object schema](https://docs.getdbt.com/docs/dbt-apis/discovery-schema-environment-applied-resources.md): The resources object allows you to paginate across all resources in your environment. - [Seed object schema](https://docs.getdbt.com/docs/dbt-apis/discovery-schema-job-seed.md): The seed object allows you to query information about a particular seed in a given job. - [Seeds object schema](https://docs.getdbt.com/docs/dbt-apis/discovery-schema-environment-applied-seeds.md): Seeds are CSV files in your dbt project that dbt can load into your data warehouse. You can query seeds through the Discovery API. - [Seeds object schema](https://docs.getdbt.com/docs/dbt-apis/discovery-schema-job-seeds.md): The seeds object allows you to query information about all seeds in a given job. - [Semantic Layer APIs](https://docs.getdbt.com/docs/dbt-apis/sl-api-overview.md): Integrate and query metrics and dimensions in downstream tools using the Semantic Layer APIs - [Service account tokens](https://docs.getdbt.com/docs/dbt-apis/service-tokens.md): Service account tokens help you define permissions for securing access to your dbt account and its projects. - [Snapshots object schema](https://docs.getdbt.com/docs/dbt-apis/discovery-schema-environment-applied-snapshots.md): Snapshots represent point-in-time copies of your data, allowing you to track historical changes. You can query your snapshots from the Discovery API. - [Snapshots object schema](https://docs.getdbt.com/docs/dbt-apis/discovery-schema-job-snapshots.md): The snapshots object allows you to query information about all snapshots in a given job. - [Source object schema](https://docs.getdbt.com/docs/dbt-apis/discovery-schema-job-source.md): The source object allows you to query information about a particular source in a given job. - [Sources object schema](https://docs.getdbt.com/docs/dbt-apis/discovery-schema-environment-applied-sources.md): Sources make it possible to name and describe the data loaded into your warehouse by your extract and load tools. You can query sources through the Discovery API. - [Sources object schema](https://docs.getdbt.com/docs/dbt-apis/discovery-schema-job-sources.md): The sources object allows you to query information about all sources in a given job. - [Tags object schema](https://docs.getdbt.com/docs/dbt-apis/discovery-schema-environment-applied-tags.md): Tags provide a mechanism to categorize and group resources within a dbt project, enabling selective execution and management of these resources. You can query tags through the Discovery API. - [Test object schema](https://docs.getdbt.com/docs/dbt-apis/discovery-schema-job-test.md): The test object allows you to query information about a particular test. - [Tests object schema](https://docs.getdbt.com/docs/dbt-apis/discovery-schema-environment-applied-tests.md): Tests are assertions you make about your models and other resources in your dbt project. When you run dbt test, dbt will tell you if each test in your project passes or fails. You can query tests through the Discovery API to understand information about them. - [Tests object schema](https://docs.getdbt.com/docs/dbt-apis/discovery-schema-job-tests.md): The tests object allows you to query information about all tests in a given job. - [Use cases and examples for the Discovery API](https://docs.getdbt.com/docs/dbt-apis/discovery-use-cases-and-examples.md): With the Discovery API, you can query the metadata in to learn more about your dbt deployments and the data it generates to analyze them and make improvements. ## Best Practices - [Adding data-informed tests with dbt Wizard](https://docs.getdbt.com/best-practices/how-to-use-wizard/wizard-4-data-informed-tests.md): Use dbt Wizard CLI to find test coverage gaps, check assumptions against warehouse data, and add focused dbt data tests. - [Available materializations](https://docs.getdbt.com/best-practices/materializations/2-available-materializations.md): Read this guide to understand the different types of materializations you can create in dbt. - [Best practice guides](https://docs.getdbt.com/best-practices.md): Learn how dbt Labs approaches building projects through our current viewpoints on structure, style, and setup. - [Best practices](https://docs.getdbt.com/best-practices/how-we-build-our-metrics/semantic-layer-9-conclusion.md): Getting started with the dbt Semantic Layer - [Best practices for dbt and Unity Catalog](https://docs.getdbt.com/best-practices/dbt-unity-catalog-best-practices.md): Learn how to configure your. - [Best practices for materializations](https://docs.getdbt.com/best-practices/materializations/5-best-practices.md): Read this guide to understand the different types of materializations you can create in dbt. - [Best practices for workflows](https://docs.getdbt.com/best-practices/best-practice-workflows.md): This page contains the collective wisdom of experienced users of dbt on how to best use it in your analytics work. Observing these best practices will help your analytics team work as effectively as possible, while implementing the pro-tips will add some polish to your dbt projects! - [Building metrics](https://docs.getdbt.com/best-practices/how-we-build-our-metrics/semantic-layer-4-build-metrics.md): Getting started with the dbt Semantic Layer - [Building Semantic Layer definitions with dbt Wizard](https://docs.getdbt.com/best-practices/how-to-use-wizard/wizard-7-semantic-layer.md): Use dbt Wizard to plan, write, and validate Semantic Layer entities, dimensions, metrics, and saved queries. - [Building semantic models](https://docs.getdbt.com/best-practices/how-we-build-our-metrics/semantic-layer-3-build-semantic-models.md): Getting started with the dbt Semantic Layer - [Clone incremental models as the first step of your CI job](https://docs.getdbt.com/best-practices/clone-incremental-models.md): Learn how to define clone incremental models as the first step of your CI job. - [Conclusion](https://docs.getdbt.com/best-practices/materializations/7-conclusion.md): Read this conclusion to our guide on using materializations in dbt and how it is a crucial skill for effective analytics engineering. - [Configuring materializations](https://docs.getdbt.com/best-practices/materializations/3-configuring-materializations.md): Read this guide to understand how to configure materializations in dbt. - [Coordinating model versions](https://docs.getdbt.com/best-practices/how-we-mesh/mesh-6-coordinate-versions.md): Use this guide to coordinate producers and consumers when introducing model versions - [dbt Mesh FAQs](https://docs.getdbt.com/best-practices/how-we-mesh/mesh-5-faqs.md): Read the FAQs to learn more about dbt Mesh, how it works, compatibility, and more. - [Debugging a failed dbt job with dbt Wizard](https://docs.getdbt.com/best-practices/how-to-use-wizard/wizard-5-debug-failed-job.md): Use dbt Wizard CLI to gather job evidence, classify a failure, identify its root cause, and validate a proposed fix. - [Deciding how to structure your dbt Mesh](https://docs.getdbt.com/best-practices/how-we-mesh/mesh-3-structures.md): Getting started with dbt Mesh patterns - [Developing with production deferral in dbt Wizard](https://docs.getdbt.com/best-practices/how-to-use-wizard/wizard-6-production-deferral.md): Configure dbt Wizard CLI to reuse production state while developing and validating a subset of a dbt project. - [Don't nest your curlies](https://docs.getdbt.com/best-practices/dont-nest-your-curlies.md): Poetry - [Examining our builds](https://docs.getdbt.com/best-practices/materializations/6-examining-builds.md): Read this guide to understand how to examine your builds in dbt. - [Extending dbt Wizard with plugins and hooks](https://docs.getdbt.com/best-practices/how-to-use-wizard/wizard-8-plugins-hooks.md): Install dbt Wizard CLI plugins from marketplaces and review lifecycle hooks before allowing them to run. - [How to use Wizard in your dbt project](https://docs.getdbt.com/best-practices/how-to-use-wizard/wizard-1-intro.md): Recommended workflows for using dbt Wizard CLI on a real dbt project, from understanding a codebase to shipping and validating changes. - [How we structure our dbt projects](https://docs.getdbt.com/best-practices/how-we-structure/1-guide-overview.md): Learn how we structure our dbt projects. - [How we style our dbt models](https://docs.getdbt.com/best-practices/how-we-style/1-how-we-style-our-dbt-models.md): Fields and model names - [How we style our dbt projects](https://docs.getdbt.com/best-practices/how-we-style/0-how-we-style-our-dbt-projects.md): Why does style matter? - [How we style our Jinja](https://docs.getdbt.com/best-practices/how-we-style/4-how-we-style-our-jinja.md): Jinja style guide - [How we style our Python](https://docs.getdbt.com/best-practices/how-we-style/3-how-we-style-our-python.md): Python tooling - [How we style our SQL](https://docs.getdbt.com/best-practices/how-we-style/2-how-we-style-our-sql.md): Basics - [How we style our YAML](https://docs.getdbt.com/best-practices/how-we-style/5-how-we-style-our-yaml.md): YAML Style Guide - [Idempotence in dbt](https://docs.getdbt.com/best-practices/idempotence.md): Learn about best practices for configuring your dbt project to ensure idempotent results. - [Implementing your mesh plan](https://docs.getdbt.com/best-practices/how-we-mesh/mesh-4-implementation.md): Getting started with dbt Mesh patterns - [Incremental models in-depth](https://docs.getdbt.com/best-practices/materializations/4-incremental-models.md): Read this guide to understand the incremental models you can create in dbt. - [Incremental patterns for near real-time data](https://docs.getdbt.com/best-practices/how-we-handle-real-time-data/2-incremental-patterns.md): Learn how to implement incremental models with MERGE, CDC, and microbatch strategies for near real-time data processing - [Intermediate: Purpose-built transformation steps](https://docs.getdbt.com/best-practices/how-we-structure/3-intermediate.md): Purpose-built transformation steps. - [Intro to dbt Mesh](https://docs.getdbt.com/best-practices/how-we-mesh/mesh-1-intro.md): Getting started with dbt Mesh patterns - [Intro to the dbt Semantic Layer](https://docs.getdbt.com/best-practices/how-we-build-our-metrics/semantic-layer-1-intro.md): Getting started with the dbt Semantic Layer - [Lambda views for near real-time dashboards](https://docs.getdbt.com/best-practices/how-we-handle-real-time-data/4-lambda-views.md): Combine batch and real-time data in a single view for operational dashboards - [Marts: Business-defined entities](https://docs.getdbt.com/best-practices/how-we-structure/4-marts.md): Our guidance here diverges if you use the . In a project without the we recommend you denormalize heavily, per the best practices below. On the other hand, if you're using the , we want to stay as normalized as possible to allow MetricFlow the most flexibility. See The dbt Semantic Layer and marts for more information. - [Materializations best practices](https://docs.getdbt.com/best-practices/materializations/1-guide-overview.md): Read this guide to understand how using materializations in dbt is a crucial skill for effective analytics engineering. - [More advanced metrics](https://docs.getdbt.com/best-practices/how-we-build-our-metrics/semantic-layer-5-advanced-metrics.md): Getting started with the dbt Semantic Layer - [Near real-time data in dbt](https://docs.getdbt.com/best-practices/how-we-handle-real-time-data/1-intro.md): Learn how to achieve near real-time data freshness with dbt through streaming ingestion and frequent transformations - [Now it's your turn](https://docs.getdbt.com/best-practices/how-we-style/6-how-we-style-conclusion.md): BYO Styles - [Operational considerations for near real-time data](https://docs.getdbt.com/best-practices/how-we-handle-real-time-data/6-operational-considerations.md): Understand the challenges, risks, and costs of implementing near real-time data pipelines with dbt - [Optimize static analysis for development and deployment](https://docs.getdbt.com/best-practices/optimize-static-analysis-for-development-and-deployment.md): Configure Fusion static analysis with strict in development and baseline in deployment for stronger local checks and faster jobs. - [Refactor an existing rollup](https://docs.getdbt.com/best-practices/how-we-build-our-metrics/semantic-layer-8-refactor-a-rollup.md): Getting started with the dbt Semantic Layer - [Semantic structure](https://docs.getdbt.com/best-practices/how-we-build-our-metrics/semantic-layer-7-semantic-structure.md): Getting started with the dbt Semantic Layer - [Set up the dbt Semantic Layer](https://docs.getdbt.com/best-practices/how-we-build-our-metrics/semantic-layer-2-setup.md): Getting started with the dbt Semantic Layer - [Staging: Preparing our atomic building blocks](https://docs.getdbt.com/best-practices/how-we-structure/2-staging.md): Preparing our atomic building blocks. - [Tactical terminology](https://docs.getdbt.com/best-practices/how-we-build-our-metrics/semantic-layer-6-terminology.md): Getting started with the dbt Semantic Layer - [The rest of the project](https://docs.getdbt.com/best-practices/how-we-structure/5-the-rest-of-the-project.md): The rest of the project. - [Understanding a dbt project with dbt Wizard](https://docs.getdbt.com/best-practices/how-to-use-wizard/wizard-2-understand-project.md): Use dbt Wizard CLI to map an unfamiliar dbt project, investigate model behavior, and identify downstream impact. - [Validating dbt changes with dbt Wizard](https://docs.getdbt.com/best-practices/how-to-use-wizard/wizard-3-validate-changes.md): Use dbt Wizard to assess impact, run the right level of validation, and review a dbt change before merging it. - [Views-only pattern for maximum freshness](https://docs.getdbt.com/best-practices/how-we-handle-real-time-data/5-views-only-pattern.md): Preserve source table latency with lightweight view transformations - [Warehouse-native features for real-time data](https://docs.getdbt.com/best-practices/how-we-handle-real-time-data/3-warehouse-native-features.md): Learn when to use dynamic tables and materialized views instead of incremental models for near real-time data - [Who is dbt Mesh for?](https://docs.getdbt.com/best-practices/how-we-mesh/mesh-2-who-is-dbt-mesh-for.md): Understanding if dbt Mesh is the right fit for your team - [Writing custom generic data tests](https://docs.getdbt.com/best-practices/writing-custom-generic-tests.md): Learn how to define your own custom generic data tests. ## Category - [Account FAQs](https://docs.getdbt.com/category/accounts.md) - [Available flags](https://docs.getdbt.com/category/available-flags.md): The list of flags available in dbt. - [Behavior change flags](https://docs.getdbt.com/category/behavior-change-flags.md): Reference documentation for each dbt behavior change flag. - [Cost Insights FAQs](https://docs.getdbt.com/category/cost-optimizations.md) - [dbt Core FAQs](https://docs.getdbt.com/category/dbt-core.md) - [Documentation FAQs](https://docs.getdbt.com/category/documentation.md) - [Environments FAQs](https://docs.getdbt.com/category/environments.md) - [General configs](https://docs.getdbt.com/category/general-configs.md): The list of general configs available in dbt. - [General properties](https://docs.getdbt.com/category/general-properties.md): The list of general properties available in dbt. - [Git FAQs](https://docs.getdbt.com/category/git.md) - [Jinja FAQs](https://docs.getdbt.com/category/jinja.md) - [Jinja reference](https://docs.getdbt.com/category/jinja-reference.md): The list of Jinja functions and context variables available in dbt. - [List of commands](https://docs.getdbt.com/category/list-of-commands.md): The list of commands available in dbt. - [Models FAQs](https://docs.getdbt.com/category/models.md) - [Project configs](https://docs.getdbt.com/category/project-configs.md): The list of project configs available in dbt. - [Project FAQs](https://docs.getdbt.com/category/projects.md) - [Runs FAQs](https://docs.getdbt.com/category/runs.md) - [Seeds FAQs](https://docs.getdbt.com/category/seeds.md) - [Setting flags](https://docs.getdbt.com/category/setting-flags.md): The flags you can set to configure dbt. - [Snapshots FAQs](https://docs.getdbt.com/category/snapshots.md) - [Tests FAQs](https://docs.getdbt.com/category/tests.md) - [Troubleshooting FAQs](https://docs.getdbt.com/category/troubleshooting.md) - [Warehouse FAQs](https://docs.getdbt.com/category/warehouse.md) ## Community - [Become a contributor](https://docs.getdbt.com/community/contribute.md): Want to get involved? Start here - [Coding contributions](https://docs.getdbt.com/community/contributing/contributing-coding.md): Contribute to dbt Packages - [Community Forum guidelines](https://docs.getdbt.com/community/resources/forum-guidelines.md): What is the dbt Community Forum? - [Contributor License Agreements](https://docs.getdbt.com/community/resources/contributor-license-agreements.md): Why we have a CLA - [dbt Community Code of Conduct](https://docs.getdbt.com/community/resources/code-of-conduct.md): Learn about the community values that shape our rules, and review our anti-harassment policy. - [dbt Community Rules of the Road](https://docs.getdbt.com/community/resources/community-rules-of-the-road.md): This community is filled with smart, kind, and helpful people who share our commitment to elevating the analytics profession. These rules help everyone understand how to best participate. - [dbt Labs Community #jobs Channels Terms and Conditions](https://docs.getdbt.com/community/resources/jobs-terms-and-conditions.md): Before posting a job in the dbt Community or submitting an application, review these terms and conditions. - [Expectations for dbt contributors](https://docs.getdbt.com/community/resources/contributor-expectations.md): Whether it's dbt-core, adapters, packages, or this very documentation site, contributing to the open source or source-available code that supports the dbt ecosystem is a great way to share your knowledge, level yourself up as a developer, and to give back to the community. The goal of this page is to help you understand what to expect when contributing to dbt ecosystem projects. - [Getting help](https://docs.getdbt.com/community/resources/getting-help.md): Community help - [How to deliver a fantastic meetup talk](https://docs.getdbt.com/community/resources/speaking-at-a-meetup.md): Speaking at a dbt meetup? Here’s all the details you’ll need to know. If you’re speaking at another event, check out our additional tips at the end of the article. - [Join the Community](https://docs.getdbt.com/community/join.md): Want to learn how organizations around the world are tackling the biggest challenges in data while making new friends from the best analytics teams? Join the dbt Community — data practitioners’ favorite place to learn new skills, keep on top of industry trends, and forge connections. - [Maintaining a Slack channel](https://docs.getdbt.com/community/resources/maintaining-a-channel.md): There are three things you should do to be a good channel maintainer in the dbt Slack community - [Online community building](https://docs.getdbt.com/community/contributing/contributing-online-community.md): Maintaining a channel in the dbt Community Slack - [Open source and source-available projects](https://docs.getdbt.com/community/resources/oss-sa-projects.md): Looking for a good place to get involved contributing code? dbt Labs supports the following repositories, organized by the language primarily needed for contribution: - [Realtime event participation](https://docs.getdbt.com/community/contributing/contributing-realtime-events.md): Speak at a Meetup - [The dbt Viewpoint](https://docs.getdbt.com/community/resources/viewpoint.md): In 2015-2016, a team of folks at RJMetrics had the opportunity to observe, and participate in, a significant evolution of the analytics ecosystem. The seeds of dbt were conceived in this environment, and the viewpoint below was written to reflect what we had learned and how we believed the world should be different. dbt is our attempt to address the workflow challenges we observed, and as such, this viewpoint is the most foundational statement of the dbt project's goals. - [Tips for organizing inclusive events](https://docs.getdbt.com/community/resources/organizing-inclusive-events.md): The dbt community is filled with dedicated community leaders who create opportunities for connection, learning and professional development within the analytics community. - [Writing contributions](https://docs.getdbt.com/community/contributing/contributing-writing.md): Contribute to the product documentation ## Docs - [_wizard-cli-full-generated](https://docs.getdbt.com/docs/dbt-ai/_wizard-cli-full-generated.md): How to read this reference - [_wizard-slash-commands-generated](https://docs.getdbt.com/docs/dbt-ai/_wizard-slash-commands-generated.md): Slash commands - [2022 dbt platform release notes](https://docs.getdbt.com/docs/dbt-versions/2022-release-notes.md): dbt platform release notes for 2022 - [2023 dbt platform release notes](https://docs.getdbt.com/docs/dbt-versions/2023-release-notes.md): dbt platform release notes for 2023 - [2024 dbt platform release notes](https://docs.getdbt.com/docs/dbt-versions/2024-release-notes.md): 2024 dbt platform release notes - [2025 dbt platform release notes](https://docs.getdbt.com/docs/dbt-versions/2025-release-notes.md): 2025 dbt platform release notes - [About AI and dbt](https://docs.getdbt.com/docs/dbt-ai/about-dbt-ai.md): Learn about AI-powered features and agents in dbt that help you build, manage, and consume governed data at scale. - [About continuous integration (CI) in dbt](https://docs.getdbt.com/docs/deploy/about-ci.md): Use CI jobs in to set up automation for testing code changes before merging to production. Additionally, enable Advanced CI features for these jobs to evaluate whether the code changes are producing the appropriate data changes you want by reviewing the comparison differences dbt provides. - [About dbt Insights Beta](https://docs.getdbt.com/docs/explore/dbt-insights.md): Learn how to query data and perform exploratory data analysis using dbt Insights - [About dbt integrations](https://docs.getdbt.com/docs/platform-integrations/overview.md): Many data applications integrate with , enabling you to leverage the power of dbt for a variety of use cases and workflows. - [About dbt LSP](https://docs.getdbt.com/docs/about-dbt-lsp.md): Learn about the dbt language server protocol (LSP) features, including on-demand (lazy) compilation for faster editor startup. - [About dbt Mesh](https://docs.getdbt.com/docs/mesh/about-mesh.md): Getting started with dbt Mesh patterns - [About dbt Model Context Protocol (MCP) server](https://docs.getdbt.com/docs/dbt-ai/about-mcp.md): Learn about the dbt MCP server - [About dbt models](https://docs.getdbt.com/docs/build/models.md): Understand the role of dbt models transforming your data into analytics-ready datasets. - [About dbt projects](https://docs.getdbt.com/docs/build/projects.md): A dbt project informs dbt about the context of your project and how to transform your data (build your data sets). By design, dbt enforces the top-level structure of a dbt project such as the dbt_project.yml file, the models directory, the snapshots directory, and so on. Within the directories of the top-level, you can organize your project in any way that meets the needs of your organization and data pipeline. - [About dbt self-hosted installations](https://docs.getdbt.com/docs/local/about-local.md): dbt tools and resources that can be installed on your local machine - [About dbt State Preview](https://docs.getdbt.com/docs/deploy/dbt-state-about.md): Learn about dbt State, its benefits, and key concepts for running only what has changed in your dbt project. - [About dbt versions](https://docs.getdbt.com/docs/dbt-versions.md): Learn about semantic versioning for dbt engines, and how long those versions are supported. - [About documentation](https://docs.getdbt.com/docs/build/documentation.md): Learn how good documentation for your dbt models helps stakeholders discover and understand your datasets. - [About Hybrid projects](https://docs.getdbt.com/docs/deploy/hybrid-projects.md): Learn how to upload dbt Core artifacts into the dbt platform to create and set up hybrid projects. - [About Iceberg catalogs](https://docs.getdbt.com/docs/build/iceberg/about-catalogs.md): Understand technical data catalogs, and how they support dbt + Iceberg workflows - [About incremental models](https://docs.getdbt.com/docs/build/incremental-models-overview.md): This is an introduction on incremental models, when to use them, and how they work in dbt. - [About incremental strategy](https://docs.getdbt.com/docs/build/incremental-strategy.md): Incremental strategies for materializations optimize performance by defining how to handle new and changed data. - [About MetricFlow](https://docs.getdbt.com/docs/build/about-metricflow.md): Learn more about MetricFlow and its key concepts - [About microbatch incremental models](https://docs.getdbt.com/docs/build/incremental-microbatch.md): Learn about the 'microbatch' strategy for incremental models. - [About model governance](https://docs.getdbt.com/docs/mesh/govern/about-model-governance.md): Information about new features related to model governance - [About profiles.yml](https://docs.getdbt.com/docs/local/profiles.yml.md): The dbt profiles.yml file contains the connection details for your data warehouse. - [About state-aware orchestration Private preview](https://docs.getdbt.com/docs/deploy/state-aware-about.md): Learn about how state-aware orchestration automatically determines which models to build by detecting changes in code or data every time a job runs. - [About static analysis](https://docs.getdbt.com/docs/build/about-static-analysis.md): New concepts and configurations you will encounter when you install the dbt Fusion engine. - [About the --empty flag](https://docs.getdbt.com/docs/build/empty-flag.md): Use the empty flag to test your code and build your tables without populating data. - [About the --sample flag](https://docs.getdbt.com/docs/build/sample-flag.md): Use the sample flag to lower development time and reduce warehouse spend. - [About the dbt VS Code extension Preview](https://docs.getdbt.com/docs/about-dbt-extension.md): Bring all the speed and power of the self-hosted dbt Fusion engine to your local dbt development workflow. - [Access Catalog from dbt platform features](https://docs.getdbt.com/docs/explore/access-from-dbt-platform.md): Learn where and how to directly access and interact with Catalog from dbt platform features and products. - [Access the dbt Insights interface](https://docs.getdbt.com/docs/explore/access-dbt-insights.md): Learn how to access the dbt Insights interface and run queries - [Add data tests to your DAG](https://docs.getdbt.com/docs/build/data-tests.md): Configure dbt data tests to assess the quality of your input data and ensure accuracy in resulting datasets. - [Add Exposures to your DAG](https://docs.getdbt.com/docs/build/exposures.md): Exposures make it possible to define and describe a downstream use of your dbt project, such as in a dashboard, application, or data science pipeline. By defining exposures, you can then: - [Add groups to your DAG](https://docs.getdbt.com/docs/build/groups.md): A group is a collection of nodes within a dbt DAG. Groups are named, and every group has an owner. They enable intentional collaboration within and across teams by restricting access to private models. - [Add Seeds to your DAG](https://docs.getdbt.com/docs/build/seeds.md): Provide seed data files for your dbt models. - [Add snapshots to your DAG](https://docs.getdbt.com/docs/build/snapshots.md): Configure snapshots in dbt to track changes to your data over time. - [Add sources to your DAG](https://docs.getdbt.com/docs/build/sources.md): Define data source tables when developing in dbt. - [Administer the Semantic Layer](https://docs.getdbt.com/docs/use-dbt-semantic-layer/setup-sl.md): Seamlessly set up the credentials and tokens to start querying the dbt Semantic Layer. - [Advanced CI](https://docs.getdbt.com/docs/deploy/advanced-ci.md): Advanced CI enables developers to compare changes by demonstrating the changes the code produces. - [Advanced data modeling](https://docs.getdbt.com/docs/build/advanced-topics.md): Learn about advanced topics for dbt Semantic Layer and MetricFlow, such as modeling workflows and more. - [Analyses](https://docs.getdbt.com/docs/build/analyses.md): Configure SQL files in dbt to create compiled code used for analyses. - [Apache Iceberg support](https://docs.getdbt.com/docs/build/iceberg/apache-iceberg-support.md): Understand dbt platform support for Iceberg catalogs. - [Apache Ossie semantic layer documents](https://docs.getdbt.com/docs/build/ossie-semantic-models.md): Use Apache Ossie JSON documents to define semantic models and metrics in your dbt project. - [Artifacts](https://docs.getdbt.com/docs/deploy/artifacts.md): Use artifacts to power your automated docs site and source freshness data. - [Available dbt versions](https://docs.getdbt.com/docs/dbt-versions/about-versions.md): About the available versions of dbt in the CLI and dbt platform - [Available integrations](https://docs.getdbt.com/docs/platform-integrations/avail-sl-integrations.md): Discover the diverse range of partners that seamlessly integrate with the powerful dbt Semantic Layer, allowing you to query and unlock valuable insights from your data ecosystem. - [Available tools](https://docs.getdbt.com/docs/dbt-ai/mcp-available-tools.md): Complete list of tools available in the dbt MCP server. - [BigQuery and Apache Iceberg](https://docs.getdbt.com/docs/build/iceberg/adapters/bigquery-iceberg-support.md): Understand BigQuery support for Apache Iceberg. - [Build and view your docs with dbt](https://docs.getdbt.com/docs/explore/build-and-view-your-docs.md): Automatically generate project documentation as you run jobs. - [Build your metrics](https://docs.getdbt.com/docs/build/build-metrics-intro.md): Learn about MetricFlow and build your metrics with semantic models - [Cache common queries](https://docs.getdbt.com/docs/use-dbt-semantic-layer/sl-cache.md): Cache common queries to speed up performance and reduce query computation. - [Changelog 2019 and 2020](https://docs.getdbt.com/docs/dbt-versions/release-notes/dbt-cloud-changelog-2019-2020.md): 2019 and 2020 Changelog for the dbt Cloud application - [Changelog 2021](https://docs.getdbt.com/docs/dbt-versions/release-notes/dbt-cloud-changelog-2021.md): 2021 Changelog for the dbt Cloud application - [Column-level lineage](https://docs.getdbt.com/docs/explore/column-level-lineage.md): Use dbt Catalog's column-level lineage to gain insights about your data at a granular level. - [Community adapters](https://docs.getdbt.com/docs/community-adapters.md): Community adapters are adapter plugins contributed and maintained by members of the community. We welcome and encourage adapter plugins contributions from the dbt community. Please be mindful that these community maintainers are intrepid volunteers who donate their time and effort — so be kind, understanding, and help out where you can! - [Configure BYOK for dbt Wizard Beta](https://docs.getdbt.com/docs/dbt-ai/wizard-byok.md): Bring your own API key to use dbt Wizard CLI. Supports OpenAI, Anthropic, AWS Bedrock, Google Gemini, Snowflake Cortex (preview), and Databricks. - [Configure environment variables](https://docs.getdbt.com/docs/local/configure-environment-variables.md): Configure environment variables - [Configure incremental models](https://docs.getdbt.com/docs/build/incremental-models.md): Learn how to configure and optimize incremental models when developing in dbt. - [Configure your local environment](https://docs.getdbt.com/docs/configure-dbt-extension.md): Optimize your VS Code extension environment (files, env vars, connectivity). - [Configuring deferral in dbt State Preview](https://docs.getdbt.com/docs/deploy/dbt-state-deferral.md): Configure which environment dbt State defers to, including project and org disambiguation and deferral target customization. - [Connect dbt MCP server to dbt platform](https://docs.getdbt.com/docs/dbt-ai/mcp-quickstart-oauth.md): Set up dbt MCP server with your dbt platform account using OAuth or token-based authentication. - [Connect to adapters](https://docs.getdbt.com/docs/connect-adapters.md): Adapters are an essential component of dbt. At their most basic level, they are how dbt connects with the various supported data platforms. At a higher-level, adapters strive to give analytics engineers more transferrable skills as well as standardize how analytics projects are structured. Gone are the days where you have to learn a new language or flavor of SQL when you move to a new job that has a different data platform. That is the power of adapters in dbt — for more detail, refer to the Build, test, document, and promote adapters guide. - [Connect to the remote dbt MCP server](https://docs.getdbt.com/docs/dbt-ai/mcp-quickstart-remote.md): Connect to the remote dbt MCP server via HTTP with no installation required. - [Connection profiles](https://docs.getdbt.com/docs/local/connection-profiles.md): Configure the connection profile for your dbt project. - [Consume metrics from your Semantic Layer](https://docs.getdbt.com/docs/use-dbt-semantic-layer/consume-metrics.md): Learn how to query and consume metrics from your deployed dbt Semantic Layer using various tools and APIs. - [Continuous deployment in dbt](https://docs.getdbt.com/docs/deploy/continuous-deployment.md): Learn about continuous deployment (CD) workflows - [Continuous integration in dbt](https://docs.getdbt.com/docs/deploy/continuous-integration.md): Learn how CI checks validate changes before you deploy code to production. - [Continuous integration jobs in dbt](https://docs.getdbt.com/docs/deploy/ci-jobs.md): Learn how to create and set up CI checks to test code changes before deploying to production. - [Contribute a dbt Core v2.0 adapter](https://docs.getdbt.com/docs/contribute-core-adapters-v2.md): This guide is a work in progress — synthesized from internal Fusion v2 adapter team docs, DuckDB/ClickHouse reference implementations, the Exasol community adapter, and the v1 adapter creation guide. - [Contribute to dbt Core adapters](https://docs.getdbt.com/docs/contribute-core-adapters.md): Contribute to existing dbt Core adapters or open a pull request for a new v1 or v2 adapter. - [Conversion metrics](https://docs.getdbt.com/docs/build/conversion.md): Use Conversion metrics to measure conversion events. - [Cost Insights](https://docs.getdbt.com/docs/explore/cost-insights.md): Track warehouse compute costs and understand the impact of optimizations across your dbt projects and models. - [Creating metrics](https://docs.getdbt.com/docs/build/metrics-overview.md): Define metrics in your dbt project to create quantitative indicators. - [Cross-platform Mesh using Iceberg catalogs Beta](https://docs.getdbt.com/docs/mesh/cross-platform-mesh.md): Understand how Iceberg catalogs and dbt Mesh can combine to enable collaboration across multiple data platforms. - [Cumulative metrics](https://docs.getdbt.com/docs/build/cumulative.md): Use Cumulative metrics to aggregate a metric over a given window. - [Custom aliases](https://docs.getdbt.com/docs/build/custom-aliases.md): Configure custom aliases to override default naming conventions for models and other resources in dbt. - [Custom databases](https://docs.getdbt.com/docs/build/custom-databases.md): Different warehouses have different names for logical databases. The information in this document covers "databases" on Snowflake, Redshift, and Postgres; "projects" on BigQuery; and "catalogs" on Databricks Unity Catalog. - [Custom schemas](https://docs.getdbt.com/docs/build/custom-schemas.md): Configure custom schemas for your dbt model's tables and views in the database. - [Custom target names](https://docs.getdbt.com/docs/build/custom-target-names.md): You can define a custom target name for any dbt job to correspond to settings in your dbt project. - [Data health signals Preview](https://docs.getdbt.com/docs/explore/data-health-signals.md): Learn how data health signals offer a quick, at-a-glance view of data health when browsing your resources in dbt Catalog. - [Data health tile](https://docs.getdbt.com/docs/explore/data-tile.md): Embed data health tiles in your dashboards to distill data health signals for data consumers. - [Databricks and Apache Iceberg](https://docs.getdbt.com/docs/build/iceberg/adapters/databricks-iceberg-support.md): Understand Databricks support for Apache Iceberg. - [dbt AI FAQs](https://docs.getdbt.com/docs/dbt-ai/dbt-ai-faqs.md): Answers to common questions about dbt AI features, including dbt Wizard and dbt Copilot. - [dbt Catalog FAQs](https://docs.getdbt.com/docs/explore/dbt-explorer-faqs.md): Learn more with the FAQs about dbt Catalog, how it works, how to interact with it, and more. - [dbt Copilot](https://docs.getdbt.com/docs/dbt-ai/copilot-overview.md): dbt Copilot is dbt's inline AI assistance experience, providing single-click generation of SQL, documentation, tests, and semantic models. - [dbt Copilot in Insights Beta](https://docs.getdbt.com/docs/dbt-ai/analyst-agent.md): Chat with your data using the Analyst agent powered by the dbt Semantic Layer - [dbt licensing](https://docs.getdbt.com/docs/dbt-licensing.md): Learn about dbt Core and Fusion licensing. - [dbt platform compatible track - changelog](https://docs.getdbt.com/docs/dbt-versions/compatible-track-changelog.md): The Compatible release track updates once per month, and it includes up-to-date open source versions as of the monthly release. - [dbt release notes](https://docs.getdbt.com/docs/dbt-versions/release-notes.md): dbt release notes - [dbt Semantic Layer](https://docs.getdbt.com/docs/use-dbt-semantic-layer/dbt-sl.md): Learn how the dbt Semantic Layer enables data teams to centrally define and query metrics. - [dbt Semantic Layer architecture](https://docs.getdbt.com/docs/use-dbt-semantic-layer/sl-architecture.md): dbt Semantic Layer product architecture and related questions. - [dbt Semantic Layer FAQs](https://docs.getdbt.com/docs/use-dbt-semantic-layer/sl-faqs.md): Read the FAQs to learn more about the dbt Semantic Layer, how it works, how to build metrics, integrations, and more. - [dbt State trial and billing Preview](https://docs.getdbt.com/docs/deploy/dbt-state-trial.md): Learn about dbt State trial and billing. - [dbt support](https://docs.getdbt.com/docs/dbt-support.md): Support for dbt is available to all users through the following channels: - [dbt tips and tricks](https://docs.getdbt.com/docs/build/dbt-tips.md): Check out any dbt-related tips and tricks to help you work faster and be more productive. - [dbt VS Code extension features Preview](https://docs.getdbt.com/docs/dbt-extension-features.md): The dbt VS Code extension is backed by the dbt Fusion engine and a powerful LSP. - [dbt Wizard CLI Beta](https://docs.getdbt.com/docs/dbt-ai/about-dbt-wizard-cli.md): The dbt Wizard CLI helps teams ship higher-quality dbt changes faster and with less risk. - [dbt Wizard CLI data use and telemetry](https://docs.getdbt.com/docs/dbt-ai/wizard-telemetry.md): Understand what dbt Wizard CLI telemetry collects, why it is collected, and how to opt out. - [dbt Wizard command reference Beta](https://docs.getdbt.com/docs/dbt-ai/wizard-cli-reference.md): Full reference for all wizard subcommands and global flags. - [dbt Wizard config reference Beta](https://docs.getdbt.com/docs/dbt-ai/wizard-config.md): Full reference for both dbt Wizard configuration files — the agent runtime config and the per-project dbt Wizard settings. - [dbt Wizard in Studio IDE Preview](https://docs.getdbt.com/docs/dbt-ai/wizard-ide.md): Use dbt Wizard in the Studio IDE to write or refactor dbt models from natural language, validate with your dbt engine, and run against your warehouse with full project context. - [dbt Wizard in the dbt platform privacy and data Beta](https://docs.getdbt.com/docs/dbt-ai/wizard-platform-privacy-data.md): Understand how dbt Wizard in the dbt platform handles your privacy and data. - [dbt Wizard slash command reference Beta](https://docs.getdbt.com/docs/dbt-ai/wizard-slash-commands.md): Full reference for Wizard interactive TUI slash commands. - [dbt Wizard use cases](https://docs.getdbt.com/docs/dbt-ai/wizard-use-cases.md): Realistic analytics engineering scenarios for dbt Wizard — from building new models to debugging failures. - [Deploy dbt](https://docs.getdbt.com/docs/deploy/deployments.md): Use the 's capabilities to seamlessly run a dbt job in production or staging environments. Rather than run dbt commands manually from the command line, you can leverage the 's in-app scheduling to automate how and when you execute dbt. - [Deploy jobs](https://docs.getdbt.com/docs/deploy/deploy-jobs.md): Learn how to create and schedule deploy jobs in dbt for the scheduler to run. When you run with dbt, you get built-in observability, logging, and alerting. - [Deploy your metrics](https://docs.getdbt.com/docs/use-dbt-semantic-layer/deploy-sl.md): Deploy the dbt Semantic Layer in dbt by running a job to materialize your metrics. - [Deployment environments](https://docs.getdbt.com/docs/deploy/deploy-environments.md): Learn about dbt's deployment environment to seamlessly schedule jobs or enable CI. - [Derived metrics](https://docs.getdbt.com/docs/build/derived.md): Derived metrics is defined as an expression of other metrics - [Dimensions](https://docs.getdbt.com/docs/build/dimensions.md): Dimensions determine the level of aggregation for a metric, and are non-aggregatable expressions. - [Discover data with Catalog](https://docs.getdbt.com/docs/explore/explore-projects.md): Learn about Catalog and how to interact with it to understand, improve, and leverage your dbt projects. - [DuckDB and Apache Iceberg Beta](https://docs.getdbt.com/docs/build/iceberg/adapters/duckdb-iceberg-support.md): Understand DuckDB support for Apache Iceberg. - [Enabling dbt State in Studio Preview](https://docs.getdbt.com/docs/deploy/dbt-state-enable-studio.md): Enable dbt State in the dbt Studio IDE for faster development runs, either at the environment level or per user. - [Enabling dbt State on individual jobs Preview](https://docs.getdbt.com/docs/deploy/dbt-state-enable-jobs.md): Enable dbt State on specific jobs in dbt platform, whether existing or newly created. - [Enhance your code](https://docs.getdbt.com/docs/build/enhance-your-code.md): Learn how you can enhance your code - [Enhance your models](https://docs.getdbt.com/docs/build/enhance-your-models.md): Learn how you can enhance your models - [Entities](https://docs.getdbt.com/docs/build/entities.md): Entities are real-world concepts that correspond to key parts of your business, such as customers, transactions, and ad campaigns. - [Environment variables](https://docs.getdbt.com/docs/build/environment-variables.md): Use environment variables to customize the behavior of your dbt project. - [Example usage for dbt State Preview](https://docs.getdbt.com/docs/deploy/dbt-state-examples.md): Side-by-side dbt Core and dbt Core with dbt State execution scenarios using the Jaffle Shop project. - [Explore cost data](https://docs.getdbt.com/docs/explore/explore-cost-data.md): View warehouse costs, optimization impact, and model performance data across your project dashboard, model pages, and job details. - [Explore multiple projects](https://docs.getdbt.com/docs/explore/explore-multiple-projects.md): Learn about project-level lineage in dbt Catalog and its uses. - [Explore your data](https://docs.getdbt.com/docs/explore/explore-your-data.md): Explore your data, models, and other resources in dbt - [External metadata ingestion Preview](https://docs.getdbt.com/docs/explore/external-metadata-ingestion.md): Connect directly to your data warehouse, giving you visibility into tables, views, and other resources that aren't defined in dbt with dbt Catalog. - [Fill null values for metrics](https://docs.getdbt.com/docs/build/fill-nulls-advanced.md): Learn about advanced topics for dbt Semantic Layer and MetricFlow, such as modeling workflows and more. - [Frequently asked questions](https://docs.getdbt.com/docs/faqs.md): Our Frequently Asked Questions (FAQs) section is a space where you can find an answer to some questions we get asked a lot (but that we’re happy to answer!). If you have a question or are still stuck on something, just reach out to us by emailing support@getdbt.com or clicking on the chat widget, and we’ll do our best to help out. - [Fusion networking requirements Preview](https://docs.getdbt.com/docs/local/fusion-networking-requirements.md): Outbound network access requirements for the dbt Fusion engine, including adapter drivers, telemetry, and manifest downloads. - [Global navigation Preview](https://docs.getdbt.com/docs/explore/global-navigation.md): Learn how to enable and use global navigation to search, explore, and analyze data assets across all your dbt projects and connected metadata sources. - [Google Sheets](https://docs.getdbt.com/docs/platform-integrations/semantic-layer/gsheets.md): Integrate with Google Sheets to query your metrics in a spreadsheet. - [Headless mode Beta](https://docs.getdbt.com/docs/dbt-ai/wizard-headless.md): Run dbt Wizard in headless mode for scripts, CI pipelines, and automation. - [Hooks and operations](https://docs.getdbt.com/docs/build/hooks-operations.md): Customize dbt workflows using hooks and operations. - [How dbt Wizard works](https://docs.getdbt.com/docs/dbt-ai/wizard-how-it-works.md): Understand the dbt Wizard agent loop, tools, project context, and approval workflow. - [How to find your dbt MCP IDs](https://docs.getdbt.com/docs/dbt-ai/mcp-find-ids.md): Step-by-step instructions for finding the numeric IDs needed for dbt MCP configuration. - [Hybrid setup](https://docs.getdbt.com/docs/deploy/hybrid-setup.md): Learn how to set up hybrid projects in the dbt platform. - [Install dbt Core 2.0](https://docs.getdbt.com/docs/local/install-dbt-core-v2.md): Install dbt Core 2.0, the open-source foundation behind Fusion. - [Install dbt Wizard CLI Beta](https://docs.getdbt.com/docs/dbt-ai/wizard-cli.md): Install, verify, update, and uninstall the dbt Wizard CLI on your local machine. - [Install the dbt VS Code extension Preview](https://docs.getdbt.com/docs/install-dbt-extension.md): Installation instructions for the dbt extension. - [Integrate Claude with dbt MCP](https://docs.getdbt.com/docs/dbt-ai/integrate-mcp-claude.md): Guide to set up claude with dbt-mcp - [Integrate Cursor with dbt MCP](https://docs.getdbt.com/docs/dbt-ai/integrate-mcp-cursor.md): Guide to set up Cursor with dbt-mcp - [Integrate Snowflake Cortex agents with dbt MCP](https://docs.getdbt.com/docs/dbt-ai/integrate-mcp-snowflake-cortex.md): Connect a Snowflake Cortex agent to the remote dbt MCP server so it can query your dbt Semantic Layer. - [Integrate VS Code with MCP](https://docs.getdbt.com/docs/dbt-ai/integrate-mcp-vscode.md): Guide to set up VS Code with dbt-mcp - [Integrate with other orchestration tools](https://docs.getdbt.com/docs/deploy/deployment-tools.md): Alongside , discover other ways to schedule and run your dbt jobs with the help of tools such as the ones described on this page. - [Jinja and macros](https://docs.getdbt.com/docs/build/jinja-macros.md): Enhance your SQL with Jinja and macros when developing in dbt to create reusable, modular logic. - [Job commands](https://docs.getdbt.com/docs/deploy/job-commands.md): How to use dbt commands to set tasks for your dbt jobs. - [Job notifications](https://docs.getdbt.com/docs/deploy/job-notifications.md): Set up notifications in dbt to receive email or Slack alerts about job run status. - [Job scheduler](https://docs.getdbt.com/docs/deploy/job-scheduler.md): The dbt job scheduler queues scheduled or API-triggered runs, before preparing the job to enter cloud data platform. Build observability into transformation workflows with the in-app scheduling, logging, and alerting. - [Jobs in the dbt platform](https://docs.getdbt.com/docs/deploy/jobs.md): Learn about the different job types in dbt and what their differences are. - [Joins](https://docs.getdbt.com/docs/build/join-logic.md): Joins allow you to combine data from different tables and create new metrics - [Materializations](https://docs.getdbt.com/docs/build/materializations.md): Configure materializations in dbt to control how the SQL is run and resulting data is stored. - [MCP environment variables reference](https://docs.getdbt.com/docs/dbt-ai/mcp-environment-variables.md): Condensed reference for all dbt MCP environment variables. - [MCP troubleshooting](https://docs.getdbt.com/docs/dbt-ai/mcp-troubleshooting.md): Solutions for common issues when setting up and using dbt MCP. - [Measures](https://docs.getdbt.com/docs/build/measures.md): Measures are aggregations performed on columns in your model. - [Merge jobs in dbt](https://docs.getdbt.com/docs/deploy/merge-jobs.md): Learn how to trigger a dbt job run when a Git pull request merges. - [MetricFlow commands](https://docs.getdbt.com/docs/build/metricflow-commands.md): Query metrics and metadata in your dbt project with the MetricFlow commands. - [MetricFlow time spine](https://docs.getdbt.com/docs/build/metricflow-time-spine.md): MetricFlow expects a default time spine table called metricflow_time_spine - [Metrics as dimensions with metric filters](https://docs.getdbt.com/docs/build/ref-metrics-in-filters.md): Add metrics as dimensions to your metric filters to create more complex metrics and gain more insights. - [Microsoft Excel](https://docs.getdbt.com/docs/platform-integrations/semantic-layer/excel.md): Integrate with Excel to query your metrics in a spreadsheet. - [Migrate to dbt Wizard](https://docs.getdbt.com/docs/dbt-ai/wizard-migrate.md): Move project context and skills from Claude Code to dbt Wizard. - [Migrate to the latest YAML spec](https://docs.getdbt.com/docs/build/latest-metrics-spec.md): Learn how to migrate from the legacy metrics spec to the latest metrics spec. - [Migrating from state-aware orchestration to dbt State Preview](https://docs.getdbt.com/docs/deploy/dbt-state-migration.md): Step-by-step guide for migrating from state-aware orchestration to dbt State. - [Model access](https://docs.getdbt.com/docs/mesh/govern/model-access.md): Define model access with group capabilities - [Model contracts](https://docs.getdbt.com/docs/mesh/govern/model-contracts.md): Model contracts define a set of parameters validated during transformation - [Model notifications](https://docs.getdbt.com/docs/deploy/model-notifications.md): While a job is running, receive email notifications in real time about any issues with your models and tests. - [Model performance](https://docs.getdbt.com/docs/explore/model-performance.md): Learn about the performance of your models so you can make improvements to save time and money. - [Model query history](https://docs.getdbt.com/docs/explore/model-query-history.md): Import and auto-generate exposures from dashboards and understand how models are used in downstream tools for a richer lineage. - [Model versions](https://docs.getdbt.com/docs/mesh/govern/model-versions.md): Version models to help with lifecycle management - [Monitor dbt State activity Preview](https://docs.getdbt.com/docs/deploy/dbt-state-interface.md): Learn how to monitor dbt State activity in dbt platform for better visibility into model builds and cost savings. - [Monitor jobs and alerts](https://docs.getdbt.com/docs/deploy/monitor-jobs.md): Monitor your dbt job and set up alerts to ensure seamless orchestration and optimize your data transformations - [Navigate the dbt Insights interface](https://docs.getdbt.com/docs/explore/navigate-dbt-insights.md): Learn how to navigate the dbt Insights interface - [Navigating the state-aware interface](https://docs.getdbt.com/docs/deploy/state-aware-interface.md): Learn how to navigate the state-aware orchestration interface for better visibility into model builds and cost tracking. - [Optimize your dbt builds](https://docs.getdbt.com/docs/optimize-builds.md): Learn how dbt State, deferral, and dbt clone can help you build more efficiently. - [Orchestrate downstream exposures Beta](https://docs.getdbt.com/docs/platform-integrations/orchestrate-exposures.md): Use dbt to proactively refresh the underlying data sources (like Tableau extracts) during scheduled dbt jobs. - [Organize your outputs](https://docs.getdbt.com/docs/build/organize-your-outputs.md): Learn how you can organize your outputs - [Packages](https://docs.getdbt.com/docs/build/packages.md): dbt packages help modularize code and transform data efficiently. - [Parallel microbatch execution](https://docs.getdbt.com/docs/build/parallel-batch-execution.md): Learn about the 'parallel batch execution' strategy for incremental models. - [Power BI Preview](https://docs.getdbt.com/docs/platform-integrations/semantic-layer/power-bi.md): Use Power BI to query the dbt Semantic Layer and produce dashboards with trusted data. - [Preview new and experimental features in the dbt platform](https://docs.getdbt.com/docs/dbt-versions/experimental-features.md): Gain early access to many new dbt Labs experimental features by enabling this in your profile. - [Product lifecycles](https://docs.getdbt.com/docs/dbt-versions/product-lifecycles.md): Learn about dbt Labs' product lifecycles. - [Project dependencies](https://docs.getdbt.com/docs/mesh/govern/project-dependencies.md): Reference public models across dbt projects - [Project recommendations](https://docs.getdbt.com/docs/explore/project-recommendations.md): dbt Catalog provides recommendations that you can take to improve the quality of your dbt project. - [Project variables](https://docs.getdbt.com/docs/build/project-variables.md): Use dbt project variables to configure conditional or reusable logic across models and other resources. - [Python models](https://docs.getdbt.com/docs/build/python-models.md): Configure Python models to enhance your dbt project. - [Ratio metrics](https://docs.getdbt.com/docs/build/ratio.md): Use ratio metrics to create a ratio out of two metrics. - [Release tracks in dbt platform](https://docs.getdbt.com/docs/dbt-versions/dbt-release-tracks.md): Learn how to get automatic upgrades to dbt in the dbt platform. Access new features and enhancements as soon as they become available. - [Retry your dbt jobs](https://docs.getdbt.com/docs/deploy/retry-jobs.md): Rerun your errored jobs from start or the failure point. - [Run the self-hosted dbt MCP server](https://docs.getdbt.com/docs/dbt-ai/mcp-quickstart-cli.md): Set up the self-hosted dbt MCP server with dbt commands - [Run visibility](https://docs.getdbt.com/docs/deploy/run-visibility.md): Monitor your jobs to make performance improvements. - [Saved queries](https://docs.getdbt.com/docs/build/saved-queries.md): Saved queries are a way to save commonly used queries in MetricFlow. They can be used to save time and avoid writing the same query over and over again. - [Semantic models](https://docs.getdbt.com/docs/build/semantic-models.md): Semantic models are YAML abstractions on top of a dbt model, connected via joining keys as edges - [Set up automatic exposures in Tableau](https://docs.getdbt.com/docs/platform-integrations/downstream-exposures-tableau.md): Set up and visualize exposures automatically by auto-generating them from Tableau dashboards, helping you understand how models are used in downstream tools for a richer lineage. - [Set up Cost Insights](https://docs.getdbt.com/docs/explore/set-up-cost-insights.md): Learn how to set up Cost Insights to track warehouse compute costs and view realized savings from state-aware orchestration across your dbt projects and models. - [Set up remote MCP](https://docs.getdbt.com/docs/dbt-ai/setup-remote-mcp.md): Learn how to set up the remote dbt-mcp server - [Set up self-hosted MCP](https://docs.getdbt.com/docs/dbt-ai/setup-local-mcp.md): Learn how to set up the self-hosted dbt-mcp server - [Setting up dbt State for non-interactive environments Preview](https://docs.getdbt.com/docs/deploy/dbt-state-cicd.md): Learn how to configure dbt State authentication for CI/CD and other non-interactive environments using service tokens or OAuth client credentials. - [Setting up dbt State Preview](https://docs.getdbt.com/docs/deploy/dbt-state-setup.md): Learn how to install and configure dbt State across dbt Core, dbt platform, and Fusion. - [Setting up state-aware orchestration Private preview](https://docs.getdbt.com/docs/deploy/state-aware-setup.md): Set up state-aware orchestration to automatically determine which models to build by detecting changes in code or data every time a job runs. - [Sign in or register Preview](https://docs.getdbt.com/docs/sign-in-dbt-extension.md): Sign in or register to unlock advanced features in the dbt VS Code extension. - [Simple metrics](https://docs.getdbt.com/docs/build/simple.md): Use simple metrics to aggregate data directly from columns in your semantic models. - [Snowflake and Apache Iceberg](https://docs.getdbt.com/docs/build/iceberg/adapters/snowflake-iceberg-support.md): Understand Snowflake support for Apache Iceberg. - [Source freshness](https://docs.getdbt.com/docs/deploy/source-freshness.md): Validate that data freshness meets expectations and alert if stale. - [SQL models](https://docs.getdbt.com/docs/build/sql-models.md): SQL models are the building blocks of your dbt project. - [Supported data platforms](https://docs.getdbt.com/docs/supported-data-platforms.md): Connect dbt to any data platform in dbt, using a dedicated adapter plugin - [Tableau](https://docs.getdbt.com/docs/platform-integrations/semantic-layer/tableau.md): Use Tableau worksheets to query the dbt Semantic Layer and produce dashboards with trusted date. - [Trusted adapters](https://docs.getdbt.com/docs/trusted-adapters.md): Trusted adapters take part in the Trusted Adapter Program, including a commitment to meet the program's requirements. They are maintained by dbt Labs, partners, and community members. Trusted adapters in undergo an additional rigorous process that covers development, documentation, user experience, and maintenance requirements. We strongly recommend using them in production environments. For further details, refer to What it means to be trusted. - [Unit tests](https://docs.getdbt.com/docs/build/unit-tests.md): Implement unit tests to validate your dbt code. - [Upgrade to Fusion Preview](https://docs.getdbt.com/docs/upgrade-to-fusion-extension.md): Upgrade your dbt project to the Fusion engine from the VS Code extension. - [Upgrade versions in dbt platform](https://docs.getdbt.com/docs/dbt-versions/upgrade-dbt-platform-version.md): In , both jobs and environments are configured to use a specific version of . The version can be upgraded at any time. - [Upgrading to dbt utils v1.0](https://docs.getdbt.com/docs/dbt-versions/core-upgrade/Older versions/upgrading-to-dbt-utils-v1.0.md): New features and breaking changes to consider as you upgrade to dbt utils v1.0. - [Upgrading to v1.0](https://docs.getdbt.com/docs/dbt-versions/core-upgrade/Older versions/upgrading-to-v1.0.md): New features and changes in dbt Core v1.0 - [Upgrading to v1.1](https://docs.getdbt.com/docs/dbt-versions/core-upgrade/Older versions/upgrading-to-v1.1.md): New features and changes in dbt Core v1.1 - [Upgrading to v1.10](https://docs.getdbt.com/docs/dbt-versions/core-upgrade/upgrading-to-v1.10.md): New features and changes in dbt Core v1.10 - [Upgrading to v1.11](https://docs.getdbt.com/docs/dbt-versions/core-upgrade/upgrading-to-v1.11.md): New features and changes in dbt Core v1.11 - [Upgrading to v1.12](https://docs.getdbt.com/docs/dbt-versions/core-upgrade/upgrading-to-v1.12.md): New features and changes in dbt Core v1.12 - [Upgrading to v1.2](https://docs.getdbt.com/docs/dbt-versions/core-upgrade/Older versions/upgrading-to-v1.2.md): New features and changes in dbt Core v1.2 - [Upgrading to v1.3](https://docs.getdbt.com/docs/dbt-versions/core-upgrade/Older versions/upgrading-to-v1.3.md): New features and changes in dbt Core v1.3 - [Upgrading to v1.4](https://docs.getdbt.com/docs/dbt-versions/core-upgrade/Older versions/upgrading-to-v1.4.md): New features and changes in dbt Core v1.4 - [Upgrading to v1.5](https://docs.getdbt.com/docs/dbt-versions/core-upgrade/Older versions/upgrading-to-v1.5.md): New features and changes in dbt Core v1.5 - [Upgrading to v1.6](https://docs.getdbt.com/docs/dbt-versions/core-upgrade/Older versions/upgrading-to-v1.6.md): New features and changes in dbt Core v1.6 - [Upgrading to v1.7](https://docs.getdbt.com/docs/dbt-versions/core-upgrade/upgrading-to-v1.7.md): New features and changes in dbt Core v1.7 - [Upgrading to v1.8](https://docs.getdbt.com/docs/dbt-versions/core-upgrade/upgrading-to-v1.8.md): New features and changes in dbt Core v1.8 - [Upgrading to v1.9](https://docs.getdbt.com/docs/dbt-versions/core-upgrade/upgrading-to-v1.9.md): New features and changes in dbt Core v1.9 - [Upgrading to v2](https://docs.getdbt.com/docs/dbt-versions/core-upgrade/upgrading-to-v2.md): New features and changes in v2 - [Use dbt Wizard locally](https://docs.getdbt.com/docs/dbt-ai/wizard-quickstart.md): Install the dbt Wizard local CLI, complete first-run onboarding, and send your first prompt from the terminal. - [Use MCP servers with dbt Wizard in the dbt platform](https://docs.getdbt.com/docs/dbt-ai/wizard-platform-mcp.md): Understand MCP server support for dbt Wizard in the dbt platform. - [Use MCP servers with the dbt Wizard CLI Beta](https://docs.getdbt.com/docs/dbt-ai/wizard-mcp.md): Connect the dbt Wizard CLI to MCP servers to give it more tools and context. - [Use skills with dbt Wizard CLI Beta](https://docs.getdbt.com/docs/dbt-ai/wizard-skills.md): Create and use skills to give dbt Wizard CLI reusable, project-specific instructions. - [Use skills with dbt Wizard in the dbt platform Beta](https://docs.getdbt.com/docs/dbt-ai/wizard-platform-skills.md): Create and use skills to give dbt Wizard in the dbt platform reusable, project-specific instructions. - [Use subagents with dbt Wizard CLI Beta](https://docs.getdbt.com/docs/dbt-ai/wizard-subagents.md): Delegate work to specialized subagents in dbt Wizard CLI. - [Use subagents with dbt Wizard in the dbt platform Beta](https://docs.getdbt.com/docs/dbt-ai/wizard-platform-subagents.md): Delegate work to specialized subagents in dbt Wizard in the dbt platform. - [User-defined functions](https://docs.getdbt.com/docs/build/udfs.md): Learn how to add user-defined functions (UDFs) to your dbt projects. - [Using catalogs.yml](https://docs.getdbt.com/docs/build/iceberg/catalogs-yml.md): Understand how Iceberg catalogs fit into your dbt Mesh configurations. - [Validations](https://docs.getdbt.com/docs/build/validation.md): The Semantic Layer, powered by MetricFlow, has three types of built-in validations, including Parsing Validation, Semantic Validation, and Data Warehouse validation, which are performed in a sequential and blocking manner. - [Version compatibility Preview](https://docs.getdbt.com/docs/dbt-versions/fusion-version-compatibility.md): Understand how the dbt Fusion engine, language server, and VS Code extension versions map together, and how to verify compatible binaries. - [Version upgrade guides](https://docs.getdbt.com/docs/dbt-versions/core-upgrade.md): Learn what's new in the latest version of dbt. - [View documentation](https://docs.getdbt.com/docs/build/view-documentation.md): Learn how robust documentation for your dbt models helps stakeholders discover and understand your datasets. - [Visualize and orchestrate downstream exposures](https://docs.getdbt.com/docs/deploy/orchestrate-exposures.md): Learn how to use dbt to automatically generate downstream exposures from dashboards and proactively refresh the underlying data sources during scheduled dbt jobs. - [Visualize and orchestrate downstream exposures](https://docs.getdbt.com/docs/platform-integrations/downstream-exposures.md): Learn how to use dbt to automatically generate exposures from dashboards and proactively refresh the underlying data sources during scheduled dbt jobs. - [Visualize downstream exposures](https://docs.getdbt.com/docs/explore/view-downstream-exposures.md): Configure downstream exposures automatically from dashboards and understand how models are used in downstream tools for a richer downstream lineage. - [Webhooks for your jobs](https://docs.getdbt.com/docs/deploy/webhooks.md): Get real-time notifications about your dbt jobs with webhooks. - [Weekly dbt single-tenant release notes](https://docs.getdbt.com/docs/dbt-versions/dbt-platform-release-notes-gen.md): Release notes for weekly single-tenant updates. - [Write queries with exports](https://docs.getdbt.com/docs/use-dbt-semantic-layer/exports.md): Use exports to write tables to the data platform on a schedule. ## Faqs - [[Error] Could not find my_project package](https://docs.getdbt.com/faqs/Troubleshooting/dispatch-could-not-find-package.md): Macros missing from packages - [Account-specific features](https://docs.getdbt.com/faqs/Accounts/account-specific-features.md): Account-specific features - [Add a seed file](https://docs.getdbt.com/faqs/Project/add-a-seed.md): Learn how to add a seed file to your project - [Are the results of freshness stored anywhere?](https://docs.getdbt.com/faqs/Project/dbt-source-freshness.md): How to access Source Freshness results - [Are there any example dbt projects?](https://docs.getdbt.com/faqs/Project/example-projects.md): List of example dbt projects - [Branches when changing Git providers or repositories](https://docs.getdbt.com/faqs/Git/branch-migration.md): How Git branch names and commit history carry over when you change providers, repositories, or remotes—for dbt Core and the dbt platform, including platform-only notes for Studio IDE and repository settings. - [Can I add tests and descriptions in a SQL config block?](https://docs.getdbt.com/faqs/Project/properties-not-in-config.md): Types of properties defined in SQL config blocks - [Can I build my models in a schema other than my target schema or split my models across multiple schemas?](https://docs.getdbt.com/faqs/Models/model-custom-schemas.md): You can build models outside target schema - [Can I build my seeds in a schema other than my target schema or can I split my seeds across multiple schemas?](https://docs.getdbt.com/faqs/Seeds/seed-custom-schemas.md): Use schema config in your dbt_project.yml file - [Can I connect my dbt project to two databases?](https://docs.getdbt.com/faqs/Warehouse/connecting-to-two-dbs-not-allowed.md): Prepare your warehouse for dbt transformations - [Can I define private packages in the dependencies.yml file?](https://docs.getdbt.com/faqs/Project_ref/define-private-packages.md): Learn how to define private packages in your project - [Can I document things other than models, like sources, seeds, and snapshots?](https://docs.getdbt.com/faqs/Docs/document-other-resources.md): Using the description key to document resources - [Can I pay via invoice?](https://docs.getdbt.com/faqs/Accounts/payment-accepted.md): What payments types are accepted - [Can I set a different connection at the environment level?](https://docs.getdbt.com/faqs/Environments/diff-database-environment.md): Separate projects for different environments workaround - [Can I set test failure thresholds?](https://docs.getdbt.com/faqs/Tests/custom-test-thresholds.md): Use configs to set custom failure thresholds in tests - [Can I store my data tests in a directory other than the `tests` directory in my project?](https://docs.getdbt.com/faqs/Tests/configurable-data-test-path.md): Where to store data tests in a directory - [Can I store my models in a directory other than the `models` directory in my project?](https://docs.getdbt.com/faqs/Models/configurable-model-path.md): How to name models directory - [Can I store my seeds in a directory other than the `seeds` directory in my project?](https://docs.getdbt.com/faqs/Seeds/configurable-data-path.md): Where to store seeds in a directory - [Can I store my snapshots in a directory other than the `snapshot` directory in my project?](https://docs.getdbt.com/faqs/Accounts/configurable-snapshot-path.md): You can see how to change snapshots directory in your project - [Can I test the uniqueness of two columns?](https://docs.getdbt.com/faqs/Tests/uniqueness-two-columns.md): Options to test uniqueness of two columns - [Can I use a YAML file extension?](https://docs.getdbt.com/faqs/Project/yaml-file-extension.md): dbt will only search for files with a `.yml` file extension - [Can I use environment variables in my profile?](https://docs.getdbt.com/faqs/Environments/profile-env-vars.md): Use env_var in your profile - [Can I use seeds to load raw data?](https://docs.getdbt.com/faqs/Seeds/load-raw-data-with-seed.md): Use seeds to load business specific logic - [Can self-hosted GitLab instances only be connected via dbt Enterprise plans?](https://docs.getdbt.com/faqs/Git/gitlab-selfhosted.md): Self hosted GitLab instances plan availability - [Debug Snapshot target is not a snapshot table errors](https://docs.getdbt.com/faqs/Snapshots/snapshot-target-is-not-a-snapshot-table.md): Debugging Snapshot target is not a snapshot table - [Do hooks run with seeds?](https://docs.getdbt.com/faqs/Seeds/seed-hooks.md): Run hooks with seeds and configure them in project.yml file - [Do hooks run with snapshots?](https://docs.getdbt.com/faqs/Snapshots/snapshot-hooks.md): Run hooks with snapshots - [Do I need to add a YAML entry for column for it to appear in the docs site?](https://docs.getdbt.com/faqs/Docs/document-all-columns.md): All columns appear in your docs site - [Do I need to create my target schema before running dbt?](https://docs.getdbt.com/faqs/Models/create-a-schema.md): Target schema is checked or created for you before running dbt - [Do ref-able resource names need to be unique?](https://docs.getdbt.com/faqs/Project/unique-resource-names.md): Unique resource names to build dependencies - [Does dbt offer extract and load functionality?](https://docs.getdbt.com/faqs/Project/transformation-tool.md): dbt is a transformation tool - [Does dbt State support incremental models?](https://docs.getdbt.com/faqs/State/incremental-models.md): Learn how dbt State works with incremental models. - [Does my `.yml` file containing tests and descriptions need to be named `schema.yml`?](https://docs.getdbt.com/faqs/Project/schema-yml-name.md): Naming your Tests and Descriptions files - [Does my operating system have prerequisites?](https://docs.getdbt.com/faqs/Core/install-pip-os-prereqs.md.md): You can check whether your operating system has prerequisites for installing dbt Core. - [Does the Cost Insights feature incur warehouse costs?](https://docs.getdbt.com/faqs/Cost optimizations/metadata-warehouse-costs.md): Explanation of whether Cost Insights queries incur warehouse costs - [Errors importing a repository on dbt project set up](https://docs.getdbt.com/faqs/Troubleshooting/error-importing-repo.md): Errors importing a repository on dbt project set up - [GitLab token refresh message](https://docs.getdbt.com/faqs/Git/gitlab-token-refresh.md): Learn how to resolve GitLab token refresh messages during your CI jobs - [How can I connect dbt to a Google Source repository?](https://docs.getdbt.com/faqs/Git/google-cloud-repo.md): Use SSH URL method to connect to Google Source Repo - [How can I consolidate projects in dbt?](https://docs.getdbt.com/faqs/Project/consolidate-projects.md): Consolidating projects in dbt - [How can I fix my .gitignore file?](https://docs.getdbt.com/faqs/Git/gitignore.md): Use these instructions to fix your gitignore file - [How can I fix my .gitignore file?](https://docs.getdbt.com/faqs/Troubleshooting/gitignore.md): Use these instructions to fix your gitignore file - [How can I see the SQL that dbt is running?](https://docs.getdbt.com/faqs/Runs/checking-logs.md): Review logs to check the SQL dbt is running - [How can I set up the right permissions in BigQuery?](https://docs.getdbt.com/faqs/Warehouse/bq-impersonate-service-account-setup.md): Use service account to set up permissions in BigQuery - [How can I update my billing information?](https://docs.getdbt.com/faqs/Accounts/change-billing.md): Instructions on how to update your billing info - [How can we move our project from a managed repository, to a self-hosted repository?](https://docs.getdbt.com/faqs/Git/managed-repo.md): Email Support to request your managed repository - [How did dbt choose which schema to build my models in?](https://docs.getdbt.com/faqs/Project/which-schema.md): You can change your target schema in your Environment Settings. - [How do I access documentation in dbt Catalog?](https://docs.getdbt.com/faqs/Docs/sharing-documentation.md): Use read-only seats to share documentation - [How do I build one seed at a time?](https://docs.getdbt.com/faqs/Seeds/build-one-seed.md): Use select flag to build one seed at a time - [How do I change a user license type to read-only in dbt?](https://docs.getdbt.com/faqs/Accounts/change-user-license.md): Changing a user license type to read-only in dbt - [How do I create dependencies between models?](https://docs.getdbt.com/faqs/Models/create-dependencies.md): Using ref function to create dependencies - [How do I debug my Jinja?](https://docs.getdbt.com/faqs/Project/debugging-jinja.md): Using target folder or log function to debug Jinja - [How do I define a column type?](https://docs.getdbt.com/faqs/Project/define-a-column-type.md): Using cast function to define a column type - [How do I delete a project in dbt?](https://docs.getdbt.com/faqs/Project/delete-a-project.md): Deleting a project in dbt - [How do I delete a user in dbt?](https://docs.getdbt.com/faqs/Accounts/delete-users.md): Deleting a user in dbt - [How do I document macros?](https://docs.getdbt.com/faqs/Docs/documenting-macros.md): You can use a schema file to document macros - [How do I exclude a table from a freshness snapshot?](https://docs.getdbt.com/faqs/Project/exclude-table-from-freshness.md): Use null to exclude a table from a freshness snapshot - [How do I load data into my warehouse?](https://docs.getdbt.com/faqs/Warehouse/loading-data.md): Recommendations on tools to load data to warehouse - [How do I populate the owner column in the generated docs?](https://docs.getdbt.com/faqs/Docs/modify-owner-column.md): Modify owner column - [How do I preserve leading zeros in a seed?](https://docs.getdbt.com/faqs/Seeds/leading-zeros-in-seed.md): Use column types to include leading zeros in seed - [How do I remove deleted models from my data warehouse?](https://docs.getdbt.com/faqs/Models/removing-deleted-models.md): Remove deleted models directly in your data warehouse - [How do I run data tests on just my sources?](https://docs.getdbt.com/faqs/Tests/testing-sources.md): Use the select source command to test sources - [How do I run models downstream of a seed?](https://docs.getdbt.com/faqs/Runs/run-downstream-of-seed.md): You run models downstread using model selection syntax - [How do I run models downstream of one source?](https://docs.getdbt.com/faqs/Runs/running-model-downstream-of-source.md): Use source selector to run models downstream of a source - [How do I run one model at a time?](https://docs.getdbt.com/faqs/Runs/run-one-model.md): Use select flags to run one model at a time - [How do I run one snapshot at a time?](https://docs.getdbt.com/faqs/Runs/run-one-snapshot.md): Use select flags to run one snapshot at a time - [How do I set a datatype for a column in my seed?](https://docs.getdbt.com/faqs/Seeds/seed-datatypes.md): Use column_types to set a datatype - [How do I snapshot freshness for one source only?](https://docs.getdbt.com/faqs/Snapshots/snapshotting-freshness-for-one-source.md): Use select flag to snapshot for specific sources - [How do I specify column types?](https://docs.getdbt.com/faqs/Models/specifying-column-types.md): Specify column types in models - [How do I test and document seeds?](https://docs.getdbt.com/faqs/Tests/testing-seeds.md): Use a schema file to test and document seeds - [How do I test one model at a time?](https://docs.getdbt.com/faqs/Tests/test-one-model.md): Use select flag to test one model at a time - [How do I transfer account ownership to another user?](https://docs.getdbt.com/faqs/Accounts/transfer-account.md): Instructions on how to transfer your dbt user account to another user - [How do I troubleshoot if cost data isn't appearing?](https://docs.getdbt.com/faqs/Cost optimizations/troubleshooting-cost-data.md): Troubleshooting steps to resolve missing cost data in Cost Insights - [How do I use the 'Custom Branch' settings in a dbt Environment?](https://docs.getdbt.com/faqs/Environments/custom-branch-settings.md): Use custom code from your repository - [How do I write long-form explanations in my descriptions?](https://docs.getdbt.com/faqs/Docs/long-descriptions.md): Write long descriptions in your documentation - [How does dbt State calculate that a model has changed?](https://docs.getdbt.com/faqs/State/model-change-calculation.md): Learn how dbt State determines whether a model has meaningfully changed. - [How does increasing job frequency affect cost reduction estimates?](https://docs.getdbt.com/faqs/Cost optimizations/job-frequency.md): Explanation of how increasing run frequency affects cost reductions - [How is data stored in dbt State?](https://docs.getdbt.com/faqs/State/data-storage.md): Learn what data dbt State sends to dbt Labs servers and how it is stored. - [How is dbt State different from using state:modified?](https://docs.getdbt.com/faqs/State/state-modified-difference.md): Learn how dbt State compares to the state:modified selector in dbt Core. - [How often is cost data refreshed?](https://docs.getdbt.com/faqs/Cost optimizations/cost-data-refresh-frequency.md): Explanation of how often cost data is refreshed - [How often should I run the snapshot command?](https://docs.getdbt.com/faqs/Runs/snapshot-frequency.md): Snapshot command intended to run on hourly/daily schedule - [How should I structure my project?](https://docs.getdbt.com/faqs/Project/structure-a-project.md): Recommendations on how to structure project - [How to delete a job or environment in dbt?](https://docs.getdbt.com/faqs/Environments/delete-environment-job.md): How to delete a job or environment - [How to generate HAR files](https://docs.getdbt.com/faqs/Troubleshooting/generate-har-file.md): How to generate HAR files for debugging - [How to migrate git providers](https://docs.getdbt.com/faqs/Git/git-migration.md): Learn how to migrate git providers in dbt with minimal disruption. - [How to upgrade a dbt account](https://docs.getdbt.com/faqs/Accounts/platform-upgrade-instructions.md): Instructions for upgrading a dbt account after the trial ends. - [I got an "unused model configurations" error message, what does this mean?](https://docs.getdbt.com/faqs/Troubleshooting/unused-model-configurations.md): Model configurations error message - [I need to use quotes to select from my source, what should I do?](https://docs.getdbt.com/faqs/Models/source-quotes.md): Use quoting property to quote values - [I'm getting a "Partial parsing enabled: 1 files deleted, 0 files added, 2 files changed" compilation error in dbt?](https://docs.getdbt.com/faqs/Troubleshooting/partial-parsing-error.md): Delete partial_parse file - [I'm getting a "Session occupied" error in dbt CLI?](https://docs.getdbt.com/faqs/Troubleshooting/long-sessions-dbt-cli.md): How to debug long-running sessions in dbt CLI - [I'm receiving a 'This run exceeded your account's run memory limits' error in my failed job](https://docs.getdbt.com/faqs/Troubleshooting/job-memory-limits.md): Use incremental models or optimize queries for job failures due to exceeded memory limits. - [I'm receiving a "Permission denied while getting Drive credential" error when trying to query from Google Drive?](https://docs.getdbt.com/faqs/Troubleshooting/access-gdrive-credential.md): Grant BigQuery service account access - [I'm receiving a 403 error 'Forbidden: Access denied' when using service tokens](https://docs.getdbt.com/faqs/Troubleshooting/ip-restrictions.md): All service token traffic is now subject to IP restrictions. To resolve 403 errors, add your third-party integration CIDRs (network addresses) to the allowlist. - [I'm receiving a git rev-list master error in the IDE?](https://docs.getdbt.com/faqs/Troubleshooting/git-revlist-error.md): Primary branch not recognized - [I'm receiving a NoneType object has no attribute error in the IDE?](https://docs.getdbt.com/faqs/Troubleshooting/nonetype-ide-error.md): Copy SSH key to your warehouse - [I'm receiving a Runtime Error Could not find profile named 'user' error?](https://docs.getdbt.com/faqs/Troubleshooting/runtime-error-could-not-find-profile.md): Re-authorize your credentials in Your profile - [I'm receiving an 'Your IDE session experienced an unknown error and was terminated. Please contact support'.](https://docs.getdbt.com/faqs/Troubleshooting/ide-session-unknown-error.md): Add a repository when seeing IDE unknown error - [I'm receiving an `Failed ALPN` error when trying to connect to the dbt Semantic Layer.](https://docs.getdbt.com/faqs/Troubleshooting/sl-alpn-error.md): To resolve the 'Failed ALPN' error in the dbt Semantic Layer, create a SSL interception exception for the dbt domain. - [I'm seeing a 'GitHub and dbt latest permissions' error](https://docs.getdbt.com/faqs/Git/github-permissions.md): GitHub and dbt permissions error - [I'm seeing a Gitlab authentication out of date error loop](https://docs.getdbt.com/faqs/Git/gitlab-authentication.md): GitLab and dbt deploy key mismatch - [I'm seeing a Gitlab authentication out of date error loop](https://docs.getdbt.com/faqs/Troubleshooting/gitlab-authentication.md): GitLab and dbt deploy key mismatch - [If I can name these files whatever I'd like, what should I name them?](https://docs.getdbt.com/faqs/Project/resource-yml-name.md): Recommendations on how to name your files - [If I rerun dbt, will there be any downtime as models are rebuilt?](https://docs.getdbt.com/faqs/Models/run-downtime.md): No downtime when re-building models in dbt - [If models can only be `select` statements, how do I insert records?](https://docs.getdbt.com/faqs/Models/insert-records.md): Incremental models to insert records - [My compiled SQL has a lot of spaces and new lines, how can I get rid of it?](https://docs.getdbt.com/faqs/Jinja/jinja-whitespace.md): Managing whitespace control - [One of my tests failed, how can I debug it?](https://docs.getdbt.com/faqs/Runs/failed-tests.md): You can debug failed tests by finding the SQL - [Receiving a 'Could not parse dbt_project.yml' error in dbt job](https://docs.getdbt.com/faqs/Troubleshooting/could-not-parse-project.md): Receiving a 'Could not parse dbt_project.yml' error in dbt? This error is typically caused by a tab indentation in your dbt_project.yml file. - [Receiving a `Failed to connect to DB` error when connecting to Snowflake](https://docs.getdbt.com/faqs/Troubleshooting/failed-snowflake-oauth-connection.md): Edit your OAuth Security integration when you see error - [Reconnecting to Snowflake OAuth after authentication expires](https://docs.getdbt.com/faqs/Troubleshooting/refresh-snowflake-oauth-credentials.md): The `authentication has expired` error happens because Snowflake requires tools to renew their OAuth connection at least every 90 days. - [Should I use separate files to declare resource properties, or one large file?](https://docs.getdbt.com/faqs/Project/multiple-resource-yml-files.md): Structuring your files and project - [Studio IDE freezes when opening the Lineage tab](https://docs.getdbt.com/faqs/Troubleshooting/studio-ide-freezes-lineage-tab.md): Workarounds for Studio IDE freezing or becoming unresponsive when the Lineage tab is active, especially with large models or multiple open model tabs. - [The columns of my seed changed, and now I get an error when running the `seed` command, what should I do?](https://docs.getdbt.com/faqs/Seeds/full-refresh-seed.md): Rerun the command with a `--full-refresh` flag - [Unable to trigger a CI job with GitLab](https://docs.getdbt.com/faqs/Troubleshooting/gitlab-webhook.md): Unable to trigger a CI job - [What are the best practices for installing dbt Core with pip?](https://docs.getdbt.com/faqs/Core/install-pip-best-practices.md.md): Instructions on how to install dbt Core with pip - [What data tests are available for me to use in dbt?](https://docs.getdbt.com/faqs/Tests/available-tests.md): Types of data tests to use in dbt - [What data tests should I add to my project?](https://docs.getdbt.com/faqs/Tests/recommended-tests.md): Recommended data tests for project - [What happened to state-aware orchestration?](https://docs.getdbt.com/faqs/Runs/what-happened-to-sao.md): Learn why state-aware orchestration is no longer available to new customers and how to adopt dbt State instead. - [What happens if dbt State servers fail?](https://docs.getdbt.com/faqs/State/server-failure.md): Learn how dbt State handles server outages. - [What happens if I add new columns to my snapshot query?](https://docs.getdbt.com/faqs/Snapshots/snapshot-schema-changes.md): Reconcile changes when adding new columns in snapshot query - [What happens if one of my runs fails?](https://docs.getdbt.com/faqs/Runs/failed-prod-run.md): Set up notifications to debug failed runs - [What happens if the SQL in my query is bad or I get a database error?](https://docs.getdbt.com/faqs/Troubleshooting/sql-errors.md): Use error message and logs to debug - [What if I work on multiple projects that each use their own dbt State?](https://docs.getdbt.com/faqs/State/multiple-projects.md): Learn how to configure dbt State when working across multiple projects. - [What if my prod environment isn't named prod?](https://docs.getdbt.com/faqs/State/non-prod-environment.md): Learn how to specify a custom defer-to environment for dbt State. - [What if my source is in a different database to my target database?](https://docs.getdbt.com/faqs/Project/source-in-different-database.md): Use database property to define source in a diff database - [What if my source is in a poorly named schema or table?](https://docs.getdbt.com/faqs/Project/source-has-bad-name.md): Use schema and identifier properities to define names - [What materializations are available in dbt?](https://docs.getdbt.com/faqs/Models/available-materializations.md): dbt ships with five built-in materializations - [What model configurations exist?](https://docs.getdbt.com/faqs/Models/available-configurations.md): Learning about model configurations - [What parts of Jinja are dbt-specific?](https://docs.getdbt.com/faqs/Accounts/dbt-specific-jinja.md): You can check which Jinja functions are dbt-specific - [What privileges does my database user need to use dbt?](https://docs.getdbt.com/faqs/Warehouse/database-privileges.md): Database privileges to use dbt - [What should I name my profile?](https://docs.getdbt.com/faqs/Environments/profile-name.md): Use company name for profile name - [What should I name my target?](https://docs.getdbt.com/faqs/Environments/target-names.md): Using targets to clarify development and production runs - [What should my profiles.yml file look like for my warehouse?](https://docs.getdbt.com/faqs/Warehouse/sample-profiles.md): Go to Profile Set up to see the structure of a profile - [What version of Python can I use?](https://docs.getdbt.com/faqs/Core/install-python-compatibility.md): Python versions supported with dbt Core - [When should I run my data tests?](https://docs.getdbt.com/faqs/Tests/when-to-test.md): Run data tests in production or when writing new code - [When should I use a UDF instead of a macro?](https://docs.getdbt.com/faqs/Project/udfs-vs-macros.md): Guidance on choosing between UDFs and macros - [Where can I find my user ID?](https://docs.getdbt.com/faqs/Accounts/find-user-id.md): Instructions on where to find your user id - [Where can I find SCIM FAQs and troubleshooting?](https://docs.getdbt.com/faqs/Accounts/scim-faq.md): Common questions and troubleshooting for SCIM provisioning in dbt platform - [Where can I find SSO FAQs and troubleshooting?](https://docs.getdbt.com/faqs/Accounts/sso-faq.md): Common questions and troubleshooting for single sign-on (SSO) in dbt platform - [Where does the metadata about last updated timestamp come from?](https://docs.getdbt.com/faqs/State/last-updated-timestamp.md): Learn where dbt State gets last updated timestamp metadata. - [Which docs should I use when writing Jinja or creating a macro?](https://docs.getdbt.com/faqs/Jinja/which-jinja-docs.md): Useful Jinja docs - [Which materialization should I use for my model?](https://docs.getdbt.com/faqs/Project/which-materialization.md): Recommendations on materializations to use for models - [Which SQL dialect should I write my models in? Or which SQL dialect does dbt use?](https://docs.getdbt.com/faqs/Models/sql-dialect.md): Use SQL dialect of your own database - [Why am I getting an "account in use" error?](https://docs.getdbt.com/faqs/Accounts/git-account-in-use.md): What to do when you receive a Git account in use error - [Why am I receiving a Runtime Error in my packages?](https://docs.getdbt.com/faqs/Troubleshooting/runtime-packages.yml.md): Update dbt_utils package in packages.yml file - [Why are profiles stored outside of my project?](https://docs.getdbt.com/faqs/Project/separate-profile.md): Profiles stored outside version control - [Why can't I just write DML in my transformations?](https://docs.getdbt.com/faqs/Project/why-not-write-dml.md): Using SQL in your transformations instead of DML. - [Why dbt compile needs a data platform connection](https://docs.getdbt.com/faqs/Warehouse/db-connection-dbt-compile.md): `dbt compile` needs a data platform connection because the work it does depends on the current state of your warehouse - [Why do I need to quote column names in Jinja?](https://docs.getdbt.com/faqs/Jinja/quoting-column-names.md): Use quotes to pass string - [Why do model and source YAML files always start with `version: 2`?](https://docs.getdbt.com/faqs/Project/why-version-2.md): .yml file structure more extensible with version 2. - [Why does my dbt output have so many macros in it?](https://docs.getdbt.com/faqs/Project/why-so-many-macros.md): Your dbt project includes many macros. - [Why does the BigQuery OAuth application require scopes to Google Drive?](https://docs.getdbt.com/faqs/Warehouse/bq-oauth-drive-scope.md): Learn more about Google Drive scopes in the BigQuery OAuth application - [Why doesn’t an indirectly referenced upstream public model appear in Explorer?](https://docs.getdbt.com/faqs/Project_ref/indirectly-reference-upstream-model.md): Learn why an indirectly referenced upstream public models don't appear in Explorer - [Why is my model being rebuilt instead of reused?](https://docs.getdbt.com/faqs/State/views-rebuilt.md): Learn the common reasons dbt State rebuilds models instead of reusing them. - [Why is Run on Pull request grayed out?](https://docs.getdbt.com/faqs/Git/run-on-pull.md): Use the GitHub auth method to enable Rull on Pull request - [Why might my actual warehouse costs differ from displayed costs?](https://docs.getdbt.com/faqs/Cost optimizations/actual-vs-displayed-costs.md): Explanation of why actual warehouse costs may differ from displayed costs - [Why would I want to impersonate a service account?](https://docs.getdbt.com/faqs/Warehouse/bq-impersonate-service-account-why.md): Build models using dedicated service account ## Fusion - [About dbt Core](https://docs.getdbt.com/docs/fusion/about-core.md): Learn what dbt Core is and when to use it. - [About profiles.yml](https://docs.getdbt.com/docs/fusion/connect-data-platform-fusion/profiles.yml.md): The dbt profiles.yml file contains the connection details for your data warehouse. - [About the dbt Fusion engine](https://docs.getdbt.com/docs/fusion/about-fusion.md): Fusion is the next-generation engine for dbt. - [Arrow ADBC and Fusion](https://docs.getdbt.com/docs/fusion/adbc.md): This document provides technical guidance for dbt partners and vendors on how to design, build, and maintain ADBC (Apache Arrow Database Connectivity) drivers for , the new dbt engine. - [BigQuery setup Preview](https://docs.getdbt.com/docs/fusion/connect-data-platform-fusion/bigquery-setup.md): Read this guide to learn about the BigQuery warehouse setup in dbt Fusion. - [Compare changes during development Beta](https://docs.getdbt.com/docs/fusion/vs-compare-changes.md): Compare how code edits will change your data while you develop your dbt platform project locally with the dbt VS Code extension. - [Connection profiles](https://docs.getdbt.com/docs/fusion/connect-data-platform-fusion/connection-profiles.md): Configure the connection profile for your dbt project in Fusion. - [Databricks setup Private preview](https://docs.getdbt.com/docs/fusion/connect-data-platform-fusion/databricks-setup.md): Read this guide to learn about the Databricks warehouse setup in dbt Fusion. - [Fusion availability](https://docs.getdbt.com/docs/fusion/fusion-availability.md): Learn where Fusion is available and what you get with dbt. - [Fusion readiness checklist](https://docs.getdbt.com/docs/fusion/fusion-readiness.md): Your to-do list for preparing for Fusion - [Fusion releases Preview](https://docs.getdbt.com/docs/fusion/fusion-releases.md): Track current versions and release history for the dbt Fusion engine. - [Get started with Fusion](https://docs.getdbt.com/docs/fusion/get-started-fusion.md): Start using the Fusion engine locally to take data transformation to the next level. - [Redshift setup Preview](https://docs.getdbt.com/docs/fusion/connect-data-platform-fusion/redshift-setup.md): Read this guide to learn about the Redshift warehouse setup in dbt Fusion. - [Salesforce Data 360 setup Beta](https://docs.getdbt.com/docs/fusion/connect-data-platform-fusion/salesforce-data-cloud-setup.md): Read this guide to learn about the Salesforce Data 360 warehouse setup in dbt. - [Snowflake setup Preview](https://docs.getdbt.com/docs/fusion/connect-data-platform-fusion/snowflake-setup.md): Read this guide to learn about the Snowflake warehouse setup in dbt Fusion. - [Supported features](https://docs.getdbt.com/docs/fusion/supported-features.md): Feature support and parity information for dbt. ## Getting Started - [dbt platform configuration checklist](https://docs.getdbt.com/docs/configuration-checklist.md): Your to-do list for setting up your dbt platform account - [dbt Quickstarts](https://docs.getdbt.com/docs/get-started-dbt.md): Begin your dbt journey by choosing how you want to develop: - [What is dbt?](https://docs.getdbt.com/docs/introduction.md): dbt transforms raw warehouse data into trusted data products and brings purpose-built AI to every stage of the analytics development lifecycle. ## Guides - [Airflow and dbt](https://docs.getdbt.com/guides/airflow-and-dbt-cloud.md): Introduction - [Analyze your data in dbt](https://docs.getdbt.com/guides/analyze-your-data.md): Introduction - [Browse our guides](https://docs.getdbt.com/guides.md) - [Browse our guides](https://docs.getdbt.com/guides/_config.md): The dbt platform is the fastest and most reliable way to deploy dbt for scalable data transformation, while dbt Core powers open-source transformation workflows. Together, they provide a seamless analytics engineering experience. Explore our step-by-step guides, quickstart tutorials, and troubleshooting resources to get started with dbt and your data platform. - [Build a data lakehouse with dbt Core and Dremio Cloud](https://docs.getdbt.com/guides/build-dremio-lakehouse.md): Learn how to build a data lakehouse with dbt Core and Dremio Cloud. - [Build, test, document, and promote adapters](https://docs.getdbt.com/guides/adapter-creation.md): Create an adapter that connects dbt to you platform, and learn how to maintain and version that adapter. - [Building dbt packages](https://docs.getdbt.com/guides/building-packages.md): When you have dbt code that might help others, you can create a package for dbt using a GitHub repository. - [Clone the Jaffle Shop sample project](https://docs.getdbt.com/guides/clone-jaffle-shop.md): Clone the Jaffle Shop sample dbt project from GitHub or GitLab. - [Connect dbt MCP to dbt platform](https://docs.getdbt.com/guides/qs-mcp-oauth.md) - [Contribute a dbt Core 2.0 adapter](https://docs.getdbt.com/guides/adapter-creation-v2.md): Learn how to contribute a new community adapter to the dbt Core 2.0 Rust monorepo, from ADBC driver registration to SQL macros. - [Create Datadog events from dbt results](https://docs.getdbt.com/guides/serverless-datadog.md): Configure a serverless app to add dbt events to Datadog logs. - [Create new materializations](https://docs.getdbt.com/guides/create-new-materializations.md): Learn how to create your own materializations. - [Customize dbt models database, schema, and alias](https://docs.getdbt.com/guides/customize-schema-alias.md): Learn how to properly adjust your generate_schema_name() and generate_alias_name() macros. - [Customizing CI/CD with custom pipelines](https://docs.getdbt.com/guides/custom-cicd-pipelines.md): Learn the benefits of version-controlled analytics code and custom pipelines in dbt for enhanced code testing and workflow automation during the development process. - [Debug errors](https://docs.getdbt.com/guides/debug-errors.md): Learn about errors and the art of debugging them. - [Debug schema names](https://docs.getdbt.com/guides/debug-schema-names.md): Learn how to debug schema names when models build under unexpected schemas. - [Fusion package upgrade guide](https://docs.getdbt.com/guides/fusion-package-compat.md): Learn how to upgrade your packages to be compatible with the dbt Fusion engine. - [Get hands-on with Apache Iceberg and local compute](https://docs.getdbt.com/guides/iceberg.md): Run dbt transformations across Snowflake and DuckDB against one shared set of Apache Iceberg tables, warehouse-free and with no data copies. - [Get started with Continuous Integration tests](https://docs.getdbt.com/guides/set-up-ci.md): Implement a CI environment for safe project validation. - [Getting started with the terminal](https://docs.getdbt.com/guides/terminal-guide.md): A short intro to the terminal for dbt users — learn how to open it, navigate folders, and run your first dbt commands. - [How to use prompts for dbt Wizard](https://docs.getdbt.com/guides/prompt-cookbook.md): A cookbook of prompts and real-world examples to use dbt Wizard efficiently. - [Hybrid development with dbt platform and Fusion](https://docs.getdbt.com/guides/fusion-platform-local-workflow.md): Introduction - [Integrate with dbt Semantic Layer using best practices](https://docs.getdbt.com/guides/sl-partner-integration-guide.md): Learn about partner integration guidelines, roadmap, and connectivity. - [Leverage dbt to generate analytics and ML-ready pipelines with SQL and Python with Snowflake](https://docs.getdbt.com/guides/dbt-python-snowpark.md): Leverage dbt to generate analytics and ML-ready pipelines with SQL and Python with Snowflake - [Migrate between dbt platform tenancy types](https://docs.getdbt.com/guides/tenancy-migration.md): A self-serve guide for migrating between dbt platform tenancy types, such as moving from multi-tenant to single-tenant. - [Migrate from dbt-spark to dbt-databricks](https://docs.getdbt.com/guides/migrate-from-spark-to-databricks.md): Learn how to migrate from dbt-spark to dbt-databricks. - [Migrate from DDL, DML, and stored procedures](https://docs.getdbt.com/guides/migrate-from-stored-procedures.md): Learn how to transform from a historical codebase of mixed DDL and DML statements to dbt models, including tips and patterns for the shift from a procedural to a declarative approach in defining datasets. - [Move from dbt Core to the dbt platform: Get started](https://docs.getdbt.com/guides/core-migration-1.md): Learn how to move from dbt Core to the dbt platform and what you need to get started. - [Move from dbt Core to the dbt platform: Optimization tips](https://docs.getdbt.com/guides/core-migration-3.md): Use this guide to learn how to optimize your dbt experience and get answers to common questions. - [Move from dbt Core to the dbt platform: What you need to know](https://docs.getdbt.com/guides/core-migration-2.md): Use this guide to understand the considerations and methods you need to move from dbt Core to the dbt platform. - [Optimize and troubleshoot dbt models on Databricks](https://docs.getdbt.com/guides/optimize-dbt-models-on-databricks.md): Learn more about optimizing and troubleshooting your dbt models on Databricks - [Post to Microsoft Teams when a job finishes](https://docs.getdbt.com/guides/zapier-ms-teams.md): Use Zapier and dbt webhooks to post to Microsoft Teams when a job finishes running. - [Post to Slack with error context when a job fails](https://docs.getdbt.com/guides/zapier-slack.md): Use a webhook or Slack message to trigger Zapier and post error context in Slack when a job fails. - [Productionize your dbt Databricks project](https://docs.getdbt.com/guides/productionize-your-dbt-databricks-project.md): Learn how to deliver models to end users and use best practices to maintain production data. - [Quickstart for dbt and Amazon Athena](https://docs.getdbt.com/guides/athena.md): Introduction - [Quickstart for dbt and Azure Synapse Analytics](https://docs.getdbt.com/guides/azure-synapse-analytics.md): Introduction - [Quickstart for dbt and BigQuery](https://docs.getdbt.com/guides/bigquery.md): Introduction - [Quickstart for dbt and Databricks](https://docs.getdbt.com/guides/databricks.md): Introduction - [Quickstart for dbt and Microsoft Fabric](https://docs.getdbt.com/guides/microsoft-fabric.md): Introduction - [Quickstart for dbt and Redshift](https://docs.getdbt.com/guides/redshift.md): Introduction - [Quickstart for dbt and Snowflake](https://docs.getdbt.com/guides/snowflake.md): Introduction - [Quickstart for dbt and Starburst Galaxy](https://docs.getdbt.com/guides/starburst-galaxy.md): Introduction - [Quickstart for dbt and Teradata](https://docs.getdbt.com/guides/teradata.md): Introduction - [Quickstart for dbt Canvas](https://docs.getdbt.com/guides/canvas.md): Introduction - [Quickstart for dbt Core from a manual install](https://docs.getdbt.com/guides/manual-install.md): Connecting your warehouse to dbt Core using the CLI. - [Quickstart for dbt Core using DuckDB](https://docs.getdbt.com/guides/duckdb.md): Learn to use dbt Core using DuckDB. - [Quickstart for the dbt Fusion engine](https://docs.getdbt.com/guides/fusion.md): Introduction - [Quickstart for the dbt Semantic Layer and Snowflake](https://docs.getdbt.com/guides/sl-snowflake-qs.md): Use this guide to build and define metrics, set up the dbt Semantic Layer, and query them using Google Sheets. - [Quickstart with dbt Mesh](https://docs.getdbt.com/guides/mesh-qs.md): Introduction - [Quickstart with MetricFlow time spine](https://docs.getdbt.com/guides/mf-time-spine.md): Introduction - [Refactoring legacy SQL to dbt](https://docs.getdbt.com/guides/refactoring-legacy-sql.md): This guide walks through refactoring a long SQL query (perhaps from a stored procedure) into modular dbt data models. - [Refresh a Mode dashboard when a job completes](https://docs.getdbt.com/guides/zapier-refresh-mode-report.md): Use Zapier to trigger a Mode dashboard refresh when a dbt job completes. - [Refresh Tableau workbook with extracts after a job finishes](https://docs.getdbt.com/guides/zapier-refresh-tableau-workbook.md): Use Zapier to trigger a Tableau workbook refresh once a dbt job completes successfully. - [Run dbt MCP locally](https://docs.getdbt.com/guides/qs-mcp-local.md) - [Set up your dbt project with Databricks](https://docs.getdbt.com/guides/set-up-your-databricks-dbt-project.md): Learn more about setting up your dbt project with Databricks. - [Trigger PagerDuty alarms when dbt jobs fail](https://docs.getdbt.com/guides/serverless-pagerduty.md): Use webhooks to configure a serverless app to trigger PagerDuty alarms. - [Upgrade to Fusion part 1: Preparing to upgrade](https://docs.getdbt.com/guides/prepare-fusion-upgrade.md): Introduction - [Upgrade to Fusion part 2: Making the move](https://docs.getdbt.com/guides/upgrade-to-fusion.md): Introduction - [Use Databricks workflows to run dbt jobs](https://docs.getdbt.com/guides/databricks-workflows.md): Learn how to use Databricks workflows to run dbt jobs - [Use Jinja to improve your SQL code](https://docs.getdbt.com/guides/using-jinja.md): Learn how to improve your SQL code using Jinja. - [Using BigQuery DataFrames with dbt Python models](https://docs.getdbt.com/guides/dbt-python-bigframes.md): Use this guide to help you set up dbt with BigQuery DataFrames (BigFrames). ## Navigation Options - [navigation-options](https://docs.getdbt.com/navigation-options.md) ## Platform - [About billing](https://docs.getdbt.com/docs/platform/billing.md): dbt billing information. - [About Canvas](https://docs.getdbt.com/docs/platform/canvas.md): dbt Canvas enables you to quickly create and visualize dbt models through a visual, drag-and-drop experience inside of dbt. - [About dbt platform profiles](https://docs.getdbt.com/docs/platform/about-profiles.md): About dbt platform profile configuration. - [About dbt Wizard](https://docs.getdbt.com/docs/platform/wizard-overview.md): dbt Wizard is an AI agent purpose-built for governed data development in dbt — available in the dbt platform and from your terminal. - [About dbt Wizard in the dbt platform Preview](https://docs.getdbt.com/docs/platform/wizard-platform.md): dbt Wizard in the dbt platform helps teams investigate, change, validate, and ship trusted dbt work with warehouse-aware AI. - [About Studio IDE](https://docs.getdbt.com/docs/platform/about-platform/about-studio-ide.md): about dbt Studio Integrated Development Environment - [About the Studio IDE](https://docs.getdbt.com/docs/platform/studio-ide/develop-in-studio.md): Develop, test, run, and build in the Studio IDE. You can compile dbt code into SQL and run it against your database directly - [Access, Regions, & IP addresses](https://docs.getdbt.com/docs/platform/about-platform/access-regions-ip-addresses.md): Available regions and ip addresses - [Billing FAQs](https://docs.getdbt.com/docs/platform/billing-faqs.md): Answers to common questions about dbt plans, billing, usage, and the Semantic Layer trial. - [Build with dbt Copilot](https://docs.getdbt.com/docs/platform/build-canvas-copilot.md): Use dbt Copilot to build visual models in Canvas with natural language prompts - [Change your dbt theme](https://docs.getdbt.com/docs/platform/about-platform/change-your-dbt-theme.md): Learn about theme switching in dbt - [Configure and use the dbt CLI](https://docs.getdbt.com/docs/platform/configure-dbt-cli.md): Instructions on how to configure the dbt CLI - [Configure BYOK for dbt Wizard in dbt platform](https://docs.getdbt.com/docs/platform/wizard-byok-platform.md): Bring your own API key to use dbt Wizard and dbt Copilot in dbt platform. Supports OpenAI, Azure AI Foundry, and Anthropic. - [dbt AI: Usage metering and limiting](https://docs.getdbt.com/docs/platform/billing/dbt-ai-usage.md): Learn how dbt AI usage is metered and limited by plan. - [dbt Architecture](https://docs.getdbt.com/docs/platform/about-platform/architecture.md): Information about the architecture, communication, and security of dbt - [dbt State usage](https://docs.getdbt.com/docs/platform/billing/dbt-state-usage.md): Learn how dbt State usage and pricing works. - [dbt Wizard home tab Preview](https://docs.getdbt.com/docs/platform/wizard-home.md): Use the dbt Wizard home tab in the dbt platform for an agent-native development workflow — iterate in natural language, review inline diffs and DAG previews, and validate changes without leaving the agent. - [Develop with AI in the Studio IDE](https://docs.getdbt.com/docs/platform/studio-ide/develop-studio-ai.md): Leverage AI to develop dbt projects in the Studio IDE - [Develop with dbt](https://docs.getdbt.com/docs/platform/about-develop-dbt.md): Learn how to develop your dbt projects using dbt. - [Edit and create dbt models](https://docs.getdbt.com/docs/platform/use-canvas.md): Access and use Canvas to create or edit dbt models through a visual, drag-and-drop experience inside of dbt. - [Enable AI features in dbt platform](https://docs.getdbt.com/docs/platform/enable-dbt-ai.md): Enable AI features in the dbt platform, including dbt Wizard and dbt Copilot, to speed up your development. - [Fix deprecation warnings](https://docs.getdbt.com/docs/platform/studio-ide/autofix-deprecations.md): Learn how you can use the autofix tool in the Studio IDE to update project code. - [Git commit signing](https://docs.getdbt.com/docs/platform/studio-ide/git-commit-signing.md): Learn how to sign your Git commits when using the IDE for development. - [How does dbt pricing work?](https://docs.getdbt.com/docs/platform/billing/how-pricing-works.md): Learn how dbt pricing works, including seats, usage, and successful models built. - [IDE user interface](https://docs.getdbt.com/docs/platform/studio-ide/ide-user-interface.md): Develop, test, run, and build in the Studio IDE. With the Studio IDE, you can compile dbt code into SQL and run it against your database directly - [Install dbt CLI](https://docs.getdbt.com/docs/platform/dbt-cli-installation.md): Instructions for installing and configuring dbt platform's CLI tool. - [Lint and format your code](https://docs.getdbt.com/docs/platform/studio-ide/lint-format.md): Integrate with popular linters and formatters like SQLFluff, sqlfmt, Black, and Prettier. - [Log in to dbt platform](https://docs.getdbt.com/docs/platform/about-platform/login.md): Use login.dbt.com to discover and access your dbt platform accounts. - [Managing usage](https://docs.getdbt.com/docs/platform/billing/managing-usage.md): Learn how to view, monitor, and manage your dbt usage. - [Migrating to account-specific access URLs](https://docs.getdbt.com/docs/platform/about-platform/account-url-migration.md): Learn how to migrate to account-specific access URLs. - [Navigate the interface](https://docs.getdbt.com/docs/platform/canvas-interface.md): The dbt Canvas interface contains an operator toolbar, operators, and a canvas to help you access and transform data through a seamless drag-and-drop dbt model creation experience in dbt. - [Optimize costs in dbt](https://docs.getdbt.com/docs/platform/billing/optimize-costs.md): Best practices to optimize model build usage and warehouse costs in dbt. - [Plans and billing](https://docs.getdbt.com/docs/platform/billing/plans-and-billing.md): Learn how billing works for each dbt plan. - [Studio IDE keyboard shortcuts](https://docs.getdbt.com/docs/platform/studio-ide/keyboard-shortcuts.md): Learn about the keyboard shortcuts available in the Studio IDE. - [Supported browsers](https://docs.getdbt.com/docs/platform/about-platform/browsers.md): dbt supports the latest browsers like Chrome and Firefox. - [Tenancy](https://docs.getdbt.com/docs/platform/about-platform/tenancy.md): Single tenant, multi-tenant, and cell-based (multi-cell) dbt platform hosting - [The dbt platform features](https://docs.getdbt.com/docs/platform/about-platform/dbt-platform-features.md): Explore dbt's features and learn why the dbt platform is the fastest way to deploy dbt - [Using defer in dbt](https://docs.getdbt.com/docs/platform/about-defer.md): Learn how to leverage defer to prod when developing with dbt. ## Reference - [.dbtignore](https://docs.getdbt.com/reference/dbtignore.md): You can create a .dbtignore file in the root of your dbt project to specify files that should be entirely ignored by dbt. The file behaves like a .gitignore file, using the same syntax. Files and subdirectories matching the pattern will not be read, parsed, or otherwise detected by dbt—as if they didn't exist. - [About adapter object](https://docs.getdbt.com/reference/dbt-jinja-functions/adapter.md): Wrap the internal database adapter with the Jinja object `adapter`. - [About adapter-specific behavior changes](https://docs.getdbt.com/reference/global-configs/adapter-behavior-changes.md): Adapter-specific behavior changes - [About as_bool filter](https://docs.getdbt.com/reference/dbt-jinja-functions/as_bool.md): Use this filter to coerce a Jinja output into boolean value. - [About as_native filter](https://docs.getdbt.com/reference/dbt-jinja-functions/as_native.md): Use this filter to coerce Jinja-compiled output into its native python. - [About as_number filter](https://docs.getdbt.com/reference/dbt-jinja-functions/as_number.md): Use this filter to convert Jinja-compiled output to a numeric value.. - [About behavior changes](https://docs.getdbt.com/reference/global-configs/behavior-changes.md): Behavior change flags let you control when to adopt new runtime behaviors in dbt. - [About builtins Jinja variable](https://docs.getdbt.com/reference/dbt-jinja-functions/builtins.md): Read this guide to understand the builtins Jinja variable in dbt. - [About config property](https://docs.getdbt.com/reference/resource-properties/config.md): - [arguments (for macros)](https://docs.getdbt.com/reference/resource-properties/arguments.md): .yml'> - [asset-paths](https://docs.getdbt.com/reference/project-configs/asset-paths.md): Read this guide to understand the asset-paths configuration in dbt. - [AWS Glue configurations](https://docs.getdbt.com/reference/resource-configs/glue-configs.md): AWS Glue Configurations - Read this in-depth guide to learn about configurations in dbt. - [batch_size](https://docs.getdbt.com/reference/resource-configs/batch-size.md): dbt uses `batch_size` to determine how large batches are when running a microbatch incremental model. - [begin](https://docs.getdbt.com/reference/resource-configs/begin.md): dbt uses `begin` to determine when a microbatch incremental model should begin from. When defined on a micorbatch incremental model, `begin` is used as the lower time bound when the model is built for the first time or fully refreshed. - [BigQuery adapter behavior changes](https://docs.getdbt.com/reference/global-configs/bigquery-changes.md): The bigqueryusebatchsourcefreshness flag - [BigQuery configurations](https://docs.getdbt.com/reference/resource-configs/bigquery-configs.md): Reference guide for Big Query configurations in dbt. - [Cache](https://docs.getdbt.com/reference/global-configs/cache.md): Cache population - [Catalog JSON file](https://docs.getdbt.com/reference/artifacts/catalog-json.md): Current schema: v1 - [Caveats to state comparison](https://docs.getdbt.com/reference/node-selection/state-comparison-caveats.md): Learn about caveats to state comparison in dbt. - [check_cols](https://docs.getdbt.com/reference/resource-configs/check_cols.md): Read this guide to understand the check_cols configuration in dbt. - [Checking version compatibility](https://docs.getdbt.com/reference/global-configs/version-compatibility.md): For the first several years of 's development, breaking changes were more common. For this reason, we encouraged setting dbt version requirements — especially if they use features that are newer or which may break in future versions of . By default, if you run a project with an incompatible dbt version, dbt will raise an error. - [clean-targets](https://docs.getdbt.com/reference/project-configs/clean-targets.md): Definition - [ClickHouse configurations](https://docs.getdbt.com/reference/resource-configs/clickhouse-configs.md): Read this guide to understand ClickHouse configurations in dbt. - [Cloudera Hive configurations](https://docs.getdbt.com/reference/resource-configs/hive-configs.md): Cloudera Hive Configurations - Read this in-depth guide to learn about configurations in dbt. - [Cloudera Impala configurations](https://docs.getdbt.com/reference/resource-configs/impala-configs.md): Impala Configs - Read this in-depth guide to learn about configurations in dbt. - [column_types](https://docs.getdbt.com/reference/resource-configs/column_types.md): Optionally specify the data type of each column in a seed instead of letting dbt infer types from the column values. - [columns](https://docs.getdbt.com/reference/resource-properties/columns.md): - [Confluent Cloud configurations](https://docs.getdbt.com/reference/resource-configs/confluent-configs.md): Reference for Confluent Cloud-specific dbt model configurations for Apache Flink. - [constraints](https://docs.getdbt.com/reference/resource-properties/constraints.md): Constraints are a feature of many data platforms. When specified, the platform will perform additional validation on data as it is being populated in a new table or inserted into a preexisting table. If the validation fails, the table creation or update fails, the operation is rolled back, and you will see a clear error message. - [contract](https://docs.getdbt.com/reference/resource-configs/contract.md): When the contract configuration is enforced, dbt will ensure that your model's returned dataset exactly matches the attributes you have defined in YAML, such as name and data_type, as well as any additional constraints supported by the data platform. - [Cross-database macros](https://docs.getdbt.com/reference/dbt-jinja-functions/cross-database-macros.md): Read this guide to understand cross-database macros in dbt. - [Cumulative metrics](https://docs.getdbt.com/reference/global-configs/behavior-flags/require_nested_cumulative_type_params.md): | requirenestedcumulativetypeparams | Latest | | - [Custom microbatch strategy](https://docs.getdbt.com/reference/global-configs/behavior-flags/require_batched_execution_for_custom_microbatch_strategy.md): This flag was removed in and in . The new behavior is always enabled. If you're upgrading, remove this flag from your dbt_project.yml. - [Data test configurations](https://docs.getdbt.com/reference/data-test-configs.md): Read this guide to learn about using data test configurations in dbt. - [database](https://docs.getdbt.com/reference/resource-configs/database.md): Override the default database when dbt creates resources in your data platform. - [Database permissions](https://docs.getdbt.com/reference/database-permissions/about-database-permissions.md): Database permissions are access rights and privileges granted to users or roles within a database management system. - [Databricks adapter behavior changes](https://docs.getdbt.com/reference/global-configs/databricks-changes.md): The following are the current behavior change flags that are specific to dbt-databricks: - [Databricks configurations](https://docs.getdbt.com/reference/resource-configs/databricks-configs.md): Configure Databricks-specific settings for models in dbt, including file formats, table properties, and materializations. - [Databricks permissions](https://docs.getdbt.com/reference/database-permissions/databricks-permissions.md): In Databricks, permissions are used to control who can perform certain actions on different database objects. Use SQL statements to manage permissions in a Databricks database. - [dbt Classes](https://docs.getdbt.com/reference/dbt-classes.md): dbt has a number of classes it uses to represent objects in a , parts of a dbt project, and the results of a command. - [dbt Command reference](https://docs.getdbt.com/reference/dbt-commands.md): You can run dbt using the following tools: - [dbt Jinja functions and context variables](https://docs.getdbt.com/reference/dbt-jinja-functions-context-variables.md): In addition to the standard Jinja library, we've added additional functions and variables to the Jinja context that are useful when working with a dbt project. Note that dependencies.yml is not Jinja rendered and therefore does not support Jinja. - [dbt State configurations](https://docs.getdbt.com/reference/resource-configs/dbt-state-configs.md): Reference for all dbt State configurations — node-level state configs and profile-level settings. - [dbt_cloud.yml file](https://docs.getdbt.com/reference/dbt_cloud.yml.md): Reference for the dbt_cloud.yml credentials file used by the dbt CLI and dbt VS Code extension to connect to the dbt platform. - [dbt_project.yml](https://docs.getdbt.com/reference/dbt_project.yml.md): Reference guide for configuring the dbt_project.yml file. - [dbt_valid_to_current](https://docs.getdbt.com/reference/resource-configs/dbt_valid_to_current.md): Use the `dbt_valid_to_current` config to set a custom indicator for the value of `dbt_valid_to` in current snapshot records - [Defer](https://docs.getdbt.com/reference/node-selection/defer.md): Defer is a powerful feature that makes it possible to run a subset of models or testsmodels, tests, or functions in a sandbox environment without having to first build their upstream parents. This can save time and computational resources when you want to test a small number of models in a large project. - [defer_to_target](https://docs.getdbt.com/reference/resource-configs/defer-to-target.md): Configure which target environment dbt State defers to for self-managed deployments. - [Define configs](https://docs.getdbt.com/reference/define-configs.md): Learn how to define configurations for your resources in a dbt project - [Define properties](https://docs.getdbt.com/reference/define-properties.md): Learn how to define properties for your resources in a properties.yml file - [Defining a database source property](https://docs.getdbt.com/reference/resource-properties/database.md): .yml'> - [Defining a schema source property](https://docs.getdbt.com/reference/resource-properties/schema.md): .yml'> - [delimiter](https://docs.getdbt.com/reference/resource-configs/delimiter.md): Customize the single-character delimiter dbt uses to separate values when loading a seed file. - [DeltaStream resource configurations](https://docs.getdbt.com/reference/resource-configs/deltastream-configs.md): DeltaStream Configurations - Read this in-depth guide to learn about configurations in dbt. - [Deprecation & warnings overview](https://docs.getdbt.com/reference/changes-overview.md): Quick reference page to help you understand deprecations, behavior changes, and deprecated flags in dbt - [deprecation_date](https://docs.getdbt.com/reference/resource-properties/deprecation_date.md): .yml'> - [Deprecations](https://docs.getdbt.com/reference/deprecations.md): Deprecated functionality still works in the v1.10 release but is no longer supported and will be removed in a future version. Deprecations currently show as warnings but don't prevent runs and other commands (unless you've configured warnings as errors), but will cause errors after upgrading if not addressed. - [description](https://docs.getdbt.com/reference/resource-properties/description.md): This guide explains how to use the description key to add YAML descriptions to dbt resources (models, sources, seeds) using markdown and Jinja for better documentation. - [Dimension properties](https://docs.getdbt.com/reference/dimension-properties.md): Complete property reference for dbt Semantic Layer dimensions: time and categorical dimensions. - [dispatch (config)](https://docs.getdbt.com/reference/project-configs/dispatch-config.md): Read this guide to understand the dispatch configuration in dbt. - [docs](https://docs.getdbt.com/reference/resource-configs/docs.md): Docs - Read this in-depth guide to learn about configurations in dbt. - [docs-paths](https://docs.getdbt.com/reference/project-configs/docs-paths.md): Read this guide to understand the docs-paths configuration in dbt. - [Doris/SelectDB configurations](https://docs.getdbt.com/reference/resource-configs/doris-configs.md): Doris/SelectDB Configurations - Read this in-depth guide to learn about configurations in dbt. - [DuckDB configurations](https://docs.getdbt.com/reference/resource-configs/duckdb-configs.md): Reference for DuckDB-specific configurations in dbt-duckdb, including secrets, DuckLake, external files, incremental strategies, and more. - [enabled](https://docs.getdbt.com/reference/resource-configs/enabled.md): Enabled - Read this in-depth guide to learn about configurations in dbt. - [entry_point](https://docs.getdbt.com/reference/resource-configs/entry-point.md): Specify the Python function that serves as the entry point when dbt creates a Python user-defined function (UDF) on Snowflake and BigQuery. - [Environment variable configs](https://docs.getdbt.com/reference/global-configs/environment-variable-configs.md): Environment variables contain a DBT_ prefix. For a list of all dbt environment variables you can set, refer to Available flags. - [evaluate_volatile_sql](https://docs.getdbt.com/reference/resource-configs/evaluate-volatile-sql.md): Configure whether dbt State stores and compares the runtime results of volatile SQL functions when deciding whether to rebuild a node. - [event_time](https://docs.getdbt.com/reference/resource-configs/event-time.md): dbt uses event_time to understand when an event occurred. When defined, event_time enables microbatch incremental models, the sample flag, and more refined comparison of datasets during Advanced CI. - [Events and logs](https://docs.getdbt.com/reference/events-logging.md): As dbt runs, it generates events. The most common way to see those events is as log messages, written in real time to two places: - [Exasol configurations](https://docs.getdbt.com/reference/resource-configs/exasol-configs.md): Exasol Configurations - Read this in-depth guide to learn about configurations in dbt. - [Exclude models from your run](https://docs.getdbt.com/reference/node-selection/exclude.md): Excluding models - [execute_hooks_on_any_reuse](https://docs.getdbt.com/reference/resource-configs/execute-hooks-on-any-reuse.md): Configure whether pre- and post-hooks run when dbt State skips a node because it's still fresh. - [Exit codes](https://docs.getdbt.com/reference/exit-codes.md): When dbt exits, it will return an exit code of either 0, 1, or 2. - [Exposure properties](https://docs.getdbt.com/reference/exposure-properties.md): Read this guide to understand exposure properties in dbt. - [external](https://docs.getdbt.com/reference/resource-properties/external.md): .yml'> - [fail_calc](https://docs.getdbt.com/reference/resource-configs/fail_calc.md): Customize how a data test calculates the number of failing records instead of using the default count of failing rows. - [Failing fast](https://docs.getdbt.com/reference/global-configs/failing-fast.md): Supply the -x or --fail-fast flag to dbt run, dbt build, or dbt test to make dbt exit immediately on the first failure. fail_fast is a global flag, so it stops on both run errors and test errors —— not just run errors. If other models are in-progress when the first failure happens, then dbt will terminate the connections for these still-running models. - [Failures in on-run-start hooks](https://docs.getdbt.com/reference/global-configs/behavior-flags/skip_nodes_if_on_run_start_fails.md): This flag was removed in and in . The new behavior is always enabled. If you're upgrading, remove this flag from your dbt_project.yml. - [Firebolt configurations](https://docs.getdbt.com/reference/resource-configs/firebolt-configs.md): Configure Firebolt-specific settings for dbt models, including quote_columns and other adapter options. - [freshness](https://docs.getdbt.com/reference/resource-properties/freshness.md): .yml'> - [freshness Private preview](https://docs.getdbt.com/reference/resource-configs/freshness.md): Read this guide to understand the `freshness` configuration in dbt. - [full_refresh](https://docs.getdbt.com/reference/resource-configs/full_refresh.md): Set the full_refresh config for models and other resources in dbt. - [Function configurations](https://docs.getdbt.com/reference/function-configs.md): Read this guide to learn about using function configurations in dbt. - [Function properties](https://docs.getdbt.com/reference/function-properties.md): Function properties can be declared in .yml files under a functions key. - [function-paths](https://docs.getdbt.com/reference/project-configs/function-paths.md): Definition - [Fusion telemetry and observability](https://docs.getdbt.com/reference/telemetry-observability.md): Fusion support for telemetry and observability - [Generic test arguments property](https://docs.getdbt.com/reference/global-configs/behavior-flags/require_generic_test_arguments_property.md): The default value is now true. To preserve the previous behavior, set this flag to false in your dbt_project.yml. - [grants](https://docs.getdbt.com/reference/resource-configs/grants.md): Manage access to the database objects dbt produces by applying grants to models, seeds, and snapshots at build time. - [Graph operators](https://docs.getdbt.com/reference/node-selection/graph-operators.md): The "plus" operator - [Greenplum configurations](https://docs.getdbt.com/reference/resource-configs/greenplum-configs.md): Greenplum Configurations - Read this in-depth guide to learn about configurations in dbt. - [group](https://docs.getdbt.com/reference/resource-configs/group.md): Assign dbt resources to groups to organize ownership and control access to private models. - [hard_deletes](https://docs.getdbt.com/reference/resource-configs/hard-deletes.md): Use the `hard_deletes` config to control how deleted rows are tracked in your snapshot table. - [IBM Db2 configurations](https://docs.getdbt.com/reference/resource-configs/ibm-db2-config.md): Configure IBM Db2-specific settings for dbt models, including instance requirements and adapter permissions. - [IBM Netezza configurations](https://docs.getdbt.com/reference/resource-configs/ibm-netezza-config.md): Configure IBM Netezza-specific settings for dbt models, including instance requirements and adapter permissions. - [IBM watsonx.data Presto configurations](https://docs.getdbt.com/reference/resource-configs/watsonx-presto-config.md): Configure IBM watsonx.data Presto-specific settings for dbt models, including instance requirements and catalog permissions. - [IBM watsonx.data Spark configurations](https://docs.getdbt.com/reference/resource-configs/watsonx-spark-config.md): Configure IBM watsonx.data Spark-specific settings for dbt models, including instance requirements and catalog permissions. - [identifier](https://docs.getdbt.com/reference/resource-properties/identifier.md): .yml'> - [Indirect selection](https://docs.getdbt.com/reference/global-configs/indirect-selection.md): Indirect selection determines which tests to run when you select models or other resources. It applies to tests that are related to your selected resources through relationships in your DAG — for example, tests on upstream or downstream models, or tests that reference multiple models. - [Infer configurations](https://docs.getdbt.com/reference/resource-configs/infer-configs.md): Read this guide to understand how to configure Infer with dbt. - [Input for unit tests](https://docs.getdbt.com/reference/resource-properties/unit-test-input.md): Use inputs in your unit tests to reference a specific model or source for the test: - [invalidate_hard_deletes legacy](https://docs.getdbt.com/reference/resource-configs/invalidate_hard_deletes.md): Invalidate_hard_deletes - Read this in-depth guide to learn about configurations in dbt. - [Jinja file extensions](https://docs.getdbt.com/reference/global-configs/behavior-flags/allow_jinja_file_extensions.md): | allowjinjafile_extensions | Latest | | - [JSON artifacts](https://docs.getdbt.com/reference/global-configs/json-artifacts.md): Write JSON artifacts - [lag_tolerance](https://docs.getdbt.com/reference/resource-configs/lag-tolerance.md): Configure lag_tolerance to prevent unnecessary node rebuilds when upstream data updates more frequently than your node needs to. - [Latest version pointer for versioned models](https://docs.getdbt.com/reference/global-configs/behavior-flags/latest_version_pointer_enabled_by_default.md): | latestversionpointerenabledby_default | Latest | | | - [latest_version](https://docs.getdbt.com/reference/resource-properties/latest_version.md): .yml'> - [latest_version_pointer](https://docs.getdbt.com/reference/resource-configs/latest_version_pointer.md): Use latest_version_pointer to automatically create a view pointing to the latest version of a versioned model. - [Legacy snapshot configuration legacy](https://docs.getdbt.com/reference/resource-configs/snapshots-jinja-legacy.md): Read about how to configure snapshots using legacy Jinja blocks - [limit](https://docs.getdbt.com/reference/resource-configs/limit.md): Limit the number of failing records returned by a data test query, which is useful when storing failures for large datasets. - [loader](https://docs.getdbt.com/reference/resource-properties/loader.md): .yml'> - [log](https://docs.getdbt.com/reference/dbt-jinja-functions/log.md): Learn more about the log Jinja function in dbt. - [Logs](https://docs.getdbt.com/reference/global-configs/logs.md): Log formatting - [lookback](https://docs.getdbt.com/reference/resource-configs/lookback.md): Configure `lookback` to determine how many 'batches' of `batch_size` to reprocess when a dbt microbatch incremental model runs incrementally - [Macro argument validation](https://docs.getdbt.com/reference/global-configs/behavior-flags/validate_macro_args.md): | validatemacroargs | Latest | | - [Macro properties](https://docs.getdbt.com/reference/macro-properties.md): You can declare macro properties and configs in .yml files in your project. - [macro-paths](https://docs.getdbt.com/reference/project-configs/macro-paths.md): Read this guide to understand the macro-paths configuration in dbt. - [Manifest JSON file](https://docs.getdbt.com/reference/artifacts/manifest-json.md): Produced by: Any dbt command that parses the project. This includes all commands, except deps, clean, debug, and init. - [Materialize configurations](https://docs.getdbt.com/reference/resource-configs/materialize-configs.md): Materialize Configurations- Read this in-depth guide to learn about configurations in dbt. - [materialized](https://docs.getdbt.com/reference/resource-configs/materialized.md): Materialized - Read this in-depth guide to learn about materializations in dbt. - [meta](https://docs.getdbt.com/reference/resource-configs/meta.md): Attach arbitrary metadata as key-value pairs to dbt resources such as models, sources, seeds, and snapshots. - [metadata_warehouse](https://docs.getdbt.com/reference/resource-configs/metadata-warehouse.md): Specify a dedicated Snowflake warehouse for dbt State metadata lookups to avoid queueing on your main compute warehouse. - [Metric properties](https://docs.getdbt.com/reference/metric-properties.md): Property reference for Semantic Layer metrics: simple, cumulative, ratio, derived, and conversion. - [MetricFlow time spine YAML](https://docs.getdbt.com/reference/global-configs/behavior-flags/require_yaml_configuration_for_mf_time_spines.md): This flag was removed in and in . The new behavior is always enabled. If you're upgrading, remove this flag from your dbt_project.yml. - [Microsoft Azure Synapse DWH configurations](https://docs.getdbt.com/reference/resource-configs/azuresynapse-configs.md): Configure index and distribution settings for Microsoft Azure Synapse data warehouse tables in dbt. - [Microsoft Fabric Data Warehouse configurations](https://docs.getdbt.com/reference/resource-configs/fabric-configs.md): Configure Microsoft Fabric Data Warehouse settings in dbt, including materializations, incremental strategies, and cross-warehouse references. - [Microsoft Fabric Spark configurations](https://docs.getdbt.com/reference/resource-configs/fabricspark-configs.md): Microsoft Fabric Spark Configurations - Read this in-depth guide to learn about configurations in dbt. - [Microsoft SQL Server configurations](https://docs.getdbt.com/reference/resource-configs/mssql-configs.md): Configure Microsoft SQL Server-specific settings for dbt models, including supported materializations and T-SQL considerations. - [MindsDB configurations](https://docs.getdbt.com/reference/resource-configs/mindsdb-configs.md): Configure MindsDB-specific settings for dbt models, including authentication and connection options. - [Model configurations](https://docs.getdbt.com/reference/model-configs.md): Read this guide to understand model configurations in dbt. - [Model properties](https://docs.getdbt.com/reference/model-properties.md): Models properties can be declared in .yml files in your models/ directory (as defined by the model-paths config). - [model_name](https://docs.getdbt.com/reference/resource-properties/model_name.md): .yml'> - [model-paths](https://docs.getdbt.com/reference/project-configs/model-paths.md): Definition - [name](https://docs.getdbt.com/reference/project-configs/name.md): Read this guide to understand the name configuration in dbt. - [name](https://docs.getdbt.com/reference/resource-properties/name.md): name - [No + prefix on resource paths](https://docs.getdbt.com/reference/global-configs/behavior-flags/require_resource_names_without_plus_prefix.md): This behavior change flag is specific to and has no equivalent in . - [No spaces in resource names](https://docs.getdbt.com/reference/global-configs/behavior-flags/require_resource_names_without_spaces.md): This flag was removed in and in . The new behavior is always enabled. If you're upgrading, remove this flag from your dbt_project.yml. - [No spaces in source and semantic model names](https://docs.getdbt.com/reference/global-configs/behavior-flags/require_source_and_semantic_model_names_without_spaces.md): | requiresourceandsemanticmodelnameswithout_spaces | Latest | | - [No specific configurations for this adapter](https://docs.getdbt.com/reference/resource-configs/no-configs.md): This data platform has no adapter-specific resource configurations in dbt. - [Node selector methods](https://docs.getdbt.com/reference/node-selection/methods.md): Selector methods return all resources that share a common property, using the - [Null-safe equality (equals macro)](https://docs.getdbt.com/reference/global-configs/behavior-flags/enable_truthy_nulls_equals_macro.md): | enabletruthynullsequalsmacro | Latest | | - [on_configuration_change](https://docs.getdbt.com/reference/resource-configs/on_configuration_change.md): on_configuration_change - Read this in-depth guide to learn about configuration change monitoring in dbt. - [on_error](https://docs.getdbt.com/reference/resource-configs/on_error.md): Use the `on_error` config to control whether downstream models are skipped when a model fails. - [on-run-start & on-run-end](https://docs.getdbt.com/reference/project-configs/on-run-start-on-run-end.md): Read this guide to understand the on-run-start and on-run-end configurations in dbt. - [Oracle configurations](https://docs.getdbt.com/reference/resource-configs/oracle-configs.md): Configure Oracle-specific settings for dbt models, including parallel hints and adapter options. - [osi-paths](https://docs.getdbt.com/reference/project-configs/osi-paths.md): Definition - [Other artifact files](https://docs.getdbt.com/reference/artifacts/other-artifacts.md): index.html - [overloads](https://docs.getdbt.com/reference/resource-properties/overloads.md): .yml'> - [overrides](https://docs.getdbt.com/reference/resource-properties/overrides.md): The overrides property is deprecated in v1.10. You can enable or disable a source from a package instead. - [Package overrides for built-in materializations](https://docs.getdbt.com/reference/global-configs/behavior-flags/require_explicit_package_overrides_for_builtin_materializations.md): This flag was removed in and in . The new behavior is always enabled. If you're upgrading, remove this flag from your dbt_project.yml. - [Package ref search order](https://docs.getdbt.com/reference/global-configs/behavior-flags/require_ref_searches_node_package_before_root.md): | requirerefsearchesnodepackagebeforeroot | Latest | | - [packages](https://docs.getdbt.com/reference/resource-configs/packages.md): Specify the third-party PyPI packages a Python user-defined function (UDF) needs so your warehouse installs them when it creates the function. - [packages-install-path](https://docs.getdbt.com/reference/project-configs/packages-install-path.md): Definition - [Parsing](https://docs.getdbt.com/reference/global-configs/parsing.md): Partial Parsing - [persist_docs](https://docs.getdbt.com/reference/resource-configs/persist_docs.md): Persist_docs - Read this in-depth guide to learn about configurations in dbt. - [Platform-specific configs](https://docs.getdbt.com/reference/resource-configs.md): Platform-specific configs are used to configure the dbt project for a specific database platform. - [Platform-specific data types](https://docs.getdbt.com/reference/resource-properties/data-types.md): Unit tests are designed to test for the expected values, not for the data types themselves. dbt takes the value you provide and attempts to cast it to the data type as inferred from the input and output models. - [Postgres configurations](https://docs.getdbt.com/reference/resource-configs/postgres-configs.md): Postgres Configurations - Read this in-depth guide to learn about configurations in dbt. - [Postgres Permissions](https://docs.getdbt.com/reference/database-permissions/postgres-permissions.md): In Postgres, permissions are used to control who can perform certain actions on different database objects. Use SQL statements to manage permissions in a Postgres database. - [pre_clone](https://docs.getdbt.com/reference/resource-configs/pre-clone.md): Configure when dbt State pre-populates incremental models and snapshots in dev by cloning their production counterparts. - [pre-hook & post-hook](https://docs.getdbt.com/reference/resource-configs/pre-hook-post-hook.md): Configure hooks to execute SQL before (pre) and after (post) a model is run in dbt. - [Print output](https://docs.getdbt.com/reference/global-configs/print-output.md): Suppress print() messages in stdout - [profile](https://docs.getdbt.com/reference/project-configs/profile.md): Read this guide to understand the profile configuration in dbt. - [Programmatic invocations](https://docs.getdbt.com/reference/programmatic-invocations.md): Programmatic invocations let you call dbt commands from Python scripts and applications, instead of running them in a shell. This is useful when you want to embed dbt runs into a larger application or workflow, while still using the same command surface area as the CLI. - [Project flags](https://docs.getdbt.com/reference/global-configs/project-flags.md): Reference the table of all flags to see which global configs are available for setting in dbtproject.yml. - [Project hooks with source freshness](https://docs.getdbt.com/reference/global-configs/behavior-flags/source_freshness_run_project_hooks.md): This flag was removed in and in . The new behavior is always enabled. If you're upgrading, remove this flag from your dbt_project.yml. - [Project Parsing](https://docs.getdbt.com/reference/parsing.md): Read this guide to understand the project parsing configuration in dbt. - [Project-level configuration for analyses](https://docs.getdbt.com/reference/global-configs/behavior-flags/require_corrected_analysis_fqns.md): | requirecorrectedanalysis_fqns | Latest | | - [Putting it together](https://docs.getdbt.com/reference/node-selection/putting-it-together.md): This can get complex! Let's say I want a nightly run of models that build off snowplow data - [query-comment](https://docs.getdbt.com/reference/project-configs/query-comment.md): The query-comment configuration also accepts a dictionary input, like so: - [quote_args](https://docs.getdbt.com/reference/resource-configs/quote_args.md): Control whether Snowflake quotes argument names when dbt creates a JavaScript user-defined function (UDF), which determines their casing. - [quote_columns](https://docs.getdbt.com/reference/resource-configs/quote_columns.md): Quote_columns - Read this in-depth guide to learn about configurations in dbt. - [Record timing info](https://docs.getdbt.com/reference/global-configs/record-timing-info.md): The -r or --record-timing-info flag saves performance profiling information to a file. This file can be visualized with snakeviz to understand the performance characteristics of a dbt invocation. - [Redshift configurations](https://docs.getdbt.com/reference/resource-configs/redshift-configs.md): Redshift Configurations - Read this in-depth guide to learn about configurations in dbt. - [Redshift permissions](https://docs.getdbt.com/reference/database-permissions/redshift-permissions.md): In Redshift, permissions are used to control who can perform certain actions on different database objects. Use SQL statements to manage permissions in a Redshift database. - [require_fresh_data_from](https://docs.getdbt.com/reference/resource-configs/require-fresh-data-from.md): Configure how many direct parent nodes need fresh data before a node is rebuilt by dbt State. - [require-dbt-version](https://docs.getdbt.com/reference/project-configs/require-dbt-version.md): Read this guide to understand the require-dbt-version configuration in dbt. - [Resource path](https://docs.getdbt.com/reference/resource-configs/resource-path.md): Learn how to use resource paths to configure resource types in dbt. - [Resource type](https://docs.getdbt.com/reference/global-configs/resource-type.md): The --resource-type and --exclude-resource-type flags include or exclude resource types from the dbt build, dbt clone, dbt test, and dbt list commands. - [returns](https://docs.getdbt.com/reference/resource-properties/returns.md): .yml'> - [Run results JSON file](https://docs.getdbt.com/reference/artifacts/run-results-json.md): Current schema: v6 - [runtime_version](https://docs.getdbt.com/reference/resource-configs/runtime-version.md): Specify the Python runtime version used to run a Python user-defined function (UDF) on Snowflake and BigQuery. - [Salesforce Data 360 configurationsBeta](https://docs.getdbt.com/reference/resource-configs/data-cloud-configs.md): Salesforce Data 360 Configurations - Read this in-depth guide to learn about configurations in dbt. - [schema](https://docs.getdbt.com/reference/resource-configs/schema.md): Override the default schema when dbt creates resources in your data platform. - [Seed configurations](https://docs.getdbt.com/reference/seed-configs.md): Read this guide to learn about using seed configurations in dbt. - [Seed properties](https://docs.getdbt.com/reference/seed-properties.md): Seed properties can be declared in .yml files under a seed key. - [seed-paths](https://docs.getdbt.com/reference/project-configs/seed-paths.md): Definition - [Semantic Layer configurations](https://docs.getdbt.com/reference/semantic-layer-reference.md): Configuration reference for the Semantic Layer: semantic models, metrics, and dimensions. - [Semantic manifest](https://docs.getdbt.com/reference/artifacts/sl-manifest.md): Learn about the semantic manifest.json file and how you can use artifacts to gain insights about your dbt Semantic Layer. - [Semantic model properties](https://docs.getdbt.com/reference/semantic-model-properties.md): Complete property reference for dbt Semantic Layer semantic models: name, model, entities, dimensions, measures, and configuration. - [Set operators](https://docs.getdbt.com/reference/node-selection/set-operators.md): Union and intersection set operators for dbt --select and --exclude. - [severity, error_if, and warn_if](https://docs.getdbt.com/reference/resource-configs/severity.md): You can use error thresholds to configure the severity of test results and set when to produce an error or warning based on the number of failed tests. - [SingleStore configurations](https://docs.getdbt.com/reference/resource-configs/singlestore-configs.md): Configure SingleStore-specific settings for dbt models, including incremental strategies such as delete+insert, append, and microbatch. - [Snapshot configurations](https://docs.getdbt.com/reference/snapshot-configs.md): Read this guide to learn about using snapshot configurations in dbt. - [Snapshot properties](https://docs.getdbt.com/reference/snapshot-properties.md): Read this guide to learn about using source properties in dbt. - [snapshot_meta_column_names](https://docs.getdbt.com/reference/resource-configs/snapshot_meta_column_names.md): Snapshot meta column names - [snapshot_name](https://docs.getdbt.com/reference/resource-configs/snapshot_name.md): Snapshot-name - Read this in-depth guide to learn about configurations in dbt. - [snapshot-paths](https://docs.getdbt.com/reference/project-configs/snapshot-paths.md): Read this guide to understand the snapshot-paths configuration in dbt. - [Snowflake adapter behavior changes](https://docs.getdbt.com/reference/global-configs/snowflake-changes.md): The snowflakedefaulttransientdynamictables flag - [Snowflake configurations](https://docs.getdbt.com/reference/resource-configs/snowflake-configs.md): Snowflake Configurations - Read this in-depth guide to learn about configurations in dbt. - [Snowflake permissions](https://docs.getdbt.com/reference/database-permissions/snowflake-permissions.md): In Snowflake, permissions are used to control who can perform certain actions on different database objects. Use SQL statements to manage permissions in a Snowflake database. - [Source configurations](https://docs.getdbt.com/reference/source-configs.md): Learn how to use source configurations in dbt. - [Source definitions for state:modified](https://docs.getdbt.com/reference/global-configs/behavior-flags/state_modified_compare_more_unrendered_values.md): This flag was removed in and in . The new behavior is always enabled. If you're upgrading, remove this flag from your dbt_project.yml. - [Source properties](https://docs.getdbt.com/reference/source-properties.md): Learn how to use source properties in dbt. - [Sources JSON file](https://docs.getdbt.com/reference/artifacts/sources-json.md): Current schema: v3 - [SQL parse](https://docs.getdbt.com/reference/global-configs/sqlparse.md): Configure sqlparse grouping limits when dbt compiles SQL. - [sql_header](https://docs.getdbt.com/reference/resource-configs/sql_header.md): Sql_header - Read this in-depth guide to learn about configurations in dbt. - [sql_header in data tests](https://docs.getdbt.com/reference/global-configs/behavior-flags/require_sql_header_in_test_configs.md): | requiresqlheaderintest_configs | Latest | | - [Starburst/Trino configurations](https://docs.getdbt.com/reference/resource-configs/trino-configs.md): Configure Starburst/Trino-specific settings for dbt models, including cluster requirements and catalog permissions. - [Starrocks configurations](https://docs.getdbt.com/reference/resource-configs/starrocks-configs.md): Starrocks Configurations - Read this in-depth guide to learn about configurations in dbt. - [Static analysis](https://docs.getdbt.com/reference/global-configs/static-analysis-flag.md): Use the --static-analysis flag to override model-level static_analysis behavior for a single run. - [static_analysis](https://docs.getdbt.com/reference/resource-configs/static-analysis.md): Use the static_analysis config to control how the Fusion engine performs static SQL analysis for models, tests, seeds, and snapshots. - [store_failures](https://docs.getdbt.com/reference/resource-configs/store_failures.md): Set whether a data test always or never stores its failing records in the database. - [store_failures_as](https://docs.getdbt.com/reference/resource-configs/store_failures_as.md): Specify how a data test stores its failures in the database: as a table, a view, or ephemerally. - [strategy](https://docs.getdbt.com/reference/resource-configs/strategy.md): Strategy - Read this in-depth guide to learn about configurations in dbt. - [Supported BigQuery functions in dbt Fusion](https://docs.getdbt.com/reference/resource-configs/bigquery-function-support.md): Check which BigQuery built-in SQL functions dbt Fusion can typecheck during static analysis. - [Supported data formats for unit tests](https://docs.getdbt.com/reference/resource-properties/data-formats.md): Currently, mock data for unit testing in dbt supports three formats: - [Supported Snowflake functions in dbt Fusion](https://docs.getdbt.com/reference/resource-configs/snowflake-function-support.md): Check which Snowflake built-in SQL functions dbt Fusion can typecheck during static analysis. - [Syntax overview](https://docs.getdbt.com/reference/node-selection/syntax.md): Node selection syntax enables you to execute dbt commands for specific models and resources. - [tags](https://docs.getdbt.com/reference/resource-configs/tags.md): Configure tags to label and organize your dbt models and resources. - [target_database](https://docs.getdbt.com/reference/resource-configs/target_database.md): Target_database - Read this in-depth guide to learn about configurations in dbt. - [target_schema](https://docs.getdbt.com/reference/resource-configs/target_schema.md): Target_schema - Read this in-depth guide to learn about configurations in dbt. - [Teradata configurations](https://docs.getdbt.com/reference/resource-configs/teradata-configs.md): Configure Teradata-specific settings for dbt models, including quote_columns and other adapter options. - [Test selection examples](https://docs.getdbt.com/reference/node-selection/test-selection-examples.md): Test selection works a little differently from other resource selection. This makes it very easy to: - [test-paths](https://docs.getdbt.com/reference/project-configs/test-paths.md): Definition - [type](https://docs.getdbt.com/reference/resource-configs/type.md): The type config specifies the type of user-defined function you're creating. - [Unique project resource names](https://docs.getdbt.com/reference/global-configs/behavior-flags/require_unique_project_resource_names.md): | requireuniqueprojectresourcenames | Latest | | - [unique_key](https://docs.getdbt.com/reference/resource-configs/unique_key.md): Learn more about unique_key configurations in dbt. - [Unit test overrides](https://docs.getdbt.com/reference/resource-properties/unit-test-overrides.md): When configuring your unit test, you can override the output of macros, project variables, or environment variables for a given unit test. - [Unit testing versioned SQL models](https://docs.getdbt.com/reference/resource-properties/unit-testing-versions.md): If your model has multiple versions, the default unit test will run on all versions of your model. To specify version(s) of your model to unit test, use include or exclude for the desired versions in your model versions config: - [updated_at](https://docs.getdbt.com/reference/resource-configs/updated_at.md): Updated_at - Read this in-depth guide to learn about configurations in dbt. - [Upsolver configurations](https://docs.getdbt.com/reference/resource-configs/upsolver-configs.md): Upsolver Configurations - Read this in-depth guide to learn about configurations in dbt. - [User settings](https://docs.getdbt.com/reference/global-configs/user-settings.md): Configure user-scoped dbt settings in ~/.dbt/user_settings.yml. - [Using the + prefix](https://docs.getdbt.com/reference/resource-configs/plus-prefix.md): The + prefix helps disambiguate between resource paths and configs in dbt_project.yml files. - [Valid schema from generate_schema_name](https://docs.getdbt.com/reference/global-configs/behavior-flags/require_valid_schema_from_generate_schema_name.md): | requirevalidschemafromgenerateschemaname | Latest | | - [version](https://docs.getdbt.com/reference/project-configs/version.md): dbt projects have two distinct types of version tags. This field has a different meaning depending on its location. - [versions](https://docs.getdbt.com/reference/resource-properties/versions.md): .yml'> - [Vertica configurations](https://docs.getdbt.com/reference/resource-configs/vertica-configs.md): Configure Vertica-specific settings for dbt models, including incremental model configurations and supported on_schema_change options. - [volatility](https://docs.getdbt.com/reference/resource-configs/volatility.md): Declare the volatility (deterministic, stable, or non-deterministic) of a user-defined function (UDF) so the warehouse can optimize how it runs. - [Warn-error handler for all warnings](https://docs.getdbt.com/reference/global-configs/behavior-flags/require_all_warnings_handled_by_warn_error.md): | requireallwarningshandledbywarnerror | Latest | | - [Warnings](https://docs.getdbt.com/reference/global-configs/warnings.md): Use --warn-error to promote all warnings to errors - [where](https://docs.getdbt.com/reference/resource-configs/where.md): Filter the rows of a model, source, seed, or snapshot that a data test evaluates. - [YAML Selectors](https://docs.getdbt.com/reference/node-selection/yaml-selectors.md): Write resource selectors in YAML, save them with a human-friendly name, and reference them using the --selector flag. - [Yellowbrick configurations](https://docs.getdbt.com/reference/resource-configs/yellowbrick-configs.md): Yellowbrick Configurations: Read this in-depth guide to learn about configurations in dbt. ## Search - [Search the documentation](https://docs.getdbt.com/search.md) ## Set up dbt - [About environments](https://docs.getdbt.com/docs/environments-in-dbt.md): In software engineering, environments are used to enable engineers to develop and test code without impacting the users of their software. Typically, there are two types of environments in dbt: - [dbt setup and installation](https://docs.getdbt.com/docs/about-setup.md): About setup and installation of self-hosted dbt and the dbt platform - [Run your dbt projects](https://docs.getdbt.com/docs/running-a-dbt-project/run-your-dbt-projects.md): You can run your dbt projects locally or using the with the dbt framework. - [Using threads](https://docs.getdbt.com/docs/running-a-dbt-project/using-threads.md): Understand what threads mean and how to use them. ### dbt local installation - [dbt environments](https://docs.getdbt.com/docs/local/dbt-core-environments.md): dbt makes it easy to maintain separate production and development environments through the use of targets within a profile. A typical profile, when using dbt locally (for example, running from your command line), will have a target named dev and have this set as the default. This means that while making changes, your objects will be built in your development target without affecting production queries made by your end users. Once you are confident in your changes, you can deploy the code to production, by running your dbt project with a prod target. - [Install dbt](https://docs.getdbt.com/docs/local/install-dbt.md): Learn how to install the dbt CLI and other tools in your Windows, macOS, or Linux environment #### Connect data platform - [About data platform connections](https://docs.getdbt.com/docs/local/connect-data-platform/about-dbt-connections.md): Learn how to connect dbt to your data platform - [Apache Spark setup](https://docs.getdbt.com/docs/local/connect-data-platform/spark-setup.md): Read this guide to learn about the Apache Spark warehouse setup in dbt. - [BigQuery](https://docs.getdbt.com/docs/local/connect-data-platform/bigquery-setup.md): Read this guide to learn about the BigQuery warehouse setup in dbt. - [Connect AlloyDB to dbt Core](https://docs.getdbt.com/docs/local/connect-data-platform/alloydb-setup.md): Profile Configuration - [Connect Athena to dbt Core](https://docs.getdbt.com/docs/local/connect-data-platform/athena-setup.md): Read this guide to learn about the Athena warehouse setup in dbt. - [Connect AWS Glue to dbt Core](https://docs.getdbt.com/docs/local/connect-data-platform/glue-setup.md): Read this guide to learn about the AWS Glue warehouse setup in dbt. - [Connect ClickHouse to dbt Core](https://docs.getdbt.com/docs/local/connect-data-platform/clickhouse-setup.md): Read this guide to learn about the ClickHouse warehouse setup in dbt. - [Connect Cloudera Hive to dbt Core](https://docs.getdbt.com/docs/local/connect-data-platform/hive-setup.md): Read this guide to learn about the Cloudera Hive warehouse setup in dbt. - [Connect Cloudera Impala to dbt Core](https://docs.getdbt.com/docs/local/connect-data-platform/impala-setup.md): Read this guide to learn about the Cloudera Impala warehouse setup in dbt. - [Connect Confluent Cloud to dbt Core](https://docs.getdbt.com/docs/local/connect-data-platform/confluent-setup.md): Set up dbt Core with Confluent Cloud for Apache Flink using the dbt-confluent adapter. - [Connect CrateDB to dbt Core](https://docs.getdbt.com/docs/local/connect-data-platform/cratedb-setup.md): Read this guide to learn about the CrateDB data platform setup in dbt. - [Connect Databend Cloud to dbt Core](https://docs.getdbt.com/docs/local/connect-data-platform/databend-setup.md): Read this guide to learn about the Databend warehouse setup in dbt. - [Connect Databricks Lakebase to dbt Core](https://docs.getdbt.com/docs/local/connect-data-platform/lakebase-setup.md): Profile Configuration - [Connect Decodable to dbt Core](https://docs.getdbt.com/docs/local/connect-data-platform/decodable-setup.md): Some core functionality may be limited. If you're interested in contributing, see the source code for the repository listed below. - [Connect DeltaStream to dbt Core](https://docs.getdbt.com/docs/local/connect-data-platform/deltastream-setup.md): Read this guide to learn about the DeltaStream warehouse setup in dbt. - [Connect Doris to dbt Core](https://docs.getdbt.com/docs/local/connect-data-platform/doris-setup.md): Read this guide to learn about the Doris warehouse setup in dbt. - [Connect Dremio to dbt Core](https://docs.getdbt.com/docs/local/connect-data-platform/dremio-setup.md): Read this guide to learn about the Dremio warehouse setup in dbt. - [Connect Exasol to dbt Core](https://docs.getdbt.com/docs/local/connect-data-platform/exasol-setup.md): Read this guide to learn about the Exasol warehouse setup in dbt. - [Connect Extrica to dbt Core](https://docs.getdbt.com/docs/local/connect-data-platform/extrica-setup.md): Read this guide to learn about the Extrica Trino Query Engine setup in dbt. - [Connect Firebolt to dbt Core](https://docs.getdbt.com/docs/local/connect-data-platform/firebolt-setup.md): Read this guide to learn about the Firebolt warehouse setup in dbt. - [Connect Greenplum to dbt Core](https://docs.getdbt.com/docs/local/connect-data-platform/greenplum-setup.md): Read this guide to learn about the Greenplum warehouse setup in dbt. - [Connect Hologres to dbt Core](https://docs.getdbt.com/docs/local/connect-data-platform/hologres-setup.md): Read this guide to learn about the Alibaba Cloud Hologres setup in dbt. - [Connect IBM Db2 to dbt Core](https://docs.getdbt.com/docs/local/connect-data-platform/ibm-db2-setup.md): Read this guide to learn about the IBM Db2 setup in dbt. - [Connect IBM Netezza to dbt Core](https://docs.getdbt.com/docs/local/connect-data-platform/ibmnetezza-setup.md): Read this guide to learn about the IBM Netezza setup in dbt. - [Connect IBM watsonx.data Presto to dbt Core](https://docs.getdbt.com/docs/local/connect-data-platform/watsonx-presto-setup.md): Read this guide to learn about the IBM watsonx.data Presto setup in dbt. - [Connect IBM watsonx.data Spark to dbt Core](https://docs.getdbt.com/docs/local/connect-data-platform/watsonx-spark-setup.md): Read this guide to learn about the IBM watsonx.data Spark setup in dbt. - [Connect Infer to dbt Core](https://docs.getdbt.com/docs/local/connect-data-platform/infer-setup.md): Read this guide to learn about the Infer warehouse setup in dbt. - [Connect iomete to dbt Core](https://docs.getdbt.com/docs/local/connect-data-platform/iomete-setup.md): Read this guide to learn about the iomete warehouse setup in dbt. - [Connect Layer to dbt Core](https://docs.getdbt.com/docs/local/connect-data-platform/layer-setup.md): Read this guide to learn about the Layer warehouse setup in dbt. - [Connect Materialize to dbt Core](https://docs.getdbt.com/docs/local/connect-data-platform/materialize-setup.md): Read this guide to learn about the Materialize warehouse setup in dbt. - [Connect MaxCompute to dbt Core](https://docs.getdbt.com/docs/local/connect-data-platform/maxcompute-setup.md): Read this guide to learn about the MaxCompute setup in dbt. - [Connect Microsoft Azure Synapse Analytics to dbt Core](https://docs.getdbt.com/docs/local/connect-data-platform/azuresynapse-setup.md): Read this guide to learn about the Mircosoft Azure Synapse Analytics dedicated SQL pool setup in dbt. - [Connect Microsoft Fabric Data Warehouse to dbt Core](https://docs.getdbt.com/docs/local/connect-data-platform/fabric-setup.md): Read this guide to learn about the Microsoft Fabric Data Warehouse setup in dbt. - [Connect Microsoft Fabric Lakehouse to dbt Core](https://docs.getdbt.com/docs/local/connect-data-platform/fabricspark-setup.md): Read this guide to learn about the Microsoft Fabric spark setup for Lakehouse in dbt. - [Connect Microsoft SQL Server to dbt Core](https://docs.getdbt.com/docs/local/connect-data-platform/mssql-setup.md): Read this guide to learn about the Microsoft SQL Server warehouse setup in dbt. - [Connect MindsDB to dbt Core](https://docs.getdbt.com/docs/local/connect-data-platform/mindsdb-setup.md): The dbt-mindsdb package allows dbt to connect to MindsDB. - [Connect MySQL to dbt Core](https://docs.getdbt.com/docs/local/connect-data-platform/mysql-setup.md): Read this guide to learn about the MySQL warehouse setup in dbt. - [Connect Oracle to dbt Core](https://docs.getdbt.com/docs/local/connect-data-platform/oracle-setup.md): Read this guide to learn about the Oracle warehouse setup in dbt. - [Connect Postgres to dbt Core](https://docs.getdbt.com/docs/local/connect-data-platform/postgres-setup.md): Read this guide to learn about the Postgres warehouse setup in dbt. - [Connect RisingWave to dbt Core](https://docs.getdbt.com/docs/local/connect-data-platform/risingwave-setup.md): Read this guide to learn about how to set up RisingWave in dbt. - [Connect Rockset to dbt Core](https://docs.getdbt.com/docs/local/connect-data-platform/rockset-setup.md): Read this guide to learn about the Rockset warehouse setup in dbt. - [Connect SingleStore to dbt Core](https://docs.getdbt.com/docs/local/connect-data-platform/singlestore-setup.md): Read this guide to learn about the SingleStore warehouse setup in dbt. - [Connect SQLite to dbt Core](https://docs.getdbt.com/docs/local/connect-data-platform/sqlite-setup.md): Read this guide to learn about the SQLite warehouse setup in dbt. - [Connect Starburst/Trino to dbt Core](https://docs.getdbt.com/docs/local/connect-data-platform/trino-setup.md): Read this guide to learn about the Starburst/Trino warehouse setup in dbt. - [Connect StarRocks to dbt Core](https://docs.getdbt.com/docs/local/connect-data-platform/starrocks-setup.md): Read this guide to learn about the Starrocks warehouse setup in dbt. - [Connect Teradata to dbt Core](https://docs.getdbt.com/docs/local/connect-data-platform/teradata-setup.md): Read this guide to learn about the Teradata warehouse setup in dbt. - [Connect TiDB to dbt Core](https://docs.getdbt.com/docs/local/connect-data-platform/tidb-setup.md): Read this guide to learn about the TiDB warehouse setup in dbt. - [Connect Upsolver to dbt Core](https://docs.getdbt.com/docs/local/connect-data-platform/upsolver-setup.md): Read this guide to learn how to configure Upsolver with dbt. - [Connect Vertica to dbt Core](https://docs.getdbt.com/docs/local/connect-data-platform/vertica-setup.md): If you're interested in contributing, check out the source code for each repository listed below. - [Connect YDB to dbt Core](https://docs.getdbt.com/docs/local/connect-data-platform/ydb-setup.md): Read this guide to learn how to configure YDB with dbt. - [Connect Yellowbrick to dbt Core](https://docs.getdbt.com/docs/local/connect-data-platform/yellowbrick-setup.md): Read this guide to learn about the Yellowbrick warehouse setup in dbt. - [Databricks setup](https://docs.getdbt.com/docs/local/connect-data-platform/databricks-setup.md): Read this guide to learn about the Databricks warehouse setup in dbt. - [DuckDB setup](https://docs.getdbt.com/docs/local/connect-data-platform/duckdb-setup.md): Read this guide to learn about the DuckDB warehouse setup in dbt. - [Redshift setup](https://docs.getdbt.com/docs/local/connect-data-platform/redshift-setup.md): Read this guide to learn about the Redshift warehouse setup in dbt. - [Sail setup](https://docs.getdbt.com/docs/local/connect-data-platform/sail-setup.md): Read this guide to learn about the Sail setup in dbt. - [Salesforce Data 360 setup Beta](https://docs.getdbt.com/docs/local/connect-data-platform/salesforce-data-cloud-setup.md): Read this guide to learn about the Salesforce Data 360 warehouse setup in dbt. - [Snowflake setup](https://docs.getdbt.com/docs/local/connect-data-platform/snowflake-setup.md): Read this guide to learn about the Snowflake warehouse setup in dbt. #### Install dbt Fusion engine - [About self-hosted Fusion installation Preview](https://docs.getdbt.com/docs/fusion/about-fusion-install.md): Install the Fusion engine in a self-hosted setup to take data transformation to the next level. ### dbt platform - [About dbt setup](https://docs.getdbt.com/docs/platform/about-platform-setup.md): Configuration settings for dbt. - [Account integrations in dbt](https://docs.getdbt.com/docs/platform/account-integrations.md): Learn how to configure account integrations for your dbt account. - [Account settings in dbt](https://docs.getdbt.com/docs/platform/account-settings.md): Learn how to enable account settings for your dbt users. - [dbt environments](https://docs.getdbt.com/docs/dbt-platform-environments.md): Learn about dbt's development environment to execute your project in the IDE - [Multi-cell migration checklist](https://docs.getdbt.com/docs/platform/migration.md): Prepare for account migration to AWS cell-based architecture. #### Connect data platform - [About data platform connections](https://docs.getdbt.com/docs/platform/connect-data-platform/about-connections.md): Information about data platform connections - [Connect Amazon Athena](https://docs.getdbt.com/docs/platform/connect-data-platform/connect-amazon-athena.md): Configure the Amazon Athena data platform connection in dbt. - [Connect Apache Spark](https://docs.getdbt.com/docs/platform/connect-data-platform/connect-apache-spark.md): Setup instructions for connecting Apache Spark to dbt - [Connect Azure Synapse Analytics](https://docs.getdbt.com/docs/platform/connect-data-platform/connect-azure-synapse-analytics.md): Configure Azure Synapse Analytics connection. - [Connect BigQuery Fusion compatible](https://docs.getdbt.com/docs/platform/connect-data-platform/connect-bigquery.md): Configure BigQuery connection. - [Connect Databricks Fusion compatible](https://docs.getdbt.com/docs/platform/connect-data-platform/connect-databricks.md): Setup instructions for connecting Databricks to dbt - [Connect Microsoft Fabric](https://docs.getdbt.com/docs/platform/connect-data-platform/connect-microsoft-fabric.md): Configure Microsoft Fabric connection. - [Connect Onehouse](https://docs.getdbt.com/docs/platform/connect-data-platform/connect-onehouse.md): Setup instructions for connecting Onehouse to dbt - [Connect PostgreSQL, Lakebase and AlloyDB](https://docs.getdbt.com/docs/platform/connect-data-platform/connect-postgresql-alloydb.md): Setup instructions for connecting PostgreSQL, Lakebase, and AlloyDB to dbt - [Connect Redshift Fusion compatible](https://docs.getdbt.com/docs/platform/connect-data-platform/connect-redshift.md): Setup instructions for connecting Redshift to dbt - [Connect Salesforce Data 360 Beta Fusion compatible](https://docs.getdbt.com/docs/platform/connect-data-platform/connect-salesforce.md): Configure Salesforce Data 360 connection. - [Connect Snowflake Fusion compatible](https://docs.getdbt.com/docs/platform/connect-data-platform/connect-snowflake.md): Configure Snowflake connection. - [Connect Starburst or Trino](https://docs.getdbt.com/docs/platform/connect-data-platform/connect-starburst-trino.md): Configure Starburst or Trino connection. - [Connect Teradata Preview](https://docs.getdbt.com/docs/platform/connect-data-platform/connect-teradata.md): Configure the Teradata platform connection in dbt. #### Git - [About git](https://docs.getdbt.com/docs/platform/git/git-version-control.md): Git overview - [Authenticate with Azure DevOps](https://docs.getdbt.com/docs/platform/git/authenticate-azure.md): dbt developers need to authenticate with Azure DevOps. - [Configure Git in dbt](https://docs.getdbt.com/docs/platform/git/configure-git.md): Learn about the Git providers supported in dbt - [Connect to Azure DevOps](https://docs.getdbt.com/docs/platform/git/connect-azure-devops.md): About Azure DevOps and dbt - [Connect to GitHub](https://docs.getdbt.com/docs/platform/git/connect-github.md): Learn how connecting your GitHub account provides convenience and another layer of security to dbt. - [Connect to GitLab](https://docs.getdbt.com/docs/platform/git/connect-gitlab.md): Learn how connecting your GitLab account provides convenience and another layer of security to dbt. - [Connect with Git clone](https://docs.getdbt.com/docs/platform/git/import-a-project-by-git-url.md): Learn how to connect to a git repository using a git URL. - [Connect with managed repository](https://docs.getdbt.com/docs/platform/git/managed-repository.md): Learn how to set up a project with a managed repository. - [Merge conflicts](https://docs.getdbt.com/docs/platform/git/merge-conflicts.md): Merge conflicts in the often occur when multiple users are simultaneously making edits to the same section in the same file. This makes it difficult for to decide what changes to incorporate in the final merge. - [PR template](https://docs.getdbt.com/docs/platform/git/pr-template.md): Configure pull request (PR) template URLs - [Set up Azure DevOps](https://docs.getdbt.com/docs/platform/git/setup-service-principal.md): You can set up your Azure DevOps by creating a Microsoft Entra ID app and adding it to dbt. - [Set up Azure DevOps with Service User](https://docs.getdbt.com/docs/platform/git/setup-service-user.md): You can set up your Azure DevOps by creating a Microsoft Entra ID app and adding it to dbt. - [Version control basics](https://docs.getdbt.com/docs/platform/git/version-control-basics.md): Leverage Git to version control your code. #### Manage access - [About environment-level permissions](https://docs.getdbt.com/docs/platform/manage-access/environment-permissions.md): About environment-level permissions to protect your information - [About user access](https://docs.getdbt.com/docs/platform/manage-access/about-user-access.md): Learn how dbt administrators can use dbt's permissioning model to control user-level access in a dbt account. - [Connect apps with OAuth Beta](https://docs.getdbt.com/docs/platform/manage-access/connect-apps-oauth.md): Manage OAuth 2.0 client registrations to connect AI tools and third-party apps to dbt. - [dbt audit log](https://docs.getdbt.com/docs/platform/manage-access/audit-log.md): You can troubleshoot possible issues and provide security audits by reviewing event activity in your account. - [Enterprise permissions](https://docs.getdbt.com/docs/platform/manage-access/enterprise-permissions.md): Permission sets for Enterprise plans. - [Invite users to dbt](https://docs.getdbt.com/docs/platform/manage-access/invite-users.md): Learn how to manually invite users to dbt - [Manage user licenses with SCIM](https://docs.getdbt.com/docs/platform/manage-access/scim-manage-user-licenses.md): Automate license assignment for Okta users via SCIM. - [Migrating to Auth0 for SSO](https://docs.getdbt.com/docs/platform/manage-access/auth0-migration.md): Required actions for migrating to Auth0 for SSO services on dbt. - [Multi-factor authentication](https://docs.getdbt.com/docs/platform/manage-access/mfa.md): Configure dbt MFA - [OAuth overview](https://docs.getdbt.com/docs/platform/manage-access/oauth-intro.md): Connect development credentials to data platforms using OAuth in the dbt platform. - [SCIM FAQs and troubleshooting](https://docs.getdbt.com/docs/platform/manage-access/scim-faq.md): Common questions and troubleshooting for SCIM provisioning in dbt platform - [Self-service Starter account permissions](https://docs.getdbt.com/docs/platform/manage-access/self-service-permissions.md): Learn how dbt administrators can use self-service permissions to control access in a dbt Starter account. - [Set up BigQuery OAuth](https://docs.getdbt.com/docs/platform/manage-access/set-up-bigquery-oauth.md): Learn how dbt administrators can use BigQuery OAuth to control access in a dbt account - [Set up Databricks OAuth](https://docs.getdbt.com/docs/platform/manage-access/set-up-databricks-oauth.md): Learn how dbt administrators and users can use Databricks OAuth to control access in a dbt account. - [Set up environment-level permissions](https://docs.getdbt.com/docs/platform/manage-access/environment-permissions-setup.md): Set up environment-level permissions to protect your information - [Set up external OAuth with Redshift](https://docs.getdbt.com/docs/platform/manage-access/redshift-external-oauth.md): Configuration instructions for dbt and external OAuth connections with Redshift - [Set up external OAuth with Snowflake](https://docs.getdbt.com/docs/platform/manage-access/snowflake-external-oauth.md): Configuration instructions for dbt and external OAuth connections with Snowflake - [Set up SCIM](https://docs.getdbt.com/docs/platform/manage-access/scim.md): Configure SCIM for SSO - [Set up SCIM with Entra ID](https://docs.getdbt.com/docs/platform/manage-access/scim-entra-id.md): Configure SCIM for Microsoft Entra ID to automate user and group provisioning. - [Set up SCIM with Okta](https://docs.getdbt.com/docs/platform/manage-access/scim-okta.md): Configure SCIM for Okta to automate user and group provisioning and license assignment. - [Set up Snowflake OAuth](https://docs.getdbt.com/docs/platform/manage-access/set-up-snowflake-oauth.md): Learn how dbt administrators can use Snowflake OAuth to control access in a dbt account. - [Set up SSO with Google Workspace](https://docs.getdbt.com/docs/platform/manage-access/set-up-sso-google-workspace.md): Learn how dbt administrators can use Single-Sign On (SSO) via Google GSuite to control access in a dbt account. - [Set up SSO with Microsoft Entra ID](https://docs.getdbt.com/docs/platform/manage-access/set-up-sso-microsoft-entra-id.md): Learn how dbt administrators can use Microsoft Entra ID to control access in a dbt account. - [Set up SSO with Okta](https://docs.getdbt.com/docs/platform/manage-access/set-up-sso-okta.md): Enterprise-tier plans support single-sign on via Okta (using SAML). - [Set up SSO with SAML 2.0](https://docs.getdbt.com/docs/platform/manage-access/set-up-sso-saml-2.0.md): Enterprise-tier plans support single-sign on (SSO) for any SAML 2.0-compliant identity provider (IdP). - [Single sign-on (SSO) overview](https://docs.getdbt.com/docs/platform/manage-access/sso-overview.md): This overview explains how users are provisioned in using single sign-on (SSO). - [Single sign-on and OAuth](https://docs.getdbt.com/docs/platform/manage-access/sso-oauth-intro.md): Overview of SSO, SCIM, and OAuth options for authentication and access in the dbt platform. - [SSO FAQs and troubleshooting](https://docs.getdbt.com/docs/platform/manage-access/sso-faq.md): Common questions and troubleshooting for single sign-on (SSO) in dbt platform - [Users and licenses](https://docs.getdbt.com/docs/platform/manage-access/seats-and-users.md): Learn how dbt administrators can use licenses and seats to control access in a dbt account. #### Secure - [About network security](https://docs.getdbt.com/docs/platform/secure/about-network-security.md): Configure network security for dbt Cloud - [About private connectivity](https://docs.getdbt.com/docs/platform/secure/private-connectivity/private-connectivity.md): Configuring private connections. - [AWS private connectivity](https://docs.getdbt.com/docs/platform/secure/private-connectivity/aws/aws-overview.md): Configure private connections for AWS deployments of the dbt platform. - [Azure private connectivity](https://docs.getdbt.com/docs/platform/secure/private-connectivity/azure/azure-overview.md): Configure private connections for Azure deployments of the dbt platform. - [Configure AWS PrivateLink for Postgres](https://docs.getdbt.com/docs/platform/secure/private-connectivity/aws/aws-postgres.md): Configuring PrivateLink for Postgres. - [Configure AWS PrivateLink for Redshift](https://docs.getdbt.com/docs/platform/secure/private-connectivity/aws/aws-redshift.md): Configuring PrivateLink for Redshift. - [Configuring AWS PrivateLink for a self-hosted service](https://docs.getdbt.com/docs/platform/secure/private-connectivity/aws/aws-self-hosted.md): Setting up an AWS PrivateLink connection between dbt and your self-hosted service. - [Configuring AWS PrivateLink for single-tenant ingress Beta](https://docs.getdbt.com/docs/platform/secure/private-connectivity/aws/aws-ingress.md): Configure inbound AWS PrivateLink so your services reach a single-tenant dbt platform instance over a private access URL. - [Configuring AWS PrivateLink for Teradata VantageCloud](https://docs.getdbt.com/docs/platform/secure/private-connectivity/aws/aws-teradata.md): Configuring AWS PrivateLink for Teradata VantageCloud. - [Configuring Azure Private Link for a self-hosted service](https://docs.getdbt.com/docs/platform/secure/private-connectivity/azure/azure-self-hosted.md): Setting up an Azure Private Link connection between dbt and your self-hosted service. - [Configuring Azure Private Link for Teradata VantageCloud](https://docs.getdbt.com/docs/platform/secure/private-connectivity/azure/azure-teradata.md): Configuring Azure Private Link for Teradata VantageCloud. - [Configuring BigQuery Private Service Connect](https://docs.getdbt.com/docs/platform/secure/private-connectivity/gcp/gcp-bigquery.md): Configuring GCP Private Service Connect for BigQuery. - [Configuring Databricks and Azure Private Link](https://docs.getdbt.com/docs/platform/secure/private-connectivity/azure/azure-databricks.md): Configuring Azure Private Link for Databricks. - [Configuring Databricks PrivateLink](https://docs.getdbt.com/docs/platform/secure/private-connectivity/aws/aws-databricks.md): Configuring AWS PrivateLink for Databricks. - [Configuring GCP Private Service Connect for a self-hosted service](https://docs.getdbt.com/docs/platform/secure/private-connectivity/gcp/gcp-self-hosted.md): Setting up a GCP Private Service Connect connection between dbt and your self-hosted service. - [Configuring Private Link for Azure Database for Postgres Flexible Server](https://docs.getdbt.com/docs/platform/secure/private-connectivity/azure/azure-postgres.md): Configuring Private Link for Azure Database for Postgres Flexible Server. - [Configuring Private Link for Azure Synapse](https://docs.getdbt.com/docs/platform/secure/private-connectivity/azure/azure-synapse.md): Configuring Private Link for Azure Synapse. - [Configuring Private Link for Microsoft Fabric Beta](https://docs.getdbt.com/docs/platform/secure/private-connectivity/azure/azure-fabric.md): Configuring Azure Private Link for Microsoft Fabric. - [Configuring public IP restrictions](https://docs.getdbt.com/docs/platform/secure/ip-restrictions.md): Restrict public access to the dbt platform by allowing only specific IP addresses. - [Configuring Snowflake and Azure Private Link](https://docs.getdbt.com/docs/platform/secure/private-connectivity/azure/azure-snowflake.md): Configuring Azure Private Link for Snowflake. - [Configuring Snowflake Private Service Connect](https://docs.getdbt.com/docs/platform/secure/private-connectivity/gcp/gcp-snowflake.md): Configuring GCP Private Service Connect for Snowflake. - [Configuring Snowflake PrivateLink](https://docs.getdbt.com/docs/platform/secure/private-connectivity/aws/aws-snowflake.md): Configuring AWS PrivateLink for Snowflake. - [GCP private connectivity](https://docs.getdbt.com/docs/platform/secure/private-connectivity/gcp/gcp-overview.md): Configure private connections for GCP deployments of the dbt platform. ## Sql Reference - [SQL AND](https://docs.getdbt.com/sql-reference/and.md): The AND operator returns results that meet all requirements passed into it. You’ll often see the AND operator used in a WHERE clause to filter query results. - [SQL ANY and ALL](https://docs.getdbt.com/sql-reference/any-all.md): The ANY operator will return true if any of the conditions passed into evaluate to true, while ALL will only return true if all conditions passed into it are true. - [SQL ARRAY_AGG](https://docs.getdbt.com/sql-reference/array-agg.md): The ARRAY_AGG function allows you to create an array of multiple data values in SQL. - [SQL AVG](https://docs.getdbt.com/sql-reference/avg.md): The AVG function is used to calculate the simple average of a numeric column, but you may also see it used in a window function to calculate rolling averages. - [SQL BETWEEN](https://docs.getdbt.com/sql-reference/between.md): The SQL BETWEEN condition allows you to specify a range of numerical, date-type, or text values to filter rows on in a query. - [SQL CASE WHEN](https://docs.getdbt.com/sql-reference/case.md): CASE statements allow you to cascade through multiple scenarios (or cases) in your data, evaluate them if they’re true, and output a corresponding value for each case. - [SQL CAST](https://docs.getdbt.com/sql-reference/cast.md): Executing the CAST function in a SELECT statement will return the column you specified as the newly specified data type. - [SQL Comments](https://docs.getdbt.com/sql-reference/comments.md): Inline SQL comments will begin with two dashes (--) in front of them in a query or dbt model; any text following these dashes is therefore what you’d call “commented out.” For longer, multi-line comments, you’ll typically see this syntax `/* your multi-line comment here */` used. - [SQL CONCAT](https://docs.getdbt.com/sql-reference/concat.md): The CONCAT function allows analytics engineers to join multiple string values in a query. - [SQL COUNT](https://docs.getdbt.com/sql-reference/count.md): COUNT is an aggregate function that is used to return the count of rows of a specified field or all rows in a dataset. It is commonly used to get baseline statistical information of a dataset, help ensure primary keys are unique, and calculate business metrics. - [SQL CROSS JOIN](https://docs.getdbt.com/sql-reference/cross-join.md): A cross join typically takes two columns between two database objects and creates a table forming a combination of all rows across joined tables, called a cartesian product. - [SQL Data Types](https://docs.getdbt.com/sql-reference/data-types.md): The different data types in SQL are numeric, string, date, booleans, and semi-structured. This content covers the differences between them and their subcategories. - [SQL DATE_PART](https://docs.getdbt.com/sql-reference/datepart.md): The DATE_PART function allows you to extract a specified date part from a date/time. Like most other SQL functions, you need to pass in arguments; for the DATE_PART function, you’ll pass in a date/timestamp/date field that you want to extract a date part from and specify the part you want removed. - [SQL DATE_TRUNC](https://docs.getdbt.com/sql-reference/date-trunc.md): The DATE_TRUNC function will truncate a date or time to the first instance of a given date part. You can truncate to the weeks, months, years, or other date parts for a date or time field. - [SQL DATEADD](https://docs.getdbt.com/sql-reference/dateadd.md): The DATEADD function in SQL adds a time/date interval to a date and then returns the date. This allows you to add or subtract a certain period of time from a given start date. - [SQL DATEDIFF](https://docs.getdbt.com/sql-reference/datediff.md): The DATEDIFF function will return the difference in specified units (ex. days, weeks, years) between a start date/time and an end date/time. - [SQL DISTINCT](https://docs.getdbt.com/sql-reference/distinct.md): Using DISTINCT in a SELECT statement will force a query to only return non-duplicate rows. You may commonly see a DISTINCT clause in COUNT functions to get counts of distinct rows. - [SQL FROM](https://docs.getdbt.com/sql-reference/from.md): The SQL FROM statement allows you to identify the database schema object (table/view) you want to select data from in a query. - [SQL GROUP BY](https://docs.getdbt.com/sql-reference/group-by.md): The GROUP BY statement allows you to group query results by specified columns and is used in pair with aggregate functions such as AVG and SUM to calculate those values across specific rows. - [SQL HAVING](https://docs.getdbt.com/sql-reference/having.md): Read this guide to learn about the SQL HAVING clause in dbt. - [SQL ILIKE](https://docs.getdbt.com/sql-reference/ilike.md): The ILIKE operator helps you easily match, find, and filter out case-insensitive string values of a specified pattern by using SQL wildcards. - [SQL IN](https://docs.getdbt.com/sql-reference/in.md): Read this guide to learn about the SQL IN operator in dbt. - [SQL INNER JOINS](https://docs.getdbt.com/sql-reference/inner-join.md): An inner join between two database objects returns all rows that have matching join keys; any keys that don’t match are omitted from the query result. - [SQL LEFT JOIN](https://docs.getdbt.com/sql-reference/left-join.md): The left join returns all rows in the FROM statement, regardless of match in the left join database object. - [SQL LIKE](https://docs.getdbt.com/sql-reference/like.md): The LIKE operator helps you easily match, find, and filter out case-sensitive string values of a specified pattern by using SQL wildcards. - [SQL LIMIT](https://docs.getdbt.com/sql-reference/limit.md): Read this guide to learn about the SQL LIMIT clause in dbt. - [SQL LOWER](https://docs.getdbt.com/sql-reference/lower.md): Using the LOWER function on a string value will return the input as an all-lowercase string. It’s an effective way to create consistent capitalization for string values across your data. - [SQL MAX](https://docs.getdbt.com/sql-reference/max.md): The SQL MAX aggregate function allows you to compute the maximum value from a column. - [SQL MIN](https://docs.getdbt.com/sql-reference/min.md): The MIN aggregate function allows you to compute the minimum value from a column or across a set of rows for a column. - [SQL NOT](https://docs.getdbt.com/sql-reference/not.md): The SQL NOT operator allows you to return results from conditions that are not true. he NOT boolean is kind of similar to an adjective—it’s often put in front of another operator. - [SQL OR](https://docs.getdbt.com/sql-reference/or.md): Read this guide to learn about the SQL OR operator in dbt. - [SQL ORDER BY](https://docs.getdbt.com/sql-reference/order-by.md): Read this guide to learn about the SQL ORDER BY clause in dbt. - [SQL OUTER JOIN](https://docs.getdbt.com/sql-reference/outer-join.md): A SQL full outer join is a join between two tables that returns all rows from both tables, regardless of join key match success. - [SQL RANK](https://docs.getdbt.com/sql-reference/rank.md): The RANK function returns the rank of a value (starting at 1) in an ordered group or dataset. - [SQL Reference](https://docs.getdbt.com/sql-reference.md): The SQL Reference is a collection of SQL functions and keywords that you can use during your daily data work. - [SQL RIGHT JOIN](https://docs.getdbt.com/sql-reference/right-join.md): Right joins return all rows in the right join database object regardless of match in the database object in the FROM statement. - [SQL ROUND](https://docs.getdbt.com/sql-reference/round.md): The ROUND aggregate function allows you to round numeric fields or values in SQL to the number of decimal places of your choosing. - [SQL ROW_NUMBER](https://docs.getdbt.com/sql-reference/row-number.md): The ROW_NUMBER function returns the unique row number of a row in an ordered group or dataset. - [SQL SELECT](https://docs.getdbt.com/sql-reference/select.md): The SQL SELECT statement is the fundamental building block of any query that allows you to select specific columns from a database schema object. - [SQL SELF JOINS](https://docs.getdbt.com/sql-reference/self-join.md): A self join allows you to join a dataset back onto itself. A common use cases to leverage a self join is when a table contains a foreign key to the primary key of that same table. - [SQL Strings](https://docs.getdbt.com/sql-reference/strings.md): Strings in SQL are words or combination of characters that you’ll typically see encased in single quotes (ex. 'Jaffle Shop', '1234 Shire Lane', 'Plan A'). - [SQL SUM](https://docs.getdbt.com/sql-reference/sum.md): The SUM aggregate function allows you to calculate the sum of a numeric column or across a set of rows for a column. - [SQL TRIM](https://docs.getdbt.com/sql-reference/trim.md): The SQL TRIM function removes the leading and trailing characters of a string. By default, it removes the blank space character from the beginning and end of a string. - [SQL UPPER](https://docs.getdbt.com/sql-reference/upper.md): Using the UPPER function on a string value will return the input as an all-uppercase string. It’s an effective way to create expected capitalization for certain string values across your data. - [SQL WHERE](https://docs.getdbt.com/sql-reference/where.md): Read this guide to learn about the SQL WHERE clause in dbt. ## Tags - [18 docs tagged with "dbt State"](https://docs.getdbt.com/tags/dbt-state.md) - [19 docs tagged with "Metrics"](https://docs.getdbt.com/tags/metrics.md) - [19 docs tagged with "Quickstart"](https://docs.getdbt.com/tags/quickstart.md) - [2 docs tagged with "Adapter creation"](https://docs.getdbt.com/tags/adapter-creation.md) - [2 docs tagged with "Agents"](https://docs.getdbt.com/tags/agents.md) - [2 docs tagged with "Analyst"](https://docs.getdbt.com/tags/analyst.md) - [2 docs tagged with "API"](https://docs.getdbt.com/tags/api.md) - [2 docs tagged with "Beginner"](https://docs.getdbt.com/tags/beginner.md) - [2 docs tagged with "Best practices"](https://docs.getdbt.com/tags/best-practices.md) - [2 docs tagged with "CI"](https://docs.getdbt.com/tags/ci.md) - [2 docs tagged with "CLI"](https://docs.getdbt.com/tags/cli.md) - [2 docs tagged with "dbt Insights"](https://docs.getdbt.com/tags/dbt-insights.md) - [2 docs tagged with "dbt MCP"](https://docs.getdbt.com/tags/dbt-mcp.md) - [2 docs tagged with "dbt Wizard"](https://docs.getdbt.com/tags/dbt-wizard.md) - [2 docs tagged with "dbt"](https://docs.getdbt.com/tags/dbt.md) - [2 docs tagged with "DuckDB"](https://docs.getdbt.com/tags/duck-db.md) - [2 docs tagged with "Git"](https://docs.getdbt.com/tags/git.md) - [2 docs tagged with "Privacy"](https://docs.getdbt.com/tags/privacy.md) - [2 docs tagged with "Redshift"](https://docs.getdbt.com/tags/redshift.md) - [2 docs tagged with "Reference"](https://docs.getdbt.com/tags/reference.md) - [2 docs tagged with "static_analysis"](https://docs.getdbt.com/tags/static-analysis.md) - [2 docs tagged with "Troubleshooting"](https://docs.getdbt.com/tags/troubleshooting.md) - [2 docs tagged with "Upgrade"](https://docs.getdbt.com/tags/upgrade.md) - [21 docs tagged with "dbt Core"](https://docs.getdbt.com/tags/dbt-core.md) - [26 docs tagged with "dbt platform"](https://docs.getdbt.com/tags/dbt-platform.md) - [26 docs tagged with "Wizard"](https://docs.getdbt.com/tags/wizard.md) - [3 docs tagged with "APIs"](https://docs.getdbt.com/tags/ap-is.md) - [3 docs tagged with "cost insights"](https://docs.getdbt.com/tags/cost-insights.md) - [3 docs tagged with "cost savings"](https://docs.getdbt.com/tags/cost-savings.md) - [3 docs tagged with "IDE"](https://docs.getdbt.com/tags/ide.md) - [3 docs tagged with "models built"](https://docs.getdbt.com/tags/models-built.md) - [3 docs tagged with "SAO"](https://docs.getdbt.com/tags/sao.md) - [34 docs tagged with "AI"](https://docs.getdbt.com/tags/ai.md) - [4 docs tagged with "BigQuery"](https://docs.getdbt.com/tags/big-query.md) - [4 docs tagged with "Orchestration"](https://docs.getdbt.com/tags/orchestration.md) - [4 docs tagged with "Platform"](https://docs.getdbt.com/tags/platform.md) - [42 docs tagged with "Semantic Layer"](https://docs.getdbt.com/tags/semantic-layer.md) - [5 docs tagged with "Migration"](https://docs.getdbt.com/tags/migration.md) - [6 docs tagged with "Databricks"](https://docs.getdbt.com/tags/databricks.md) - [6 docs tagged with "dbt Fusion engine"](https://docs.getdbt.com/tags/dbt-fusion-engine.md) - [6 docs tagged with "dbt Fusion"](https://docs.getdbt.com/tags/dbt-fusion.md) - [6 docs tagged with "Snowflake"](https://docs.getdbt.com/tags/snowflake.md) - [6 docs tagged with "Webhooks"](https://docs.getdbt.com/tags/webhooks.md) - [7 docs tagged with "scheduler"](https://docs.getdbt.com/tags/scheduler.md) - [One doc tagged with "Amazon"](https://docs.getdbt.com/tags/amazon.md) - [One doc tagged with "Athena"](https://docs.getdbt.com/tags/athena.md) - [One doc tagged with "BigFrames"](https://docs.getdbt.com/tags/big-frames.md) - [One doc tagged with "Canvas"](https://docs.getdbt.com/tags/canvas.md) - [One doc tagged with "Configuration"](https://docs.getdbt.com/tags/configuration.md) - [One doc tagged with "Copilot"](https://docs.getdbt.com/tags/copilot.md) - [One doc tagged with "cost optimization"](https://docs.getdbt.com/tags/cost-optimization.md) - [One doc tagged with "cost optimizations"](https://docs.getdbt.com/tags/cost-optimizations.md) - [One doc tagged with "cost reduction"](https://docs.getdbt.com/tags/cost-reduction.md) - [One doc tagged with "cost reductions"](https://docs.getdbt.com/tags/cost-reductions.md) - [One doc tagged with "Dremio"](https://docs.getdbt.com/tags/dremio.md) - [One doc tagged with "Fusion"](https://docs.getdbt.com/tags/fusion.md) - [One doc tagged with "GCP"](https://docs.getdbt.com/tags/gcp.md) - [One doc tagged with "Google"](https://docs.getdbt.com/tags/google.md) - [One doc tagged with "Governance"](https://docs.getdbt.com/tags/governance.md) - [One doc tagged with "Iceberg"](https://docs.getdbt.com/tags/iceberg.md) - [One doc tagged with "Intelligence"](https://docs.getdbt.com/tags/intelligence.md) - [One doc tagged with "Jan-1-2020"](https://docs.getdbt.com/tags/jan-1-2020.md) - [One doc tagged with "Jan-1-2021"](https://docs.getdbt.com/tags/jan-1-2021.md) - [One doc tagged with "Jinja"](https://docs.getdbt.com/tags/jinja.md) - [One doc tagged with "Local development"](https://docs.getdbt.com/tags/local-development.md) - [One doc tagged with "MCP"](https://docs.getdbt.com/tags/mcp.md) - [One doc tagged with "Model"](https://docs.getdbt.com/tags/model.md) - [One doc tagged with "SQL"](https://docs.getdbt.com/tags/sql.md) - [One doc tagged with "Studio"](https://docs.getdbt.com/tags/studio.md) - [One doc tagged with "Tenancy"](https://docs.getdbt.com/tags/tenancy.md) - [One doc tagged with "Teradata"](https://docs.getdbt.com/tags/teradata.md) - [One doc tagged with "v0.5.0"](https://docs.getdbt.com/tags/v-0-5-0.md) - [One doc tagged with "v1.1.01"](https://docs.getdbt.com/tags/v-1-1-01.md) - [One doc tagged with "v1.1.02"](https://docs.getdbt.com/tags/v-1-1-02.md) - [One doc tagged with "v1.1.03"](https://docs.getdbt.com/tags/v-1-1-03.md) - [One doc tagged with "v1.1.04"](https://docs.getdbt.com/tags/v-1-1-04.md) - [One doc tagged with "v1.1.05"](https://docs.getdbt.com/tags/v-1-1-05.md) - [One doc tagged with "v1.1.06"](https://docs.getdbt.com/tags/v-1-1-06.md) - [One doc tagged with "v1.1.07"](https://docs.getdbt.com/tags/v-1-1-07.md) - [One doc tagged with "v1.1.08"](https://docs.getdbt.com/tags/v-1-1-08.md) - [One doc tagged with "v1.1.09"](https://docs.getdbt.com/tags/v-1-1-09.md) - [One doc tagged with "v1.1.10"](https://docs.getdbt.com/tags/v-1-1-10.md) - [One doc tagged with "v1.1.11"](https://docs.getdbt.com/tags/v-1-1-11.md) - [One doc tagged with "v1.1.12"](https://docs.getdbt.com/tags/v-1-1-12.md) - [One doc tagged with "v1.1.13"](https://docs.getdbt.com/tags/v-1-1-13.md) - [One doc tagged with "v1.1.14"](https://docs.getdbt.com/tags/v-1-1-14.md) - [One doc tagged with "v1.1.15"](https://docs.getdbt.com/tags/v-1-1-15.md) - [One doc tagged with "v1.1.16"](https://docs.getdbt.com/tags/v-1-1-16.md) - [One doc tagged with "v1.1.18"](https://docs.getdbt.com/tags/v-1-1-18.md) - [One doc tagged with "v1.1.19"](https://docs.getdbt.com/tags/v-1-1-19.md) - [One doc tagged with "v1.1.20"](https://docs.getdbt.com/tags/v-1-1-20.md) - [One doc tagged with "v1.1.21"](https://docs.getdbt.com/tags/v-1-1-21.md) - [One doc tagged with "v1.1.22"](https://docs.getdbt.com/tags/v-1-1-22.md) - [One doc tagged with "v1.1.23"](https://docs.getdbt.com/tags/v-1-1-23.md) - [One doc tagged with "v1.1.24"](https://docs.getdbt.com/tags/v-1-1-24.md) - [One doc tagged with "v1.1.25"](https://docs.getdbt.com/tags/v-1-1-25.md) - [One doc tagged with "v1.1.26"](https://docs.getdbt.com/tags/v-1-1-26.md) - [One doc tagged with "v1.1.27"](https://docs.getdbt.com/tags/v-1-1-27.md) - [One doc tagged with "v1.1.28"](https://docs.getdbt.com/tags/v-1-1-28.md) - [One doc tagged with "v1.1.29"](https://docs.getdbt.com/tags/v-1-1-29.md) - [One doc tagged with "v1.1.30"](https://docs.getdbt.com/tags/v-1-1-30.md) - [One doc tagged with "v1.1.31"](https://docs.getdbt.com/tags/v-1-1-31.md) - [One doc tagged with "v1.1.32"](https://docs.getdbt.com/tags/v-1-1-32.md) - [One doc tagged with "v1.1.33"](https://docs.getdbt.com/tags/v-1-1-33.md) - [One doc tagged with "v1.1.34"](https://docs.getdbt.com/tags/v-1-1-34.md) - [One doc tagged with "v1.1.35"](https://docs.getdbt.com/tags/v-1-1-35.md) - [One doc tagged with "v1.1.36"](https://docs.getdbt.com/tags/v-1-1-36.md) - [One doc tagged with "v1.1.37"](https://docs.getdbt.com/tags/v-1-1-37.md) - [One doc tagged with "v1.1.38"](https://docs.getdbt.com/tags/v-1-1-38.md) - [One doc tagged with "v1.1.39"](https://docs.getdbt.com/tags/v-1-1-39.md) - [One doc tagged with "v1.1.40"](https://docs.getdbt.com/tags/v-1-1-40.md) - [One doc tagged with "v1.1.41"](https://docs.getdbt.com/tags/v-1-1-41.md) - [Tags](https://docs.getdbt.com/tags.md) ## Terms - [hover-terms](https://docs.getdbt.com/terms/hover-terms.md)