Skip to main content
dbt Cloud logo
  • Category: developer tools
  • Auth: BEARER_TOKEN, OAUTH2
  • Composio-managed OAuth available? No
  • Tools: 20
  • Triggers: 0
  • Slug: DBT_CLOUD
  • Version: 20261101_00

Tools

Slug: DBT_CLOUD_ADMIN_API_DELETEDelete dbt Cloud administrative resources or configuration using one predeclared v2 or v3 Admin API operation identified by provider operation ID. Operations include bulk deletion of project environment variables; deleted resources and configuration cannot be recovered by this action.

Input Parameters

object
Optional scalar query parameters for the selected operation.
string ("admin_v3_destroy_adapter" | "admin_v3_delete_account_connection_delete" | "admin_v2_destroy_ssh_tunnel" | "admin_v3_delete_credentials" | "admin_v3_destroy_projects_environment_variable" | "admin_v3_destroy_projects_environment_variables_bulk" | "admin_v3_delete_environment_sao_cache" | "admin_v3_destroy_environment" | "admin_v3_destroy_extended_attributes" | "admin_v3_delete_ip_restriction" | "admin_v2_destroy_job" | "admin_v3_destroy_license_map" | "admin_v3_delete_lineage_integration" | "admin_v2_destroy_notification" | "admin_v3_destroy_oauth_configuration" | "admin_v3_delete_private_endpoint" | "admin_v3_delete_profile" | "admin_v3_destroy_project" | "admin_v3_destroy_repository" | "admin_v3_destroy_service_token" | "admin_v3_delete_account_scoped_pat" | "admin_v3_delete_user_credentials" | "admin_v3_destroy_webhooks_subscription")
required
Exact documented dbt Cloud Admin API DELETE operation ID. Use the matching operation in the official v2 or v3 OpenAPI specification for its exact path and query parameters.
object
Path parameters required by the selected operation. Do not include account_id; it is always taken from the connected account.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: DBT_CLOUD_ADMIN_API_READPerform one predeclared dbt Cloud Admin read selected by provider operation ID, using its path and optional query parameters. The action accepts bearer-token or OAuth connections with account:read.

Input Parameters

object
Documented query parameters for the selected operation.
string ("admin_v2_list_account_license_allocations" | "admin_v2_list_invites" | "admin_v2_list_notifications" | "admin_v2_list_ssh_tunnels" | "admin_v2_list_users" | "admin_v2_retrieve_account" | "admin_v2_retrieve_invite" | "admin_v2_retrieve_job_artifact" | "admin_v2_retrieve_notification" | "admin_v2_retrieve_run_step" | "admin_v2_retrieve_ssh_tunnel" | "admin_v2_retrieve_user" | "admin_v3_download_bulk_audit_log_export" | "admin_v3_get_account_scoped_pat" | "admin_v3_get_bulk_audit_log_export_status" | "admin_v3_get_credentials" | "admin_v3_get_lineage_integration" | "admin_v3_get_recent_audit_log_events_csv" | "admin_v3_get_user_credentials" | "admin_v3_list_account_connections" | "admin_v3_list_account_scoped_pats" | "admin_v3_list_accounts" | "admin_v3_list_collections_from_bi_tool" | "admin_v3_list_collections_from_bi_tool_2" | "admin_v3_list_credentials" | "admin_v3_list_favorite_asset_responses" | "admin_v3_list_groups" | "admin_v3_list_ip_restrictions" | "admin_v3_list_license_maps" | "admin_v3_list_lineage_integrations" | "admin_v3_list_oauthconfigurations" | "admin_v3_list_private_endpoints" | "admin_v3_list_profiles" | "admin_v3_list_recent_audit_log_events" | "admin_v3_list_repositories" | "admin_v3_list_semantic_layer_credentials" | "admin_v3_list_service_tokens" | "admin_v3_list_user_credentials" | "admin_v3_list_users" | "admin_v3_list_webhooks_events" | "admin_v3_list_webhooks_subscription_event_receipt" | "admin_v3_list_webhooks_subscriptions" | "admin_v3_retrieve_account_connection" | "admin_v3_retrieve_adapter" | "admin_v3_retrieve_adapter_schema" | "admin_v3_retrieve_environment" | "admin_v3_retrieve_extended_attributes" | "admin_v3_retrieve_group" | "admin_v3_retrieve_ip_restriction" | "admin_v3_retrieve_license_map" | "admin_v3_retrieve_oauth_configuration" | "admin_v3_retrieve_private_endpoint" | "admin_v3_retrieve_profile" | "admin_v3_retrieve_project" | "admin_v3_retrieve_projects_environment_variables_environment" | "admin_v3_retrieve_projects_environment_variables_job" | "admin_v3_retrieve_projects_environment_variables_user" | "admin_v3_retrieve_projects_managed_repositories_download" | "admin_v3_retrieve_repository" | "admin_v3_retrieve_service_token" | "admin_v3_retrieve_service_tokens_permission" | "admin_v3_retrieve_user" | "admin_v3_retrieve_webhooks_subscription" | "admin_v3_test_webhooks_subscription" | "admin_v3_validate_client_ip_against_ip_restrictions" | "admin_v3_validate_client_ip_against_ip_restrictions_excluding_specified_ip_rule")
required
Documented dbt Cloud Admin API GET operation ID. Use the matching operation in the official v2 or v3 OpenAPI specification to determine its exact path and query parameters.
object
Values for the selected operation’s documented path placeholders. Do not supply account_id; it always comes from the connection.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: DBT_CLOUD_ADMIN_API_WRITEExecute one predeclared dbt Cloud Administrative API POST, PATCH, or PUT operation. Selected operations may create or mutate administrative resources; review the matching provider OpenAPI operation, path parameters, query, and body before execution. Operation values are provider operation IDs. This action is bearer-token only because the operation set includes routes outside dbt Cloud’s officially documented OAuth scopes.

