dbt Cloud v0.1.20 published on Friday, Sep 27, 2024 by Pulumi
dbtcloud.getJobs
Explore with Pulumi AI
Example Usage
import * as pulumi from "@pulumi/pulumi";
import * as dbtcloud from "@pulumi/dbtcloud";
// we can search all jobs by project
const testAllJobsInProject = dbtcloud.getJobs({
    projectId: 1234,
});
// or by environment
const testAllJobsInEnvironment = dbtcloud.getJobs({
    environmentId: 1234,
});
const myJobsProd = testAllJobsInProject.then(testAllJobsInProject => .filter(job => job.environment?.deploymentType == "production").map(job => (job)));
import pulumi
import pulumi_dbtcloud as dbtcloud
# we can search all jobs by project
test_all_jobs_in_project = dbtcloud.get_jobs(project_id=1234)
# or by environment
test_all_jobs_in_environment = dbtcloud.get_jobs(environment_id=1234)
my_jobs_prod = [job for job in test_all_jobs_in_project.jobs if job.environment.deployment_type == "production"]
Coming soon!
using System.Collections.Generic;
using System.Linq;
using Pulumi;
using DbtCloud = Pulumi.DbtCloud;
return await Deployment.RunAsync(() => 
{
    // we can search all jobs by project
    var testAllJobsInProject = DbtCloud.GetJobs.Invoke(new()
    {
        ProjectId = 1234,
    });
    // or by environment
    var testAllJobsInEnvironment = DbtCloud.GetJobs.Invoke(new()
    {
        EnvironmentId = 1234,
    });
    var myJobsProd = .Where(job => job.Environment?.DeploymentType == "production").Select(job => 
    {
        return job;
    }).ToList();
});
Coming soon!
Coming soon!
Using getJobs
Two invocation forms are available. The direct form accepts plain arguments and either blocks until the result value is available, or returns a Promise-wrapped result. The output form accepts Input-wrapped arguments and returns an Output-wrapped result.
function getJobs(args: GetJobsArgs, opts?: InvokeOptions): Promise<GetJobsResult>
function getJobsOutput(args: GetJobsOutputArgs, opts?: InvokeOptions): Output<GetJobsResult>def get_jobs(environment_id: Optional[int] = None,
             project_id: Optional[int] = None,
             opts: Optional[InvokeOptions] = None) -> GetJobsResult
def get_jobs_output(environment_id: Optional[pulumi.Input[int]] = None,
             project_id: Optional[pulumi.Input[int]] = None,
             opts: Optional[InvokeOptions] = None) -> Output[GetJobsResult]func GetJobs(ctx *Context, args *GetJobsArgs, opts ...InvokeOption) (*GetJobsResult, error)
func GetJobsOutput(ctx *Context, args *GetJobsOutputArgs, opts ...InvokeOption) GetJobsResultOutput> Note: This function is named GetJobs in the Go SDK.
public static class GetJobs 
{
    public static Task<GetJobsResult> InvokeAsync(GetJobsArgs args, InvokeOptions? opts = null)
    public static Output<GetJobsResult> Invoke(GetJobsInvokeArgs args, InvokeOptions? opts = null)
}public static CompletableFuture<GetJobsResult> getJobs(GetJobsArgs args, InvokeOptions options)
// Output-based functions aren't available in Java yet
fn::invoke:
  function: dbtcloud:index/getJobs:getJobs
  arguments:
    # arguments dictionaryThe following arguments are supported:
