Docs Packages
  1. Packages
  2. dbt Cloud
  3. API Docs
  4. FabricCredential
dbt Cloud v0.1.8 published on Tuesday, Jun 11, 2024 by Pulumi
pulumi/pulumi-dbtcloud

dbtcloud.FabricCredential

Explore with Pulumi AI

dbtcloud logo
dbt Cloud v0.1.8 published on Tuesday, Jun 11, 2024 by Pulumi
pulumi/pulumi-dbtcloud

    Example Usage

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

// when using AD authentication
const myFabricCredAd = new dbtcloud.FabricCredential("my_fabric_cred_ad", {
    projectId: dbtProject.id,
    adapterId: myFabricConnection.adapterId,
    schema: "my_schema",
    user: "my_user",
    password: "my_password",
    schemaAuthorization: "abcd",
});
// when using service principal authentication
const myFabricCredServPrinc = new dbtcloud.FabricCredential("my_fabric_cred_serv_princ", {
    projectId: dbtProject.id,
    adapterId: myFabricConnection.adapterId,
    schema: "my_schema",
    clientId: "my_client_id",
    tenantId: "my_tenant_id",
    clientSecret: "my_secret",
    schemaAuthorization: "abcd",
});

    import pulumi
import pulumi_dbtcloud as dbtcloud

# when using AD authentication
my_fabric_cred_ad = dbtcloud.FabricCredential("my_fabric_cred_ad",
    project_id=dbt_project["id"],
    adapter_id=my_fabric_connection["adapterId"],
    schema="my_schema",
    user="my_user",
    password="my_password",
    schema_authorization="abcd")
# when using service principal authentication
my_fabric_cred_serv_princ = dbtcloud.FabricCredential("my_fabric_cred_serv_princ",
    project_id=dbt_project["id"],
    adapter_id=my_fabric_connection["adapterId"],
    schema="my_schema",
    client_id="my_client_id",
    tenant_id="my_tenant_id",
    client_secret="my_secret",
    schema_authorization="abcd")

    package main

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

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		// when using AD authentication
		_, err := dbtcloud.NewFabricCredential(ctx, "my_fabric_cred_ad", &dbtcloud.FabricCredentialArgs{
			ProjectId:           pulumi.Any(dbtProject.Id),
			AdapterId:           pulumi.Any(myFabricConnection.AdapterId),
			Schema:              pulumi.String("my_schema"),
			User:                pulumi.String("my_user"),
			Password:            pulumi.String("my_password"),
			SchemaAuthorization: pulumi.String("abcd"),
		})
		if err != nil {
			return err
		}
		// when using service principal authentication
		_, err = dbtcloud.NewFabricCredential(ctx, "my_fabric_cred_serv_princ", &dbtcloud.FabricCredentialArgs{
			ProjectId:           pulumi.Any(dbtProject.Id),
			AdapterId:           pulumi.Any(myFabricConnection.AdapterId),
			Schema:              pulumi.String("my_schema"),
			ClientId:            pulumi.String("my_client_id"),
			TenantId:            pulumi.String("my_tenant_id"),
			ClientSecret:        pulumi.String("my_secret"),
			SchemaAuthorization: pulumi.String("abcd"),
		})
		if err != nil {
			return err
		}
		return nil
	})
}

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

return await Deployment.RunAsync(() => 
{
    // when using AD authentication
    var myFabricCredAd = new DbtCloud.FabricCredential("my_fabric_cred_ad", new()
    {
        ProjectId = dbtProject.Id,
        AdapterId = myFabricConnection.AdapterId,
        Schema = "my_schema",
        User = "my_user",
        Password = "my_password",
        SchemaAuthorization = "abcd",
    });

    // when using service principal authentication
    var myFabricCredServPrinc = new DbtCloud.FabricCredential("my_fabric_cred_serv_princ", new()
    {
        ProjectId = dbtProject.Id,
        AdapterId = myFabricConnection.AdapterId,
        Schema = "my_schema",
        ClientId = "my_client_id",
        TenantId = "my_tenant_id",
        ClientSecret = "my_secret",
        SchemaAuthorization = "abcd",
    });

});

    package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.dbtcloud.FabricCredential;
