1. Packages
  2. Packages
  3. dbt Cloud Provider
  4. API Docs
  5. PostgresCredential
Viewing docs for dbt Cloud v1.8.2
published on Thursday, May 14, 2026 by Pulumi
Schema (JSON)
pulumi/pulumi-dbtcloud

dbtcloud.PostgresCredential

dbtcloud logo
Viewing docs for dbt Cloud v1.8.2
published on Thursday, May 14, 2026 by Pulumi
Schema (JSON)
pulumi/pulumi-dbtcloud

    Postgres credential resource.

    Example Usage

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

// Using the classic sensitive attribute (stored in state)
const postgresProdCredential = new dbtcloud.PostgresCredential("postgres_prod_credential", {
    isActive: true,
    projectId: Number(dbtProject.id),
    type: "postgres",
    defaultSchema: "my_schema",
    username: "my_username",
    password: "my_password",
    numThreads: 16,
});
const config = new pulumi.Config();
const postgresPassword = config.require("postgresPassword");
const postgresProdCredentialWo = new dbtcloud.PostgresCredential("postgres_prod_credential_wo", {
    isActive: true,
    projectId: Number(dbtProject.id),
    type: "postgres",
    defaultSchema: "my_schema",
    username: "my_username",
    passwordWo: postgresPassword,
    passwordWoVersion: 1,
    numThreads: 16,
});

    import pulumi
import pulumi_dbtcloud as dbtcloud

# Using the classic sensitive attribute (stored in state)
postgres_prod_credential = dbtcloud.PostgresCredential("postgres_prod_credential",
    is_active=True,
    project_id=int(dbt_project["id"]),
    type="postgres",
    default_schema="my_schema",
    username="my_username",
    password="my_password",
    num_threads=16)
config = pulumi.Config()
postgres_password = config.require("postgresPassword")
postgres_prod_credential_wo = dbtcloud.PostgresCredential("postgres_prod_credential_wo",
    is_active=True,
    project_id=int(dbt_project["id"]),
    type="postgres",
    default_schema="my_schema",
    username="my_username",
    password_wo=postgres_password,
    password_wo_version=1,
    num_threads=16)

    package main

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

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		// Using the classic sensitive attribute (stored in state)
		_, err := dbtcloud.NewPostgresCredential(ctx, "postgres_prod_credential", &dbtcloud.PostgresCredentialArgs{
			IsActive:      pulumi.Bool(true),
			ProjectId:     pulumi.Any(dbtProject.Id),
			Type:          pulumi.String("postgres"),
			DefaultSchema: pulumi.String("my_schema"),
			Username:      pulumi.String("my_username"),
			Password:      pulumi.String("my_password"),
			NumThreads:    pulumi.Int(16),
		})
		if err != nil {
			return err
		}
		cfg := config.New(ctx, "")
		postgresPassword := cfg.Require("postgresPassword")
		_, err = dbtcloud.NewPostgresCredential(ctx, "postgres_prod_credential_wo", &dbtcloud.PostgresCredentialArgs{
			IsActive:          pulumi.Bool(true),
			ProjectId:         pulumi.Any(dbtProject.Id),
			Type:              pulumi.String("postgres"),
			DefaultSchema:     pulumi.String("my_schema"),
			Username:          pulumi.String("my_username"),
			PasswordWo:        pulumi.String(pulumi.String(postgresPassword)),
			PasswordWoVersion: pulumi.Int(1),
			NumThreads:        pulumi.Int(16),
		})
		if err != nil {
			return err
		}
		return nil
	})
}

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

