1. Packages
  2. Databricks Provider
  3. API Docs
  4. Query
Viewing docs for Databricks v1.88.0
published on Thursday, Feb 26, 2026 by Pulumi
Schema (JSON)
pulumi/pulumi-databricks

databricks.Query

databricks logo
Viewing docs for Databricks v1.88.0
published on Thursday, Feb 26, 2026 by Pulumi
Schema (JSON)
pulumi/pulumi-databricks

    This resource allows you to manage Databricks SQL Queries. It supersedes databricks.SqlQuery resource - see migration guide below for more details.

    This resource can only be used with a workspace-level provider!

    Example Usage

    import * as pulumi from "@pulumi/pulumi";
import * as databricks from "@pulumi/databricks";

const sharedDir = new databricks.Directory("shared_dir", {path: "/Shared/Queries"});
// This will be replaced with new databricks_query resource
const _this = new databricks.Query("this", {
    warehouseId: example.id,
    displayName: "My Query Name",
    queryText: "SELECT 42 as value",
    parentPath: sharedDir.path,
});

    import pulumi
import pulumi_databricks as databricks

shared_dir = databricks.Directory("shared_dir", path="/Shared/Queries")
# This will be replaced with new databricks_query resource
this = databricks.Query("this",
    warehouse_id=example["id"],
    display_name="My Query Name",
    query_text="SELECT 42 as value",
    parent_path=shared_dir.path)

    package main

import (
	"github.com/pulumi/pulumi-databricks/sdk/go/databricks"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		sharedDir, err := databricks.NewDirectory(ctx, "shared_dir", &databricks.DirectoryArgs{
			Path: pulumi.String("/Shared/Queries"),
		})
		if err != nil {
			return err
		}
		// This will be replaced with new databricks_query resource
		_, err = databricks.NewQuery(ctx, "this", &databricks.QueryArgs{
			WarehouseId: pulumi.Any(example.Id),
			DisplayName: pulumi.String("My Query Name"),
			QueryText:   pulumi.String("SELECT 42 as value"),
			ParentPath:  sharedDir.Path,
		})
		if err != nil {
			return err
		}
		return nil
	})
}

    using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Databricks = Pulumi.Databricks;

return await Deployment.RunAsync(() => 
{
    var sharedDir = new Databricks.Directory("shared_dir", new()
    {
        Path = "/Shared/Queries",
    });

    // This will be replaced with new databricks_query resource
    var @this = new Databricks.Query("this", new()
    {
        WarehouseId = example.Id,
        DisplayName = "My Query Name",
        QueryText = "SELECT 42 as value",
        ParentPath = sharedDir.Path,
    });

});

    package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.databricks.Directory;
import com.pulumi.databricks.DirectoryArgs;
import com.pulumi.databricks.Query;
import com.pulumi.databricks.QueryArgs;
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) {
        var sharedDir = new Directory("sharedDir", DirectoryArgs.builder()
            .path("/Shared/Queries")
            .build());

        // This will be replaced with new databricks_query resource
        var this_ = new Query("this", QueryArgs.builder()
            .warehouseId(example.id())
            .displayName("My Query Name")
            .queryText("SELECT 42 as value")
            .parentPath(sharedDir.path())
            .build());

    }
}

    resources:
  sharedDir:
    type: databricks:Directory
    name: shared_dir
    properties:
      path: /Shared/Queries
  # This will be replaced with new databricks_query resource
  this:
    type: databricks:Query
    properties:
      warehouseId: ${example.id}
      displayName: My Query Name
      queryText: SELECT 42 as value
      parentPath: ${sharedDir.path}

    Migrating from databricks.SqlQuery resource

    Under the hood, the new resource uses the same data as the databricks.SqlQuery, but exposed via different API. This means that we can migrate existing queries without recreating them. This operation is done in few steps:

    • Record the ID of existing databricks.SqlQuery, for example, by executing the terraform state show databricks_sql_query.query command.
    • Create the code for the new implementation performing following changes:
      • the name attribute is now named display_name
      • the parent (if exists) is renamed to parent_path attribute, and should be converted from folders/object_id to the actual path.
      • Blocks that specify values in the parameter block were renamed (see above).

    For example, if we have the original databricks.SqlQuery defined as:

    import * as pulumi from "@pulumi/pulumi";
import * as databricks from "@pulumi/databricks";

const query = new databricks.SqlQuery("query", {
    dataSourceId: example.dataSourceId,
    query: "select 42 as value",
    name: "My Query",
    parent: `folders/${sharedDir.objectId}`,
    parameters: [{
        name: "p1",
        title: "Title for p1",
        text: {
            value: "default",
        },
    }],
});

    import pulumi
import pulumi_databricks as databricks

query = databricks.SqlQuery("query",
    data_source_id=example["dataSourceId"],
    query="select 42 as value",
    name="My Query",
    parent=f"folders/{shared_dir['objectId']}",
    parameters=[{
        "name": "p1",
        "title": "Title for p1",
        "text": {
            "value": "default",
        },
    }])

    package main

import (
	"github.com/pulumi/pulumi-databricks/sdk/go/databricks"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := databricks.NewSqlQuery(ctx, "query", &databricks.SqlQueryArgs{
			DataSourceId: pulumi.Any(example.DataSourceId),
			Query:        pulumi.String("select 42 as value"),
			Name:         pulumi.String("My Query"),
			Parent:       pulumi.Sprintf("folders/%v", sharedDir.ObjectId),
			Parameters: databricks.SqlQueryParameterArray{
				&databricks.SqlQueryParameterArgs{
					Name:  pulumi.String("p1"),
					Title: pulumi.String("Title for p1"),
					Text: &databricks.SqlQueryParameterTextArgs{
						Value: pulumi.String("default"),
					},
				},
			},
		})
		if err != nil {
			return err
		}
		return nil
	})
}

    using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Databricks = Pulumi.Databricks;

return await Deployment.RunAsync(() => 
{
    var query = new Databricks.SqlQuery("query", new()
    {
        DataSourceId = example.DataSourceId,
        Query = "select 42 as value",
        Name = "My Query",
        Parent = $"folders/{sharedDir.ObjectId}",
        Parameters = new[]
        {
            new Databricks.Inputs.SqlQueryParameterArgs
            {
                Name = "p1",
                Title = "Title for p1",
                Text = new Databricks.Inputs.SqlQueryParameterTextArgs
                {
                    Value = "default",
                },
            },
        },
    });

});

    package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.databricks.SqlQuery;
import com.pulumi.databricks.SqlQueryArgs;
import com.pulumi.databricks.inputs.SqlQueryParameterArgs;
import com.pulumi.databricks.inputs.SqlQueryParameterTextArgs;
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) {
        var query = new SqlQuery("query", SqlQueryArgs.builder()
            .dataSourceId(example.dataSourceId())
            .query("select 42 as value")
            .name("My Query")
            .parent(String.format("folders/%s", sharedDir.objectId()))
            .parameters(SqlQueryParameterArgs.builder()
                .name("p1")
                .title("Title for p1")
                .text(SqlQueryParameterTextArgs.builder()
                    .value("default")
                    .build())
                .build())
            .build());

    }
}

    resources:
  query:
    type: databricks:SqlQuery
    properties:
      dataSourceId: ${example.dataSourceId}
      query: select 42 as value
      name: My Query
      parent: folders/${sharedDir.objectId}
      parameters:
        - name: p1
          title: Title for p1
          text:
            value: default

    we’ll have a new resource defined as:

    import * as pulumi from "@pulumi/pulumi";
import * as databricks from "@pulumi/databricks";

const query = new databricks.Query("query", {
    warehouseId: example.id,
    queryText: "select 42 as value",
    displayName: "My Query",
    parentPath: sharedDir.path,
    parameters: [{
        name: "p1",
        title: "Title for p1",
        textValue: {
            value: "default",
        },
    }],
});

    import pulumi
import pulumi_databricks as databricks