- Environment
Id int - The ID of the environment for which we want to retrieve the jobs (one of 
project_idorenvironment_idmust be set) - Project
Id int - The ID of the project for which we want to retrieve the jobs (one of 
project_idorenvironment_idmust be set) 
- Environment
Id int - The ID of the environment for which we want to retrieve the jobs (one of 
project_idorenvironment_idmust be set) - Project
Id int - The ID of the project for which we want to retrieve the jobs (one of 
project_idorenvironment_idmust be set) 
- environment
Id Integer - The ID of the environment for which we want to retrieve the jobs (one of 
project_idorenvironment_idmust be set) - project
Id Integer - The ID of the project for which we want to retrieve the jobs (one of 
project_idorenvironment_idmust be set) 
- environment
Id number - The ID of the environment for which we want to retrieve the jobs (one of 
project_idorenvironment_idmust be set) - project
Id number - The ID of the project for which we want to retrieve the jobs (one of 
project_idorenvironment_idmust be set) 
- environment_
id int - The ID of the environment for which we want to retrieve the jobs (one of 
project_idorenvironment_idmust be set) - project_
id int - The ID of the project for which we want to retrieve the jobs (one of 
project_idorenvironment_idmust be set) 
- environment
Id Number - The ID of the environment for which we want to retrieve the jobs (one of 
project_idorenvironment_idmust be set) - project
Id Number - The ID of the project for which we want to retrieve the jobs (one of 
project_idorenvironment_idmust be set) 
getJobs Result
The following output properties are available:
- Id string
 - The provider-assigned unique ID for this managed resource.
 - Jobs
List<Pulumi.
Dbt Cloud. Outputs. Get Jobs Job>  - Set of jobs with their details
 - Environment
Id int - The ID of the environment for which we want to retrieve the jobs (one of 
project_idorenvironment_idmust be set) - Project
Id int - The ID of the project for which we want to retrieve the jobs (one of 
project_idorenvironment_idmust be set) 
- Id string
 - The provider-assigned unique ID for this managed resource.
 - Jobs
[]Get
Jobs Job  - Set of jobs with their details
 - Environment
Id int - The ID of the environment for which we want to retrieve the jobs (one of 
project_idorenvironment_idmust be set) - Project
Id int - The ID of the project for which we want to retrieve the jobs (one of 
project_idorenvironment_idmust be set) 
- id String
 - The provider-assigned unique ID for this managed resource.
 - jobs
List<Get
Jobs Job>  - Set of jobs with their details
 - environment
Id Integer - The ID of the environment for which we want to retrieve the jobs (one of 
project_idorenvironment_idmust be set) - project
Id Integer - The ID of the project for which we want to retrieve the jobs (one of 
project_idorenvironment_idmust be set) 
- id string
 - The provider-assigned unique ID for this managed resource.
 - jobs
Get
Jobs Job[]  - Set of jobs with their details
 - environment
Id number - The ID of the environment for which we want to retrieve the jobs (one of 
project_idorenvironment_idmust be set) - project
Id number - The ID of the project for which we want to retrieve the jobs (one of 
project_idorenvironment_idmust be set) 
- id str
 - The provider-assigned unique ID for this managed resource.
 - jobs
Sequence[Get
Jobs Job]  - Set of jobs with their details
 - environment_
id int - The ID of the environment for which we want to retrieve the jobs (one of 
project_idorenvironment_idmust be set) - project_
id int - The ID of the project for which we want to retrieve the jobs (one of 
project_idorenvironment_idmust be set) 
- id String
 - The provider-assigned unique ID for this managed resource.
 - jobs List<Property Map>
 - Set of jobs with their details
 - environment
Id Number - The ID of the environment for which we want to retrieve the jobs (one of 
project_idorenvironment_idmust be set) - project
Id Number - The ID of the project for which we want to retrieve the jobs (one of 
project_idorenvironment_idmust be set) 
Supporting Types
GetJobsJob  
- Dbt
Version string - The version of dbt used for the job. If not set, the environment version will be used.
 - Deferring
Environment intId  - The ID of the environment this job defers to
 - Deferring
Job intDefinition Id  - [Deprecated - deferral is now set at the environment level] The ID of the job definition this job defers to
 - Description string
 - The description of the job
 - Environment
Pulumi.
Dbt Cloud. Inputs. Get Jobs Job Environment  - Details of the environment the job is running in
 - Environment
Id int - The ID of environment
 - Execute
Steps List<string> - The list of steps to run in the job
 - Execution