return await Deployment.RunAsync(() => 
{
    // Using the classic sensitive attribute (stored in state)
    var postgresProdCredential = new DbtCloud.PostgresCredential("postgres_prod_credential", new()
    {
        IsActive = true,
        ProjectId = dbtProject.Id,
        Type = "postgres",
        DefaultSchema = "my_schema",
        Username = "my_username",
        Password = "my_password",
        NumThreads = 16,
    });

    var config = new Config();
    var postgresPassword = config.Require("postgresPassword");
    var postgresProdCredentialWo = new DbtCloud.PostgresCredential("postgres_prod_credential_wo", new()
    {
        IsActive = true,
        ProjectId = dbtProject.Id,
        Type = "postgres",
        DefaultSchema = "my_schema",
        Username = "my_username",
        PasswordWo = postgresPassword,
        PasswordWoVersion = 1,
        NumThreads = 16,
    });

});

    package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.dbtcloud.PostgresCredential;
import com.pulumi.dbtcloud.PostgresCredentialArgs;
import java.util.ArrayList;
import java.util.Arrays;
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 config = ctx.config();
        // Using the classic sensitive attribute (stored in state)
        var postgresProdCredential = new PostgresCredential("postgresProdCredential", PostgresCredentialArgs.builder()
            .isActive(true)
            .projectId(dbtProject.id())
            .type("postgres")
            .defaultSchema("my_schema")
            .username("my_username")
            .password("my_password")
            .numThreads(16)
            .build());

        final var postgresPassword = config.require("postgresPassword");
        var postgresProdCredentialWo = new PostgresCredential("postgresProdCredentialWo", PostgresCredentialArgs.builder()
            .isActive(true)
            .projectId(dbtProject.id())
            .type("postgres")
            .defaultSchema("my_schema")
            .username("my_username")
            .passwordWo(postgresPassword)
            .passwordWoVersion(1)
            .numThreads(16)
            .build());

    }
}

    configuration:
  # Using write-only attributes (not stored in state, requires Terraform >= 1.11)
  # //
  # // The password_wo value is never persisted in the Terraform state file.
  # // Use password_wo_version to trigger an update when the password changes.
  postgresPassword:
    type: string
resources:
  # Using the classic sensitive attribute (stored in state)
  postgresProdCredential:
    type: dbtcloud:PostgresCredential
    name: postgres_prod_credential
    properties:
      isActive: true
      projectId: ${dbtProject.id}
      type: postgres
      defaultSchema: my_schema
      username: my_username
      password: my_password
      numThreads: 16
  postgresProdCredentialWo:
    type: dbtcloud:PostgresCredential
    name: postgres_prod_credential_wo
    properties:
      isActive: true
      projectId: ${dbtProject.id}
      type: postgres
      defaultSchema: my_schema
      username: my_username
      passwordWo: ${postgresPassword}
      passwordWoVersion: 1
      numThreads: 16

    Example coming soon!

    Create PostgresCredential Resource

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

    Constructor syntax

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

@overload
def PostgresCredential(resource_name: str,
                       opts: Optional[ResourceOptions] = None,
                       project_id: Optional[int] = None,
                       username: Optional[str] = None,
                       default_schema: Optional[str] = None,
                       is_active: Optional[bool] = None,
                       num_threads: Optional[int] = None,
                       password: Optional[str] = None,
                       password_wo: Optional[str] = None,
                       password_wo_version: Optional[int] = None,
                       semantic_layer_credential: Optional[bool] = None,
                       target_name: Optional[str] = None,
                       type: Optional[str] = None)
    func NewPostgresCredential(ctx *Context, name string, args PostgresCredentialArgs, opts ...ResourceOption) (*PostgresCredential, error)
    public PostgresCredential(string name, PostgresCredentialArgs args, CustomResourceOptions? opts = null)
    public PostgresCredential(String name, PostgresCredentialArgs args)