import com.pulumi.dbtcloud.FabricCredentialArgs;
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) {
        // when using AD authentication
        var myFabricCredAd = new FabricCredential("myFabricCredAd", FabricCredentialArgs.builder()
            .projectId(dbtProject.id())
            .adapterId(myFabricConnection.adapterId())
            .schema("my_schema")
            .user("my_user")
            .password("my_password")
            .schemaAuthorization("abcd")
            .build());

        // when using service principal authentication
        var myFabricCredServPrinc = new FabricCredential("myFabricCredServPrinc", FabricCredentialArgs.builder()
            .projectId(dbtProject.id())
            .adapterId(myFabricConnection.adapterId())
            .schema("my_schema")
            .clientId("my_client_id")
            .tenantId("my_tenant_id")
            .clientSecret("my_secret")
            .schemaAuthorization("abcd")
            .build());

    }
}

    resources:
  # when using AD authentication
  myFabricCredAd:
    type: dbtcloud:FabricCredential
    name: my_fabric_cred_ad
    properties:
      projectId: ${dbtProject.id}
      adapterId: ${myFabricConnection.adapterId}
      schema: my_schema
      user: my_user
      password: my_password
      schemaAuthorization: abcd
  # when using service principal authentication
  myFabricCredServPrinc:
    type: dbtcloud:FabricCredential
    name: my_fabric_cred_serv_princ
    properties:
      projectId: ${dbtProject.id}
      adapterId: ${myFabricConnection.adapterId}
      schema: my_schema
      clientId: my_client_id
      tenantId: my_tenant_id
      clientSecret: my_secret
      schemaAuthorization: abcd

    Create FabricCredential Resource

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

    Constructor syntax

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

@overload
def FabricCredential(resource_name: str,
                     opts: Optional[ResourceOptions] = None,
                     adapter_id: Optional[int] = None,
                     project_id: Optional[int] = None,
                     schema: Optional[str] = None,
                     client_id: Optional[str] = None,
                     client_secret: Optional[str] = None,
                     password: Optional[str] = None,
                     schema_authorization: Optional[str] = None,
                     tenant_id: Optional[str] = None,
                     user: Optional[str] = None)
    func NewFabricCredential(ctx *Context, name string, args FabricCredentialArgs, opts ...ResourceOption) (*FabricCredential, error)
    public FabricCredential(string name, FabricCredentialArgs args, CustomResourceOptions? opts = null)
    public FabricCredential(String name, FabricCredentialArgs args)
public FabricCredential(String name, FabricCredentialArgs args, CustomResourceOptions options)

    type: dbtcloud:FabricCredential
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 FabricCredentialArgs
    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 FabricCredentialArgs
    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 FabricCredentialArgs
    The arguments to resource properties.
    opts ResourceOption
    Bag of options to control resource's behavior.
    name string
    The unique name of the resource.
    args FabricCredentialArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    name String
    The unique name of the resource.
    args FabricCredentialArgs
    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 fabricCredentialResource = new DbtCloud.FabricCredential("fabricCredentialResource", new()
{
    AdapterId = 0,
    ProjectId = 0,
    Schema = "string",
    ClientId = "string",
    ClientSecret = "string",
    Password = "string",
    SchemaAuthorization = "string",
    TenantId = "string",
    User = "string",
});

    example, err := dbtcloud.NewFabricCredential(ctx, "fabricCredentialResource", &dbtcloud.FabricCredentialArgs{
	AdapterId:           pulumi.Int(0),
	ProjectId:           pulumi.Int(0),
	Schema:              pulumi.String("string"),
	ClientId:            pulumi.String("string"),
	ClientSecret:        pulumi.String("string"),
	Password:            pulumi.String("string"),
	SchemaAuthorization: pulumi.String("string"),
	TenantId:            pulumi.String("string"),
	User:                pulumi.String("string"),
})

    var fabricCredentialResource = new FabricCredential("fabricCredentialResource", FabricCredentialArgs.builder()
    .adapterId(0)
    .projectId(0)
    .schema("string")
    .clientId("string")
    .clientSecret("string")
    .password("string")
    .schemaAuthorization("string")
    .tenantId("string")
    .user("string")
    .build());

    fabric_credential_resource = dbtcloud.FabricCredential("fabricCredentialResource",
    adapter_id=0,
    project_id=0,
    schema="string",
    client_id="string",
    client_secret="string",
    password="string",
    schema_authorization="string",
    tenant_id="string",
    user="string")

    const fabricCredentialResource = new dbtcloud.FabricCredential("fabricCredentialResource", {
    adapterId: 0,
    projectId: 0,
    schema: "string",
    clientId: "string",
    clientSecret: "string",
    password: "string",
    schemaAuthorization: "string",
    tenantId: "string",
    user: "string",
});

    type: dbtcloud:FabricCredential