Pulumi.
Dbt Cloud. Inputs. Get Jobs Job Execution  - Generate
Docs bool - Whether the job generate docs
 - Id int
 - The ID of the job
 - Job
Completion Pulumi.Trigger Condition Dbt Cloud. Inputs. Get Jobs Job Job Completion Trigger Condition  - Whether the job is triggered by the completion of another job
 - Job
Type string - The type of job (e.g. CI, scheduled)
 - Name string
 - The name of the job
 - Project
Id int - The ID of the project
 - Run
Generate boolSources  - Whether the job test source freshness
 - Schedule
Pulumi.
Dbt Cloud. Inputs. Get Jobs Job Schedule  - Settings
Pulumi.
Dbt Cloud. Inputs. Get Jobs Job Settings  - Triggers
Pulumi.
Dbt Cloud. Inputs. Get Jobs Job Triggers  - Triggers
On boolDraft Pr  - Whether the CI job should be automatically triggered on draft PRs
 
- Dbt
Version string - The version of dbt used for the job. If not set, the environment version will be used.
 - Deferring
Environment intId  - The ID of the environment this job defers to
 - Deferring
Job intDefinition Id  - [Deprecated - deferral is now set at the environment level] The ID of the job definition this job defers to
 - Description string
 - The description of the job
 - Environment
Get
Jobs Job Environment  - Details of the environment the job is running in
 - Environment
Id int - The ID of environment
 - Execute
Steps []string - The list of steps to run in the job
 - Execution
Get
Jobs Job Execution  - Generate
Docs bool - Whether the job generate docs
 - Id int
 - The ID of the job
 - Job
Completion GetTrigger Condition Jobs Job Job Completion Trigger Condition  - Whether the job is triggered by the completion of another job
 - Job
Type string - The type of job (e.g. CI, scheduled)
 - Name string
 - The name of the job
 - Project
Id int - The ID of the project
 - Run
Generate boolSources  - Whether the job test source freshness
 - Schedule
Get
Jobs Job Schedule  - Settings
Get
Jobs Job Settings  - Triggers
Get
Jobs Job Triggers  - Triggers
On boolDraft Pr  - Whether the CI job should be automatically triggered on draft PRs
 
- dbt
Version String - The version of dbt used for the job. If not set, the environment version will be used.
 - deferring
Environment IntegerId  - The ID of the environment this job defers to
 - deferring
Job IntegerDefinition Id  - [Deprecated - deferral is now set at the environment level] The ID of the job definition this job defers to
 - description String
 - The description of the job
 - environment
Get
Jobs Job Environment  - Details of the environment the job is running in
 - environment
Id Integer - The ID of environment
 - execute
Steps List<String> - The list of steps to run in the job
 - execution
Get
Jobs Job Execution  - generate
Docs Boolean - Whether the job generate docs
 - id Integer
 - The ID of the job
 - job
Completion GetTrigger Condition Jobs Job Job Completion Trigger Condition  - Whether the job is triggered by the completion of another job
 - job
Type String - The type of job (e.g. CI, scheduled)
 - name String
 - The name of the job
 - project
Id Integer - The ID of the project
 - run
Generate BooleanSources  - Whether the job test source freshness
 - schedule
Get
Jobs Job Schedule  - settings
Get
Jobs Job Settings  - triggers
Get
Jobs Job Triggers  - triggers
On BooleanDraft Pr  - Whether the CI job should be automatically triggered on draft PRs
 
- dbt
Version string - The version of dbt used for the job. If not set, the environment version will be used.
 - deferring
Environment numberId  - The ID of the environment this job defers to
 - deferring
Job numberDefinition Id  - [Deprecated - deferral is now set at the environment level] The ID of the job definition this job defers to
 - description string
 - The description of the job
 - environment
Get
Jobs Job Environment  - Details of the environment the job is running in
 - environment
Id number - The ID of environment
 - execute
Steps string[] - The list of steps to run in the job
 - execution
Get
Jobs Job Execution  - generate
Docs boolean - Whether the job generate docs
 - id number
 - The ID of the job
 - job