Input Parameters

object
Documented JSON request body; omit when the operation takes no body.
object
Documented query parameters as JSON values.
string ("admin_v2_create_job" | "admin_v2_create_notification" | "admin_v2_create_ssh_tunnel" | "admin_v2_partial_update_account" | "admin_v2_retry_failed_job" | "admin_v2_unsubscribe_from_notifications" | "admin_v2_update_account" | "admin_v2_update_job" | "admin_v2_update_license_permissions" | "admin_v2_update_notification" | "admin_v2_update_ssh_tunnel" | "admin_v2_update_user" | "admin_v3_assign_group_permissions" | "admin_v3_assign_user_to_groups" | "admin_v3_create_account_connection" | "admin_v3_create_account_scoped_pat" | "admin_v3_create_adapter" | "admin_v3_create_credentials" | "admin_v3_create_environment" | "admin_v3_create_extended_attributes" | "admin_v3_create_group" | "admin_v3_create_license_map" | "admin_v3_create_lineage_integration" | "admin_v3_create_managed_repository" | "admin_v3_create_oauthconfiguration" | "admin_v3_create_private_endpoint" | "admin_v3_create_profile" | "admin_v3_create_project" | "admin_v3_create_projects_environment_variable" | "admin_v3_create_projects_environment_variables_bulk" | "admin_v3_create_repository" | "admin_v3_create_service_token" | "admin_v3_create_user_credentials" | "admin_v3_create_webhooks_subscription" | "admin_v3_enable_ip_restrictions" | "admin_v3_partial_update_credentials" | "admin_v3_rotate_account_scoped_pat" | "admin_v3_save_ip_restriction" | "admin_v3_send_user_invites" | "admin_v3_submit_bulk_audit_log_export_request" | "admin_v3_update_account_connection" | "admin_v3_update_adapter" | "admin_v3_update_credentials" | "admin_v3_update_environment" | "admin_v3_update_extended_attributes" | "admin_v3_update_group" | "admin_v3_update_ip_restriction" | "admin_v3_update_license_map" | "admin_v3_update_lineage_integration" | "admin_v3_update_lineage_integration_selections" | "admin_v3_update_oauth_configuration" | "admin_v3_update_private_endpoint" | "admin_v3_update_profile" | "admin_v3_update_project" | "admin_v3_update_projects_environment_variable" | "admin_v3_update_projects_environment_variables_bulk" | "admin_v3_update_repository" | "admin_v3_update_service_token" | "admin_v3_update_user_credentials" | "admin_v3_update_webhooks_subscription")
required
Documented dbt Cloud Admin operation ID. Use the matching operation in the official v2 or v3 OpenAPI specification for exact path, query, and JSON body fields.
object
Exact non-account path parameters required by the selected operation.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: DBT_CLOUD_CANCEL_RUNIrreversibly request cancellation of a queued, starting, or running dbt Cloud run. This mutates the selected run’s execution state and does not delete its run record. The response is the run record returned after the cancellation request.