properties:
    adapterId: 0
    clientId: string
    clientSecret: string
    password: string
    projectId: 0
    schema: string
    schemaAuthorization: string
    tenantId: string
    user: string

    FabricCredential Resource Properties

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

    Inputs

    The FabricCredential resource accepts the following input properties:

    AdapterId int
    Fabric adapter ID for the credential
    ProjectId int
    Project ID to create the Fabric credential in
    Schema string
    The schema where to create the dbt models
    ClientId string
    The client ID of the Azure Active Directory service principal. This is only used when connecting to Azure SQL with an AAD service principal.
    ClientSecret string
    The client secret of the Azure Active Directory service principal. This is only used when connecting to Azure SQL with an AAD service principal.
    Password string
    The password for the account to connect to. Only used when connection with AD user/pass
    SchemaAuthorization string
    Optionally set this to the principal who should own the schemas created by dbt
    TenantId string
    The tenant ID of the Azure Active Directory instance. This is only used when connecting to Azure SQL with a service principal.
    User string
    The username of the Fabric account to connect to. Only used when connection with AD user/pass
    AdapterId int
    Fabric adapter ID for the credential
    ProjectId int
    Project ID to create the Fabric credential in
    Schema string
    The schema where to create the dbt models
    ClientId string
    The client ID of the Azure Active Directory service principal. This is only used when connecting to Azure SQL with an AAD service principal.
    ClientSecret string
    The client secret of the Azure Active Directory service principal. This is only used when connecting to Azure SQL with an AAD service principal.
    Password string
    The password for the account to connect to. Only used when connection with AD user/pass
    SchemaAuthorization string
    Optionally set this to the principal who should own the schemas created by dbt
    TenantId string
    The tenant ID of the Azure Active Directory instance. This is only used when connecting to Azure SQL with a service principal.
    User string
    The username of the Fabric account to connect to. Only used when connection with AD user/pass
    adapterId Integer
    Fabric adapter ID for the credential
    projectId Integer
    Project ID to create the Fabric credential in
    schema String
    The schema where to create the dbt models
    clientId String
    The client ID of the Azure Active Directory service principal. This is only used when connecting to Azure SQL with an AAD service principal.
    clientSecret String
    The client secret of the Azure Active Directory service principal. This is only used when connecting to Azure SQL with an AAD service principal.
    password String
    The password for the account to connect to. Only used when connection with AD user/pass
    schemaAuthorization String
    Optionally set this to the principal who should own the schemas created by dbt
    tenantId String
    The tenant ID of the Azure Active Directory instance. This is only used when connecting to Azure SQL with a service principal.
    user String
    The username of the Fabric account to connect to. Only used when connection with AD user/pass
    adapterId number
    Fabric adapter ID for the credential
    projectId number
    Project ID to create the Fabric credential in
    schema string
    The schema where to create the dbt models
    clientId string
    The client ID of the Azure Active Directory service principal. This is only used when connecting to Azure SQL with an AAD service principal.
    clientSecret string
    The client secret of the Azure Active Directory service principal. This is only used when connecting to Azure SQL with an AAD service principal.
    password string
    The password for the account to connect to. Only used when connection with AD user/pass
    schemaAuthorization string
    Optionally set this to the principal who should own the schemas created by dbt
    tenantId string
    The tenant ID of the Azure Active Directory instance. This is only used when connecting to Azure SQL with a service principal.
    user string
    The username of the Fabric account to connect to. Only used when connection with AD user/pass
    adapter_id int
    Fabric adapter ID for the credential
    project_id int
    Project ID to create the Fabric credential in
    schema str
    The schema where to create the dbt models
    client_id str
    The client ID of the Azure Active Directory service principal. This is only used when connecting to Azure SQL with an AAD service principal.
    client_secret str
    The client secret of the Azure Active Directory service principal. This is only used when connecting to Azure SQL with an AAD service principal.
    password str
    The password for the account to connect to. Only used when connection with AD user/pass
    schema_authorization str
    Optionally set this to the principal who should own the schemas created by dbt
    tenant_id str
    The tenant ID of the Azure Active Directory instance. This is only used when connecting to Azure SQL with a service principal.
    user str
    The username of the Fabric account to connect to. Only used when connection with AD user/pass
    adapterId Number
    Fabric adapter ID for the credential
    projectId Number
    Project ID to create the Fabric credential in
    schema String
    The schema where to create the dbt models
    clientId String
    The client ID of the Azure Active Directory service principal. This is only used when connecting to Azure SQL with an AAD service principal.
    clientSecret String
    The client secret of the Azure Active Directory service principal. This is only used when connecting to Azure SQL with an AAD service principal.
    password String
    The password for the account to connect to. Only used when connection with AD user/pass
    schemaAuthorization String
    Optionally set this to the principal who should own the schemas created by dbt
    tenantId String
    The tenant ID of the Azure Active Directory instance. This is only used when connecting to Azure SQL with a service principal.
    user String
    The username of the Fabric account to connect to. Only used when connection with AD user/pass

    Outputs

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

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

    Look up Existing FabricCredential Resource

    Get an existing FabricCredential 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?: FabricCredentialState, opts?: CustomResourceOptions): FabricCredential
    @staticmethod