public PostgresCredential(String name, PostgresCredentialArgs args, CustomResourceOptions options)

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


    resource "dbtcloud_postgrescredential" "name" {
    # resource properties
}

    Parameters

    name string
    The unique name of the resource.
    args PostgresCredentialArgs
    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 PostgresCredentialArgs
    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 PostgresCredentialArgs
    The arguments to resource properties.
    opts ResourceOption
    Bag of options to control resource's behavior.
    name string
    The unique name of the resource.
    args PostgresCredentialArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    name String
    The unique name of the resource.
    args PostgresCredentialArgs
    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 postgresCredentialResource = new DbtCloud.PostgresCredential("postgresCredentialResource", new()
{
    ProjectId = 0,
    Username = "string",
    DefaultSchema = "string",
    IsActive = false,
    NumThreads = 0,
    Password = "string",
    PasswordWo = "string",
    PasswordWoVersion = 0,
    SemanticLayerCredential = false,
    TargetName = "string",
    Type = "string",
});

    example, err := dbtcloud.NewPostgresCredential(ctx, "postgresCredentialResource", &dbtcloud.PostgresCredentialArgs{
	ProjectId:               pulumi.Int(0),
	Username:                pulumi.String("string"),
	DefaultSchema:           pulumi.String("string"),
	IsActive:                pulumi.Bool(false),
	NumThreads:              pulumi.Int(0),
	Password:                pulumi.String("string"),
	PasswordWo:              pulumi.String("string"),
	PasswordWoVersion:       pulumi.Int(0),
	SemanticLayerCredential: pulumi.Bool(false),
	TargetName:              pulumi.String("string"),
	Type:                    pulumi.String("string"),
})

    resource "dbtcloud_postgrescredential" "postgresCredentialResource" {
  project_id                = 0
  username                  = "string"
  default_schema            = "string"
  is_active                 = false
  num_threads               = 0
  password                  = "string"
  password_wo               = "string"
  password_wo_version       = 0
  semantic_layer_credential = false
  target_name               = "string"
  type                      = "string"
}

    var postgresCredentialResource = new PostgresCredential("postgresCredentialResource", PostgresCredentialArgs.builder()
    .projectId(0)
    .username("string")
    .defaultSchema("string")
    .isActive(false)
    .numThreads(0)
    .password("string")
    .passwordWo("string")
    .passwordWoVersion(0)
    .semanticLayerCredential(false)
    .targetName("string")
    .type("string")
    .build());

    postgres_credential_resource = dbtcloud.PostgresCredential("postgresCredentialResource",
    project_id=0,
    username="string",
    default_schema="string",
    is_active=False,
    num_threads=0,
    password="string",
    password_wo="string",
    password_wo_version=0,
    semantic_layer_credential=False,
    target_name="string",
    type="string")

    const postgresCredentialResource = new dbtcloud.PostgresCredential("postgresCredentialResource", {
    projectId: 0,
    username: "string",
    defaultSchema: "string",
    isActive: false,
    numThreads: 0,
    password: "string",
    passwordWo: "string",
    passwordWoVersion: 0,
    semanticLayerCredential: false,
    targetName: "string",
    type: "string",
});

    type: dbtcloud:PostgresCredential
