# Paradime: Guides

## Guides

### Foundations

- [Foundations](https://docs.paradime.io/guides/foundations/index.md): Short, plain-language explainers of the core concepts behind Paradime: the platform, dbt, environments, AI agents, orchestration, and observability.
- [How Paradime works](https://docs.paradime.io/guides/foundations/how-paradime-works.md): The mental model behind Paradime: workspaces, the apps inside the platform, and the Admin, Developer, and Business roles that control what each user can do.
- [What is dbt™?](https://docs.paradime.io/guides/foundations/what-is-dbt.md): A five-minute orientation to dbt™: models, sources, tests, and why analytics teams use it to transform data directly inside their cloud data warehouse.
- [Environments and connections](https://docs.paradime.io/guides/foundations/environments-and-connections.md): How Paradime connects to your data warehouse, and why development, scheduler, and cost environments are kept separate for safer and cheaper dbt™ runs.
- [What is DinoAI?](https://docs.paradime.io/guides/foundations/what-is-dinoai.md): DinoAI is Paradime's AI layer: an in-IDE copilot, autonomous background agents, and programmable agents. Here's what each one does and when to use it.
- [What is Bolt?](https://docs.paradime.io/guides/foundations/what-is-bolt.md): Bolt is Paradime's orchestrator: it runs your dbt™ project on schedules, powers CI/CD with Turbo CI, and alerts your team when something breaks.
- [Monitoring and discovery](https://docs.paradime.io/guides/foundations/monitoring-and-discovery.md): How Radar, Catalog, and Lineage work together to answer three questions: what is this data, where does it come from, and what is it costing us?
- [Key terms](https://docs.paradime.io/guides/foundations/key-terms.md): A short glossary of the terms you'll meet across the Paradime app and docs, from workspace and Bolt to Radar, DinoAI, and Turbo CI, with links to learn more.

### Automate with AI agents

- [Automate with AI agents](https://docs.paradime.io/guides/programmable-agents/index.md): Build DinoAI programmable agents that automate analytics engineering, data platform, and on-call work, and run them on a schedule with Paradime Bolt.

#### Build & run agents

- [Build an agent in the UI](https://docs.paradime.io/guides/programmable-agents/build-in-the-agent-ui.md): Build a DinoAI agent visually in the Agent builder: set its identity, tools, and output, then deploy it as a pull request to your repository.
- [Run an agent with Bolt](https://docs.paradime.io/guides/programmable-agents/run-an-agent-with-bolt.md): Run a DinoAI agent from a Bolt schedule with the Run Paradime DinoAI Agent command, so it runs on a cron, after another schedule, on a PR merge, or in Turbo CI.

#### Pipeline reliability & on-call

- [Bolt pipeline healer](https://docs.paradime.io/guides/programmable-agents/bolt-pipeline-healer.md): Build a DinoAI agent that auto-diagnoses a failed Paradime Bolt run and opens a fix PR, while deduplicating against prior attempts and open pull requests.
- [Bolt CI healer](https://docs.paradime.io/guides/programmable-agents/bolt-ci-healer.md): Build a DinoAI agent that self-heals failed Turbo CI checks by pushing a fix commit to the PR branch, with a loop-guard that escalates instead of retrying.
- [MongoDB schema drift healer](https://docs.paradime.io/guides/programmable-agents/mongo-schema-drift-healer.md): Build a DinoAI agent that heals dbt™ failures from MongoDB schema drift by inspecting raw VARIANT data, patching the staging model, and opening a fix PR.
- [Pipeline incident commander (Airflow)](https://docs.paradime.io/guides/programmable-agents/incident-commander.md): Build a DinoAI orchestrator that spawns three specialist sub-agents in parallel to triage a pipeline incident, then posts a unified summary to Slack.
- [Self-heal Dagster pipelines](https://docs.paradime.io/guides/programmable-agents/self-healing-pipelines-dagster.md): Build a DinoAI agent that recovers from failed Dagster ops by triaging the exception, patching the source, and opening a single fix PR per failed run.
- [Snowflake Task migrator](https://docs.paradime.io/guides/programmable-agents/snowflake-task-migrator.md): Build a DinoAI agent that migrates Snowflake Tasks into dbt™ models and Bolt schedules-as-code, one task per PR, with a data diff validating each migration.

#### Code quality

- [dbt™ documentation backfiller](https://docs.paradime.io/guides/programmable-agents/doc-backfiller.md): Build a DinoAI agent that detects missing or stale YAML descriptions, drafts them from the SQL, commits them to the PR branch, and posts a summary to Slack.
- [dbt™ test maintainer](https://docs.paradime.io/guides/programmable-agents/test-maintainer.md): Build a DinoAI agent that writes missing dbt™ tests, validates them with `dbt test`, and commits the result back to the PR branch.
- [End-to-end PR reviewer](https://docs.paradime.io/guides/programmable-agents/end-to-end-pr-reviewer.md): DinoAI agent that checks PR scope against Linear, validates dbt™ code, tests, and docs, then posts a verdict via a GitHub Action that gates merges.
- [End-to-end PR reviewer (Jira)](https://docs.paradime.io/guides/programmable-agents/end-to-end-pr-reviewer-jira.md): DinoAI agent that checks PR scope against Jira, validates dbt™ code, tests, and docs, then posts a verdict via a GitHub Action that gates merges.
- [dbt™ impact assessor](https://docs.paradime.io/guides/programmable-agents/impact-assessor.md): DinoAI agent that maps downstream models and exposures for a changed dbt™ model, flags breaking-change risk, and posts an impact report to the PR.

#### Slack bots

- [Jira intake agent](https://docs.paradime.io/guides/programmable-agents/jira-intake-agent.md): Set up a DinoAI Slack bot that interviews data requesters in plain language, checks for duplicates, and files well-formed Jira tickets for your data team.
- [Linear intake agent](https://docs.paradime.io/guides/programmable-agents/linear-intake-agent.md): Build a Slack intake bot that interviews requesters, infers priority, checks for duplicates, and files Linear issues into your team's triage flow.

#### Backlog & tickets

- [GitHub Issues backlog agent](https://docs.paradime.io/guides/programmable-agents/github-issues-backlog-agent.md): Build a DinoAI agent that picks up Agent Ready GitHub issues, implements dbt™ models with tests and docs, opens one PR per issue, and posts progress to Slack.
- [Linear backlog agent](https://docs.paradime.io/guides/programmable-agents/linear-backlog-agent.md): Build a DinoAI agent that picks up Agent Ready Linear tickets, implements dbt™ models with tests and docs, opens one PR per ticket, and posts progress to Slack.
- [Jira backlog agent](https://docs.paradime.io/guides/programmable-agents/jira-backlog-agent.md): Build a DinoAI agent that picks up Agent Ready Jira issues, implements dbt™ models with tests and docs, opens a PR per issue, and posts progress to Slack.
- [Jira change request agent](https://docs.paradime.io/guides/programmable-agents/jira-change-request-agent.md): Build a DinoAI agent that picks up Jira change request tickets, validates each request against your warehouse data, and opens a PR or escalates the ticket.
- [MongoDB schema drift triager](https://docs.paradime.io/guides/programmable-agents/mongodb-schema-drift-triager.md): Build a Jira-driven DinoAI agent that picks up agent-ready tickets, verifies the requested dbt™ change against MongoDB and Snowflake, and ships it as a PR.

#### Cost optimization

- [Query cost optimizer (Snowflake)](https://docs.paradime.io/guides/programmable-agents/dbt-tm-model-query-cost-optimizer-snowflake.md): Build a DinoAI agent that finds expensive Snowflake dbt™ models, rewrites Snowflake anti-patterns, opens a fix PR, and posts a credit summary to Slack.
- [Query cost optimizer (BigQuery)](https://docs.paradime.io/guides/programmable-agents/dbt-tm-model-query-cost-optimizer-bigquery.md): Build a DinoAI agent that finds expensive BigQuery dbt™ models, rewrites SQL anti-patterns, opens a fix PR, and posts a cost summary to Slack.

#### Analytics & reporting

- [Weekly Metrics Pulse Reporter](https://docs.paradime.io/guides/programmable-agents/weekly-metrics-pulse-agent.md): Schedule a DinoAI agent to check product metrics weekly, flag movements against a baseline, and post a digest to Slack for your review.

### Set up & configure

- [Set up & configure](https://docs.paradime.io/guides/set-up-and-configure/index.md): Stand up a Paradime workspace and configure it for your team: warehouse connections, git repositories, users, roles, and other workspace settings.

#### Workspace setup

- [Getting Started with your Paradime Workspace](https://docs.paradime.io/guides/paradime-101/getting-started-with-your-paradime-workspace/index.md): Set up your Paradime workspace: create a workspace, connect a data warehouse and git repository, and add users so your team can start building in dbt™.
- [Create a workspace](https://docs.paradime.io/guides/paradime-101/getting-started-with-your-paradime-workspace/creating-a-workspace.md): Create a new Paradime workspace and connect your git repository and data warehouse, the foundation every team member builds on for dbt™ development.
- [Create and manage environments](https://docs.paradime.io/guides/paradime-101/getting-started-with-your-paradime-workspace/setting-up-data-warehouse-connections.md): Understand Paradime Code IDE, Bolt, and Agent environments, add a warehouse connection to each, set up Turbo CI, and target connections from the dbt™ CLI.
- [Manage workspace configurations](https://docs.paradime.io/guides/paradime-101/getting-started-with-your-paradime-workspace/managing-workspace-configurations.md): Manage the dbt™ version, environment variables, and API keys for your Paradime workspace so every user shares a consistent, secure setup.
- [Manage users](https://docs.paradime.io/guides/paradime-101/getting-started-with-your-paradime-workspace/managing-users-in-the-workspace.md): Invite people to your Paradime workspace, assign Admin, Developer, or Business roles, deactivate users, and set up auto-join email domains.
- [Upgrade dbt Core™ version](https://docs.paradime.io/guides/upgrade-dbt-core-version.md): Change the dbt Core™ version for your Paradime workspace so the Code IDE and Bolt run a consistent, up-to-date version for everyone.

#### Connections

- [Data Warehouse essentials](https://docs.paradime.io/guides/data-warehouse-essentials/index.md): Guides for configuring and connecting your data warehouse to Paradime, covering advanced setup patterns across supported platforms.
- [Manage connections](https://docs.paradime.io/guides/data-warehouse-essentials/manage-connections/index.md): Manage Connections in Paradime: Oversee and configure data warehouse connections for dbt™ projects. Ensure seamless data integration.
- [Configure a connection](https://docs.paradime.io/guides/data-warehouse-essentials/manage-connections/configure-a-connection.md): Add a data warehouse connection to a Paradime environment: choose your provider, enter credentials, set the target and schema, and test it.
- [Set an alternative default connection](https://docs.paradime.io/guides/data-warehouse-essentials/manage-connections/set-alternative-default-connection.md): Change which warehouse connection is the default for an environment in Paradime, so dbt™ commands run against the database you want.
- [Delete a connection](https://docs.paradime.io/guides/data-warehouse-essentials/manage-connections/delete-connections.md): Permanently remove an unused data warehouse connection from Paradime to keep your environments clean, with the safeguards you need to know first.
- [Optional connection attributes](https://docs.paradime.io/guides/data-warehouse-essentials/optional-connection-attributes.md): Add a custom profiles.yml snippet to a Paradime connection to set any attribute your dbt™ adapter supports, like timeouts, priority, or retries.
- [Set up a BigQuery multi-project service account](https://docs.paradime.io/guides/data-warehouse-essentials/bigquery-multi-project-service-account.md): Configure a Google Cloud service account to read and write across multiple BigQuery projects, then point your dbt™ project at the right source and target.
- [Snowflake DinoAI Agent Key-Pair Setup](https://docs.paradime.io/guides/paradime-101/getting-started-with-the-dinoai-background-agent/snowflake-dinoai-agent-key-pair-setup.md): Set up Snowflake key-pair authentication for the DinoAI Background Agent: generate RSA keys, create a service user, grant access, and wire it into Paradime.

#### Data mesh & multi-project

- [Data Mesh Setup](https://docs.paradime.io/guides/data-mesh-setup/index.md): Paradime extends dbt™ Mesh with cross-project dependencies, model groups, access control, graph lineage, and data discovery for large multi-project setups.
- [Configure Project dependencies](https://docs.paradime.io/guides/data-mesh-setup/configure-project-dependencies.md): Set up dbt™ Mesh cross-project dependencies in Paradime so downstream projects reference upstream models as APIs without importing them as packages.
- [Model access](https://docs.paradime.io/guides/data-mesh-setup/model-access.md): Configure dbt™ Mesh model access to control visibility across projects and groups by marking models as public or private in dbt_project.yml or properties.yml.
- [Model groups](https://docs.paradime.io/guides/data-mesh-setup/model-groups.md): Group dbt™ models to define ownership and access boundaries: keep private models scoped to a team while exposing public models across projects in the mesh.
- [Workspaces and data mesh](https://docs.paradime.io/guides/paradime-fundamentals/workspaces-and-data-mesh.md): A Paradime Workspace is a self-contained unit that comes with its own repo, users, data warehouse connections, production schedules, alerting, and notifications
- [PII Anonymization with dbt™ Mesh Setup](https://docs.paradime.io/guides/pii-anonymization-with-dbt-tm-mesh-setup.md): Set up dbt™ Mesh in Paradime to anonymize PII across projects using hashing, cross-project references, and public model contracts for downstream teams.

### Orchestrate data pipelines

- [Orchestrate data pipelines](https://docs.paradime.io/guides/ship-to-production/index.md): Run your data pipelines in production with Bolt: create and schedule jobs, orchestrate your whole stack, set up CI/CD, and monitor every run.

#### Create & schedule jobs

- [Create a schedule](https://docs.paradime.io/guides/paradime-101/running-dbt-in-production-with-bolt/creating-bolt-schedules.md): Create a Paradime Bolt schedule from the UI to run and orchestrate your dbt™ production jobs on a cron trigger, with logging and failure alerts.
- [Schedule types and triggers](https://docs.paradime.io/guides/paradime-101/running-dbt-in-production-with-bolt/understanding-schedule-types-and-triggers.md): Understand the Bolt schedule types (Standard, Deferred, Turbo CI) and triggers (cron, on completion, on merge, API), and when to use each.
- [Orchestrate your whole stack](https://docs.paradime.io/guides/orchestrate-data-pipelines/orchestrate-your-whole-stack.md): Run ingestion syncs, Python scripts, and dbt™ commands from a single Paradime Bolt schedule so your end-to-end data pipeline runs in the right order.
- [Manage schedules as code](https://docs.paradime.io/guides/orchestrate-data-pipelines/manage-schedules-as-code.md): Define Paradime Bolt schedules as YAML in your dbt™ repository, organize them with a modular .bolt/ folder, and deploy them straight from the UI.
- [Run SQL statements in Bolt schedules](https://docs.paradime.io/guides/running-sql-statements-in-bolt.md): Run plain SQL statements like CREATE OR REPLACE, GRANT, or ALTER in a Bolt schedule by wrapping them in a dbt run-operation macro.

#### Data ingestion with dlt

- [Using dlt in Paradime](https://docs.paradime.io/guides/using-dlt-in-paradime/index.md): Guides for building and running dlt (data load tool) ingestion pipelines alongside your dbt™ projects in Paradime, with shared credentials and Bolt runs.
- [dlt credentials via environment variables](https://docs.paradime.io/guides/using-dlt-in-paradime/dlt-source-and-destination-credentials-via-environment-variables.md): Map environment variables to dlt (data load tool) source and destination credentials so pipelines can authenticate securely across Paradime environments.
- [Reuse dbt™ BigQuery credentials in dlt pipelines](https://docs.paradime.io/guides/using-dlt-in-paradime/reuse-dbt-tm-connection-credentials-in-dlt-pipelines-bigquery.md): Reuse your dbt™ profiles.yml BigQuery credentials to authenticate dlt pipelines in Paradime, avoiding duplicate secrets and simplifying credential management.
- [Ingest Google Sheets into Snowflake with dltHub](https://docs.paradime.io/guides/using-dlt-in-paradime/python-data-pipeline-using-dlthub-google-sheets-to-snowflake.md): Build a Python data pipeline in Paradime that uses dltHub to ingest Google Sheets data into Snowflake, then run it on a Bolt schedule for automated updates.

#### Set up CI/CD

- [Set up Turbo CI](https://docs.paradime.io/guides/orchestrate-data-pipelines/set-up-turbo-ci.md): Configure Turbo CI so every pull request builds and tests only your changed dbt™ models in a temporary schema, with the run status posted on the PR.
- [Set up continuous deployment](https://docs.paradime.io/guides/orchestrate-data-pipelines/set-up-continuous-deployment.md): Automatically deploy your dbt™ changes to production the moment a pull request merges, using a Paradime Bolt schedule triggered on the default branch.
- [Compare column-level lineage on pull requests](https://docs.paradime.io/guides/orchestrate-data-pipelines/compare-column-level-lineage.md): Surface the exact downstream columns and dashboards affected by a dbt™ pull request, so reviewers can approve changes with confidence.
- [Migrate Turbo CI from --target flags to a CI environment](https://docs.paradime.io/guides/migrations/migrate-turbo-ci-to-a-dedicated-environment.md): Move your Turbo CI schedule from appending --target ci on every command to a dedicated CI environment with its own connection, and clean up your commands.

#### Monitor & operate

- [View run history and analytics](https://docs.paradime.io/guides/paradime-101/running-dbt-in-production-with-bolt/viewing-run-history-and-analytics.md): Review Bolt run history, logs, and artifacts in Paradime to track success rates, inspect failures, and check source freshness for your dbt™ jobs.
- [Set up notifications](https://docs.paradime.io/guides/paradime-101/running-dbt-in-production-with-bolt/setting-up-notifications.md): Send Slack and email notifications on Bolt schedule runs in Paradime, so your team knows immediately when a production job passes or fails.
- [Debug a failed run](https://docs.paradime.io/guides/paradime-101/running-dbt-in-production-with-bolt/debugging-failed-runs.md): Debug failed dbt™ runs in Paradime Bolt: find the failure, read the summary, console, and debug logs, and test the compiled SQL to fix the root cause.
- [Set up alerts](https://docs.paradime.io/guides/orchestrate-data-pipelines/set-up-alerts.md): Use Bolt alert templates to control exactly what your Slack and Microsoft Teams failure notifications say, with Jinja2 variables for run and error context.
- [Set up self-healing](https://docs.paradime.io/guides/orchestrate-data-pipelines/set-up-self-healing.md): Enable self-healing on a Bolt schedule so a DinoAI agent diagnoses and opens a fix PR when a production run fails, in the failure's Slack thread.
- [Send failures to your incident tools](https://docs.paradime.io/guides/orchestrate-data-pipelines/send-failures-to-incident-tools.md): Add an incident trigger to a Bolt schedule so a failed run automatically creates an incident in PagerDuty, Datadog, incident.io, or New Relic.

#### Templates

- [Job templates](https://docs.paradime.io/guides/orchestrate-data-pipelines/templates/index.md): Ready-made Paradime Bolt templates for dbt™ pipeline automation: testing, monitoring, incident triggers, and integrations with Jira, Linear, Census, and more.

##### dbt™ jobs

- [dbt™ Templates](https://docs.paradime.io/guides/orchestrate-data-pipelines/templates/dbt-tm-templates/index.md): Essential dbt™ templates for foundational data pipeline operations including model execution, testing, source monitoring, and incremental rebuilds.
- [Run and Test all your dbt™ Models](https://docs.paradime.io/guides/orchestrate-data-pipelines/templates/dbt-tm-templates/run-and-test-all-your-dbt-tm-models.md): Use this Bolt template to execute and test every dbt™ model in your project on a schedule, with build, test, and source freshness commands preconfigured.
- [Snapshot Source Data Freshness](https://docs.paradime.io/guides/orchestrate-data-pipelines/templates/dbt-tm-templates/snapshot-source-data-freshness.md): Bolt template that runs dbt™ source freshness checks on a schedule and snapshots the results so you can monitor stale sources and data delivery SLAs.
- [Build and Test Models with New Source Data](https://docs.paradime.io/guides/orchestrate-data-pipelines/templates/dbt-tm-templates/deferred-model-execution.md): Bolt template that runs dbt™ models only when new source data has landed by combining source freshness checks with deferred model execution.
- [Re-executes the last dbt™ command from the point of failure](https://docs.paradime.io/guides/orchestrate-data-pipelines/templates/dbt-tm-templates/re-executes-the-last-dbt-command.md): Use this Bolt template to re-execute and test dbt™ models from the last point of failure with dbt retry, skipping the models that already succeeded.

##### CI/CD

- [CI/CD Templates](https://docs.paradime.io/guides/orchestrate-data-pipelines/templates/ci-cd-templates/index.md): CI/CD templates for automated testing and deployment workflows that integrate with your git workflow for seamless development and production releases.
- [Test Code Changes On Pull Requests](https://docs.paradime.io/guides/orchestrate-data-pipelines/templates/ci-cd-templates/test-code-changes-on-pull-requests.md): Bolt template that runs and tests modified dbt™ models and their downstream dependencies whenever a pull request opens, powering Turbo CI checks.
- [Lint and Test Code Changes On Pull Requests](https://docs.paradime.io/guides/orchestrate-data-pipelines/templates/ci-cd-templates/lint-and-test-code-changes-on-pull-requests.md): Bolt template that runs pre-commit hooks on changed files, then builds and tests modified dbt™ models with Turbo CI whenever a pull request opens.
- [Deploy Code Changes On Merge](https://docs.paradime.io/guides/orchestrate-data-pipelines/templates/ci-cd-templates/deploy-code-changes-on-merge.md): Bolt template that runs a merge-based CI/CD deploy for your dbt™ project whenever a pull request lands, promoting code changes to production automatically.

##### Observability

- [Observability Templates](https://docs.paradime.io/guides/orchestrate-data-pipelines/templates/observability-templates/index.md): Data observability templates for monitoring data quality, pipeline health, and automated alerting through Elementary integration with team communication tools.
- [Send Elementary alerts to Slack](https://docs.paradime.io/guides/orchestrate-data-pipelines/templates/observability-templates/send-elementary-alerts-to-slack.md): Use this Bolt template to forward Elementary data observability alerts to a Slack channel after your Paradime Bolt dbt™ runs complete.
- [Send Elementary alerts to MS Teams](https://docs.paradime.io/guides/orchestrate-data-pipelines/templates/observability-templates/send-elementary-alerts-to-ms-teams.md): Use this Bolt template to forward Elementary data observability alerts to a Microsoft Teams channel after your dbt™ runs finish in Paradime.

##### Ticketing

- [Ticketing Templates](https://docs.paradime.io/guides/orchestrate-data-pipelines/templates/ticketing-templates/index.md): Ticketing system integrations that automatically create tickets and work items when pipeline failures occur, streamlining incident tracking and resolution.
- [Create Jira Tickets](https://docs.paradime.io/guides/orchestrate-data-pipelines/templates/ticketing-templates/create-jira-tickets.md): Bolt template that automatically creates a Jira ticket whenever a dbt™ production run fails, so pipeline failures land in your existing Jira workflow.
- [Create Linear Issues](https://docs.paradime.io/guides/orchestrate-data-pipelines/templates/ticketing-templates/create-linear-issues.md): Bolt template that automatically creates a Linear issue whenever a dbt™ production run fails, so pipeline failures land in your existing Linear workflow.
- [Create Azure DevOps Items](https://docs.paradime.io/guides/orchestrate-data-pipelines/templates/ticketing-templates/create-azure-devops-items.md): Bolt template that automatically creates an Azure DevOps work item whenever a dbt™ production run fails, so the failure is tracked in your backlog.

##### Reverse ETL

- [Reverse ETL Templates](https://docs.paradime.io/guides/orchestrate-data-pipelines/templates/reverse-etl-templates/index.md): Reverse ETL templates for automatically triggering data syncs to operational tools and customer engagement platforms after successful pipeline runs.
- [Trigger Census Syncs](https://docs.paradime.io/guides/orchestrate-data-pipelines/templates/reverse-etl-templates/trigger-census-syncs.md): Bolt template that automatically triggers Census reverse-ETL syncs after a successful dbt™ production run so downstream SaaS tools get fresh data.
- [Trigger Hightouch Syncs](https://docs.paradime.io/guides/orchestrate-data-pipelines/templates/reverse-etl-templates/trigger-hightouch-syncs.md): Use this Bolt template to trigger Hightouch syncs when the configured Paradime Bolt dbt™ schedules succeed, keeping downstream tools fresh automatically.
- [Trigger Hightouch Sequence Sync](https://docs.paradime.io/guides/orchestrate-data-pipelines/templates/reverse-etl-templates/trigger-hightouch-sequence-sync.md): Use this Bolt template to automatically trigger a Hightouch sequence sync after a successful dbt™ production run in Paradime, keeping downstream tools fresh.

##### Dashboards

- [Dashboard Templates](https://docs.paradime.io/guides/orchestrate-data-pipelines/templates/dashboard-templates/index.md): Dashboard refresh templates for automatically updating analytics dashboards and reports when your data pipelines complete successfully.
- [Trigger Hex Projects](https://docs.paradime.io/guides/orchestrate-data-pipelines/templates/dashboard-templates/trigger-hex-projects.md): Bolt template that automatically triggers a Hex project after a successful dbt™ production run so downstream Hex notebooks refresh with fresh data.

##### Incidents

- [Incident Templates](https://docs.paradime.io/guides/orchestrate-data-pipelines/templates/incident-templates/index.md): Incident management templates for automatically creating incidents in various platforms when pipeline failures occur, enabling rapid response and resolution.
- [Create Datadog Incident](https://docs.paradime.io/guides/orchestrate-data-pipelines/templates/incident-templates/create-datadog-incident.md): Use this Bolt template to automatically create a Datadog incident whenever a dbt™ production schedule fails, so your on-call rotation is paged in Datadog.
- [Create PagerDuty Incident](https://docs.paradime.io/guides/orchestrate-data-pipelines/templates/incident-templates/create-pagerduty-incident.md): Use this Bolt template to automatically page your on-call rotation in PagerDuty whenever the configured Paradime Bolt dbt™ schedule fails.
- [Create Incident in incident.io](https://docs.paradime.io/guides/orchestrate-data-pipelines/templates/incident-templates/create-incident-in-incident.io.md): Use this Bolt template to automatically open an incident.io incident whenever the configured Paradime Bolt dbt™ schedule fails or overruns.
- [Create New Relic Incidents](https://docs.paradime.io/guides/orchestrate-data-pipelines/templates/incident-templates/create-new-relic-incidents.md): Bolt template that automatically creates a New Relic incident whenever a dbt™ production run fails, so on-call teams see pipeline issues in real time.
- [Create Rootly Incident](https://docs.paradime.io/guides/orchestrate-data-pipelines/templates/incident-templates/create-rootly-incident.md): Use this Bolt template to automatically create a Rootly incident whenever the configured Paradime Bolt dbt™ schedule fails or overruns.

#### Trigger Bolt externally

- [Trigger Bolt externally](https://docs.paradime.io/guides/orchestrate-data-pipelines/trigger-bolt-externally.md): Run Paradime Bolt schedules from outside Paradime using the Bolt API, Airflow, or Dagster so your dbt™ jobs fit inside an existing orchestration setup.

### Migrate to Paradime

- [Migrations](https://docs.paradime.io/guides/migrations/index.md): Step-by-step guides for migrating your dbt™ jobs and pipelines to Paradime from dbt Cloud™, GitHub Actions, Turbo CI, and other orchestration platforms.
- [Migrate dbt™ jobs from GitHub Actions to Paradime Bolt](https://docs.paradime.io/guides/migrations/migrating-dbt-tm-jobs-from-github-actions-to-paradime-bolt.md): Step-by-step migration guide for moving dbt™ jobs from GitHub Actions workflows to Paradime Bolt, covering schedules, secrets, and deferred runs.

#### dbt™ cloud to Paradime

- [dbt™ cloud to Paradime](https://docs.paradime.io/guides/migrations/dbt-cloud-tm-importer/index.md): dbt Cloud™ Importer in Paradime: Import dbt Cloud™ projects into Paradime with one click to simplify project management and integration.
- [Translating Key Terms](https://docs.paradime.io/guides/migrations/dbt-cloud-tm-importer/translation-of-key-terms.md): A dbt Cloud™ to Paradime translation guide mapping jobs, environments, connections, and other key terms between the two platforms side by side.
- [Migration Playbook](https://docs.paradime.io/guides/migrations/dbt-cloud-tm-importer/migration-from-dbt-cloud-playbook.md): A six-phase playbook for migrating hundreds of dbt Cloud™ jobs to Paradime Bolt over 5–10 days, covering audit, cutover, validation, and decommission.
- [Migration Checklist](https://docs.paradime.io/guides/migrations/dbt-cloud-tm-importer/migration-checklist.md): A dbt Cloud™ to Paradime migration checklist covering jobs, environments, users, and connections to keep your team on track through the cutover.
- [Transferring dbt™ Jobs](https://docs.paradime.io/guides/migrations/dbt-cloud-tm-importer/transferring-dbt-tm-jobs.md): Import your dbt Cloud™ jobs into Paradime Bolt schedules with a single click using the built-in importer, available on the Team and Enterprise plans.

#### dbt™ version upgrades

- [dbt™ version upgrades](https://docs.paradime.io/guides/migrations/dbt-version-upgrades/index.md): Upgrade the dbt Core™ version your Paradime workspace runs on, one release at a time, with per-version guides and a DinoAI agent to do the prep work.
- [Upgrade to dbt™ 1.9](https://docs.paradime.io/guides/migrations/dbt-version-upgrades/upgrade-to-dbt-1.9.md): Move your Paradime workspace to dbt Core™ 1.9: microbatch incremental models, redesigned snapshots, new behavior flags, and a Snowflake breaking change.
- [Upgrade to dbt™ 1.10](https://docs.paradime.io/guides/migrations/dbt-version-upgrades/upgrade-to-dbt-1.10.md): Move your Paradime workspace to dbt Core™ 1.10: sample mode, the anchors: key, and the first wave of deprecation warnings to clean up on the road to v2.
- [Upgrade to dbt™ 1.11](https://docs.paradime.io/guides/migrations/dbt-version-upgrades/upgrade-to-dbt-1.11.md): Move your Paradime workspace to dbt Core™ 1.11: user-defined functions, the DBT_ENGINE_ variable prefix, and JSON-schema deprecation warnings by default.
- [Upgrade to dbt™ 1.12](https://docs.paradime.io/guides/migrations/dbt-version-upgrades/upgrade-to-dbt-1.12.md): Move your Paradime workspace to dbt Core™ 1.12: the opt-in v2 Rust parser, native private packages, vars.yml, and seven behavior flags flipping on.
- [Prepare for dbt™ v2](https://docs.paradime.io/guides/migrations/dbt-version-upgrades/prepare-for-dbt-v2.md): Get your dbt™ project v2-ready: resolve every deprecation, update CLI flags, and understand the behavior changes the new engine enforces.
- [Upgrade with the DinoAI agent](https://docs.paradime.io/guides/migrations/dbt-version-upgrades/upgrade-with-the-dinoai-agent.md): Build a DinoAI agent that prepares your dbt™ project for a target dbt Core™ version: it finds deprecations, fixes them, validates the build, and opens a PR.

### Develop in Paradime

- [Develop in Paradime](https://docs.paradime.io/guides/develop-in-paradime/index.md): Build, document, and refine dbt™ models in the Paradime Code IDE with DinoAI, from your first model to AI-assisted development and git workflows.

#### Build in the IDE

- [Set up a dbt™ project](https://docs.paradime.io/guides/paradime-101/getting-started-with-the-paradime-ide/setting-up-a-dbt-project.md): Initialize a dbt™ project in the Paradime Code IDE with the CLI, generate sources from your warehouse, and commit your first work.
- [Create a dbt™ model](https://docs.paradime.io/guides/paradime-101/getting-started-with-the-paradime-ide/creating-a-dbt-model.md): Create your first dbt™ model in the Paradime Code IDE: branch, write SQL against a source, materialize it with dbt run, and ship it through git.
- [Explore data in the Code IDE](https://docs.paradime.io/guides/paradime-101/getting-started-with-the-paradime-ide/data-exploration-in-the-code-ide.md): Preview compiled SQL and query results with the Data Explorer, and prototype throwaway queries in the Scratchpad, without leaving the Paradime Code IDE.
- [Defer to production](https://docs.paradime.io/guides/paradime-fundamentals/dbt-tm-defer-to-production.md): Use dbt™ defer in the Paradime Code IDE to read unchanged parents from production, build only the models you're working on, and cut development run time.
- [Visualize data lineage](https://docs.paradime.io/guides/paradime-101/getting-started-with-the-paradime-ide/utilizing-advanced-developer-features/visualize-data-lineage.md): Use the Code IDE lineage view to see a model's upstream and downstream dependencies, jump between related files, and assess impact before you ship.
- [Enforce SQL and YAML best practices](https://docs.paradime.io/guides/paradime-101/getting-started-with-the-paradime-ide/utilizing-advanced-developer-features/enforce-sql-and-yaml-best-practices.md): Lint and auto-format your dbt™ code in Paradime with SQLFluff (SQL) and Prettier (YAML), and customize the rules to match your team's standards.
- [Work with CSV files](https://docs.paradime.io/guides/paradime-101/getting-started-with-the-paradime-ide/utilizing-advanced-developer-features/working-with-csv-files.md): Use the Rainbow CSV feature in the Paradime Code IDE to read, align, and lint CSV files, useful when preparing dbt™ seeds for your project.

#### Build with DinoAI

- [DinoAI copilot use cases](https://docs.paradime.io/guides/dinoai-copilot-use-cases/index.md): Practical examples of how to use the DinoAI copilot to solve real analytics engineering tasks and accelerate your dbt™ development workflow.
- [Create sources from your warehouse](https://docs.paradime.io/guides/dinoai-copilot-use-cases/creating-sources-from-your-warehouse.md): Auto-generate accurate sources.yml files from your warehouse metadata using DinoAI, so you avoid the manual work of documenting source tables.
- [Generate dbt™ models](https://docs.paradime.io/guides/dinoai-copilot-use-cases/generating-dbt-tm-models.md): Use DinoAI to build dbt™ models faster, turning raw source tables into readable SQL with proper joins, CTEs, and transformations that follow team standards.
- [Build marts models](https://docs.paradime.io/guides/dinoai-copilot-use-cases/building-marts-models.md): Use DinoAI to build intermediate and marts models that join multiple tables with the right relationships, CTEs, and business logic.
- [Generate documentation](https://docs.paradime.io/guides/dinoai-copilot-use-cases/generating-documentation.md): Use DinoAI to auto-generate model and column descriptions with tests across an entire folder, turning days of documentation work into minutes.
- [Configure data pipelines](https://docs.paradime.io/guides/dinoai-copilot-use-cases/configuring-data-pipelines.md): Use DinoAI to update your dbt_project.yml so models map to your folder structure with the right materializations, schemas, and tags.
- [Fix errors with Jira](https://docs.paradime.io/guides/dinoai-copilot-use-cases/fixing-errors-with-jira.md): Pull Jira ticket details straight into DinoAI to analyze production errors, suggest fixes, and guide implementation without leaving your dbt™ workflow.
- [Debug failed dbt™ commands with terminal context](https://docs.paradime.io/guides/dinoai-copilot-use-cases/debugging-failed-dbt-tm-commands-with-terminal-context.md): Send terminal error output straight to DinoAI in the Paradime IDE for targeted troubleshooting of failed dbt™ commands without switching windows.
- [Research with Perplexity](https://docs.paradime.io/guides/dinoai-copilot-use-cases/researching-with-perplexity.md): Use DinoAI's Perplexity-powered web search to pull cited, up-to-date answers on dbt™ techniques and best practices, then apply them in your project.
- [Provide additional context using PDFs](https://docs.paradime.io/guides/dinoai-copilot-use-cases/providing-additional-context-using-pdfs.md): Attach project-specific PDFs as context for DinoAI to extract business rules and technical specs, then generate dbt™ models that reflect your requirements.
- [Generate pull request descriptions](https://docs.paradime.io/guides/dinoai-copilot-use-cases/generating-pull-request-descriptions.md): Auto-generate detailed pull request descriptions with DinoAI by analyzing your git branch diff, so reviewers get clear context and reviews move faster.
- [Set up .dinorules using your project as context](https://docs.paradime.io/guides/dinoai-copilot-use-cases/using-your-project-as-context-to-set-up-.dinorules.md): Generate .dinorules that codify your team's conventions by pointing DinoAI at existing dbt™ project files, so rules reflect real patterns not a blank file.
- [Accelerating dbt™ Development](https://docs.paradime.io/guides/paradime-101/getting-started-with-the-paradime-ide/dinoai-accelerating-your-analytics-engineering-workflow/accelerating-dbt-development.md): Use DinoAI in the Paradime IDE to speed up dbt™ development: create and explain models, debug SQL, and convert raw SQL into standardized dbt™ code.
- [Accelerating GitOps](https://docs.paradime.io/guides/paradime-101/getting-started-with-the-paradime-ide/dinoai-accelerating-your-analytics-engineering-workflow/accelerating-git-ops.md): Use DinoAI to accelerate GitOps in Paradime: auto-generate commit messages and pull request descriptions for cleaner history and faster dbt™ code reviews.
- [Accelerating Data Governance](https://docs.paradime.io/guides/paradime-101/getting-started-with-the-paradime-ide/dinoai-accelerating-your-analytics-engineering-workflow/accelerating-data-governance.md): Use DinoAI to automate dbt™ data governance tasks: generate tests, write documentation, and visualize entity relationships in your Paradime IDE.

#### Version control with Git

- [Working with Git](https://docs.paradime.io/guides/working-with-git/index.md): Version-control your dbt™ project in Paradime with Git Lite or Git Advanced: branch, commit, push, resolve merge conflicts, and protect the main branch.
- [Use Git Lite](https://docs.paradime.io/guides/working-with-git/git-lite.md): Work with version control the simple way in the Code IDE: create branches, commit, push, and open pull requests with built-in safeguards.
- [Use Git Advanced](https://docs.paradime.io/guides/working-with-git/git-advanced.md): Take full control of version control in the Code IDE: selectively stage files, manage branches, and commit with detailed control from the IDE.
- [Work with read-only branches](https://docs.paradime.io/guides/working-with-git/read-only-branches.md): Understand why Paradime protects your main and master branches as read-only, and how to make changes through a new branch and a pull request.
- [Resolve merge conflicts](https://docs.paradime.io/guides/working-with-git/merge-conflicts.md): Resolve Git merge conflicts on your dbt™ project in the Paradime Code IDE using inline actions to accept, reject, or combine conflicting changes.
- [Delete branches](https://docs.paradime.io/guides/working-with-git/delete-branches.md): Keep your dbt™ project repository tidy by pruning merged branches in one click or deleting specific branches individually in the Code IDE.
- [Explore Git history with GitLens](https://docs.paradime.io/guides/working-with-git/gitlens.md): Use GitLens in the Paradime Code IDE to explore file history, line-level authorship, and search or compare commits across your dbt project.
- [Set up a GitHub merge queue with Paradime Turbo CI](https://docs.paradime.io/guides/working-with-git/github-merge-queue.md): Configure a GitHub merge queue that runs Paradime Turbo CI on batched pull requests, so failing changes are caught before they merge to main.
- [Connecting a repository asynchronously](https://docs.paradime.io/guides/working-with-git/connecting-a-repository-asynchronously.md): Save a Git repository in Paradime before the deploy key is installed, leaving it pending, then verify the connection later once the key is added.
- [Configure signed commits with SSH keys](https://docs.paradime.io/guides/working-with-git/configuring-signed-commits-on-paradime-with-ssh-keys.md): Set up SSH key-based commit signing in the Paradime Code IDE so every commit you push is signed and shows as Verified on GitHub or GitLab.
- [Protect the main branch on GitHub](https://docs.paradime.io/guides/working-with-git/github-branch-protection-guide-preventing-direct-commits-to-main.md): Set up GitHub branch protection rules to prevent direct pushes to main, require pull request reviews, and enforce the rules across your organization.

### Learn dbt™

- [dbt™ fundamentals](https://docs.paradime.io/guides/dbt-fundamentals/index.md): Learn the dbt basics with Paradime's clear, step-by-step guidance, making it straightforward to master dbt and start building with confidence.

#### Getting started with dbt™

- [Getting started with dbt™](https://docs.paradime.io/guides/dbt-fundamentals/getting-started-with-dbt/index.md): An introduction to dbt™ for beginners, covering core concepts, project structure, models, sources, and testing to help you build reliable data transformations.
- [Introduction](https://docs.paradime.io/guides/dbt-fundamentals/getting-started-with-dbt/introduction.md): How dbt™ transforms SQL-based analytics by centralizing transformations in the warehouse, its role in the ELT stack, and the benefits for data reliability.
- [Project Strucuture](https://docs.paradime.io/guides/dbt-fundamentals/getting-started-with-dbt/project-strucuture.md): How dbt™ projects are structured for scalability and maintainability, covering models, sources, config files, and best practices for organizing SQL.
- [Working with Sources](https://docs.paradime.io/guides/dbt-fundamentals/getting-started-with-dbt/working-with-sources.md): How dbt™ sources manage raw data tables: define them in YAML, use the source() function, track dependencies, and monitor freshness against SLAs.
- [Testing Data Quality](https://docs.paradime.io/guides/dbt-fundamentals/getting-started-with-dbt/testing-data-quality.md): How dbt™ testing ensures data accuracy: built-in and custom tests, schema validations, referential integrity checks, and practices for high-quality pipelines.
- [Models and Transformations](https://docs.paradime.io/guides/dbt-fundamentals/getting-started-with-dbt/models-and-transformations.md): How dbt™ models streamline data transformations with SQL, ref() dependencies, materializations, and Jinja macros for modular, testable, reusable code.

#### Configuring your dbt™ Project

- [Configuring your dbt™ Project](https://docs.paradime.io/guides/dbt-fundamentals/configuring-your-dbt-project/index.md): Configure your dbt™ project the right way: dbt_project.yml, sources, seeds, snapshots, tests, macros, packages, tags, and other core settings.
- [Setting up your dbt_project.yml](https://docs.paradime.io/guides/dbt-fundamentals/configuring-your-dbt-project/setting-up-your-dbt_project.yml.md): Configure the dbt_project.yml file: its purpose, the key sections that define models, seeds, and tests, and best practices for keeping the file organized.
- [Defining Your Sources in sources.yml](https://docs.paradime.io/guides/dbt-fundamentals/configuring-your-dbt-project/define-your-sources.yml.md): Covers how to properly define and use sources in dbt™ by configuring the `sources.yml` file, referencing sources in models, and ensuring data quality.
- [Testing Source Freshness](https://docs.paradime.io/guides/dbt-fundamentals/configuring-your-dbt-project/testing-source-freshness.md): Configure and run dbt™ source freshness checks so raw tables are always up to date, with tips for setup, optimization, and reliable data pipelines.
- [Unit Testing](https://docs.paradime.io/guides/dbt-fundamentals/configuring-your-dbt-project/unit-testing.md): Learn how to use unit tests in dbt™ to validate transformation logic, prevent errors, and improve code reliability before deploying to production.
- [Working with Tags](https://docs.paradime.io/guides/dbt-fundamentals/configuring-your-dbt-project/working-with-tags-in-your-dbt-tm-project.md): Use tags in dbt™ to organize models, streamline execution with the --select flag, and improve workflow efficiency in your analytics engineering pipelines.
- [Managing Seeds](https://docs.paradime.io/guides/dbt-fundamentals/configuring-your-dbt-project/managing-seeds.md): Use dbt™ seeds to manage static data: create, load, configure, and maintain CSV files in your project so reference data ships alongside your models.
- [Environment Management](https://docs.paradime.io/guides/dbt-fundamentals/configuring-your-dbt-project/environment-management.md): Set up and manage development, testing, and production environments in dbt™ projects, and understand how Paradime maps each environment to your warehouse.
- [Variables and Parameters](https://docs.paradime.io/guides/dbt-fundamentals/configuring-your-dbt-project/variables-and-parameters.md): Use variables and parameters in dbt™ to make transformations configurable, flexible, and environment-aware across development, CI, and production runs.
- [Macros](https://docs.paradime.io/guides/dbt-fundamentals/configuring-your-dbt-project/macros.md): Use dbt™ macros to build reusable SQL logic and modular transformations, from writing your own macros to combining dbt packages for common patterns.
- [Custom Tests](https://docs.paradime.io/guides/dbt-fundamentals/configuring-your-dbt-project/custom-tests.md): Extend dbt™ testing with custom tests: build singular and generic tests, parameterize them, and combine dbt packages to cover project-specific checks.
- [Hooks & Operational Tasks](https://docs.paradime.io/guides/dbt-fundamentals/configuring-your-dbt-project/hooks-and-operational-tasks.md): Use dbt™ hooks to automate operational tasks like granting permissions, managing metadata, and running custom logic before or after model or project runs.
- [Packages](https://docs.paradime.io/guides/dbt-fundamentals/configuring-your-dbt-project/packages.md): Extend dbt™ with packages by installing, using, and creating reusable macros, models, and tests so your team doesn't have to rebuild common functionality.

#### Model Materializations

- [Model Materializations](https://docs.paradime.io/guides/dbt-fundamentals/model-materializations/index.md): The dbt™ materialization strategies (table, view, incremental, ephemeral) and how to configure them at the project or individual model level.
- [Table Materialization](https://docs.paradime.io/guides/dbt-fundamentals/model-materializations/table-materialization.md): Learn how the dbt™ table materialization works, when to use it over views or incremental models, and its advantages and limitations in the warehouse.
- [View​ Materialization](https://docs.paradime.io/guides/dbt-fundamentals/model-materializations/view-materialization.md): Learn how the dbt™ view materialization works, when to prefer it over tables or incremental models, and its advantages and limitations in the warehouse.
- [Ephemeral Materialization](https://docs.paradime.io/guides/dbt-fundamentals/model-materializations/ephemeral-materialization.md): Describes dbt's ephemeral materialization, which integrates models as CTEs in dependent models, discussing advantages, disadvantages, and recommended use cases.
- [Snapshots](https://docs.paradime.io/guides/dbt-fundamentals/model-materializations/snapshots.md): Use dbt™ snapshots to track historical changes with Type 2 Slowly Changing Dimensions, covering configuration, strategies, metadata, and best practices.

##### Incremental Materialization

- [Incremental Materialization](https://docs.paradime.io/guides/dbt-fundamentals/model-materializations/incremental-materialization/index.md): How dbt™ incremental materializations update only new or modified rows in large tables, including the strategies to choose and their trade-offs in production.
- [Using Merge for Incremental Models](https://docs.paradime.io/guides/dbt-fundamentals/model-materializations/incremental-materialization/using-merge-for-incremental-models.md): Details the merge strategy for incremental models, which updates existing records and inserts new ones using a database MERGE statement.
- [Using Delete+Insert for Incremental Models](https://docs.paradime.io/guides/dbt-fundamentals/model-materializations/incremental-materialization/using-delete+insert-for-incremental-models.md): Covers the delete+insert method for incremental models, which replaces batches of records by first deleting them and then inserting new versions.
- [Using Append for Incremental Models](https://docs.paradime.io/guides/dbt-fundamentals/model-materializations/incremental-materialization/using-append-for-incremental-models.md): Explains the append-only method for incremental models, ideal for event logs and immutable data where records are only added, never updated.
- [Using Microbatch for Incremental Models](https://docs.paradime.io/guides/dbt-fundamentals/model-materializations/incremental-materialization/using-microbatch-for-incremental-models.md): Explores the microbatch method for incremental models, designed for processing very large datasets in smaller batches for improved reliability and performance.

#### Running dbt™

- [Running dbt™](https://docs.paradime.io/guides/dbt-fundamentals/running-dbt/index.md): Master the dbt™ CLI commands, selectors, and graph operators used to execute and control your dbt™ project runs from Paradime or your local terminal.

##### Mastering the dbt™ CLI

- [Mastering the dbt™ CLI](https://docs.paradime.io/guides/dbt-fundamentals/running-dbt/mastering-the-dbt-cli/index.md): A deep dive into dbt™ CLI commands, selector methods, and graph operators for precise control over which models, tests, and sources run in a build.
- [Commands](https://docs.paradime.io/guides/dbt-fundamentals/running-dbt/mastering-the-dbt-cli/commands.md): The key dbt™ CLI commands and their use cases: run, test, source freshness, compile, documentation, and utility commands for controlling transformations.
- [dbt selector methods for precise CLI runs and tests](https://docs.paradime.io/guides/dbt-fundamentals/running-dbt/mastering-the-dbt-cli/methods.md): Use dbt selector methods to filter resources by tags, sources, paths, and configurations for more precise dbt runs and tests from the Paradime CLI.
- [Selector Methods](https://docs.paradime.io/guides/dbt-fundamentals/running-dbt/mastering-the-dbt-cli/selector-methods.md): Use dbt™ selector methods to filter resources by tags, sources, configs, and other properties, with wildcard support for precise CLI targeting.
- [Graph Operators](https://docs.paradime.io/guides/dbt-fundamentals/running-dbt/mastering-the-dbt-cli/graph-operators.md): Use dbt™ graph operators with --select to navigate the DAG and target specific models and their dependencies for precise execution in data pipelines.