1. Packages
  2. Databricks Provider
  3. API Docs
  4. getWarehousesDefaultWarehouseOverride
Viewing docs for Databricks v1.90.0
published on Thursday, Mar 19, 2026 by Pulumi
Schema (JSON)
pulumi/pulumi-databricks

databricks.getWarehousesDefaultWarehouseOverride

databricks logo
Viewing docs for Databricks v1.90.0
published on Thursday, Mar 19, 2026 by Pulumi
Schema (JSON)
pulumi/pulumi-databricks

    Public Beta

    The Default Warehouse Override data source allows you to retrieve information about a user’s default warehouse selection configuration in Databricks SQL.

    You can use this data source to:

    • Retrieve the current default warehouse override configuration for a user
    • Check whether a user has a custom warehouse configured or uses last-selected behavior
    • Get the warehouse ID if a custom warehouse is configured

    Note The resource name format is default-warehouse-overrides/{default_warehouse_override_id}, where default_warehouse_override_id represents a user ID.

    Example Usage

    Get a User’s Override

    This example retrieves the default warehouse override for a specific user. The name format is default-warehouse-overrides/{default_warehouse_override_id}:

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

const user = databricks.getWarehousesDefaultWarehouseOverride({
    name: `default-warehouse-overrides/${example.id}`,
});

    import pulumi
import pulumi_databricks as databricks

user = databricks.get_warehouses_default_warehouse_override(name=f"default-warehouse-overrides/{example['id']}")

    package main

import (
	"fmt"

	"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.LookupWarehousesDefaultWarehouseOverride(ctx, &databricks.LookupWarehousesDefaultWarehouseOverrideArgs{
			Name: fmt.Sprintf("default-warehouse-overrides/%v", example.Id),
		}, nil)
		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 user = Databricks.GetWarehousesDefaultWarehouseOverride.Invoke(new()
    {
        Name = $"default-warehouse-overrides/{example.Id}",
    });

});

    package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.databricks.DatabricksFunctions;
import com.pulumi.databricks.inputs.GetWarehousesDefaultWarehouseOverrideArgs;
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 user = DatabricksFunctions.getWarehousesDefaultWarehouseOverride(GetWarehousesDefaultWarehouseOverrideArgs.builder()
            .name(String.format("default-warehouse-overrides/%s", example.id()))
            .build());

    }
}

    variables:
  user:
    fn::invoke:
      function: databricks:getWarehousesDefaultWarehouseOverride
      arguments:
        name: default-warehouse-overrides/${example.id}

    Using getWarehousesDefaultWarehouseOverride

    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 getWarehousesDefaultWarehouseOverride(args: GetWarehousesDefaultWarehouseOverrideArgs, opts?: InvokeOptions): Promise<GetWarehousesDefaultWarehouseOverrideResult>
function getWarehousesDefaultWarehouseOverrideOutput(args: GetWarehousesDefaultWarehouseOverrideOutputArgs, opts?: InvokeOptions): Output<GetWarehousesDefaultWarehouseOverrideResult>
    def get_warehouses_default_warehouse_override(name: Optional[str] = None,
                                              provider_config: Optional[GetWarehousesDefaultWarehouseOverrideProviderConfig] = None,
                                              opts: Optional[InvokeOptions] = None) -> GetWarehousesDefaultWarehouseOverrideResult
def get_warehouses_default_warehouse_override_output(name: Optional[pulumi.Input[str]] = None,
                                              provider_config: Optional[pulumi.Input[GetWarehousesDefaultWarehouseOverrideProviderConfigArgs]] = None,
                                              opts: Optional[InvokeOptions] = None) -> Output[GetWarehousesDefaultWarehouseOverrideResult]
    func LookupWarehousesDefaultWarehouseOverride(ctx *Context, args *LookupWarehousesDefaultWarehouseOverrideArgs, opts ...InvokeOption) (*LookupWarehousesDefaultWarehouseOverrideResult, error)
func LookupWarehousesDefaultWarehouseOverrideOutput(ctx *Context, args *LookupWarehousesDefaultWarehouseOverrideOutputArgs, opts ...InvokeOption) LookupWarehousesDefaultWarehouseOverrideResultOutput

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

    public static class GetWarehousesDefaultWarehouseOverride 
{
    public static Task<GetWarehousesDefaultWarehouseOverrideResult> InvokeAsync(GetWarehousesDefaultWarehouseOverrideArgs args, InvokeOptions? opts = null)
    public static Output<GetWarehousesDefaultWarehouseOverrideResult> Invoke(GetWarehousesDefaultWarehouseOverrideInvokeArgs args, InvokeOptions? opts = null)
}
    public static CompletableFuture<GetWarehousesDefaultWarehouseOverrideResult> getWarehousesDefaultWarehouseOverride(GetWarehousesDefaultWarehouseOverrideArgs args, InvokeOptions options)
