1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. EmWarehouse
  5. getEtlRuns
Oracle Cloud Infrastructure v1.33.0 published on Thursday, Apr 25, 2024 by Pulumi

oci.EmWarehouse.getEtlRuns

Explore with Pulumi AI

oci logo
Oracle Cloud Infrastructure v1.33.0 published on Thursday, Apr 25, 2024 by Pulumi

    This data source provides the list of Em Warehouse Etl Runs in Oracle Cloud Infrastructure Em Warehouse service.

    Gets a list of runs of an EmWarehouseResource by identifier

    Example Usage

    import * as pulumi from "@pulumi/pulumi";
    import * as oci from "@pulumi/oci";
    
    const testEmWarehouseEtlRuns = oci.EmWarehouse.getEtlRuns({
        emWarehouseId: testEmWarehouse.id,
        compartmentId: compartmentId,
        displayName: emWarehouseEtlRunDisplayName,
    });
    
    import pulumi
    import pulumi_oci as oci
    
    test_em_warehouse_etl_runs = oci.EmWarehouse.get_etl_runs(em_warehouse_id=test_em_warehouse["id"],
        compartment_id=compartment_id,
        display_name=em_warehouse_etl_run_display_name)
    
    package main
    
    import (
    	"github.com/pulumi/pulumi-oci/sdk/go/oci/EmWarehouse"
    	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
    )
    
    func main() {
    	pulumi.Run(func(ctx *pulumi.Context) error {
    		_, err := EmWarehouse.GetEtlRuns(ctx, &emwarehouse.GetEtlRunsArgs{
    			EmWarehouseId: testEmWarehouse.Id,
    			CompartmentId: pulumi.StringRef(compartmentId),
    			DisplayName:   pulumi.StringRef(emWarehouseEtlRunDisplayName),
    		}, nil)
    		if err != nil {
    			return err
    		}
    		return nil
    	})
    }
    
    using System.Collections.Generic;
    using System.Linq;
    using Pulumi;
    using Oci = Pulumi.Oci;
    
    return await Deployment.RunAsync(() => 
    {
        var testEmWarehouseEtlRuns = Oci.EmWarehouse.GetEtlRuns.Invoke(new()
        {
            EmWarehouseId = testEmWarehouse.Id,
            CompartmentId = compartmentId,
            DisplayName = emWarehouseEtlRunDisplayName,
        });
    
    });
    
    package generated_program;
    
    import com.pulumi.Context;
    import com.pulumi.Pulumi;
    import com.pulumi.core.Output;
    import com.pulumi.oci.EmWarehouse.EmWarehouseFunctions;
    import com.pulumi.oci.EmWarehouse.inputs.GetEtlRunsArgs;
    import java.util.List;
    import java.util.ArrayList;
    import java.util.Map;
    import java.io.File;
    import java.nio.file.Files;
    import java.nio.file.Paths;
    
    public class App {
        public static void main(String[] args) {
            Pulumi.run(App::stack);
        }
    
        public static void stack(Context ctx) {
            final var testEmWarehouseEtlRuns = EmWarehouseFunctions.getEtlRuns(GetEtlRunsArgs.builder()
                .emWarehouseId(testEmWarehouse.id())
                .compartmentId(compartmentId)
                .displayName(emWarehouseEtlRunDisplayName)
                .build());
    
        }
    }
    
    variables:
      testEmWarehouseEtlRuns:
        fn::invoke:
          Function: oci:EmWarehouse:getEtlRuns
          Arguments:
            emWarehouseId: ${testEmWarehouse.id}
            compartmentId: ${compartmentId}
            displayName: ${emWarehouseEtlRunDisplayName}
    

    Using getEtlRuns

    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 getEtlRuns(args: GetEtlRunsArgs, opts?: InvokeOptions): Promise<GetEtlRunsResult>
    function getEtlRunsOutput(args: GetEtlRunsOutputArgs, opts?: InvokeOptions): Output<GetEtlRunsResult>
    def get_etl_runs(compartment_id: Optional[str] = None,
                     display_name: Optional[str] = None,
                     em_warehouse_id: Optional[str] = None,
                     filters: Optional[Sequence[_emwarehouse.GetEtlRunsFilter]] = None,
                     opts: Optional[InvokeOptions] = None) -> GetEtlRunsResult
    def get_etl_runs_output(compartment_id: Optional[pulumi.Input[str]] = None,
                     display_name: Optional[pulumi.Input[str]] = None,
                     em_warehouse_id: Optional[pulumi.Input[str]] = None,
                     filters: Optional[pulumi.Input[Sequence[pulumi.Input[_emwarehouse.GetEtlRunsFilterArgs]]]] = None,
                     opts: Optional[InvokeOptions] = None) -> Output[GetEtlRunsResult]
    func GetEtlRuns(ctx *Context, args *GetEtlRunsArgs, opts ...InvokeOption) (*GetEtlRunsResult, error)
    func GetEtlRunsOutput(ctx *Context, args *GetEtlRunsOutputArgs, opts ...InvokeOption) GetEtlRunsResultOutput

    > Note: This function is named GetEtlRuns in the Go SDK.

    public static class GetEtlRuns 
    {
        public static Task<GetEtlRunsResult> InvokeAsync(GetEtlRunsArgs args, InvokeOptions? opts = null)
        public static Output<GetEtlRunsResult> Invoke(GetEtlRunsInvokeArgs args, InvokeOptions? opts = null)
    }
    public static CompletableFuture<GetEtlRunsResult> getEtlRuns(GetEtlRunsArgs args, InvokeOptions options)
    // Output-based functions aren't available in Java yet
    
    fn::invoke:
      function: oci:EmWarehouse/getEtlRuns:getEtlRuns
      arguments:
        # arguments dictionary

    The following arguments are supported:

    EmWarehouseId string
    unique EmWarehouse identifier
    CompartmentId string
    The ID of the compartment in which to list resources.
    DisplayName string
    A filter to return only resources that match the entire display name given.
    Filters List<GetEtlRunsFilter>
    EmWarehouseId string
    unique EmWarehouse identifier
    CompartmentId string
    The ID of the compartment in which to list resources.
    DisplayName string
    A filter to return only resources that match the entire display name given.
    Filters []GetEtlRunsFilter
    emWarehouseId String
    unique EmWarehouse identifier
    compartmentId String
    The ID of the compartment in which to list resources.
    displayName String
    A filter to return only resources that match the entire display name given.
    filters List<GetEtlRunsFilter>
    emWarehouseId string
    unique EmWarehouse identifier
    compartmentId string
    The ID of the compartment in which to list resources.
    displayName string
    A filter to return only resources that match the entire display name given.
    filters GetEtlRunsFilter[]
    em_warehouse_id str
    unique EmWarehouse identifier
    compartment_id str
    The ID of the compartment in which to list resources.
    display_name str
    A filter to return only resources that match the entire display name given.
    filters Sequence[emwarehouse.GetEtlRunsFilter]
    emWarehouseId String
    unique EmWarehouse identifier
    compartmentId String
    The ID of the compartment in which to list resources.
    displayName String
    A filter to return only resources that match the entire display name given.
    filters List<Property Map>

    getEtlRuns Result

    The following output properties are available:

    EmWarehouseId string
    EtlRunCollections List<GetEtlRunsEtlRunCollection>
    The list of etl_run_collection.
    Id string
    The provider-assigned unique ID for this managed resource.
    CompartmentId string
    Compartment Identifier
    DisplayName string
    The name of the ETLRun.
    Filters List<GetEtlRunsFilter>
    EmWarehouseId string
    EtlRunCollections []GetEtlRunsEtlRunCollection
    The list of etl_run_collection.
    Id string
    The provider-assigned unique ID for this managed resource.
    CompartmentId string
    Compartment Identifier
    DisplayName string
    The name of the ETLRun.
    Filters []GetEtlRunsFilter
    emWarehouseId String
    etlRunCollections List<GetEtlRunsEtlRunCollection>
    The list of etl_run_collection.
    id String
    The provider-assigned unique ID for this managed resource.
    compartmentId String
    Compartment Identifier
    displayName String
    The name of the ETLRun.
    filters List<GetEtlRunsFilter>
    emWarehouseId string
    etlRunCollections GetEtlRunsEtlRunCollection[]
    The list of etl_run_collection.
    id string
    The provider-assigned unique ID for this managed resource.
    compartmentId string
    Compartment Identifier
    displayName string
    The name of the ETLRun.
    filters GetEtlRunsFilter[]
    em_warehouse_id str
    etl_run_collections Sequence[emwarehouse.GetEtlRunsEtlRunCollection]
    The list of etl_run_collection.
    id str
    The provider-assigned unique ID for this managed resource.
    compartment_id str
    Compartment Identifier
    display_name str
    The name of the ETLRun.
    filters Sequence[emwarehouse.GetEtlRunsFilter]
    emWarehouseId String
    etlRunCollections List<Property Map>
    The list of etl_run_collection.
    id String
    The provider-assigned unique ID for this managed resource.
    compartmentId String
    Compartment Identifier
    displayName String
    The name of the ETLRun.
    filters List<Property Map>

    Supporting Types

    GetEtlRunsEtlRunCollection

    GetEtlRunsEtlRunCollectionItem

    GetEtlRunsEtlRunCollectionItemItem

    CompartmentId string
    The ID of the compartment in which to list resources.
    DataReadInBytes string
    Data read by the dataflow run
    DataWritten string
    Data written by the dataflow run
    DefinedTags Dictionary<string, object>
    Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
    DisplayName string
    A filter to return only resources that match the entire display name given.
    FreeformTags Dictionary<string, object>
    Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
    LifecycleDetails string
    Details of the lifecycle state
    RunDurationInMilliseconds string
    Dataflow run duration
    State string
    The current state of the etlRun.
    TimeCreated string
    Time when the dataflow run was created
    TimeUpdated string
    Time when the dataflow run was updated
    CompartmentId string
    The ID of the compartment in which to list resources.
    DataReadInBytes string
    Data read by the dataflow run
    DataWritten string
    Data written by the dataflow run
    DefinedTags map[string]interface{}
    Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
    DisplayName string
    A filter to return only resources that match the entire display name given.
    FreeformTags map[string]interface{}
    Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
    LifecycleDetails string
    Details of the lifecycle state
    RunDurationInMilliseconds string
    Dataflow run duration
    State string
    The current state of the etlRun.
    TimeCreated string
    Time when the dataflow run was created
    TimeUpdated string
    Time when the dataflow run was updated
    compartmentId String
    The ID of the compartment in which to list resources.
    dataReadInBytes String
    Data read by the dataflow run
    dataWritten String
    Data written by the dataflow run
    definedTags Map<String,Object>
    Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
    displayName String
    A filter to return only resources that match the entire display name given.
    freeformTags Map<String,Object>
    Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
    lifecycleDetails String
    Details of the lifecycle state
    runDurationInMilliseconds String
    Dataflow run duration
    state String
    The current state of the etlRun.
    timeCreated String
    Time when the dataflow run was created
    timeUpdated String
    Time when the dataflow run was updated
    compartmentId string
    The ID of the compartment in which to list resources.
    dataReadInBytes string
    Data read by the dataflow run
    dataWritten string
    Data written by the dataflow run
    definedTags {[key: string]: any}
    Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
    displayName string
    A filter to return only resources that match the entire display name given.
    freeformTags {[key: string]: any}
    Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
    lifecycleDetails string
    Details of the lifecycle state
    runDurationInMilliseconds string
    Dataflow run duration
    state string
    The current state of the etlRun.
    timeCreated string
    Time when the dataflow run was created
    timeUpdated string
    Time when the dataflow run was updated
    compartment_id str
    The ID of the compartment in which to list resources.
    data_read_in_bytes str
    Data read by the dataflow run
    data_written str
    Data written by the dataflow run
    defined_tags Mapping[str, Any]
    Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
    display_name str
    A filter to return only resources that match the entire display name given.
    freeform_tags Mapping[str, Any]
    Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
    lifecycle_details str
    Details of the lifecycle state
    run_duration_in_milliseconds str
    Dataflow run duration
    state str
    The current state of the etlRun.
    time_created str
    Time when the dataflow run was created
    time_updated str
    Time when the dataflow run was updated
    compartmentId String
    The ID of the compartment in which to list resources.
    dataReadInBytes String
    Data read by the dataflow run
    dataWritten String
    Data written by the dataflow run
    definedTags Map<Any>
    Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
    displayName String
    A filter to return only resources that match the entire display name given.
    freeformTags Map<Any>
    Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
    lifecycleDetails String
    Details of the lifecycle state
    runDurationInMilliseconds String
    Dataflow run duration
    state String
    The current state of the etlRun.
    timeCreated String
    Time when the dataflow run was created
    timeUpdated String
    Time when the dataflow run was updated

    GetEtlRunsFilter

    Name string
    Values List<string>
    Regex bool
    Name string
    Values []string
    Regex bool
    name String
    values List<String>
    regex Boolean
    name string
    values string[]
    regex boolean
    name str
    values Sequence[str]
    regex bool
    name String
    values List<String>
    regex Boolean

    Package Details

    Repository
    oci pulumi/pulumi-oci
    License
    Apache-2.0
    Notes
    This Pulumi package is based on the oci Terraform Provider.
    oci logo
    Oracle Cloud Infrastructure v1.33.0 published on Thursday, Apr 25, 2024 by Pulumi