Input Parameters

integer
required
Numeric ID of the queued, starting, or running dbt Cloud run to cancel.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: DBT_CLOUD_DOWNLOAD_RUN_ARTIFACTDownload one artifact file from a completed dbt Cloud run using a path returned by List Run Artifacts.

Input Parameters

integer
One-based run step index. Omit it to download the artifact compiled for the run’s last step.
integer
required
Numeric ID of the dbt Cloud run that produced the artifact.
string
required
Artifact path exactly as returned by List Run Artifacts, such as manifest.json or metadata/telemetry-1-otel.parquet.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: DBT_CLOUD_FIND_SEMANTIC_SAVED_QUERIESList or search saved Semantic Layer queries, or return one exact saved query by name.

Input Parameters

Substring for listing saved queries; mutually exclusive with saved_query_name.
integer
Maximum saved queries in this page (1-100).
string
Opaque cursor returned by a previous list call; omit for page one.
integer
required
Semantic Layer production environment to query.
string
Exact saved-query name to retrieve; omit to list or search.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: DBT_CLOUD_GET_JOBReturn one dbt Cloud job definition and optionally selected related execution context.

Input Parameters

integer
required
Job to retrieve.
Related job objects to include in the response.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: DBT_CLOUD_GET_RUNReturn one dbt Cloud run with optional job, environment, step, retry, audit, or log context.

Input Parameters

integer
required
Run to retrieve.
Related run objects to include in the response.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: DBT_CLOUD_GET_RUN_FAILURE_DETAILSReturn dbt Cloud status and step logs for a failed run. This action only reads the run record and never starts or enqueues a retry.

Input Parameters

integer
required
Failed run whose failure diagnostics to retrieve.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: DBT_CLOUD_LIST_ENVIRONMENTSReturn one page of environments for a dbt Cloud project, with optional deployment and name filters.

Input Parameters

integer
Maximum environments in this page (1-100).
integer
required
Project whose environments to list.
string
Opaque cursor returned by a previous call; omit for the first page and pass it back unchanged to continue.
string
Case-insensitive substring to match against environment names.
string ("production" | "staging")
Restrict results to production or staging environments.
Related environment objects to include.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: DBT_CLOUD_LIST_JOBSReturn one page of dbt Cloud jobs, optionally filtered by project, environment, name, schedule, or state. By default, only active jobs are requested.

Input Parameters

integer
Maximum jobs in this page (1-100).
string ("active" | "deleted" | "all")
Soft-deletion state to return.
integer
Project whose jobs to return.
string
Opaque cursor returned by a previous call; omit for the first page.
string
Case-insensitive substring to match against job names.
integer
Environment whose jobs to return.
Related job objects to include.
boolean
Filter by whether jobs run on a schedule.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: DBT_CLOUD_LIST_PROJECTSReturn one page of dbt Cloud projects, optionally filtered by name, IDs, or deletion state. By default, only active projects are requested.

Input Parameters

integer
Maximum projects in this page (1-100).
string ("active" | "deleted" | "all")
Soft-deletion state to return.
string
Opaque cursor returned by a previous call; omit for the first page.
array
Project IDs to include.
string
Case-insensitive substring to match against project names.
Related project objects to include.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: DBT_CLOUD_LIST_RUN_ARTIFACTSReturn artifact paths available for a completed dbt Cloud run.

Input Parameters

integer
required
Completed run whose artifact paths to list.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: DBT_CLOUD_LIST_RUNSReturn one page of dbt Cloud runs, optionally filtered by job, project, environment, status, creation time, finish time, or deletion state.

Input Parameters

integer
Maximum runs in this page (1-100).
string ("active" | "deleted" | "all")
Run soft-deletion state to return. ‘all’ omits the provider state filter.
integer
Job ID persisted on each run record; sent as dbt’s job_definition_id filter. Runs whose job was deleted or detached may report 0 instead.
array
Run statuses to include. Multiple values are combined as one filter.
integer
Project ID persisted on each run record. Runs whose project was deleted or detached may report 0 instead.
string
Opaque cursor returned by a previous call; omit for the first page.
integer
Environment whose runs to return.
Related run objects to include in each result.
array
Inclusive creation-time range as exactly two ISO 8601 timestamps: start, then end.
array
Inclusive finish-time range as exactly two ISO 8601 timestamps: start, then end.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: DBT_CLOUD_LIST_SEMANTIC_ATTRIBUTESList dimensions, entities, group-bys, or queryable time granularities in the Semantic Layer. Dimensions and time granularities require selected metrics; entities and group-bys can be listed without them, and results are paginated except for time granularities.

