1. Packages
  2. Databricks Provider
  3. API Docs
  4. getPostgresProjects
Databricks v1.81.0 published on Thursday, Jan 8, 2026 by Pulumi
databricks logo
Databricks v1.81.0 published on Thursday, Jan 8, 2026 by Pulumi

    Private Preview

    Using getPostgresProjects

    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 getPostgresProjects(args: GetPostgresProjectsArgs, opts?: InvokeOptions): Promise<GetPostgresProjectsResult>
    function getPostgresProjectsOutput(args: GetPostgresProjectsOutputArgs, opts?: InvokeOptions): Output<GetPostgresProjectsResult>
    def get_postgres_projects(page_size: Optional[int] = None,
                              opts: Optional[InvokeOptions] = None) -> GetPostgresProjectsResult
    def get_postgres_projects_output(page_size: Optional[pulumi.Input[int]] = None,
                              opts: Optional[InvokeOptions] = None) -> Output[GetPostgresProjectsResult]
    func GetPostgresProjects(ctx *Context, args *GetPostgresProjectsArgs, opts ...InvokeOption) (*GetPostgresProjectsResult, error)
    func GetPostgresProjectsOutput(ctx *Context, args *GetPostgresProjectsOutputArgs, opts ...InvokeOption) GetPostgresProjectsResultOutput

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

    public static class GetPostgresProjects 
    {
        public static Task<GetPostgresProjectsResult> InvokeAsync(GetPostgresProjectsArgs args, InvokeOptions? opts = null)
        public static Output<GetPostgresProjectsResult> Invoke(GetPostgresProjectsInvokeArgs args, InvokeOptions? opts = null)
    }
    public static CompletableFuture<GetPostgresProjectsResult> getPostgresProjects(GetPostgresProjectsArgs args, InvokeOptions options)
    public static Output<GetPostgresProjectsResult> getPostgresProjects(GetPostgresProjectsArgs args, InvokeOptions options)
    
    fn::invoke:
      function: databricks:index/getPostgresProjects:getPostgresProjects
      arguments:
        # arguments dictionary

    The following arguments are supported:

    PageSize int
    Upper bound for items returned
    PageSize int
    Upper bound for items returned
    pageSize Integer
    Upper bound for items returned
    pageSize number
    Upper bound for items returned
    page_size int
    Upper bound for items returned
    pageSize Number
    Upper bound for items returned

    getPostgresProjects Result

    The following output properties are available:

    Id string
    The provider-assigned unique ID for this managed resource.
    Projects List<GetPostgresProjectsProject>
    PageSize int
    Id string
    The provider-assigned unique ID for this managed resource.
    Projects []GetPostgresProjectsProject
    PageSize int
    id String
    The provider-assigned unique ID for this managed resource.
    projects List<GetPostgresProjectsProject>
    pageSize Integer
    id string
    The provider-assigned unique ID for this managed resource.
    projects GetPostgresProjectsProject[]
    pageSize number
    id str
    The provider-assigned unique ID for this managed resource.
    projects Sequence[GetPostgresProjectsProject]
    page_size int
    id String
    The provider-assigned unique ID for this managed resource.
    projects List<Property Map>
    pageSize Number

    Supporting Types

    GetPostgresProjectsProject

    CreateTime string
    (string) - A timestamp indicating when the project was created
    Name string
    (string) - The resource name of the project. Format: projects/{project_id}
    Spec GetPostgresProjectsProjectSpec
    (ProjectSpec) - The desired state of a Project
    Status GetPostgresProjectsProjectStatus
    (ProjectStatus) - The current status of a Project
    Uid string
    (string) - System generated unique ID for the project
    UpdateTime string
    (string) - A timestamp indicating when the project was last updated
    CreateTime string
    (string) - A timestamp indicating when the project was created
    Name string
    (string) - The resource name of the project. Format: projects/{project_id}
    Spec GetPostgresProjectsProjectSpec
    (ProjectSpec) - The desired state of a Project
    Status GetPostgresProjectsProjectStatus
    (ProjectStatus) - The current status of a Project
    Uid string
    (string) - System generated unique ID for the project
    UpdateTime string
    (string) - A timestamp indicating when the project was last updated
    createTime String
    (string) - A timestamp indicating when the project was created
    name String
    (string) - The resource name of the project. Format: projects/{project_id}
    spec GetPostgresProjectsProjectSpec
    (ProjectSpec) - The desired state of a Project
    status GetPostgresProjectsProjectStatus
    (ProjectStatus) - The current status of a Project
    uid String
    (string) - System generated unique ID for the project
    updateTime String
    (string) - A timestamp indicating when the project was last updated
    createTime string
    (string) - A timestamp indicating when the project was created
    name string
    (string) - The resource name of the project. Format: projects/{project_id}
    spec GetPostgresProjectsProjectSpec
    (ProjectSpec) - The desired state of a Project
    status GetPostgresProjectsProjectStatus
    (ProjectStatus) - The current status of a Project
    uid string
    (string) - System generated unique ID for the project
    updateTime string
    (string) - A timestamp indicating when the project was last updated
    create_time str
    (string) - A timestamp indicating when the project was created
    name str
    (string) - The resource name of the project. Format: projects/{project_id}
    spec GetPostgresProjectsProjectSpec
    (ProjectSpec) - The desired state of a Project
    status GetPostgresProjectsProjectStatus
    (ProjectStatus) - The current status of a Project
    uid str
    (string) - System generated unique ID for the project
    update_time str
    (string) - A timestamp indicating when the project was last updated
    createTime String
    (string) - A timestamp indicating when the project was created
    name String
    (string) - The resource name of the project. Format: projects/{project_id}
    spec Property Map
    (ProjectSpec) - The desired state of a Project
    status Property Map
    (ProjectStatus) - The current status of a Project
    uid String
    (string) - System generated unique ID for the project
    updateTime String
    (string) - A timestamp indicating when the project was last updated

    GetPostgresProjectsProjectSpec

    DefaultEndpointSettings GetPostgresProjectsProjectSpecDefaultEndpointSettings
    (ProjectDefaultEndpointSettings) - The effective default endpoint settings
    DisplayName string
    (string) - The effective human-readable project name
    HistoryRetentionDuration string
    (string) - The effective number of seconds to retain the shared history for point in time recovery
    PgVersion int
    (integer) - The effective major Postgres version number
    Settings GetPostgresProjectsProjectSpecSettings
    (ProjectSettings) - The effective project settings
    DefaultEndpointSettings GetPostgresProjectsProjectSpecDefaultEndpointSettings
    (ProjectDefaultEndpointSettings) - The effective default endpoint settings
    DisplayName string
    (string) - The effective human-readable project name
    HistoryRetentionDuration string
    (string) - The effective number of seconds to retain the shared history for point in time recovery
    PgVersion int
    (integer) - The effective major Postgres version number
    Settings GetPostgresProjectsProjectSpecSettings
    (ProjectSettings) - The effective project settings
    defaultEndpointSettings GetPostgresProjectsProjectSpecDefaultEndpointSettings
    (ProjectDefaultEndpointSettings) - The effective default endpoint settings
    displayName String
    (string) - The effective human-readable project name
    historyRetentionDuration String
    (string) - The effective number of seconds to retain the shared history for point in time recovery
    pgVersion Integer
    (integer) - The effective major Postgres version number
    settings GetPostgresProjectsProjectSpecSettings
    (ProjectSettings) - The effective project settings
    defaultEndpointSettings GetPostgresProjectsProjectSpecDefaultEndpointSettings
    (ProjectDefaultEndpointSettings) - The effective default endpoint settings
    displayName string
    (string) - The effective human-readable project name
    historyRetentionDuration string
    (string) - The effective number of seconds to retain the shared history for point in time recovery
    pgVersion number
    (integer) - The effective major Postgres version number
    settings GetPostgresProjectsProjectSpecSettings
    (ProjectSettings) - The effective project settings
    default_endpoint_settings GetPostgresProjectsProjectSpecDefaultEndpointSettings
    (ProjectDefaultEndpointSettings) - The effective default endpoint settings
    display_name str
    (string) - The effective human-readable project name
    history_retention_duration str
    (string) - The effective number of seconds to retain the shared history for point in time recovery
    pg_version int
    (integer) - The effective major Postgres version number
    settings GetPostgresProjectsProjectSpecSettings
    (ProjectSettings) - The effective project settings
    defaultEndpointSettings Property Map
    (ProjectDefaultEndpointSettings) - The effective default endpoint settings
    displayName String
    (string) - The effective human-readable project name
    historyRetentionDuration String
    (string) - The effective number of seconds to retain the shared history for point in time recovery
    pgVersion Number
    (integer) - The effective major Postgres version number
    settings Property Map
    (ProjectSettings) - The effective project settings

    GetPostgresProjectsProjectSpecDefaultEndpointSettings

    AutoscalingLimitMaxCu double
    (number) - The maximum number of Compute Units
    AutoscalingLimitMinCu double
    (number) - The minimum number of Compute Units
    PgSettings Dictionary<string, string>
    (object) - A raw representation of Postgres settings
    PgbouncerSettings Dictionary<string, string>
    (object) - A raw representation of PgBouncer settings
    SuspendTimeoutDuration string
    (string) - Duration of inactivity after which the compute endpoint is automatically suspended
    AutoscalingLimitMaxCu float64
    (number) - The maximum number of Compute Units
    AutoscalingLimitMinCu float64
    (number) - The minimum number of Compute Units
    PgSettings map[string]string
    (object) - A raw representation of Postgres settings
    PgbouncerSettings map[string]string
    (object) - A raw representation of PgBouncer settings
    SuspendTimeoutDuration string
    (string) - Duration of inactivity after which the compute endpoint is automatically suspended
    autoscalingLimitMaxCu Double
    (number) - The maximum number of Compute Units
    autoscalingLimitMinCu Double
    (number) - The minimum number of Compute Units
    pgSettings Map<String,String>
    (object) - A raw representation of Postgres settings
    pgbouncerSettings Map<String,String>
    (object) - A raw representation of PgBouncer settings
    suspendTimeoutDuration String
    (string) - Duration of inactivity after which the compute endpoint is automatically suspended
    autoscalingLimitMaxCu number
    (number) - The maximum number of Compute Units
    autoscalingLimitMinCu number
    (number) - The minimum number of Compute Units
    pgSettings {[key: string]: string}
    (object) - A raw representation of Postgres settings
    pgbouncerSettings {[key: string]: string}
    (object) - A raw representation of PgBouncer settings
    suspendTimeoutDuration string
    (string) - Duration of inactivity after which the compute endpoint is automatically suspended
    autoscaling_limit_max_cu float
    (number) - The maximum number of Compute Units
    autoscaling_limit_min_cu float
    (number) - The minimum number of Compute Units
    pg_settings Mapping[str, str]
    (object) - A raw representation of Postgres settings
    pgbouncer_settings Mapping[str, str]
    (object) - A raw representation of PgBouncer settings
    suspend_timeout_duration str
    (string) - Duration of inactivity after which the compute endpoint is automatically suspended
    autoscalingLimitMaxCu Number
    (number) - The maximum number of Compute Units
    autoscalingLimitMinCu Number
    (number) - The minimum number of Compute Units
    pgSettings Map<String>
    (object) - A raw representation of Postgres settings
    pgbouncerSettings Map<String>
    (object) - A raw representation of PgBouncer settings
    suspendTimeoutDuration String
    (string) - Duration of inactivity after which the compute endpoint is automatically suspended

    GetPostgresProjectsProjectSpecSettings

    EnableLogicalReplication bool
    (boolean) - Sets wal_level=logical for all compute endpoints in this project. All active endpoints will be suspended. Once enabled, logical replication cannot be disabled
    EnableLogicalReplication bool
    (boolean) - Sets wal_level=logical for all compute endpoints in this project. All active endpoints will be suspended. Once enabled, logical replication cannot be disabled
    enableLogicalReplication Boolean
    (boolean) - Sets wal_level=logical for all compute endpoints in this project. All active endpoints will be suspended. Once enabled, logical replication cannot be disabled
    enableLogicalReplication boolean
    (boolean) - Sets wal_level=logical for all compute endpoints in this project. All active endpoints will be suspended. Once enabled, logical replication cannot be disabled
    enable_logical_replication bool
    (boolean) - Sets wal_level=logical for all compute endpoints in this project. All active endpoints will be suspended. Once enabled, logical replication cannot be disabled
    enableLogicalReplication Boolean
    (boolean) - Sets wal_level=logical for all compute endpoints in this project. All active endpoints will be suspended. Once enabled, logical replication cannot be disabled

    GetPostgresProjectsProjectStatus

    BranchLogicalSizeLimitBytes int
    (integer) - The logical size limit for a branch
    ComputeLastActiveTime string
    (string) - The most recent time when any endpoint of this project was active
    DefaultEndpointSettings GetPostgresProjectsProjectStatusDefaultEndpointSettings
    (ProjectDefaultEndpointSettings) - The effective default endpoint settings
    DisplayName string
    (string) - The effective human-readable project name
    HistoryRetentionDuration string
    (string) - The effective number of seconds to retain the shared history for point in time recovery
    PgVersion int
    (integer) - The effective major Postgres version number
    Settings GetPostgresProjectsProjectStatusSettings
    (ProjectSettings) - The effective project settings
    SyntheticStorageSizeBytes int
    (integer) - The current space occupied by the project in storage
    BranchLogicalSizeLimitBytes int
    (integer) - The logical size limit for a branch
    ComputeLastActiveTime string
    (string) - The most recent time when any endpoint of this project was active
    DefaultEndpointSettings GetPostgresProjectsProjectStatusDefaultEndpointSettings
    (ProjectDefaultEndpointSettings) - The effective default endpoint settings
    DisplayName string
    (string) - The effective human-readable project name
    HistoryRetentionDuration string
    (string) - The effective number of seconds to retain the shared history for point in time recovery
    PgVersion int
    (integer) - The effective major Postgres version number
    Settings GetPostgresProjectsProjectStatusSettings
    (ProjectSettings) - The effective project settings
    SyntheticStorageSizeBytes int
    (integer) - The current space occupied by the project in storage
    branchLogicalSizeLimitBytes Integer
    (integer) - The logical size limit for a branch
    computeLastActiveTime String
    (string) - The most recent time when any endpoint of this project was active
    defaultEndpointSettings GetPostgresProjectsProjectStatusDefaultEndpointSettings
    (ProjectDefaultEndpointSettings) - The effective default endpoint settings
    displayName String
    (string) - The effective human-readable project name
    historyRetentionDuration String
    (string) - The effective number of seconds to retain the shared history for point in time recovery
    pgVersion Integer
    (integer) - The effective major Postgres version number
    settings GetPostgresProjectsProjectStatusSettings
    (ProjectSettings) - The effective project settings
    syntheticStorageSizeBytes Integer
    (integer) - The current space occupied by the project in storage
    branchLogicalSizeLimitBytes number
    (integer) - The logical size limit for a branch
    computeLastActiveTime string
    (string) - The most recent time when any endpoint of this project was active
    defaultEndpointSettings GetPostgresProjectsProjectStatusDefaultEndpointSettings
    (ProjectDefaultEndpointSettings) - The effective default endpoint settings
    displayName string
    (string) - The effective human-readable project name
    historyRetentionDuration string
    (string) - The effective number of seconds to retain the shared history for point in time recovery
    pgVersion number
    (integer) - The effective major Postgres version number
    settings GetPostgresProjectsProjectStatusSettings
    (ProjectSettings) - The effective project settings
    syntheticStorageSizeBytes number
    (integer) - The current space occupied by the project in storage
    branch_logical_size_limit_bytes int
    (integer) - The logical size limit for a branch
    compute_last_active_time str
    (string) - The most recent time when any endpoint of this project was active
    default_endpoint_settings GetPostgresProjectsProjectStatusDefaultEndpointSettings
    (ProjectDefaultEndpointSettings) - The effective default endpoint settings
    display_name str
    (string) - The effective human-readable project name
    history_retention_duration str
    (string) - The effective number of seconds to retain the shared history for point in time recovery
    pg_version int
    (integer) - The effective major Postgres version number
    settings GetPostgresProjectsProjectStatusSettings
    (ProjectSettings) - The effective project settings
    synthetic_storage_size_bytes int
    (integer) - The current space occupied by the project in storage
    branchLogicalSizeLimitBytes Number
    (integer) - The logical size limit for a branch
    computeLastActiveTime String
    (string) - The most recent time when any endpoint of this project was active
    defaultEndpointSettings Property Map
    (ProjectDefaultEndpointSettings) - The effective default endpoint settings
    displayName String
    (string) - The effective human-readable project name
    historyRetentionDuration String
    (string) - The effective number of seconds to retain the shared history for point in time recovery
    pgVersion Number
    (integer) - The effective major Postgres version number
    settings Property Map
    (ProjectSettings) - The effective project settings
    syntheticStorageSizeBytes Number
    (integer) - The current space occupied by the project in storage

    GetPostgresProjectsProjectStatusDefaultEndpointSettings

    AutoscalingLimitMaxCu double
    (number) - The maximum number of Compute Units
    AutoscalingLimitMinCu double
    (number) - The minimum number of Compute Units
    PgSettings Dictionary<string, string>
    (object) - A raw representation of Postgres settings
    PgbouncerSettings Dictionary<string, string>
    (object) - A raw representation of PgBouncer settings
    SuspendTimeoutDuration string
    (string) - Duration of inactivity after which the compute endpoint is automatically suspended
    AutoscalingLimitMaxCu float64
    (number) - The maximum number of Compute Units
    AutoscalingLimitMinCu float64
    (number) - The minimum number of Compute Units
    PgSettings map[string]string
    (object) - A raw representation of Postgres settings
    PgbouncerSettings map[string]string
    (object) - A raw representation of PgBouncer settings
    SuspendTimeoutDuration string
    (string) - Duration of inactivity after which the compute endpoint is automatically suspended
    autoscalingLimitMaxCu Double
    (number) - The maximum number of Compute Units
    autoscalingLimitMinCu Double
    (number) - The minimum number of Compute Units
    pgSettings Map<String,String>
    (object) - A raw representation of Postgres settings
    pgbouncerSettings Map<String,String>
    (object) - A raw representation of PgBouncer settings
    suspendTimeoutDuration String
    (string) - Duration of inactivity after which the compute endpoint is automatically suspended
    autoscalingLimitMaxCu number
    (number) - The maximum number of Compute Units
    autoscalingLimitMinCu number
    (number) - The minimum number of Compute Units
    pgSettings {[key: string]: string}
    (object) - A raw representation of Postgres settings
    pgbouncerSettings {[key: string]: string}
    (object) - A raw representation of PgBouncer settings
    suspendTimeoutDuration string
    (string) - Duration of inactivity after which the compute endpoint is automatically suspended
    autoscaling_limit_max_cu float
    (number) - The maximum number of Compute Units
    autoscaling_limit_min_cu float
    (number) - The minimum number of Compute Units
    pg_settings Mapping[str, str]
    (object) - A raw representation of Postgres settings
    pgbouncer_settings Mapping[str, str]
    (object) - A raw representation of PgBouncer settings
    suspend_timeout_duration str
    (string) - Duration of inactivity after which the compute endpoint is automatically suspended
    autoscalingLimitMaxCu Number
    (number) - The maximum number of Compute Units
    autoscalingLimitMinCu Number
    (number) - The minimum number of Compute Units
    pgSettings Map<String>
    (object) - A raw representation of Postgres settings
    pgbouncerSettings Map<String>
    (object) - A raw representation of PgBouncer settings
    suspendTimeoutDuration String
    (string) - Duration of inactivity after which the compute endpoint is automatically suspended

    GetPostgresProjectsProjectStatusSettings

    EnableLogicalReplication bool
    (boolean) - Sets wal_level=logical for all compute endpoints in this project. All active endpoints will be suspended. Once enabled, logical replication cannot be disabled
    EnableLogicalReplication bool
    (boolean) - Sets wal_level=logical for all compute endpoints in this project. All active endpoints will be suspended. Once enabled, logical replication cannot be disabled
    enableLogicalReplication Boolean
    (boolean) - Sets wal_level=logical for all compute endpoints in this project. All active endpoints will be suspended. Once enabled, logical replication cannot be disabled
    enableLogicalReplication boolean
    (boolean) - Sets wal_level=logical for all compute endpoints in this project. All active endpoints will be suspended. Once enabled, logical replication cannot be disabled
    enable_logical_replication bool
    (boolean) - Sets wal_level=logical for all compute endpoints in this project. All active endpoints will be suspended. Once enabled, logical replication cannot be disabled
    enableLogicalReplication Boolean
    (boolean) - Sets wal_level=logical for all compute endpoints in this project. All active endpoints will be suspended. Once enabled, logical replication cannot be disabled

    Package Details

    Repository
    databricks pulumi/pulumi-databricks
    License
    Apache-2.0
    Notes
    This Pulumi package is based on the databricks Terraform Provider.
    databricks logo
    Databricks v1.81.0 published on Thursday, Jan 8, 2026 by Pulumi
      Meet Neo: Your AI Platform Teammate