Completion GetTrigger Condition Jobs Job Job Completion Trigger Condition  - Whether the job is triggered by the completion of another job
 - job
Type string - The type of job (e.g. CI, scheduled)
 - name string
 - The name of the job
 - project
Id number - The ID of the project
 - run
Generate booleanSources  - Whether the job test source freshness
 - schedule
Get
Jobs Job Schedule  - settings
Get
Jobs Job Settings  - triggers
Get
Jobs Job Triggers  - triggers
On booleanDraft Pr  - Whether the CI job should be automatically triggered on draft PRs
 
- dbt_
version str - The version of dbt used for the job. If not set, the environment version will be used.
 - deferring_
environment_ intid  - The ID of the environment this job defers to
 - deferring_
job_ intdefinition_ id  - [Deprecated - deferral is now set at the environment level] The ID of the job definition this job defers to
 - description str
 - The description of the job
 - environment
Get
Jobs Job Environment  - Details of the environment the job is running in
 - environment_
id int - The ID of environment
 - execute_
steps Sequence[str] - The list of steps to run in the job
 - execution
Get
Jobs Job Execution  - generate_
docs bool - Whether the job generate docs
 - id int
 - The ID of the job
 - job_
completion_ Gettrigger_ condition Jobs Job Job Completion Trigger Condition  - Whether the job is triggered by the completion of another job
 - job_
type str - The type of job (e.g. CI, scheduled)
 - name str
 - The name of the job
 - project_
id int - The ID of the project
 - run_
generate_ boolsources  - Whether the job test source freshness
 - schedule
Get
Jobs Job Schedule  - settings
Get
Jobs Job Settings  - triggers
Get
Jobs Job Triggers  - triggers_
on_ booldraft_ pr  - Whether the CI job should be automatically triggered on draft PRs
 
- dbt
Version String - The version of dbt used for the job. If not set, the environment version will be used.
 - deferring
Environment NumberId  - The ID of the environment this job defers to
 - deferring
Job NumberDefinition Id  - [Deprecated - deferral is now set at the environment level] The ID of the job definition this job defers to
 - description String
 - The description of the job
 - environment Property Map
 - Details of the environment the job is running in
 - environment
Id Number - The ID of environment
 - execute
Steps List<String> - The list of steps to run in the job
 - execution Property Map
 - generate
Docs Boolean - Whether the job generate docs
 - id Number
 - The ID of the job
 - job
Completion Property MapTrigger Condition  - Whether the job is triggered by the completion of another job
 - job
Type String - The type of job (e.g. CI, scheduled)
 - name String
 - The name of the job
 - project
Id Number - The ID of the project
 - run
Generate BooleanSources  - Whether the job test source freshness
 - schedule Property Map
 - settings Property Map
 - triggers Property Map
 - triggers
On BooleanDraft Pr  - Whether the CI job should be automatically triggered on draft PRs
 
GetJobsJobEnvironment   
- Deployment
Type string - Type of deployment environment: staging, production
 - Id int
 - ID of the environment
 - Name string
 - Name of the environment
 - Project
Id int - Type string
 - Environment type: development or deployment
 
- Deployment
Type string - Type of deployment environment: staging, production
 - Id int
 - ID of the environment
 - Name string
 - Name of the environment
 - Project
Id int - Type string
 - Environment type: development or deployment
 
- deployment
Type String - Type of deployment environment: staging, production
 - id Integer
 - ID of the environment
 - name String
 - Name of the environment
 - project
Id Integer - type String
 - Environment type: development or deployment
 
- deployment
Type string - Type of deployment environment: staging, production
 - id number
 - ID of the environment
 - name string
 - Name of the environment
 - project
Id number - type string
 - Environment type: development or deployment
 
- deployment_
type str - Type of deployment environment: staging, production
 - id int
 - ID of the environment
 - name str
 - Name of the environment
 - project_
id int - type str
 - Environment type: development or deployment
 