properties:
    defaultSchema: string
    isActive: false
    numThreads: 0
    password: string
    passwordWo: string
    passwordWoVersion: 0
    projectId: 0
    semanticLayerCredential: false
    targetName: string
    type: string
    username: string

    PostgresCredential 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 PostgresCredential resource accepts the following input properties:

    ProjectId int
    Project ID to create the Postgres/Redshift/AlloyDB credential in.
    Username string
    Username for Postgres/Redshift/AlloyDB
    DefaultSchema string
    Default schema name. Optional only when semanticlayercredential is set to true; otherwise, this field is required.
    IsActive bool
    Whether the Postgres/Redshift/AlloyDB credential is active
    NumThreads int
    Number of threads to use (required for Redshift)
    Password string
    Password for Postgres/Redshift/AlloyDB. Consider using passwordWo instead, which is not stored in state.
    PasswordWo string
    NOTE: This field is write-only and its value will not be updated in state as part of read operations. Write-only alternative to password. The value is not stored in state. Requires passwordWoVersion to trigger updates.
    PasswordWoVersion int
    Version number for passwordWo. Increment this value to trigger an update of the password when using passwordWo.
    SemanticLayerCredential bool
    This field indicates that the credential is used as part of the Semantic Layer configuration. It is used to create a Postgres credential for the Semantic Layer.
    TargetName string
    Default schema name
    Type string
    Type of connection. One of (postgres/redshift). Use postgres for alloydb connections. Optional only when semanticlayercredential is set to true; otherwise, this field is required.
    ProjectId int
    Project ID to create the Postgres/Redshift/AlloyDB credential in.
    Username string
    Username for Postgres/Redshift/AlloyDB
    DefaultSchema string
    Default schema name. Optional only when semanticlayercredential is set to true; otherwise, this field is required.
    IsActive bool
    Whether the Postgres/Redshift/AlloyDB credential is active
    NumThreads int
    Number of threads to use (required for Redshift)
    Password string
    Password for Postgres/Redshift/AlloyDB. Consider using passwordWo instead, which is not stored in state.
    PasswordWo string
    NOTE: This field is write-only and its value will not be updated in state as part of read operations. Write-only alternative to password. The value is not stored in state. Requires passwordWoVersion to trigger updates.
    PasswordWoVersion int
    Version number for passwordWo. Increment this value to trigger an update of the password when using passwordWo.
    SemanticLayerCredential bool
    This field indicates that the credential is used as part of the Semantic Layer configuration. It is used to create a Postgres credential for the Semantic Layer.
    TargetName string
    Default schema name
    Type string
    Type of connection. One of (postgres/redshift). Use postgres for alloydb connections. Optional only when semanticlayercredential is set to true; otherwise, this field is required.
    project_id number
    Project ID to create the Postgres/Redshift/AlloyDB credential in.
    username string
    Username for Postgres/Redshift/AlloyDB
    default_schema string
    Default schema name. Optional only when semanticlayercredential is set to true; otherwise, this field is required.
    is_active bool
    Whether the Postgres/Redshift/AlloyDB credential is active
    num_threads number
    Number of threads to use (required for Redshift)
    password string
    Password for Postgres/Redshift/AlloyDB. Consider using passwordWo instead, which is not stored in state.
    password_wo string
    NOTE: This field is write-only and its value will not be updated in state as part of read operations. Write-only alternative to password. The value is not stored in state. Requires passwordWoVersion to trigger updates.
    password_wo_version number
    Version number for passwordWo. Increment this value to trigger an update of the password when using passwordWo.
    semantic_layer_credential bool
    This field indicates that the credential is used as part of the Semantic Layer configuration. It is used to create a Postgres credential for the Semantic Layer.
    target_name string
    Default schema name
    type string
    Type of connection. One of (postgres/redshift). Use postgres for alloydb connections. Optional only when semanticlayercredential is set to true; otherwise, this field is required.
    projectId Integer
    Project ID to create the Postgres/Redshift/AlloyDB credential in.
    username String
    Username for Postgres/Redshift/AlloyDB
    defaultSchema String
    Default schema name. Optional only when semanticlayercredential is set to true; otherwise, this field is required.
    isActive Boolean
    Whether the Postgres/Redshift/AlloyDB credential is active
    numThreads Integer
    Number of threads to use (required for Redshift)
    password String
    Password for Postgres/Redshift/AlloyDB. Consider using passwordWo instead, which is not stored in state.
    passwordWo String
    NOTE: This field is write-only and its value will not be updated in state as part of read operations. Write-only alternative to password. The value is not stored in state. Requires passwordWoVersion to trigger updates.
    passwordWoVersion Integer
    Version number for passwordWo. Increment this value to trigger an update of the password when using passwordWo.
    semanticLayerCredential Boolean
    This field indicates that the credential is used as part of the Semantic Layer configuration. It is used to create a Postgres credential for the Semantic Layer.
    targetName String
    Default schema name
    type String
    Type of connection. One of (postgres/redshift). Use postgres for alloydb connections. Optional only when semanticlayercredential is set to true; otherwise, this field is required.
    projectId number
    Project ID to create the Postgres/Redshift/AlloyDB credential in.
    username string
    Username for Postgres/Redshift/AlloyDB
    defaultSchema string
    Default schema name. Optional only when semanticlayercredential is set to true; otherwise, this field is required.
    isActive boolean
    Whether the Postgres/Redshift/AlloyDB credential is active
    numThreads number
    Number of threads to use (required for Redshift)
    password string
    Password for Postgres/Redshift/AlloyDB. Consider using passwordWo instead, which is not stored in state.
    passwordWo string
    NOTE: This field is write-only and its value will not be updated in state as part of read operations. Write-only alternative to password. The value is not stored in state. Requires passwordWoVersion to trigger updates.
    passwordWoVersion number
    Version number for passwordWo. Increment this value to trigger an update of the password when using passwordWo.
    semanticLayerCredential boolean
    This field indicates that the credential is used as part of the Semantic Layer configuration. It is used to create a Postgres credential for the Semantic Layer.
    targetName string
    Default schema name
    type string
    Type of connection. One of (postgres/redshift). Use postgres for alloydb connections. Optional only when semanticlayercredential is set to true; otherwise, this field is required.
    project_id int
    Project ID to create the Postgres/Redshift/AlloyDB credential in.
    username str
    Username for Postgres/Redshift/AlloyDB
    default_schema str
    Default schema name. Optional only when semanticlayercredential is set to true; otherwise, this field is required.
    is_active bool
    Whether the Postgres/Redshift/AlloyDB credential is active
    num_threads int
    Number of threads to use (required for Redshift)
    password str
    Password for Postgres/Redshift/AlloyDB. Consider using passwordWo instead, which is not stored in state.
    password_wo str
    NOTE: This field is write-only and its value will not be updated in state as part of read operations. Write-only alternative to password. The value is not stored in state. Requires passwordWoVersion to trigger updates.
    password_wo_version int
    Version number for passwordWo. Increment this value to trigger an update of the password when using passwordWo.
    semantic_layer_credential bool
    This field indicates that the credential is used as part of the Semantic Layer configuration. It is used to create a Postgres credential for the Semantic Layer.
    target_name str
    Default schema name
    type str
    Type of connection. One of (postgres/redshift). Use postgres for alloydb connections. Optional only when semanticlayercredential is set to true; otherwise, this field is required.
    projectId Number
    Project ID to create the Postgres/Redshift/AlloyDB credential in.
    username String
    Username for Postgres/Redshift/AlloyDB
    defaultSchema String
    Default schema name. Optional only when semanticlayercredential is set to true; otherwise, this field is required.
    isActive Boolean
    Whether the Postgres/Redshift/AlloyDB credential is active
    numThreads Number
    Number of threads to use (required for Redshift)
    password String
    Password for Postgres/Redshift/AlloyDB. Consider using passwordWo instead, which is not stored in state.
    passwordWo String
    NOTE: This field is write-only and its value will not be updated in state as part of read operations. Write-only alternative to password. The value is not stored in state. Requires passwordWoVersion to trigger updates.
    passwordWoVersion Number
    Version number for passwordWo. Increment this value to trigger an update of the password when using passwordWo.
    semanticLayerCredential Boolean
    This field indicates that the credential is used as part of the Semantic Layer configuration. It is used to create a Postgres credential for the Semantic Layer.
    targetName String
    Default schema name
    type String
    Type of connection. One of (postgres/redshift). Use postgres for alloydb connections. Optional only when semanticlayercredential is set to true; otherwise, this field is required.

    Outputs

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

    CredentialId int
    The system Postgres/Redshift/AlloyDB credential ID.
    Id string
    The provider-assigned unique ID for this managed resource.
    CredentialId int
    The system Postgres/Redshift/AlloyDB credential ID.
    Id string
    The provider-assigned unique ID for this managed resource.
    credential_id number
    The system Postgres/Redshift/AlloyDB credential ID.
    id string
    The provider-assigned unique ID for this managed resource.
    credentialId Integer
    The system Postgres/Redshift/AlloyDB credential ID.
    id String
    The provider-assigned unique ID for this managed resource.
    credentialId number
    The system Postgres/Redshift/AlloyDB credential ID.
    id string
    The provider-assigned unique ID for this managed resource.
    credential_id int
    The system Postgres/Redshift/AlloyDB credential ID.
    id str
    The provider-assigned unique ID for this managed resource.
    credentialId Number
    The system Postgres/Redshift/AlloyDB credential ID.
    id String
    The provider-assigned unique ID for this managed resource.

    Look up Existing PostgresCredential Resource

    Get an existing PostgresCredential 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?: PostgresCredentialState, opts?: CustomResourceOptions): PostgresCredential
    @staticmethod