def get(resource_name: str,
        id: str,
        opts: Optional[ResourceOptions] = None,
        adapter_id: Optional[int] = None,
        client_id: Optional[str] = None,
        client_secret: Optional[str] = None,
        credential_id: Optional[int] = None,
        password: Optional[str] = None,
        project_id: Optional[int] = None,
        schema: Optional[str] = None,
        schema_authorization: Optional[str] = None,
        tenant_id: Optional[str] = None,
        user: Optional[str] = None) -> FabricCredential
    func GetFabricCredential(ctx *Context, name string, id IDInput, state *FabricCredentialState, opts ...ResourceOption) (*FabricCredential, error)
    public static FabricCredential Get(string name, Input<string> id, FabricCredentialState? state, CustomResourceOptions? opts = null)
    public static FabricCredential get(String name, Output<String> id, FabricCredentialState state, CustomResourceOptions options)
    Resource lookup is not supported in YAML
    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:
    AdapterId int
    Fabric adapter ID for the credential
    ClientId string
    The client ID of the Azure Active Directory service principal. This is only used when connecting to Azure SQL with an AAD service principal.
    ClientSecret string
    The client secret of the Azure Active Directory service principal. This is only used when connecting to Azure SQL with an AAD service principal.
    CredentialId int
    The system Fabric credential ID
    Password string
    The password for the account to connect to. Only used when connection with AD user/pass
    ProjectId int
    Project ID to create the Fabric credential in
    Schema string
    The schema where to create the dbt models
    SchemaAuthorization string
    Optionally set this to the principal who should own the schemas created by dbt
    TenantId string
    The tenant ID of the Azure Active Directory instance. This is only used when connecting to Azure SQL with a service principal.
    User string
    The username of the Fabric account to connect to. Only used when connection with AD user/pass
    AdapterId int
    Fabric adapter ID for the credential
    ClientId string
    The client ID of the Azure Active Directory service principal. This is only used when connecting to Azure SQL with an AAD service principal.
    ClientSecret string
    The client secret of the Azure Active Directory service principal. This is only used when connecting to Azure SQL with an AAD service principal.
    CredentialId int
    The system Fabric credential ID
    Password string
    The password for the account to connect to. Only used when connection with AD user/pass
    ProjectId int
    Project ID to create the Fabric credential in
    Schema string
    The schema where to create the dbt models
    SchemaAuthorization string
    Optionally set this to the principal who should own the schemas created by dbt
    TenantId string
    The tenant ID of the Azure Active Directory instance. This is only used when connecting to Azure SQL with a service principal.
    User string
    The username of the Fabric account to connect to. Only used when connection with AD user/pass
    adapterId Integer
    Fabric adapter ID for the credential
    clientId String
    The client ID of the Azure Active Directory service principal. This is only used when connecting to Azure SQL with an AAD service principal.
    clientSecret String
    The client secret of the Azure Active Directory service principal. This is only used when connecting to Azure SQL with an AAD service principal.
    credentialId Integer
    The system Fabric credential ID
    password String
    The password for the account to connect to. Only used when connection with AD user/pass
    projectId Integer
    Project ID to create the Fabric credential in
    schema String
    The schema where to create the dbt models
    schemaAuthorization String
    Optionally set this to the principal who should own the schemas created by dbt
    tenantId String
    The tenant ID of the Azure Active Directory instance. This is only used when connecting to Azure SQL with a service principal.
    user String
    The username of the Fabric account to connect to. Only used when connection with AD user/pass
    adapterId number
    Fabric adapter ID for the credential
    clientId string
    The client ID of the Azure Active Directory service principal. This is only used when connecting to Azure SQL with an AAD service principal.
    clientSecret string
    The client secret of the Azure Active Directory service principal. This is only used when connecting to Azure SQL with an AAD service principal.
    credentialId number
    The system Fabric credential ID
    password string
    The password for the account to connect to. Only used when connection with AD user/pass
    projectId number
    Project ID to create the Fabric credential in
    schema string
    The schema where to create the dbt models
    schemaAuthorization string
    Optionally set this to the principal who should own the schemas created by dbt
    tenantId string
    The tenant ID of the Azure Active Directory instance. This is only used when connecting to Azure SQL with a service principal.
    user string
    The username of the Fabric account to connect to. Only used when connection with AD user/pass
    adapter_id int
    Fabric adapter ID for the credential
    client_id str
    The client ID of the Azure Active Directory service principal. This is only used when connecting to Azure SQL with an AAD service principal.
    client_secret str
    The client secret of the Azure Active Directory service principal. This is only used when connecting to Azure SQL with an AAD service principal.
    credential_id int
    The system Fabric credential ID
    password str
    The password for the account to connect to. Only used when connection with AD user/pass
    project_id int
    Project ID to create the Fabric credential in
    schema str
    The schema where to create the dbt models
    schema_authorization str
    Optionally set this to the principal who should own the schemas created by dbt
    tenant_id str
    The tenant ID of the Azure Active Directory instance. This is only used when connecting to Azure SQL with a service principal.
    user str
    The username of the Fabric account to connect to. Only used when connection with AD user/pass
    adapterId Number
    Fabric adapter ID for the credential
    clientId String
    The client ID of the Azure Active Directory service principal. This is only used when connecting to Azure SQL with an AAD service principal.
    clientSecret String
    The client secret of the Azure Active Directory service principal. This is only used when connecting to Azure SQL with an AAD service principal.
    credentialId Number
    The system Fabric credential ID
    password String
    The password for the account to connect to. Only used when connection with AD user/pass
    projectId Number
    Project ID to create the Fabric credential in
    schema String
    The schema where to create the dbt models
    schemaAuthorization String
    Optionally set this to the principal who should own the schemas created by dbt
    tenantId String
    The tenant ID of the Azure Active Directory instance. This is only used when connecting to Azure SQL with a service principal.
    user String
    The username of the Fabric account to connect to. Only used when connection with AD user/pass

    Import

    using import blocks (requires Terraform >= 1.5)

    import {

    to = dbtcloud_fabric_credential.my_fabric_credential

    id = “project_id:credential_id”

    }

    import {

    to = dbtcloud_fabric_credential.my_fabric_credential

    id = “12345:6789”

    }

    using the older import command

    $ pulumi import dbtcloud:index/fabricCredential:FabricCredential my_fabric_credential "project_id:credential_id"

    $ pulumi import dbtcloud:index/fabricCredential:FabricCredential my_fabric_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
    dbt Cloud v0.1.8 published on Tuesday, Jun 11, 2024 by Pulumi
    pulumi/pulumi-dbtcloud