- deployment
Type String - Type of deployment environment: staging, production
 - id Number
 - ID of the environment
 - name String
 - Name of the environment
 - project
Id Number - type String
 - Environment type: development or deployment
 
GetJobsJobExecution   
- Timeout
Seconds int - The number of seconds before the job times out
 
- Timeout
Seconds int - The number of seconds before the job times out
 
- timeout
Seconds Integer - The number of seconds before the job times out
 
- timeout
Seconds number - The number of seconds before the job times out
 
- timeout_
seconds int - The number of seconds before the job times out
 
- timeout
Seconds Number - The number of seconds before the job times out
 
GetJobsJobJobCompletionTriggerCondition      
GetJobsJobJobCompletionTriggerConditionCondition       
- job_
id int - project_
id int - statuses Sequence[str]
 
GetJobsJobSchedule   
- Cron string
 - The cron schedule for the job. Only used if triggers.schedule is true
 
- Cron string
 - The cron schedule for the job. Only used if triggers.schedule is true
 
- cron String
 - The cron schedule for the job. Only used if triggers.schedule is true
 
- cron string
 - The cron schedule for the job. Only used if triggers.schedule is true
 
- cron str
 - The cron schedule for the job. Only used if triggers.schedule is true
 
- cron String
 - The cron schedule for the job. Only used if triggers.schedule is true
 
GetJobsJobSettings   
- Target
Name string - Value for 
target.namein the Jinja context - Threads int
 - Number of threads to run dbt with
 
- Target
Name string - Value for 
target.namein the Jinja context - Threads int
 - Number of threads to run dbt with
 
- target
Name String - Value for 
target.namein the Jinja context - threads Integer
 - Number of threads to run dbt with
 
- target
Name string - Value for 
target.namein the Jinja context - threads number
 - Number of threads to run dbt with
 
- target_
name str - Value for 
target.namein the Jinja context - threads int
 - Number of threads to run dbt with
 
- target
Name String - Value for 
target.namein the Jinja context - threads Number
 - Number of threads to run dbt with
 
GetJobsJobTriggers   
- Git
Provider boolWebhook  - Whether the job runs automatically on PR creation
 - Github
Webhook bool - Whether the job runs automatically on PR creation
 - On
Merge bool - Whether the job runs automatically once a PR is merged
 - Schedule bool
 - Whether the job runs on a schedule
 
- Git
Provider boolWebhook  - Whether the job runs automatically on PR creation
 - Github
Webhook bool - Whether the job runs automatically on PR creation
 - On
Merge bool - Whether the job runs automatically once a PR is merged
 - Schedule bool
 - Whether the job runs on a schedule
 
- git
Provider BooleanWebhook  - Whether the job runs automatically on PR creation
 - github
Webhook Boolean - Whether the job runs automatically on PR creation
 - on
Merge Boolean - Whether the job runs automatically once a PR is merged
 - schedule Boolean
 - Whether the job runs on a schedule
 
- git
Provider booleanWebhook  - Whether the job runs automatically on PR creation
 - github
Webhook boolean - Whether the job runs automatically on PR creation
 - on
Merge boolean - Whether the job runs automatically once a PR is merged
 - schedule boolean
 - Whether the job runs on a schedule
 
- git_
provider_ boolwebhook  - Whether the job runs automatically on PR creation
 - github_
webhook bool - Whether the job runs automatically on PR creation
 - on_
merge bool - Whether the job runs automatically once a PR is merged
 - schedule bool
 - Whether the job runs on a schedule
 
- git
Provider BooleanWebhook  - Whether the job runs automatically on PR creation
 - github
Webhook Boolean - Whether the job runs automatically on PR creation
 - on
Merge Boolean - Whether the job runs automatically once a PR is merged
 - schedule Boolean
 - Whether the job runs on a schedule
 
Package Details
- Repository
 - dbtcloud pulumi/pulumi-dbtcloud
 - License
 - Apache-2.0
 - Notes
 - This Pulumi package is based on the 
dbtcloudTerraform Provider.