def get(resource_name: str,
        id: str,
        opts: Optional[ResourceOptions] = None,
        credential_id: Optional[int] = None,
        default_schema: Optional[str] = None,
        is_active: Optional[bool] = None,
        num_threads: Optional[int] = None,
        password: Optional[str] = None,
        password_wo: Optional[str] = None,
        password_wo_version: Optional[int] = None,
        project_id: Optional[int] = None,
        semantic_layer_credential: Optional[bool] = None,
        target_name: Optional[str] = None,
        type: Optional[str] = None,
        username: Optional[str] = None) -> PostgresCredential
    func GetPostgresCredential(ctx *Context, name string, id IDInput, state *PostgresCredentialState, opts ...ResourceOption) (*PostgresCredential, error)
    public static PostgresCredential Get(string name, Input<string> id, PostgresCredentialState? state, CustomResourceOptions? opts = null)
    public static PostgresCredential get(String name, Output<String> id, PostgresCredentialState state, CustomResourceOptions options)
    resources:  _:    type: dbtcloud:PostgresCredential    get:      id: ${id}
    import {
  to = dbtcloud_postgrescredential.example
  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:
    CredentialId int
    The system Postgres/Redshift/AlloyDB credential ID.
    DefaultSchema string
    Default schema name. Optional only when semanticlayercredential is set to true; otherwise, this field is required.
    IsActive bool
    Whether the Postgres/Redshift/AlloyDB credential is active
    NumThreads int
    Number of threads to use (required for Redshift)
    Password string
    Password for Postgres/Redshift/AlloyDB. Consider using passwordWo instead, which is not stored in state.
    PasswordWo string
    NOTE: This field is write-only and its value will not be updated in state as part of read operations. Write-only alternative to password. The value is not stored in state. Requires passwordWoVersion to trigger updates.
    PasswordWoVersion int
    Version number for passwordWo. Increment this value to trigger an update of the password when using passwordWo.
    ProjectId int
    Project ID to create the Postgres/Redshift/AlloyDB credential in.
    SemanticLayerCredential bool
    This field indicates that the credential is used as part of the Semantic Layer configuration. It is used to create a Postgres credential for the Semantic Layer.
    TargetName string
    Default schema name
    Type string
    Type of connection. One of (postgres/redshift). Use postgres for alloydb connections. Optional only when semanticlayercredential is set to true; otherwise, this field is required.
    Username string
    Username for Postgres/Redshift/AlloyDB
    CredentialId int
    The system Postgres/Redshift/AlloyDB credential ID.
    DefaultSchema string
    Default schema name. Optional only when semanticlayercredential is set to true; otherwise, this field is required.
    IsActive bool
    Whether the Postgres/Redshift/AlloyDB credential is active
    NumThreads int
    Number of threads to use (required for Redshift)
    Password string
    Password for Postgres/Redshift/AlloyDB. Consider using passwordWo instead, which is not stored in state.
    PasswordWo string
    NOTE: This field is write-only and its value will not be updated in state as part of read operations. Write-only alternative to password. The value is not stored in state. Requires passwordWoVersion to trigger updates.
    PasswordWoVersion int
    Version number for passwordWo. Increment this value to trigger an update of the password when using passwordWo.
    ProjectId int
    Project ID to create the Postgres/Redshift/AlloyDB credential in.
    SemanticLayerCredential bool
    This field indicates that the credential is used as part of the Semantic Layer configuration. It is used to create a Postgres credential for the Semantic Layer.
    TargetName string
    Default schema name
    Type string
    Type of connection. One of (postgres/redshift). Use postgres for alloydb connections. Optional only when semanticlayercredential is set to true; otherwise, this field is required.
    Username string
    Username for Postgres/Redshift/AlloyDB
    credential_id number
    The system Postgres/Redshift/AlloyDB credential ID.
    default_schema string
    Default schema name. Optional only when semanticlayercredential is set to true; otherwise, this field is required.
    is_active bool
    Whether the Postgres/Redshift/AlloyDB credential is active
    num_threads number
    Number of threads to use (required for Redshift)
    password string
    Password for Postgres/Redshift/AlloyDB. Consider using passwordWo instead, which is not stored in state.
    password_wo string
    NOTE: This field is write-only and its value will not be updated in state as part of read operations. Write-only alternative to password. The value is not stored in state. Requires passwordWoVersion to trigger updates.
    password_wo_version number
    Version number for passwordWo. Increment this value to trigger an update of the password when using passwordWo.
    project_id number
    Project ID to create the Postgres/Redshift/AlloyDB credential in.
    semantic_layer_credential bool
    This field indicates that the credential is used as part of the Semantic Layer configuration. It is used to create a Postgres credential for the Semantic Layer.
    target_name string
    Default schema name
    type string
    Type of connection. One of (postgres/redshift). Use postgres for alloydb connections. Optional only when semanticlayercredential is set to true; otherwise, this field is required.
    username string
    Username for Postgres/Redshift/AlloyDB
    credentialId Integer
    The system Postgres/Redshift/AlloyDB credential ID.
    defaultSchema String
    Default schema name. Optional only when semanticlayercredential is set to true; otherwise, this field is required.
    isActive Boolean
    Whether the Postgres/Redshift/AlloyDB credential is active
    numThreads Integer
    Number of threads to use (required for Redshift)
    password String
    Password for Postgres/Redshift/AlloyDB. Consider using passwordWo instead, which is not stored in state.
    passwordWo String
    NOTE: This field is write-only and its value will not be updated in state as part of read operations. Write-only alternative to password. The value is not stored in state. Requires passwordWoVersion to trigger updates.
    passwordWoVersion Integer
    Version number for passwordWo. Increment this value to trigger an update of the password when using passwordWo.
    projectId Integer
    Project ID to create the Postgres/Redshift/AlloyDB credential in.
    semanticLayerCredential Boolean
    This field indicates that the credential is used as part of the Semantic Layer configuration. It is used to create a Postgres credential for the Semantic Layer.
    targetName String
    Default schema name
    type String
    Type of connection. One of (postgres/redshift). Use postgres for alloydb connections. Optional only when semanticlayercredential is set to true; otherwise, this field is required.
    username String
    Username for Postgres/Redshift/AlloyDB
    credentialId number
    The system Postgres/Redshift/AlloyDB credential ID.
    defaultSchema string
    Default schema name. Optional only when semanticlayercredential is set to true; otherwise, this field is required.
    isActive boolean
    Whether the Postgres/Redshift/AlloyDB credential is active
    numThreads number
    Number of threads to use (required for Redshift)
    password string
    Password for Postgres/Redshift/AlloyDB. Consider using passwordWo instead, which is not stored in state.
    passwordWo string
    NOTE: This field is write-only and its value will not be updated in state as part of read operations. Write-only alternative to password. The value is not stored in state. Requires passwordWoVersion to trigger updates.
    passwordWoVersion number
    Version number for passwordWo. Increment this value to trigger an update of the password when using passwordWo.
    projectId number
    Project ID to create the Postgres/Redshift/AlloyDB credential in.
    semanticLayerCredential boolean
    This field indicates that the credential is used as part of the Semantic Layer configuration. It is used to create a Postgres credential for the Semantic Layer.
    targetName string
    Default schema name
    type string
    Type of connection. One of (postgres/redshift). Use postgres for alloydb connections. Optional only when semanticlayercredential is set to true; otherwise, this field is required.
    username string
    Username for Postgres/Redshift/AlloyDB
    credential_id int
    The system Postgres/Redshift/AlloyDB credential ID.
    default_schema str
    Default schema name. Optional only when semanticlayercredential is set to true; otherwise, this field is required.
    is_active bool
    Whether the Postgres/Redshift/AlloyDB credential is active
    num_threads int
    Number of threads to use (required for Redshift)
    password str
    Password for Postgres/Redshift/AlloyDB. Consider using passwordWo instead, which is not stored in state.
    password_wo str
    NOTE: This field is write-only and its value will not be updated in state as part of read operations. Write-only alternative to password. The value is not stored in state. Requires passwordWoVersion to trigger updates.
    password_wo_version int
    Version number for passwordWo. Increment this value to trigger an update of the password when using passwordWo.
    project_id int
    Project ID to create the Postgres/Redshift/AlloyDB credential in.
    semantic_layer_credential bool
    This field indicates that the credential is used as part of the Semantic Layer configuration. It is used to create a Postgres credential for the Semantic Layer.
    target_name str
    Default schema name
    type str
    Type of connection. One of (postgres/redshift). Use postgres for alloydb connections. Optional only when semanticlayercredential is set to true; otherwise, this field is required.
    username str
    Username for Postgres/Redshift/AlloyDB
    credentialId Number
    The system Postgres/Redshift/AlloyDB credential ID.
    defaultSchema String
    Default schema name. Optional only when semanticlayercredential is set to true; otherwise, this field is required.
    isActive Boolean
    Whether the Postgres/Redshift/AlloyDB credential is active
    numThreads Number
    Number of threads to use (required for Redshift)
    password String
    Password for Postgres/Redshift/AlloyDB. Consider using passwordWo instead, which is not stored in state.
    passwordWo String
    NOTE: This field is write-only and its value will not be updated in state as part of read operations. Write-only alternative to password. The value is not stored in state. Requires passwordWoVersion to trigger updates.
    passwordWoVersion Number
    Version number for passwordWo. Increment this value to trigger an update of the password when using passwordWo.
    projectId Number
    Project ID to create the Postgres/Redshift/AlloyDB credential in.
    semanticLayerCredential Boolean
    This field indicates that the credential is used as part of the Semantic Layer configuration. It is used to create a Postgres credential for the Semantic Layer.
    targetName String
    Default schema name
    type String
    Type of connection. One of (postgres/redshift). Use postgres for alloydb connections. Optional only when semanticlayercredential is set to true; otherwise, this field is required.
    username String
    Username for Postgres/Redshift/AlloyDB

    Import

    using import blocks (requires Terraform >= 1.5) import { to = dbtcloud_postgres_credential.my_credential id = “project_id:credential_id” }

    import { to = dbtcloud_postgres_credential.my_credential id = “12345:6789” }

    using the older import command

    $ pulumi import dbtcloud:index/postgresCredential:PostgresCredential my_credential "project_id:credential_id"
$ pulumi import dbtcloud:index/postgresCredential:PostgresCredential my_credential 12345:6789

    To learn more about importing existing cloud resources, see Importing resources.

    Package Details

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