query = databricks.Query("query",
    warehouse_id=example["id"],
    query_text="select 42 as value",
    display_name="My Query",
    parent_path=shared_dir["path"],
    parameters=[{
        "name": "p1",
        "title": "Title for p1",
        "text_value": {
            "value": "default",
        },
    }])

    package main

import (
	"github.com/pulumi/pulumi-databricks/sdk/go/databricks"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := databricks.NewQuery(ctx, "query", &databricks.QueryArgs{
			WarehouseId: pulumi.Any(example.Id),
			QueryText:   pulumi.String("select 42 as value"),
			DisplayName: pulumi.String("My Query"),
			ParentPath:  pulumi.Any(sharedDir.Path),
			Parameters: databricks.QueryParameterArray{
				&databricks.QueryParameterArgs{
					Name:  pulumi.String("p1"),
					Title: pulumi.String("Title for p1"),
					TextValue: &databricks.QueryParameterTextValueArgs{
						Value: pulumi.String("default"),
					},
				},
			},
		})
		if err != nil {
			return err
		}
		return nil
	})
}

    using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Databricks = Pulumi.Databricks;

return await Deployment.RunAsync(() => 
{
    var query = new Databricks.Query("query", new()
    {
        WarehouseId = example.Id,
        QueryText = "select 42 as value",
        DisplayName = "My Query",
        ParentPath = sharedDir.Path,
        Parameters = new[]
        {
            new Databricks.Inputs.QueryParameterArgs
            {
                Name = "p1",
                Title = "Title for p1",
                TextValue = new Databricks.Inputs.QueryParameterTextValueArgs
                {
                    Value = "default",
                },
            },
        },
    });

});

    package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.databricks.Query;
import com.pulumi.databricks.QueryArgs;
import com.pulumi.databricks.inputs.QueryParameterArgs;
import com.pulumi.databricks.inputs.QueryParameterTextValueArgs;
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) {
        var query = new Query("query", QueryArgs.builder()
            .warehouseId(example.id())
            .queryText("select 42 as value")
            .displayName("My Query")
            .parentPath(sharedDir.path())
            .parameters(QueryParameterArgs.builder()
                .name("p1")
                .title("Title for p1")
                .textValue(QueryParameterTextValueArgs.builder()
                    .value("default")
                    .build())
                .build())
            .build());

    }
}

    resources:
  query:
    type: databricks:Query
    properties:
      warehouseId: ${example.id}
      queryText: select 42 as value
      displayName: My Query
      parentPath: ${sharedDir.path}
      parameters:
        - name: p1
          title: Title for p1
          textValue:
            value: default

    Access Control

    databricks.Permissions can control which groups or individual users can Manage, Edit, Run or View individual queries.

    import * as pulumi from "@pulumi/pulumi";
import * as databricks from "@pulumi/databricks";

const queryUsage = new databricks.Permissions("query_usage", {
    sqlQueryId: query.id,
    accessControls: [{
        groupName: "users",
        permissionLevel: "CAN_RUN",
    }],
});

    import pulumi
import pulumi_databricks as databricks

query_usage = databricks.Permissions("query_usage",
    sql_query_id=query["id"],
    access_controls=[{
        "group_name": "users",
        "permission_level": "CAN_RUN",
    }])

    package main

import (
	"github.com/pulumi/pulumi-databricks/sdk/go/databricks"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := databricks.NewPermissions(ctx, "query_usage", &databricks.PermissionsArgs{
			SqlQueryId: pulumi.Any(query.Id),
			AccessControls: databricks.PermissionsAccessControlArray{
				&databricks.PermissionsAccessControlArgs{
					GroupName:       pulumi.String("users"),
					PermissionLevel: pulumi.String("CAN_RUN"),
				},
			},
		})
		if err != nil {
			return err
		}
		return nil
	})
}

    using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Databricks = Pulumi.Databricks;

return await Deployment.RunAsync(() => 
{
    var queryUsage = new Databricks.Permissions("query_usage", new()
    {
        SqlQueryId = query.Id,
        AccessControls = new[]
        {
            new Databricks.Inputs.PermissionsAccessControlArgs
            {
                GroupName = "users",
                PermissionLevel = "CAN_RUN",
            },
        },
    });

});

    package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.databricks.Permissions;
import com.pulumi.databricks.PermissionsArgs;
import com.pulumi.databricks.inputs.PermissionsAccessControlArgs;
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) {
        var queryUsage = new Permissions("queryUsage", PermissionsArgs.builder()
            .sqlQueryId(query.id())
            .accessControls(PermissionsAccessControlArgs.builder()
                .groupName("users")
                .permissionLevel("CAN_RUN")
                .build())
            .build());

    }
}

    resources:
  queryUsage:
    type: databricks:Permissions
    name: query_usage
    properties:
      sqlQueryId: ${query.id}
      accessControls:
        - groupName: users
          permissionLevel: CAN_RUN

    The following resources are often used in the same context:

    * databricks.Alert to manage Databricks SQL Alerts. * databricks.SqlEndpoint to manage Databricks SQL Endpoints. * databricks.Directory to manage directories in Databricks Workpace.

    Create Query Resource

    Resources are created with functions called constructors. To learn more about declaring and configuring resources, see Resources.

    Constructor syntax

    new Query(name: string, args: QueryArgs, opts?: CustomResourceOptions);
    @overload
def Query(resource_name: str,
          args: QueryArgs,
          opts: Optional[ResourceOptions] = None)

@overload
def Query(resource_name: str,
          opts: Optional[ResourceOptions] = None,
          display_name: Optional[str] = None,
          warehouse_id: Optional[str] = None,
          query_text: Optional[str] = None,
          parent_path: Optional[str] = None,
          owner_user_name: Optional[str] = None,
          parameters: Optional[Sequence[QueryParameterArgs]] = None,
          apply_auto_limit: Optional[bool] = None,
          provider_config: Optional[QueryProviderConfigArgs] = None,
          description: Optional[str] = None,
          run_as_mode: Optional[str] = None,
          schema: Optional[str] = None,
          tags: Optional[Sequence[str]] = None,
          catalog: Optional[str] = None)
    func NewQuery(ctx *Context, name string, args QueryArgs, opts ...ResourceOption) (*Query, error)
    public Query(string name, QueryArgs args, CustomResourceOptions? opts = null)
    public Query(String name, QueryArgs args)
public Query(String name, QueryArgs args, CustomResourceOptions options)

    type: databricks:Query
