1. Packages
  2. Dynatrace
  3. API Docs
  4. getDql
Dynatrace v0.28.0 published on Sunday, May 11, 2025 by Pulumiverse

dynatrace.getDql

Explore with Pulumi AI

dynatrace logo
Dynatrace v0.28.0 published on Sunday, May 11, 2025 by Pulumiverse

    Example Usage

    import * as pulumi from "@pulumi/pulumi";
    import * as dynatrace from "@pulumi/dynatrace";
    
    const _this = dynatrace.getDql({
        query: "fetch events",
    });
    
    import pulumi
    import pulumi_dynatrace as dynatrace
    
    this = dynatrace.get_dql(query="fetch events")
    
    package main
    
    import (
    	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
    	"github.com/pulumiverse/pulumi-dynatrace/sdk/go/dynatrace"
    )
    
    func main() {
    	pulumi.Run(func(ctx *pulumi.Context) error {
    		_, err := dynatrace.GetDql(ctx, &dynatrace.GetDqlArgs{
    			Query: "fetch events",
    		}, nil)
    		if err != nil {
    			return err
    		}
    		return nil
    	})
    }
    
    using System.Collections.Generic;
    using System.Linq;
    using Pulumi;
    using Dynatrace = Pulumi.Dynatrace;
    
    return await Deployment.RunAsync(() => 
    {
        var @this = Dynatrace.GetDql.Invoke(new()
        {
            Query = "fetch events",
        });
    
    });
    
    package generated_program;
    
    import com.pulumi.Context;
    import com.pulumi.Pulumi;
    import com.pulumi.core.Output;
    import com.pulumi.dynatrace.DynatraceFunctions;
    import com.pulumi.dynatrace.inputs.GetDqlArgs;
    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 this = DynatraceFunctions.getDql(GetDqlArgs.builder()
                .query("fetch events")
                .build());
    
        }
    }
    
    variables:
      this:
        fn::invoke:
          function: dynatrace:getDql
          arguments:
            query: fetch events
    

    will produce content for the results attribute like this:

    [
        {
            "event.id"                             = "-7629786693326919096_1745910027748"
            "Event source"                         = "OS services monitoring"
            ...
            timestamp                              = "2025-04-29T07:00:44.416000000Z"
        },
        {
            ...
        },
        ...
    ]
    

    You can also use Heredoc syntax for better readability of complex DQL queries.

    import * as pulumi from "@pulumi/pulumi";
    import * as dynatrace from "@pulumi/dynatrace";
    
    const _this = dynatrace.getDql({
        query: `    fetch events |
        filter event.type == "davis" AND davis.status != "CLOSED" |
        fields timestamp, davis.title, davis.underMaintenance, davis.status |
        sort timestamp |
        limit 10  
    
    `,
    });
    
    import pulumi
    import pulumi_dynatrace as dynatrace
    
    this = dynatrace.get_dql(query="""    fetch events |
        filter event.type == "davis" AND davis.status != "CLOSED" |
        fields timestamp, davis.title, davis.underMaintenance, davis.status |
        sort timestamp |
        limit 10  
    
    """)
    
    package main
    
    import (
    	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
    	"github.com/pulumiverse/pulumi-dynatrace/sdk/go/dynatrace"
    )
    
    func main() {
    	pulumi.Run(func(ctx *pulumi.Context) error {
    		_, err := dynatrace.GetDql(ctx, &dynatrace.GetDqlArgs{
    			Query: `    fetch events |
        filter event.type == "davis" AND davis.status != "CLOSED" |
        fields timestamp, davis.title, davis.underMaintenance, davis.status |
        sort timestamp |
        limit 10  
    
    `,
    		}, nil)
    		if err != nil {
    			return err
    		}
    		return nil
    	})
    }
    
    using System.Collections.Generic;
    using System.Linq;
    using Pulumi;
    using Dynatrace = Pulumi.Dynatrace;
    
    return await Deployment.RunAsync(() => 
    {
        var @this = Dynatrace.GetDql.Invoke(new()
        {
            Query = @"    fetch events |
        filter event.type == ""davis"" AND davis.status != ""CLOSED"" |
        fields timestamp, davis.title, davis.underMaintenance, davis.status |
        sort timestamp |
        limit 10  
    
    ",
        });
    
    });
    
    package generated_program;
    
    import com.pulumi.Context;
    import com.pulumi.Pulumi;
    import com.pulumi.core.Output;
    import com.pulumi.dynatrace.DynatraceFunctions;
    import com.pulumi.dynatrace.inputs.GetDqlArgs;
    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 this = DynatraceFunctions.getDql(GetDqlArgs.builder()
                .query("""
        fetch events |
        filter event.type == "davis" AND davis.status != "CLOSED" |
        fields timestamp, davis.title, davis.underMaintenance, davis.status |
        sort timestamp |
        limit 10  
    
                """)
                .build());
    
        }
    }
    
    variables:
      this:
        fn::invoke:
          function: dynatrace:getDql
          arguments:
            query: "    fetch events |\n    filter event.type == \"davis\" AND davis.status != \"CLOSED\" |\n    fields timestamp, davis.title, davis.underMaintenance, davis.status |\n    sort timestamp |\n    limit 10  \n\n"
    

    {{ .SchemaMarkdown | trimspace }}

    Using getDql

    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 getDql(args: GetDqlArgs, opts?: InvokeOptions): Promise<GetDqlResult>
    function getDqlOutput(args: GetDqlOutputArgs, opts?: InvokeOptions): Output<GetDqlResult>
    def get_dql(default_sampling_ratio: Optional[float] = None,
                default_scan_limit_gbytes: Optional[int] = None,
                default_timeframe_end: Optional[str] = None,
                default_timeframe_start: Optional[str] = None,
                fetch_timeout_seconds: Optional[int] = None,
                locale: Optional[str] = None,
                max_result_bytes: Optional[int] = None,
                max_result_records: Optional[int] = None,
                query: Optional[str] = None,
                timezone: Optional[str] = None,
                opts: Optional[InvokeOptions] = None) -> GetDqlResult
    def get_dql_output(default_sampling_ratio: Optional[pulumi.Input[float]] = None,
                default_scan_limit_gbytes: Optional[pulumi.Input[int]] = None,
                default_timeframe_end: Optional[pulumi.Input[str]] = None,
                default_timeframe_start: Optional[pulumi.Input[str]] = None,
                fetch_timeout_seconds: Optional[pulumi.Input[int]] = None,
                locale: Optional[pulumi.Input[str]] = None,
                max_result_bytes: Optional[pulumi.Input[int]] = None,
                max_result_records: Optional[pulumi.Input[int]] = None,
                query: Optional[pulumi.Input[str]] = None,
                timezone: Optional[pulumi.Input[str]] = None,
                opts: Optional[InvokeOptions] = None) -> Output[GetDqlResult]
    func GetDql(ctx *Context, args *GetDqlArgs, opts ...InvokeOption) (*GetDqlResult, error)
    func GetDqlOutput(ctx *Context, args *GetDqlOutputArgs, opts ...InvokeOption) GetDqlResultOutput

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

    public static class GetDql 
    {
        public static Task<GetDqlResult> InvokeAsync(GetDqlArgs args, InvokeOptions? opts = null)
        public static Output<GetDqlResult> Invoke(GetDqlInvokeArgs args, InvokeOptions? opts = null)
    }
    public static CompletableFuture<GetDqlResult> getDql(GetDqlArgs args, InvokeOptions options)
    public static Output<GetDqlResult> getDql(GetDqlArgs args, InvokeOptions options)
    
    fn::invoke:
      function: dynatrace:index/getDql:getDql
      arguments:
        # arguments dictionary

    The following arguments are supported:

    getDql Result

    The following output properties are available:

    Id string
    The provider-assigned unique ID for this managed resource.
    Query string
    Records string
    DefaultSamplingRatio double
    DefaultScanLimitGbytes int
    DefaultTimeframeEnd string
    DefaultTimeframeStart string
    FetchTimeoutSeconds int
    Locale string
    MaxResultBytes int
    MaxResultRecords int
    Timezone string
    Id string
    The provider-assigned unique ID for this managed resource.
    Query string
    Records string
    DefaultSamplingRatio float64
    DefaultScanLimitGbytes int
    DefaultTimeframeEnd string
    DefaultTimeframeStart string
    FetchTimeoutSeconds int
    Locale string
    MaxResultBytes int
    MaxResultRecords int
    Timezone string
    id String
    The provider-assigned unique ID for this managed resource.
    query String
    records String
    defaultSamplingRatio Double
    defaultScanLimitGbytes Integer
    defaultTimeframeEnd String
    defaultTimeframeStart String
    fetchTimeoutSeconds Integer
    locale String
    maxResultBytes Integer
    maxResultRecords Integer
    timezone String
    id string
    The provider-assigned unique ID for this managed resource.
    query string
    records string
    defaultSamplingRatio number
    defaultScanLimitGbytes number
    defaultTimeframeEnd string
    defaultTimeframeStart string
    fetchTimeoutSeconds number
    locale string
    maxResultBytes number
    maxResultRecords number
    timezone string
    id String
    The provider-assigned unique ID for this managed resource.
    query String
    records String
    defaultSamplingRatio Number
    defaultScanLimitGbytes Number
    defaultTimeframeEnd String
    defaultTimeframeStart String
    fetchTimeoutSeconds Number
    locale String
    maxResultBytes Number
    maxResultRecords Number
    timezone String

    Package Details

    Repository
    dynatrace pulumiverse/pulumi-dynatrace
    License
    Apache-2.0
    Notes
    This Pulumi package is based on the dynatrace Terraform Provider.
    dynatrace logo
    Dynatrace v0.28.0 published on Sunday, May 11, 2025 by Pulumiverse