public static Output<GetWarehousesDefaultWarehouseOverrideResult> getWarehousesDefaultWarehouseOverride(GetWarehousesDefaultWarehouseOverrideArgs args, InvokeOptions options)

    fn::invoke:
  function: databricks:index/getWarehousesDefaultWarehouseOverride:getWarehousesDefaultWarehouseOverride
  arguments:
    # arguments dictionary

    The following arguments are supported:

    Name string
    The resource name of the default warehouse override. Format: default-warehouse-overrides/{default_warehouse_override_id}
    ProviderConfig GetWarehousesDefaultWarehouseOverrideProviderConfig
    Configure the provider for management through account provider.
    Name string
    The resource name of the default warehouse override. Format: default-warehouse-overrides/{default_warehouse_override_id}
    ProviderConfig GetWarehousesDefaultWarehouseOverrideProviderConfig
    Configure the provider for management through account provider.
    name String
    The resource name of the default warehouse override. Format: default-warehouse-overrides/{default_warehouse_override_id}
    providerConfig GetWarehousesDefaultWarehouseOverrideProviderConfig
    Configure the provider for management through account provider.
    name string
    The resource name of the default warehouse override. Format: default-warehouse-overrides/{default_warehouse_override_id}
    providerConfig GetWarehousesDefaultWarehouseOverrideProviderConfig
    Configure the provider for management through account provider.
    name str
    The resource name of the default warehouse override. Format: default-warehouse-overrides/{default_warehouse_override_id}
    provider_config GetWarehousesDefaultWarehouseOverrideProviderConfig
    Configure the provider for management through account provider.
    name String
    The resource name of the default warehouse override. Format: default-warehouse-overrides/{default_warehouse_override_id}
    providerConfig Property Map
    Configure the provider for management through account provider.

    getWarehousesDefaultWarehouseOverride Result

    The following output properties are available:

    DefaultWarehouseOverrideId string
    (string) - The ID component of the resource name (user ID)
    Id string
    The provider-assigned unique ID for this managed resource.
    Name string
    (string) - The resource name of the default warehouse override. Format: default-warehouse-overrides/{default_warehouse_override_id}
    Type string
    (string) - The type of override behavior. Possible values are: CUSTOM, LAST_SELECTED
    WarehouseId string
    (string) - The specific warehouse ID when type is CUSTOM. Not set for LAST_SELECTED type
    ProviderConfig GetWarehousesDefaultWarehouseOverrideProviderConfig
    DefaultWarehouseOverrideId string
    (string) - The ID component of the resource name (user ID)
    Id string
    The provider-assigned unique ID for this managed resource.
    Name string
    (string) - The resource name of the default warehouse override. Format: default-warehouse-overrides/{default_warehouse_override_id}
    Type string
    (string) - The type of override behavior. Possible values are: CUSTOM, LAST_SELECTED
    WarehouseId string
    (string) - The specific warehouse ID when type is CUSTOM. Not set for LAST_SELECTED type
    ProviderConfig GetWarehousesDefaultWarehouseOverrideProviderConfig
    defaultWarehouseOverrideId String
    (string) - The ID component of the resource name (user ID)
    id String
    The provider-assigned unique ID for this managed resource.
    name String
    (string) - The resource name of the default warehouse override. Format: default-warehouse-overrides/{default_warehouse_override_id}
    type String
    (string) - The type of override behavior. Possible values are: CUSTOM, LAST_SELECTED
    warehouseId String
    (string) - The specific warehouse ID when type is CUSTOM. Not set for LAST_SELECTED type
    providerConfig GetWarehousesDefaultWarehouseOverrideProviderConfig
    defaultWarehouseOverrideId string
    (string) - The ID component of the resource name (user ID)
    id string
    The provider-assigned unique ID for this managed resource.
    name string
    (string) - The resource name of the default warehouse override. Format: default-warehouse-overrides/{default_warehouse_override_id}
    type string
    (string) - The type of override behavior. Possible values are: CUSTOM, LAST_SELECTED
    warehouseId string
    (string) - The specific warehouse ID when type is CUSTOM. Not set for LAST_SELECTED type
    providerConfig GetWarehousesDefaultWarehouseOverrideProviderConfig
    default_warehouse_override_id str
    (string) - The ID component of the resource name (user ID)
    id str
    The provider-assigned unique ID for this managed resource.
    name str
    (string) - The resource name of the default warehouse override. Format: default-warehouse-overrides/{default_warehouse_override_id}
    type str
    (string) - The type of override behavior. Possible values are: CUSTOM, LAST_SELECTED
    warehouse_id str
    (string) - The specific warehouse ID when type is CUSTOM. Not set for LAST_SELECTED type
    provider_config GetWarehousesDefaultWarehouseOverrideProviderConfig
    defaultWarehouseOverrideId String
    (string) - The ID component of the resource name (user ID)
    id String
    The provider-assigned unique ID for this managed resource.
    name String
    (string) - The resource name of the default warehouse override. Format: default-warehouse-overrides/{default_warehouse_override_id}
    type String
    (string) - The type of override behavior. Possible values are: CUSTOM, LAST_SELECTED
    warehouseId String
    (string) - The specific warehouse ID when type is CUSTOM. Not set for LAST_SELECTED type
    providerConfig Property Map

    Supporting Types

    GetWarehousesDefaultWarehouseOverrideProviderConfig

    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.90.0
    published on Thursday, Mar 19, 2026 by Pulumi
    Schema (JSON)
    pulumi/pulumi-databricks
      Try Pulumi Cloud free. Your team will thank you.