properties: # The arguments to resource properties.
options: # Bag of options to control resource's behavior.

    Parameters

    name string
    The unique name of the resource.
    args QueryArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    resource_name str
    The unique name of the resource.
    args QueryArgs
    The arguments to resource properties.
    opts ResourceOptions
    Bag of options to control resource's behavior.
    ctx Context
    Context object for the current deployment.
    name string
    The unique name of the resource.
    args QueryArgs
    The arguments to resource properties.
    opts ResourceOption
    Bag of options to control resource's behavior.
    name string
    The unique name of the resource.
    args QueryArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    name String
    The unique name of the resource.
    args QueryArgs
    The arguments to resource properties.
    options CustomResourceOptions
    Bag of options to control resource's behavior.

    Constructor example

    The following reference example uses placeholder values for all input properties.

    var queryResource = new Databricks.Query("queryResource", new()
{
    DisplayName = "string",
    WarehouseId = "string",
    QueryText = "string",
    ParentPath = "string",
    OwnerUserName = "string",
    Parameters = new[]
    {
        new Databricks.Inputs.QueryParameterArgs
        {
            Name = "string",
            DateRangeValue = new Databricks.Inputs.QueryParameterDateRangeValueArgs
            {
                DateRangeValue = new Databricks.Inputs.QueryParameterDateRangeValueDateRangeValueArgs
                {
                    End = "string",
                    Start = "string",
                },
                DynamicDateRangeValue = "string",
                Precision = "string",
                StartDayOfWeek = 0,
            },
            DateValue = new Databricks.Inputs.QueryParameterDateValueArgs
            {
                DateValue = "string",
                DynamicDateValue = "string",
                Precision = "string",
            },
            EnumValue = new Databricks.Inputs.QueryParameterEnumValueArgs
            {
                EnumOptions = "string",
                MultiValuesOptions = new Databricks.Inputs.QueryParameterEnumValueMultiValuesOptionsArgs
                {
                    Prefix = "string",
                    Separator = "string",
                    Suffix = "string",
                },
                Values = new[]
                {
                    "string",
                },
            },
            NumericValue = new Databricks.Inputs.QueryParameterNumericValueArgs
            {
                Value = 0,
            },
            QueryBackedValue = new Databricks.Inputs.QueryParameterQueryBackedValueArgs
            {
                QueryId = "string",
                MultiValuesOptions = new Databricks.Inputs.QueryParameterQueryBackedValueMultiValuesOptionsArgs
                {
                    Prefix = "string",
                    Separator = "string",
                    Suffix = "string",
                },
                Values = new[]
                {
                    "string",
                },
            },
            TextValue = new Databricks.Inputs.QueryParameterTextValueArgs
            {
                Value = "string",
            },
            Title = "string",
        },
    },
    ApplyAutoLimit = false,
    ProviderConfig = new Databricks.Inputs.QueryProviderConfigArgs
    {
        WorkspaceId = "string",
    },
    Description = "string",
    RunAsMode = "string",
    Schema = "string",
    Tags = new[]
    {
        "string",
    },
    Catalog = "string",
});

    example, err := databricks.NewQuery(ctx, "queryResource", &databricks.QueryArgs{
	DisplayName:   pulumi.String("string"),
	WarehouseId:   pulumi.String("string"),
	QueryText:     pulumi.String("string"),
	ParentPath:    pulumi.String("string"),
	OwnerUserName: pulumi.String("string"),
	Parameters: databricks.QueryParameterArray{
		&databricks.QueryParameterArgs{
			Name: pulumi.String("string"),
			DateRangeValue: &databricks.QueryParameterDateRangeValueArgs{
				DateRangeValue: &databricks.QueryParameterDateRangeValueDateRangeValueArgs{
					End:   pulumi.String("string"),
					Start: pulumi.String("string"),
				},
				DynamicDateRangeValue: pulumi.String("string"),
				Precision:             pulumi.String("string"),
				StartDayOfWeek:        pulumi.Int(0),
			},
			DateValue: &databricks.QueryParameterDateValueArgs{
				DateValue:        pulumi.String("string"),
				DynamicDateValue: pulumi.String("string"),
				Precision:        pulumi.String("string"),
			},
			EnumValue: &databricks.QueryParameterEnumValueArgs{
				EnumOptions: pulumi.String("string"),
				MultiValuesOptions: &databricks.QueryParameterEnumValueMultiValuesOptionsArgs{
					Prefix:    pulumi.String("string"),
					Separator: pulumi.String("string"),
					Suffix:    pulumi.String("string"),
				},
				Values: pulumi.StringArray{
					pulumi.String("string"),
				},
			},
			NumericValue: &databricks.QueryParameterNumericValueArgs{
				Value: pulumi.Float64(0),
			},
			QueryBackedValue: &databricks.QueryParameterQueryBackedValueArgs{
				QueryId: pulumi.String("string"),
				MultiValuesOptions: &databricks.QueryParameterQueryBackedValueMultiValuesOptionsArgs{
					Prefix:    pulumi.String("string"),
					Separator: pulumi.String("string"),
					Suffix:    pulumi.String("string"),
				},
				Values: pulumi.StringArray{
					pulumi.String("string"),
				},
			},
			TextValue: &databricks.QueryParameterTextValueArgs{
				Value: pulumi.String("string"),
			},
			Title: pulumi.String("string"),
		},
	},
	ApplyAutoLimit: pulumi.Bool(false),
	ProviderConfig: &databricks.QueryProviderConfigArgs{
		WorkspaceId: pulumi.String("string"),
	},
	Description: pulumi.String("string"),
	RunAsMode:   pulumi.String("string"),
	Schema:      pulumi.String("string"),
	Tags: pulumi.StringArray{
		pulumi.String("string"),
	},
	Catalog: pulumi.String("string"),
})

    var queryResource = new Query("queryResource", QueryArgs.builder()
    .displayName("string")
    .warehouseId("string")
    .queryText("string")
    .parentPath("string")
    .ownerUserName("string")
    .parameters(QueryParameterArgs.builder()
        .name("string")
        .dateRangeValue(QueryParameterDateRangeValueArgs.builder()
            .dateRangeValue(QueryParameterDateRangeValueDateRangeValueArgs.builder()
                .end("string")
                .start("string")
                .build())
            .dynamicDateRangeValue("string")
            .precision("string")
            .startDayOfWeek(0)
            .build())
        .dateValue(QueryParameterDateValueArgs.builder()
            .dateValue("string")
            .dynamicDateValue("string")
            .precision("string")
            .build())
        .enumValue(QueryParameterEnumValueArgs.builder()
            .enumOptions("string")
            .multiValuesOptions(QueryParameterEnumValueMultiValuesOptionsArgs.builder()
                .prefix("string")
                .separator("string")
                .suffix("string")
                .build())
            .values("string")
            .build())
        .numericValue(QueryParameterNumericValueArgs.builder()
            .value(0.0)
            .build())
        .queryBackedValue(QueryParameterQueryBackedValueArgs.builder()
            .queryId("string")
            .multiValuesOptions(QueryParameterQueryBackedValueMultiValuesOptionsArgs.builder()
                .prefix("string")
                .separator("string")
                .suffix("string")
                .build())
            .values("string")
            .build())
        .textValue(QueryParameterTextValueArgs.builder()
            .value("string")
            .build())
        .title("string")
        .build())
    .applyAutoLimit(false)
    .providerConfig(QueryProviderConfigArgs.builder()
        .workspaceId("string")
        .build())
    .description("string")
    .runAsMode("string")
    .schema("string")
    .tags("string")
    .catalog("string")
    .build());

    query_resource = databricks.Query("queryResource",
    display_name="string",
    warehouse_id="string",
    query_text="string",
    parent_path="string",
    owner_user_name="string",
    parameters=[{
        "name": "string",
        "date_range_value": {
            "date_range_value": {
                "end": "string",
                "start": "string",
            },
            "dynamic_date_range_value": "string",
            "precision": "string",
            "start_day_of_week": 0,
        },
        "date_value": {
            "date_value": "string",
            "dynamic_date_value": "string",
            "precision": "string",
        },
        "enum_value": {
            "enum_options": "string",
            "multi_values_options": {
                "prefix": "string",
                "separator": "string",
                "suffix": "string",
            },
            "values": ["string"],
        },
        "numeric_value": {
            "value": 0,
        },
        "query_backed_value": {
            "query_id": "string",
            "multi_values_options": {
                "prefix": "string",
                "separator": "string",
                "suffix": "string",
            },
            "values": ["string"],
        },
        "text_value": {
            "value": "string",
        },
        "title": "string",
    }],
    apply_auto_limit=False,
    provider_config={
        "workspace_id": "string",
    },
    description="string",
    run_as_mode="string",
    schema="string",
    tags=["string"],
    catalog="string")

    const queryResource = new databricks.Query("queryResource", {
    displayName: "string",
    warehouseId: "string",
    queryText: "string",
    parentPath: "string",
    ownerUserName: "string",
    parameters: [{
        name: "string",
        dateRangeValue: {
            dateRangeValue: {
                end: "string",
                start: "string",
            },
            dynamicDateRangeValue: "string",
            precision: "string",
            startDayOfWeek: 0,
        },
        dateValue: {
            dateValue: "string",
            dynamicDateValue: "string",
            precision: "string",
        },
        enumValue: {
            enumOptions: "string",
            multiValuesOptions: {
                prefix: "string",
                separator: "string",
                suffix: "string",
            },
            values: ["string"],
        },
        numericValue: {
            value: 0,
        },
        queryBackedValue: {
            queryId: "string",
            multiValuesOptions: {
                prefix: "string",
                separator: "string",
                suffix: "string",
            },
            values: ["string"],
        },
        textValue: {
            value: "string",
        },
        title: "string",
    }],
    applyAutoLimit: false,
    providerConfig: {
        workspaceId: "string",
    },
    description: "string",
    runAsMode: "string",
    schema: "string",
    tags: ["string"],
    catalog: "string",
});

    type: databricks:Query