Input Parameters

string
Substring filter for dimensions, entities, or group-bys; not used for time granularities.
array
Metrics is a list of objects shaped like [{“name”: “revenue”}]. It selects the metrics whose compatible attributes to return. Required and non-empty for dimension and time_granularity; optional for entity and group_by.
integer
Maximum attributes in this page when the selected operation is paginated.
string
Opaque cursor returned by a previous paginated call; omit for page one.
string ("dimension" | "entity" | "group_by" | "time_granularity")
required
Kind of queryable attribute to list. dimension and time_granularity require at least one metric; entity and group_by do not.
integer
required
Semantic Layer production environment to query.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: DBT_CLOUD_LIST_SEMANTIC_METRICSReturn one page of governed Semantic Layer metrics, optionally searched or grouped.

Input Parameters

string
Substring used by the documented metrics search.
array
Grouping definitions for the metric listing.
integer
Maximum metrics in this page.
string
Opaque cursor returned by a previous call; omit for page one.
integer
required
Semantic Layer production environment to query.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: DBT_CLOUD_QUERY_DISCOVERY_METADATAList dbt metadata resources in an environment or job-run context, retrieve one node by case-sensitive unique ID, or inspect model health in an environment.

Input Parameters

integer
Maximum resources in this page (1-100).
integer
Job ID; required when context is job.
integer
Historical run ID for job context; omit for the latest run.
string ("environment" | "job")
required
Use latest environment state or a job’s latest or specified run.
string ("list_resources" | "get_node_details" | "get_model_health")
required
Discovery intent to execute.
string
Case-sensitive dbt unique ID; required for node details or model health.
string
Opaque cursor returned by a previous list call; omit for the first page.
string ("model" | "source" | "seed" | "snapshot" | "test" | "macro" | "metric" | "exposure")
Resource family; required for listing and details. Model health is fixed to model.
integer
Environment ID; required when context is environment.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: DBT_CLOUD_QUERY_SEMANTIC_METRICSSubmit an ad-hoc dbt Semantic Layer query using metrics and/or group-bys, or execute a saved query; poll it to a documented terminal state and return one decoded JSON result page. Pass next_cursor to retrieve another page without creating a new query.

Input Parameters

integer
Maximum records requested from the metric query.
array
Semantic Layer filter expressions for an ad-hoc or saved query.
array
Metrics for an ad-hoc query; omit when saved_query is set.
array
Dimensions or entities used to group an ad-hoc query.
array
Result ordering; each item selects exactly one metric or group_by target.
string
Opaque result-page cursor returned by this action. When set, fetches that page without creating or polling another query.
string
Saved-query name to execute; mutually exclusive with metrics and group_by.
integer
Semantic Layer production environment to query. Required when starting a query; omit when continuing with next_cursor.
integer
Maximum total polling time before failing. Must not exceed poll_interval_seconds multiplied by 99, or by 79 when include_query_metadata is true.
number
Seconds between status checks. Must be large enough that poll_timeout_seconds uses at most 99 checks, or 79 when include_query_metadata is true.
boolean
Also query the documented queryRecords field and include the matching execution record when available.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: DBT_CLOUD_RETRY_RUNStart a new retry from a failed dbt Cloud run and return the newly enqueued run record.

Input Parameters

integer
required
Numeric ID of the failed dbt Cloud run to retry.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: DBT_CLOUD_TRIGGER_JOB_RUNStart a new run for a dbt Cloud job, optionally overriding its revision, target, commands, docs generation, threads, or timeout. Each successful call enqueues a new run.

Input Parameters

string
required
Non-empty reason recorded for this run.
integer
required
Numeric ID of the dbt Cloud job to run.
string
Git commit SHA to check out before running.
string
Git branch to check out before running.
array
Non-empty dbt commands that replace the job’s configured commands.
string
Destination schema override for the configured target.
integer
Number of execution threads to use.
string ("fallback" | "extended" | "compatible" | "latest" | "fusion-fallback" | "fusion-extended" | "latest-fusion" | "fusion-stable" | "fusion-nightly")
dbt runtime channel override.
string
Override for the target.name context value.
boolean
Whether this run should generate docs.
integer
Run timeout in seconds.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not