properties:
    applyAutoLimit: false
    catalog: string
    description: string
    displayName: string
    ownerUserName: string
    parameters:
        - dateRangeValue:
            dateRangeValue:
                end: string
                start: string
            dynamicDateRangeValue: string
            precision: string
            startDayOfWeek: 0
          dateValue:
            dateValue: string
            dynamicDateValue: string
            precision: string
          enumValue:
            enumOptions: string
            multiValuesOptions:
                prefix: string
                separator: string
                suffix: string
            values:
                - string
          name: string
          numericValue:
            value: 0
          queryBackedValue:
            multiValuesOptions:
                prefix: string
                separator: string
                suffix: string
            queryId: string
            values:
                - string
          textValue:
            value: string
          title: string
    parentPath: string
    providerConfig:
        workspaceId: string
    queryText: string
    runAsMode: string
    schema: string
    tags:
        - string
    warehouseId: string

    Query Resource Properties

    To learn more about resource properties and how to use them, see Inputs and Outputs in the Architecture and Concepts docs.

    Inputs

    In Python, inputs that are objects can be passed either as argument classes or as dictionary literals.

    The Query resource accepts the following input properties:

    DisplayName string
    Name of the query.
    QueryText string
    Text of SQL query.
    WarehouseId string
    ID of a SQL warehouse which will be used to execute this query.
    ApplyAutoLimit bool
    Whether to apply a 1000 row limit to the query result.
    Catalog string
    Name of the catalog where this query will be executed.
    Description string
    General description that conveys additional information about this query such as usage notes.
    OwnerUserName string
    Query owner's username.
    Parameters List<QueryParameter>
    Query parameter definition. Consists of following attributes (one of *_value is required):
    ParentPath string
    The path to a workspace folder containing the query. The default is the user's home folder. If changed, the query will be recreated.
    ProviderConfig QueryProviderConfig
    Configure the provider for management through account provider. This block consists of the following fields:
    RunAsMode string
    Sets the "Run as" role for the object. Should be one of OWNER, VIEWER.
    Schema string
    Name of the schema where this query will be executed.
    Tags List<string>
    Tags that will be added to the query.
    DisplayName string
    Name of the query.
    QueryText string
    Text of SQL query.
    WarehouseId string
    ID of a SQL warehouse which will be used to execute this query.
    ApplyAutoLimit bool
    Whether to apply a 1000 row limit to the query result.
    Catalog string
    Name of the catalog where this query will be executed.
    Description string
    General description that conveys additional information about this query such as usage notes.
    OwnerUserName string
    Query owner's username.
    Parameters []QueryParameterArgs
    Query parameter definition. Consists of following attributes (one of *_value is required):
    ParentPath string
    The path to a workspace folder containing the query. The default is the user's home folder. If changed, the query will be recreated.
    ProviderConfig QueryProviderConfigArgs
    Configure the provider for management through account provider. This block consists of the following fields:
    RunAsMode string
    Sets the "Run as" role for the object. Should be one of OWNER, VIEWER.
    Schema string
    Name of the schema where this query will be executed.
    Tags []string
    Tags that will be added to the query.
    displayName String
    Name of the query.
    queryText String
    Text of SQL query.
    warehouseId String
    ID of a SQL warehouse which will be used to execute this query.
    applyAutoLimit Boolean
    Whether to apply a 1000 row limit to the query result.
    catalog String
    Name of the catalog where this query will be executed.
    description String
    General description that conveys additional information about this query such as usage notes.
    ownerUserName String
    Query owner's username.
    parameters List<QueryParameter>
    Query parameter definition. Consists of following attributes (one of *_value is required):
    parentPath String
    The path to a workspace folder containing the query. The default is the user's home folder. If changed, the query will be recreated.
    providerConfig QueryProviderConfig
    Configure the provider for management through account provider. This block consists of the following fields:
    runAsMode String
    Sets the "Run as" role for the object. Should be one of OWNER, VIEWER.
    schema String
    Name of the schema where this query will be executed.
    tags List<String>
    Tags that will be added to the query.
    displayName string
    Name of the query.
    queryText string
    Text of SQL query.
    warehouseId string
    ID of a SQL warehouse which will be used to execute this query.
    applyAutoLimit boolean
    Whether to apply a 1000 row limit to the query result.
    catalog string
    Name of the catalog where this query will be executed.
    description string
    General description that conveys additional information about this query such as usage notes.
    ownerUserName string
    Query owner's username.
    parameters QueryParameter[]
    Query parameter definition. Consists of following attributes (one of *_value is required):
    parentPath string
    The path to a workspace folder containing the query. The default is the user's home folder. If changed, the query will be recreated.
    providerConfig QueryProviderConfig
    Configure the provider for management through account provider. This block consists of the following fields:
    runAsMode string
    Sets the "Run as" role for the object. Should be one of OWNER, VIEWER.
    schema string
    Name of the schema where this query will be executed.
    tags string[]
    Tags that will be added to the query.
    display_name str
    Name of the query.
    query_text str
    Text of SQL query.
    warehouse_id str
    ID of a SQL warehouse which will be used to execute this query.
    apply_auto_limit bool
    Whether to apply a 1000 row limit to the query result.
    catalog str
    Name of the catalog where this query will be executed.
    description str
    General description that conveys additional information about this query such as usage notes.
    owner_user_name str
    Query owner's username.
    parameters Sequence[QueryParameterArgs]
    Query parameter definition. Consists of following attributes (one of *_value is required):
    parent_path str
    The path to a workspace folder containing the query. The default is the user's home folder. If changed, the query will be recreated.
    provider_config QueryProviderConfigArgs
    Configure the provider for management through account provider. This block consists of the following fields:
    run_as_mode str
    Sets the "Run as" role for the object. Should be one of OWNER, VIEWER.
    schema str
    Name of the schema where this query will be executed.
    tags Sequence[str]
    Tags that will be added to the query.
    displayName String
    Name of the query.
    queryText String
    Text of SQL query.
    warehouseId String
    ID of a SQL warehouse which will be used to execute this query.
    applyAutoLimit Boolean
    Whether to apply a 1000 row limit to the query result.
    catalog String
    Name of the catalog where this query will be executed.
    description String
    General description that conveys additional information about this query such as usage notes.
    ownerUserName String
    Query owner's username.
    parameters List<Property Map>
    Query parameter definition. Consists of following attributes (one of *_value is required):
    parentPath String
    The path to a workspace folder containing the query. The default is the user's home folder. If changed, the query will be recreated.
    providerConfig Property Map
    Configure the provider for management through account provider. This block consists of the following fields:
    runAsMode String
    Sets the "Run as" role for the object. Should be one of OWNER, VIEWER.
    schema String
    Name of the schema where this query will be executed.
    tags List<String>
    Tags that will be added to the query.

    Outputs

    All input properties are implicitly available as output properties. Additionally, the Query resource produces the following output properties:

    CreateTime string
    The timestamp string indicating when the query was created.
    Id string
    The provider-assigned unique ID for this managed resource.
    LastModifierUserName string
    Username of the user who last saved changes to this query.
    LifecycleState string
    The workspace state of the query. Used for tracking trashed status. (Possible values are ACTIVE or TRASHED).
    UpdateTime string
    The timestamp string indicating when the query was updated.
    CreateTime string
    The timestamp string indicating when the query was created.
    Id string
    The provider-assigned unique ID for this managed resource.
    LastModifierUserName string
    Username of the user who last saved changes to this query.
    LifecycleState string
    The workspace state of the query. Used for tracking trashed status. (Possible values are ACTIVE or TRASHED).
    UpdateTime string
    The timestamp string indicating when the query was updated.
    createTime String
    The timestamp string indicating when the query was created.
    id String
    The provider-assigned unique ID for this managed resource.
    lastModifierUserName String
    Username of the user who last saved changes to this query.
    lifecycleState String
    The workspace state of the query. Used for tracking trashed status. (Possible values are ACTIVE or TRASHED).
    updateTime String
    The timestamp string indicating when the query was updated.
    createTime string
    The timestamp string indicating when the query was created.
    id string
    The provider-assigned unique ID for this managed resource.
    lastModifierUserName string
    Username of the user who last saved changes to this query.
    lifecycleState string
    The workspace state of the query. Used for tracking trashed status. (Possible values are ACTIVE or TRASHED).
    updateTime string
    The timestamp string indicating when the query was updated.
    create_time str
    The timestamp string indicating when the query was created.
    id str
    The provider-assigned unique ID for this managed resource.
    last_modifier_user_name str
    Username of the user who last saved changes to this query.
    lifecycle_state str
    The workspace state of the query. Used for tracking trashed status. (Possible values are ACTIVE or TRASHED).
    update_time str
    The timestamp string indicating when the query was updated.
    createTime String
    The timestamp string indicating when the query was created.
    id String
    The provider-assigned unique ID for this managed resource.
    lastModifierUserName String
    Username of the user who last saved changes to this query.
    lifecycleState String
    The workspace state of the query. Used for tracking trashed status. (Possible values are ACTIVE or TRASHED).
    updateTime String
    The timestamp string indicating when the query was updated.

    Look up Existing Query Resource

    Get an existing Query resource’s state with the given name, ID, and optional extra properties used to qualify the lookup.

    public static get(name: string, id: Input<ID>, state?: QueryState, opts?: CustomResourceOptions): Query
    @staticmethod
def get(resource_name: str,
        id: str,
        opts: Optional[ResourceOptions] = None,
        apply_auto_limit: Optional[bool] = None,
        catalog: Optional[str] = None,
        create_time: Optional[str] = None,
        description: Optional[str] = None,
        display_name: Optional[str] = None,
        last_modifier_user_name: Optional[str] = None,
        lifecycle_state: Optional[str] = None,
        owner_user_name: Optional[str] = None,
        parameters: Optional[Sequence[QueryParameterArgs]] = None,
        parent_path: Optional[str] = None,
        provider_config: Optional[QueryProviderConfigArgs] = None,
        query_text: Optional[str] = None,
        run_as_mode: Optional[str] = None,
        schema: Optional[str] = None,
        tags: Optional[Sequence[str]] = None,
        update_time: Optional[str] = None,
        warehouse_id: Optional[str] = None) -> Query
    func GetQuery(ctx *Context, name string, id IDInput, state *QueryState, opts ...ResourceOption) (*Query, error)
    public static Query Get(string name, Input<string> id, QueryState? state, CustomResourceOptions? opts = null)
    public static Query get(String name, Output<String> id, QueryState state, CustomResourceOptions options)
    resources:  _:    type: databricks:Query    get:      id: ${id}
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    resource_name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    The following state arguments are supported:
    ApplyAutoLimit bool
    Whether to apply a 1000 row limit to the query result.
    Catalog string
    Name of the catalog where this query will be executed.
    CreateTime string
    The timestamp string indicating when the query was created.
    Description string
    General description that conveys additional information about this query such as usage notes.
    DisplayName string
    Name of the query.
    LastModifierUserName string
    Username of the user who last saved changes to this query.
    LifecycleState string
    The workspace state of the query. Used for tracking trashed status. (Possible values are ACTIVE or TRASHED).
    OwnerUserName string
    Query owner's username.
    Parameters List<QueryParameter>
    Query parameter definition. Consists of following attributes (one of *_value is required):
    ParentPath string
    The path to a workspace folder containing the query. The default is the user's home folder. If changed, the query will be recreated.
    ProviderConfig QueryProviderConfig
    Configure the provider for management through account provider. This block consists of the following fields:
    QueryText string
    Text of SQL query.
    RunAsMode string
    Sets the "Run as" role for the object. Should be one of OWNER, VIEWER.
    Schema string
    Name of the schema where this query will be executed.
    Tags List<string>
    Tags that will be added to the query.
    UpdateTime string
    The timestamp string indicating when the query was updated.
    WarehouseId string
    ID of a SQL warehouse which will be used to execute this query.
    ApplyAutoLimit bool
    Whether to apply a 1000 row limit to the query result.
    Catalog string
    Name of the catalog where this query will be executed.
    CreateTime string
    The timestamp string indicating when the query was created.
    Description string
    General description that conveys additional information about this query such as usage notes.
    DisplayName string
    Name of the query.
    LastModifierUserName string
    Username of the user who last saved changes to this query.
    LifecycleState string
    The workspace state of the query. Used for tracking trashed status. (Possible values are ACTIVE or TRASHED).
    OwnerUserName string
    Query owner's username.
    Parameters []QueryParameterArgs
    Query parameter definition. Consists of following attributes (one of *_value is required):
    ParentPath string
    The path to a workspace folder containing the query. The default is the user's home folder. If changed, the query will be recreated.
    ProviderConfig QueryProviderConfigArgs
    Configure the provider for management through account provider. This block consists of the following fields:
    QueryText string
    Text of SQL query.
    RunAsMode string
    Sets the "Run as" role for the object. Should be one of OWNER, VIEWER.
    Schema string
    Name of the schema where this query will be executed.
    Tags []string
    Tags that will be added to the query.
    UpdateTime string
    The timestamp string indicating when the query was updated.
    WarehouseId string
    ID of a SQL warehouse which will be used to execute this query.
    applyAutoLimit Boolean
    Whether to apply a 1000 row limit to the query result.
    catalog String
    Name of the catalog where this query will be executed.
    createTime String
    The timestamp string indicating when the query was created.
    description String
    General description that conveys additional information about this query such as usage notes.
    displayName String
    Name of the query.
    lastModifierUserName String
    Username of the user who last saved changes to this query.
    lifecycleState String
    The workspace state of the query. Used for tracking trashed status. (Possible values are ACTIVE or TRASHED).
    ownerUserName String
    Query owner's username.
    parameters List<QueryParameter>
    Query parameter definition. Consists of following attributes (one of *_value is required):
    parentPath String
    The path to a workspace folder containing the query. The default is the user's home folder. If changed, the query will be recreated.
    providerConfig QueryProviderConfig
    Configure the provider for management through account provider. This block consists of the following fields:
    queryText String
    Text of SQL query.
    runAsMode String
    Sets the "Run as" role for the object. Should be one of OWNER, VIEWER.
    schema String
    Name of the schema where this query will be executed.
    tags List<String>
    Tags that will be added to the query.
    updateTime String
    The timestamp string indicating when the query was updated.
    warehouseId String
    ID of a SQL warehouse which will be used to execute this query.
    applyAutoLimit boolean
    Whether to apply a 1000 row limit to the query result.
    catalog string
    Name of the catalog where this query will be executed.
    createTime string
    The timestamp string indicating when the query was created.
    description string
    General description that conveys additional information about this query such as usage notes.
    displayName string
    Name of the query.
    lastModifierUserName string
    Username of the user who last saved changes to this query.
    lifecycleState string
    The workspace state of the query. Used for tracking trashed status. (Possible values are ACTIVE or TRASHED).
    ownerUserName string
    Query owner's username.
    parameters QueryParameter[]
    Query parameter definition. Consists of following attributes (one of *_value is required):
    parentPath string
    The path to a workspace folder containing the query. The default is the user's home folder. If changed, the query will be recreated.
    providerConfig QueryProviderConfig
    Configure the provider for management through account provider. This block consists of the following fields:
    queryText string
    Text of SQL query.
    runAsMode string
    Sets the "Run as" role for the object. Should be one of OWNER, VIEWER.
    schema string
    Name of the schema where this query will be executed.
    tags string[]
    Tags that will be added to the query.
    updateTime string
    The timestamp string indicating when the query was updated.
    warehouseId string
    ID of a SQL warehouse which will be used to execute this query.
    apply_auto_limit bool
    Whether to apply a 1000 row limit to the query result.
    catalog str
    Name of the catalog where this query will be executed.
    create_time str
    The timestamp string indicating when the query was created.
    description str
    General description that conveys additional information about this query such as usage notes.
    display_name str
    Name of the query.
    last_modifier_user_name str
    Username of the user who last saved changes to this query.
    lifecycle_state str
    The workspace state of the query. Used for tracking trashed status. (Possible values are ACTIVE or TRASHED).
    owner_user_name str
    Query owner's username.
    parameters Sequence[QueryParameterArgs]
    Query parameter definition. Consists of following attributes (one of *_value is required):
    parent_path str
    The path to a workspace folder containing the query. The default is the user's home folder. If changed, the query will be recreated.
    provider_config QueryProviderConfigArgs
    Configure the provider for management through account provider. This block consists of the following fields:
    query_text str
    Text of SQL query.
    run_as_mode str
    Sets the "Run as" role for the object. Should be one of OWNER, VIEWER.
    schema str
    Name of the schema where this query will be executed.
    tags Sequence[str]
    Tags that will be added to the query.
    update_time str
    The timestamp string indicating when the query was updated.
    warehouse_id str
    ID of a SQL warehouse which will be used to execute this query.
    applyAutoLimit Boolean
    Whether to apply a 1000 row limit to the query result.
    catalog String
    Name of the catalog where this query will be executed.
    createTime String
    The timestamp string indicating when the query was created.
    description String
    General description that conveys additional information about this query such as usage notes.
    displayName String
    Name of the query.
    lastModifierUserName String
    Username of the user who last saved changes to this query.
    lifecycleState String
    The workspace state of the query. Used for tracking trashed status. (Possible values are ACTIVE or TRASHED).
    ownerUserName String
    Query owner's username.
    parameters List<Property Map>
    Query parameter definition. Consists of following attributes (one of *_value is required):
    parentPath String
    The path to a workspace folder containing the query. The default is the user's home folder. If changed, the query will be recreated.
    providerConfig Property Map
    Configure the provider for management through account provider. This block consists of the following fields:
    queryText String
    Text of SQL query.
    runAsMode String
    Sets the "Run as" role for the object. Should be one of OWNER, VIEWER.
    schema String
    Name of the schema where this query will be executed.
    tags List<String>
    Tags that will be added to the query.
    updateTime String
    The timestamp string indicating when the query was updated.
    warehouseId String
    ID of a SQL warehouse which will be used to execute this query.

    Supporting Types

    QueryParameter, QueryParameterArgs

    Name string
    Literal parameter marker that appears between double curly braces in the query text.
    DateRangeValue QueryParameterDateRangeValue
    Date-range query parameter value. Consists of following attributes (Can only specify one of dynamic_date_range_value or date_range_value):
    DateValue QueryParameterDateValue
    Date query parameter value. Consists of following attributes (Can only specify one of dynamic_date_value or date_value):
    EnumValue QueryParameterEnumValue
    Dropdown parameter value. Consists of following attributes:
    NumericValue QueryParameterNumericValue
    Numeric parameter value. Consists of following attributes:
    QueryBackedValue QueryParameterQueryBackedValue
    Query-based dropdown parameter value. Consists of following attributes:
    TextValue QueryParameterTextValue
    Text parameter value. Consists of following attributes:
    Title string
    Text displayed in the user-facing parameter widget in the UI.
    Name string
    Literal parameter marker that appears between double curly braces in the query text.
    DateRangeValue QueryParameterDateRangeValue
    Date-range query parameter value. Consists of following attributes (Can only specify one of dynamic_date_range_value or date_range_value):
    DateValue QueryParameterDateValue
    Date query parameter value. Consists of following attributes (Can only specify one of dynamic_date_value or date_value):
    EnumValue QueryParameterEnumValue
    Dropdown parameter value. Consists of following attributes:
    NumericValue QueryParameterNumericValue
    Numeric parameter value. Consists of following attributes:
    QueryBackedValue QueryParameterQueryBackedValue
    Query-based dropdown parameter value. Consists of following attributes:
    TextValue QueryParameterTextValue
    Text parameter value. Consists of following attributes:
    Title string
    Text displayed in the user-facing parameter widget in the UI.
    name String
    Literal parameter marker that appears between double curly braces in the query text.
    dateRangeValue QueryParameterDateRangeValue
    Date-range query parameter value. Consists of following attributes (Can only specify one of dynamic_date_range_value or date_range_value):
    dateValue QueryParameterDateValue
    Date query parameter value. Consists of following attributes (Can only specify one of dynamic_date_value or date_value):
    enumValue QueryParameterEnumValue
    Dropdown parameter value. Consists of following attributes:
    numericValue QueryParameterNumericValue
    Numeric parameter value. Consists of following attributes:
    queryBackedValue QueryParameterQueryBackedValue
    Query-based dropdown parameter value. Consists of following attributes:
    textValue QueryParameterTextValue
    Text parameter value. Consists of following attributes:
    title String
    Text displayed in the user-facing parameter widget in the UI.
    name string
    Literal parameter marker that appears between double curly braces in the query text.
    dateRangeValue QueryParameterDateRangeValue
    Date-range query parameter value. Consists of following attributes (Can only specify one of dynamic_date_range_value or date_range_value):
    dateValue QueryParameterDateValue
    Date query parameter value. Consists of following attributes (Can only specify one of dynamic_date_value or date_value):
    enumValue QueryParameterEnumValue
    Dropdown parameter value. Consists of following attributes:
    numericValue QueryParameterNumericValue
    Numeric parameter value. Consists of following attributes:
    queryBackedValue QueryParameterQueryBackedValue
    Query-based dropdown parameter value. Consists of following attributes:
    textValue QueryParameterTextValue
    Text parameter value. Consists of following attributes:
    title string
    Text displayed in the user-facing parameter widget in the UI.
    name str
    Literal parameter marker that appears between double curly braces in the query text.
    date_range_value QueryParameterDateRangeValue
    Date-range query parameter value. Consists of following attributes (Can only specify one of dynamic_date_range_value or date_range_value):
    date_value QueryParameterDateValue
    Date query parameter value. Consists of following attributes (Can only specify one of dynamic_date_value or date_value):
    enum_value QueryParameterEnumValue
    Dropdown parameter value. Consists of following attributes:
    numeric_value QueryParameterNumericValue
    Numeric parameter value. Consists of following attributes:
    query_backed_value QueryParameterQueryBackedValue
    Query-based dropdown parameter value. Consists of following attributes:
    text_value QueryParameterTextValue
    Text parameter value. Consists of following attributes:
    title str
    Text displayed in the user-facing parameter widget in the UI.
    name String
    Literal parameter marker that appears between double curly braces in the query text.
    dateRangeValue Property Map
    Date-range query parameter value. Consists of following attributes (Can only specify one of dynamic_date_range_value or date_range_value):
    dateValue Property Map
    Date query parameter value. Consists of following attributes (Can only specify one of dynamic_date_value or date_value):
    enumValue Property Map
    Dropdown parameter value. Consists of following attributes:
    numericValue Property Map
    Numeric parameter value. Consists of following attributes:
    queryBackedValue Property Map
    Query-based dropdown parameter value. Consists of following attributes:
    textValue Property Map
    Text parameter value. Consists of following attributes:
    title String
    Text displayed in the user-facing parameter widget in the UI.

    QueryParameterDateRangeValue, QueryParameterDateRangeValueArgs

    DateRangeValue QueryParameterDateRangeValueDateRangeValue
    Manually specified date-time range value. Consists of the following attributes:
    DynamicDateRangeValue string
    Dynamic date-time range value based on current date-time. Possible values are TODAY, YESTERDAY, THIS_WEEK, THIS_MONTH, THIS_YEAR, LAST_WEEK, LAST_MONTH, LAST_YEAR, LAST_HOUR, LAST_8_HOURS, LAST_24_HOURS, LAST_7_DAYS, LAST_14_DAYS, LAST_30_DAYS, LAST_60_DAYS, LAST_90_DAYS, LAST_12_MONTHS.
    Precision string
    Date-time precision to format the value into when the query is run. Possible values are DAY_PRECISION, MINUTE_PRECISION, SECOND_PRECISION. Defaults to DAY_PRECISION (YYYY-MM-DD).
    StartDayOfWeek int
    Specify what day that starts the week.
    DateRangeValue QueryParameterDateRangeValueDateRangeValue
    Manually specified date-time range value. Consists of the following attributes:
    DynamicDateRangeValue string
    Dynamic date-time range value based on current date-time. Possible values are TODAY, YESTERDAY, THIS_WEEK, THIS_MONTH, THIS_YEAR, LAST_WEEK, LAST_MONTH, LAST_YEAR, LAST_HOUR, LAST_8_HOURS, LAST_24_HOURS, LAST_7_DAYS, LAST_14_DAYS, LAST_30_DAYS, LAST_60_DAYS, LAST_90_DAYS, LAST_12_MONTHS.
    Precision string
    Date-time precision to format the value into when the query is run. Possible values are DAY_PRECISION, MINUTE_PRECISION, SECOND_PRECISION. Defaults to DAY_PRECISION (YYYY-MM-DD).
    StartDayOfWeek int
    Specify what day that starts the week.
    dateRangeValue QueryParameterDateRangeValueDateRangeValue
    Manually specified date-time range value. Consists of the following attributes:
    dynamicDateRangeValue String
    Dynamic date-time range value based on current date-time. Possible values are TODAY, YESTERDAY, THIS_WEEK, THIS_MONTH, THIS_YEAR, LAST_WEEK, LAST_MONTH, LAST_YEAR, LAST_HOUR, LAST_8_HOURS, LAST_24_HOURS, LAST_7_DAYS, LAST_14_DAYS, LAST_30_DAYS, LAST_60_DAYS, LAST_90_DAYS, LAST_12_MONTHS.
    precision String
    Date-time precision to format the value into when the query is run. Possible values are DAY_PRECISION, MINUTE_PRECISION, SECOND_PRECISION. Defaults to DAY_PRECISION (YYYY-MM-DD).
    startDayOfWeek Integer
    Specify what day that starts the week.
    dateRangeValue QueryParameterDateRangeValueDateRangeValue
    Manually specified date-time range value. Consists of the following attributes:
    dynamicDateRangeValue string
    Dynamic date-time range value based on current date-time. Possible values are TODAY, YESTERDAY, THIS_WEEK, THIS_MONTH, THIS_YEAR, LAST_WEEK, LAST_MONTH, LAST_YEAR, LAST_HOUR, LAST_8_HOURS, LAST_24_HOURS, LAST_7_DAYS, LAST_14_DAYS, LAST_30_DAYS, LAST_60_DAYS, LAST_90_DAYS, LAST_12_MONTHS.
    precision string
    Date-time precision to format the value into when the query is run. Possible values are DAY_PRECISION, MINUTE_PRECISION, SECOND_PRECISION. Defaults to DAY_PRECISION (YYYY-MM-DD).
    startDayOfWeek number
    Specify what day that starts the week.
    date_range_value QueryParameterDateRangeValueDateRangeValue
    Manually specified date-time range value. Consists of the following attributes:
    dynamic_date_range_value str
    Dynamic date-time range value based on current date-time. Possible values are TODAY, YESTERDAY, THIS_WEEK, THIS_MONTH, THIS_YEAR, LAST_WEEK, LAST_MONTH, LAST_YEAR, LAST_HOUR, LAST_8_HOURS, LAST_24_HOURS, LAST_7_DAYS, LAST_14_DAYS, LAST_30_DAYS, LAST_60_DAYS, LAST_90_DAYS, LAST_12_MONTHS.
    precision str
    Date-time precision to format the value into when the query is run. Possible values are DAY_PRECISION, MINUTE_PRECISION, SECOND_PRECISION. Defaults to DAY_PRECISION (YYYY-MM-DD).
    start_day_of_week int
    Specify what day that starts the week.
    dateRangeValue Property Map
    Manually specified date-time range value. Consists of the following attributes:
    dynamicDateRangeValue String
    Dynamic date-time range value based on current date-time. Possible values are TODAY, YESTERDAY, THIS_WEEK, THIS_MONTH, THIS_YEAR, LAST_WEEK, LAST_MONTH, LAST_YEAR, LAST_HOUR, LAST_8_HOURS, LAST_24_HOURS, LAST_7_DAYS, LAST_14_DAYS, LAST_30_DAYS, LAST_60_DAYS, LAST_90_DAYS, LAST_12_MONTHS.
    precision String
    Date-time precision to format the value into when the query is run. Possible values are DAY_PRECISION, MINUTE_PRECISION, SECOND_PRECISION. Defaults to DAY_PRECISION (YYYY-MM-DD).
    startDayOfWeek Number
    Specify what day that starts the week.

    QueryParameterDateRangeValueDateRangeValue, QueryParameterDateRangeValueDateRangeValueArgs

    End string
    end of the date range.
    Start string
    begin of the date range.
    End string
    end of the date range.
    Start string
    begin of the date range.
    end String
    end of the date range.
    start String
    begin of the date range.
    end string
    end of the date range.
    start string
    begin of the date range.
    end str
    end of the date range.
    start str
    begin of the date range.
    end String
    end of the date range.
    start String
    begin of the date range.

    QueryParameterDateValue, QueryParameterDateValueArgs

    DateValue string
    Manually specified date-time value
    DynamicDateValue string
    Dynamic date-time value based on current date-time. Possible values are NOW, YESTERDAY.
    Precision string
    Date-time precision to format the value into when the query is run. Possible values are DAY_PRECISION, MINUTE_PRECISION, SECOND_PRECISION. Defaults to DAY_PRECISION (YYYY-MM-DD).
    DateValue string
    Manually specified date-time value
    DynamicDateValue string
    Dynamic date-time value based on current date-time. Possible values are NOW, YESTERDAY.
    Precision string
    Date-time precision to format the value into when the query is run. Possible values are DAY_PRECISION, MINUTE_PRECISION, SECOND_PRECISION. Defaults to DAY_PRECISION (YYYY-MM-DD).
    dateValue String
    Manually specified date-time value
    dynamicDateValue String
    Dynamic date-time value based on current date-time. Possible values are NOW, YESTERDAY.
    precision String
    Date-time precision to format the value into when the query is run. Possible values are DAY_PRECISION, MINUTE_PRECISION, SECOND_PRECISION. Defaults to DAY_PRECISION (YYYY-MM-DD).
    dateValue string
    Manually specified date-time value
    dynamicDateValue string
    Dynamic date-time value based on current date-time. Possible values are NOW, YESTERDAY.
    precision string
    Date-time precision to format the value into when the query is run. Possible values are DAY_PRECISION, MINUTE_PRECISION, SECOND_PRECISION. Defaults to DAY_PRECISION (YYYY-MM-DD).
    date_value str
    Manually specified date-time value
    dynamic_date_value str
    Dynamic date-time value based on current date-time. Possible values are NOW, YESTERDAY.
    precision str
    Date-time precision to format the value into when the query is run. Possible values are DAY_PRECISION, MINUTE_PRECISION, SECOND_PRECISION. Defaults to DAY_PRECISION (YYYY-MM-DD).
    dateValue String
    Manually specified date-time value
    dynamicDateValue String
    Dynamic date-time value based on current date-time. Possible values are NOW, YESTERDAY.
    precision String
    Date-time precision to format the value into when the query is run. Possible values are DAY_PRECISION, MINUTE_PRECISION, SECOND_PRECISION. Defaults to DAY_PRECISION (YYYY-MM-DD).

    QueryParameterEnumValue, QueryParameterEnumValueArgs

    EnumOptions string
    List of valid query parameter values, newline delimited.
    MultiValuesOptions QueryParameterEnumValueMultiValuesOptions
    If specified, allows multiple values to be selected for this parameter. Consists of following attributes:
    Values List<string>
    List of selected query parameter values.
    EnumOptions string
    List of valid query parameter values, newline delimited.
    MultiValuesOptions QueryParameterEnumValueMultiValuesOptions
    If specified, allows multiple values to be selected for this parameter. Consists of following attributes:
    Values []string
    List of selected query parameter values.
    enumOptions String
    List of valid query parameter values, newline delimited.
    multiValuesOptions QueryParameterEnumValueMultiValuesOptions
    If specified, allows multiple values to be selected for this parameter. Consists of following attributes:
    values List<String>
    List of selected query parameter values.
    enumOptions string
    List of valid query parameter values, newline delimited.
    multiValuesOptions QueryParameterEnumValueMultiValuesOptions
    If specified, allows multiple values to be selected for this parameter. Consists of following attributes:
    values string[]
    List of selected query parameter values.
    enum_options str
    List of valid query parameter values, newline delimited.
    multi_values_options QueryParameterEnumValueMultiValuesOptions
    If specified, allows multiple values to be selected for this parameter. Consists of following attributes:
    values Sequence[str]
    List of selected query parameter values.
    enumOptions String
    List of valid query parameter values, newline delimited.
    multiValuesOptions Property Map
    If specified, allows multiple values to be selected for this parameter. Consists of following attributes:
    values List<String>
    List of selected query parameter values.

    QueryParameterEnumValueMultiValuesOptions, QueryParameterEnumValueMultiValuesOptionsArgs

    Prefix string
    Character that prefixes each selected parameter value.
    Separator string
    Character that separates each selected parameter value. Defaults to a comma.
    Suffix string
    Character that suffixes each selected parameter value.
    Prefix string
    Character that prefixes each selected parameter value.
    Separator string
    Character that separates each selected parameter value. Defaults to a comma.
    Suffix string
    Character that suffixes each selected parameter value.
    prefix String
    Character that prefixes each selected parameter value.
    separator String
    Character that separates each selected parameter value. Defaults to a comma.
    suffix String
    Character that suffixes each selected parameter value.
    prefix string
    Character that prefixes each selected parameter value.
    separator string
    Character that separates each selected parameter value. Defaults to a comma.
    suffix string
    Character that suffixes each selected parameter value.
    prefix str
    Character that prefixes each selected parameter value.
    separator str
    Character that separates each selected parameter value. Defaults to a comma.
    suffix str
    Character that suffixes each selected parameter value.
    prefix String
    Character that prefixes each selected parameter value.
    separator String
    Character that separates each selected parameter value. Defaults to a comma.
    suffix String
    Character that suffixes each selected parameter value.

    QueryParameterNumericValue, QueryParameterNumericValueArgs

    Value double
    actual numeric value.
    Value float64
    actual numeric value.
    value Double
    actual numeric value.
    value number
    actual numeric value.
    value float
    actual numeric value.
    value Number
    actual numeric value.

    QueryParameterQueryBackedValue, QueryParameterQueryBackedValueArgs

    QueryId string
    ID of the query that provides the parameter values.
    MultiValuesOptions QueryParameterQueryBackedValueMultiValuesOptions
    If specified, allows multiple values to be selected for this parameter. Consists of following attributes:
    Values List<string>
    List of selected query parameter values.
    QueryId string
    ID of the query that provides the parameter values.
    MultiValuesOptions QueryParameterQueryBackedValueMultiValuesOptions
    If specified, allows multiple values to be selected for this parameter. Consists of following attributes:
    Values []string
    List of selected query parameter values.
    queryId String
    ID of the query that provides the parameter values.
    multiValuesOptions QueryParameterQueryBackedValueMultiValuesOptions
    If specified, allows multiple values to be selected for this parameter. Consists of following attributes:
    values List<String>
    List of selected query parameter values.
    queryId string
    ID of the query that provides the parameter values.
    multiValuesOptions QueryParameterQueryBackedValueMultiValuesOptions
    If specified, allows multiple values to be selected for this parameter. Consists of following attributes:
    values string[]
    List of selected query parameter values.
    query_id str
    ID of the query that provides the parameter values.
    multi_values_options QueryParameterQueryBackedValueMultiValuesOptions
    If specified, allows multiple values to be selected for this parameter. Consists of following attributes:
    values Sequence[str]
    List of selected query parameter values.
    queryId String
    ID of the query that provides the parameter values.
    multiValuesOptions Property Map
    If specified, allows multiple values to be selected for this parameter. Consists of following attributes:
    values List<String>
    List of selected query parameter values.

    QueryParameterQueryBackedValueMultiValuesOptions, QueryParameterQueryBackedValueMultiValuesOptionsArgs

    Prefix string
    Character that prefixes each selected parameter value.
    Separator string
    Character that separates each selected parameter value. Defaults to a comma.
    Suffix string
    Character that suffixes each selected parameter value.
    Prefix string
    Character that prefixes each selected parameter value.
    Separator string
    Character that separates each selected parameter value. Defaults to a comma.
    Suffix string
    Character that suffixes each selected parameter value.
    prefix String
    Character that prefixes each selected parameter value.
    separator String
    Character that separates each selected parameter value. Defaults to a comma.
    suffix String
    Character that suffixes each selected parameter value.
    prefix string
    Character that prefixes each selected parameter value.
    separator string
    Character that separates each selected parameter value. Defaults to a comma.
    suffix string
    Character that suffixes each selected parameter value.
    prefix str
    Character that prefixes each selected parameter value.
    separator str
    Character that separates each selected parameter value. Defaults to a comma.
    suffix str
    Character that suffixes each selected parameter value.
    prefix String
    Character that prefixes each selected parameter value.
    separator String
    Character that separates each selected parameter value. Defaults to a comma.
    suffix String
    Character that suffixes each selected parameter value.

    QueryParameterTextValue, QueryParameterTextValueArgs

    Value string
    actual text value.
    Value string
    actual text value.
    value String
    actual text value.
    value string
    actual text value.
    value str
    actual text value.
    value String
    actual text value.

    QueryProviderConfig, QueryProviderConfigArgs

    WorkspaceId string
    Workspace ID which the resource belongs to. This workspace must be part of the account which the provider is configured with.
    WorkspaceId string
    Workspace ID which the resource belongs to. This workspace must be part of the account which the provider is configured with.
    workspaceId String
    Workspace ID which the resource belongs to. This workspace must be part of the account which the provider is configured with.
    workspaceId string
    Workspace ID which the resource belongs to. This workspace must be part of the account which the provider is configured with.
    workspace_id str
    Workspace ID which the resource belongs to. This workspace must be part of the account which the provider is configured with.
    workspaceId String
    Workspace ID which the resource belongs to. This workspace must be part of the account which the provider is configured with.

    Package Details

    Repository
    databricks pulumi/pulumi-databricks
    License
    Apache-2.0
    Notes
    This Pulumi package is based on the databricks Terraform Provider.
    databricks logo
    Viewing docs for Databricks v1.88.0
    published on Thursday, Feb 26, 2026 by Pulumi
    Schema (JSON)
    pulumi/pulumi-databricks
      Try Pulumi Cloud free. Your team will thank you.