Manages Snowflake platform metadata credentials for external metadata ingestion in dbt Cloud.
This resource configures credentials that allow dbt Cloud to connect directly to your Snowflake warehouse to ingest metadata outside of normal dbt project runs. This enables features like:
- Catalog Ingestion: Ingest metadata about tables/views not defined in dbt
- Cost Optimization: Query warehouse cost and performance data
- Cost Insights: Enhanced cost visibility and analysis
Note: At least one of
catalog_ingestion_enabled,cost_optimization_enabled, orcost_insights_enabledmust be enabled for the credential to be usable.
Note: The
connection_idcannot be changed after creation. To use a different connection, you must destroy and recreate the resource.
Example Usage
import * as pulumi from "@pulumi/pulumi";
import * as dbtcloud from "@pulumi/dbtcloud";
// Example: Snowflake Platform Metadata Credential with password auth
const passwordAuth = new dbtcloud.SnowflakePlatformMetadataCredential("password_auth", {
connectionId: snowflake.id,
catalogIngestionEnabled: true,
costOptimizationEnabled: true,
costInsightsEnabled: false,
authType: "password",
user: "METADATA_READER",
password: snowflakePassword,
role: "METADATA_READER_ROLE",
warehouse: "METADATA_WH",
});
// Example: Snowflake Platform Metadata Credential with keypair auth
const keypairAuth = new dbtcloud.SnowflakePlatformMetadataCredential("keypair_auth", {
connectionId: snowflake.id,
catalogIngestionEnabled: true,
costOptimizationEnabled: false,
costInsightsEnabled: false,
authType: "keypair",
user: "METADATA_READER",
privateKey: snowflakePrivateKey,
privateKeyPassphrase: snowflakePrivateKeyPassphrase,
role: "METADATA_READER_ROLE",
warehouse: "METADATA_WH",
});
import pulumi
import pulumi_dbtcloud as dbtcloud
# Example: Snowflake Platform Metadata Credential with password auth
password_auth = dbtcloud.SnowflakePlatformMetadataCredential("password_auth",
connection_id=snowflake["id"],
catalog_ingestion_enabled=True,
cost_optimization_enabled=True,
cost_insights_enabled=False,
auth_type="password",
user="METADATA_READER",
password=snowflake_password,
role="METADATA_READER_ROLE",
warehouse="METADATA_WH")
# Example: Snowflake Platform Metadata Credential with keypair auth
keypair_auth = dbtcloud.SnowflakePlatformMetadataCredential("keypair_auth",
connection_id=snowflake["id"],
catalog_ingestion_enabled=True,
cost_optimization_enabled=False,
cost_insights_enabled=False,
auth_type="keypair",
user="METADATA_READER",
private_key=snowflake_private_key,
private_key_passphrase=snowflake_private_key_passphrase,
role="METADATA_READER_ROLE",
warehouse="METADATA_WH")
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 {
// Example: Snowflake Platform Metadata Credential with password auth
_, err := dbtcloud.NewSnowflakePlatformMetadataCredential(ctx, "password_auth", &dbtcloud.SnowflakePlatformMetadataCredentialArgs{
ConnectionId: pulumi.Any(snowflake.Id),
CatalogIngestionEnabled: pulumi.Bool(true),
CostOptimizationEnabled: pulumi.Bool(true),
CostInsightsEnabled: pulumi.Bool(false),
AuthType: pulumi.String("password"),
User: pulumi.String("METADATA_READER"),
Password: pulumi.Any(snowflakePassword),
Role: pulumi.String("METADATA_READER_ROLE"),
Warehouse: pulumi.String("METADATA_WH"),
})
if err != nil {
return err
}
// Example: Snowflake Platform Metadata Credential with keypair auth
_, err = dbtcloud.NewSnowflakePlatformMetadataCredential(ctx, "keypair_auth", &dbtcloud.SnowflakePlatformMetadataCredentialArgs{
ConnectionId: pulumi.Any(snowflake.Id),
CatalogIngestionEnabled: pulumi.Bool(true),
CostOptimizationEnabled: pulumi.Bool(false),
CostInsightsEnabled: pulumi.Bool(false),
AuthType: pulumi.String("keypair"),
User: pulumi.String("METADATA_READER"),
PrivateKey: pulumi.Any(snowflakePrivateKey),
PrivateKeyPassphrase: pulumi.Any(snowflakePrivateKeyPassphrase),
Role: pulumi.String("METADATA_READER_ROLE"),
Warehouse: pulumi.String("METADATA_WH"),
})
if err != nil {
return err
}
return nil
})
}
using System.Collections.Generic;
using System.Linq;
using Pulumi;
using DbtCloud = Pulumi.DbtCloud;
return await Deployment.RunAsync(() =>
{
// Example: Snowflake Platform Metadata Credential with password auth
var passwordAuth = new DbtCloud.SnowflakePlatformMetadataCredential("password_auth", new()
{
ConnectionId = snowflake.Id,
CatalogIngestionEnabled = true,
CostOptimizationEnabled = true,
CostInsightsEnabled = false,
AuthType = "password",
User = "METADATA_READER",
Password = snowflakePassword,
Role = "METADATA_READER_ROLE",
Warehouse = "METADATA_WH",
});
// Example: Snowflake Platform Metadata Credential with keypair auth
var keypairAuth = new DbtCloud.SnowflakePlatformMetadataCredential("keypair_auth", new()
{
ConnectionId = snowflake.Id,
CatalogIngestionEnabled = true,
CostOptimizationEnabled = false,
CostInsightsEnabled = false,
AuthType = "keypair",
User = "METADATA_READER",
PrivateKey = snowflakePrivateKey,
PrivateKeyPassphrase = snowflakePrivateKeyPassphrase,
Role = "METADATA_READER_ROLE",
Warehouse = "METADATA_WH",
});
});
package generated_program;
import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.dbtcloud.SnowflakePlatformMetadataCredential;
import com.pulumi.dbtcloud.SnowflakePlatformMetadataCredentialArgs;
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) {
// Example: Snowflake Platform Metadata Credential with password auth
var passwordAuth = new SnowflakePlatformMetadataCredential("passwordAuth", SnowflakePlatformMetadataCredentialArgs.builder()
.connectionId(snowflake.id())
.catalogIngestionEnabled(true)
.costOptimizationEnabled(true)
.costInsightsEnabled(false)
.authType("password")
.user("METADATA_READER")
.password(snowflakePassword)
.role("METADATA_READER_ROLE")
.warehouse("METADATA_WH")
.build());
// Example: Snowflake Platform Metadata Credential with keypair auth
var keypairAuth = new SnowflakePlatformMetadataCredential("keypairAuth", SnowflakePlatformMetadataCredentialArgs.builder()
.connectionId(snowflake.id())
.catalogIngestionEnabled(true)
.costOptimizationEnabled(false)
.costInsightsEnabled(false)
.authType("keypair")
.user("METADATA_READER")
.privateKey(snowflakePrivateKey)
.privateKeyPassphrase(snowflakePrivateKeyPassphrase)
.role("METADATA_READER_ROLE")
.warehouse("METADATA_WH")
.build());
}
}
resources:
# Example: Snowflake Platform Metadata Credential with password auth
passwordAuth:
type: dbtcloud:SnowflakePlatformMetadataCredential
name: password_auth
properties:
connectionId: ${snowflake.id}
catalogIngestionEnabled: true
costOptimizationEnabled: true
costInsightsEnabled: false
authType: password
user: METADATA_READER
password: ${snowflakePassword}
role: METADATA_READER_ROLE
warehouse: METADATA_WH
# Example: Snowflake Platform Metadata Credential with keypair auth
keypairAuth:
type: dbtcloud:SnowflakePlatformMetadataCredential
name: keypair_auth
properties:
connectionId: ${snowflake.id}
catalogIngestionEnabled: true
costOptimizationEnabled: false
costInsightsEnabled: false
authType: keypair
user: METADATA_READER
privateKey: ${snowflakePrivateKey}
privateKeyPassphrase: ${snowflakePrivateKeyPassphrase}
role: METADATA_READER_ROLE
warehouse: METADATA_WH
Create SnowflakePlatformMetadataCredential Resource
Resources are created with functions called constructors. To learn more about declaring and configuring resources, see Resources.
Constructor syntax
new SnowflakePlatformMetadataCredential(name: string, args: SnowflakePlatformMetadataCredentialArgs, opts?: CustomResourceOptions);@overload
def SnowflakePlatformMetadataCredential(resource_name: str,
args: SnowflakePlatformMetadataCredentialArgs,
opts: Optional[ResourceOptions] = None)
@overload
def SnowflakePlatformMetadataCredential(resource_name: str,
opts: Optional[ResourceOptions] = None,
auth_type: Optional[str] = None,
connection_id: Optional[int] = None,
role: Optional[str] = None,
user: Optional[str] = None,
warehouse: Optional[str] = None,
catalog_ingestion_enabled: Optional[bool] = None,
cost_insights_enabled: Optional[bool] = None,
cost_optimization_enabled: Optional[bool] = None,
password: Optional[str] = None,
private_key: Optional[str] = None,
private_key_passphrase: Optional[str] = None)func NewSnowflakePlatformMetadataCredential(ctx *Context, name string, args SnowflakePlatformMetadataCredentialArgs, opts ...ResourceOption) (*SnowflakePlatformMetadataCredential, error)public SnowflakePlatformMetadataCredential(string name, SnowflakePlatformMetadataCredentialArgs args, CustomResourceOptions? opts = null)
public SnowflakePlatformMetadataCredential(String name, SnowflakePlatformMetadataCredentialArgs args)
public SnowflakePlatformMetadataCredential(String name, SnowflakePlatformMetadataCredentialArgs args, CustomResourceOptions options)
type: dbtcloud:SnowflakePlatformMetadataCredential
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 SnowflakePlatformMetadataCredentialArgs
- 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 SnowflakePlatformMetadataCredentialArgs
- 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 SnowflakePlatformMetadataCredentialArgs
- The arguments to resource properties.
- opts ResourceOption
- Bag of options to control resource's behavior.
- name string
- The unique name of the resource.
- args SnowflakePlatformMetadataCredentialArgs
- The arguments to resource properties.
- opts CustomResourceOptions
- Bag of options to control resource's behavior.
- name String
- The unique name of the resource.
- args SnowflakePlatformMetadataCredentialArgs
- 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 snowflakePlatformMetadataCredentialResource = new DbtCloud.SnowflakePlatformMetadataCredential("snowflakePlatformMetadataCredentialResource", new()
{
AuthType = "string",
ConnectionId = 0,
Role = "string",
User = "string",
Warehouse = "string",
CatalogIngestionEnabled = false,
CostInsightsEnabled = false,
CostOptimizationEnabled = false,
Password = "string",
PrivateKey = "string",
PrivateKeyPassphrase = "string",
});
example, err := dbtcloud.NewSnowflakePlatformMetadataCredential(ctx, "snowflakePlatformMetadataCredentialResource", &dbtcloud.SnowflakePlatformMetadataCredentialArgs{
AuthType: pulumi.String("string"),
ConnectionId: pulumi.Int(0),
Role: pulumi.String("string"),
User: pulumi.String("string"),
Warehouse: pulumi.String("string"),
CatalogIngestionEnabled: pulumi.Bool(false),
CostInsightsEnabled: pulumi.Bool(false),
CostOptimizationEnabled: pulumi.Bool(false),
Password: pulumi.String("string"),
PrivateKey: pulumi.String("string"),
PrivateKeyPassphrase: pulumi.String("string"),
})
var snowflakePlatformMetadataCredentialResource = new SnowflakePlatformMetadataCredential("snowflakePlatformMetadataCredentialResource", SnowflakePlatformMetadataCredentialArgs.builder()
.authType("string")
.connectionId(0)
.role("string")
.user("string")
.warehouse("string")
.catalogIngestionEnabled(false)
.costInsightsEnabled(false)
.costOptimizationEnabled(false)
.password("string")
.privateKey("string")
.privateKeyPassphrase("string")
.build());
snowflake_platform_metadata_credential_resource = dbtcloud.SnowflakePlatformMetadataCredential("snowflakePlatformMetadataCredentialResource",
auth_type="string",
connection_id=0,
role="string",
user="string",
warehouse="string",
catalog_ingestion_enabled=False,
cost_insights_enabled=False,
cost_optimization_enabled=False,
password="string",
private_key="string",
private_key_passphrase="string")
const snowflakePlatformMetadataCredentialResource = new dbtcloud.SnowflakePlatformMetadataCredential("snowflakePlatformMetadataCredentialResource", {
authType: "string",
connectionId: 0,
role: "string",
user: "string",
warehouse: "string",
catalogIngestionEnabled: false,
costInsightsEnabled: false,
costOptimizationEnabled: false,
password: "string",
privateKey: "string",
privateKeyPassphrase: "string",
});
type: dbtcloud:SnowflakePlatformMetadataCredential
properties:
authType: string
catalogIngestionEnabled: false
connectionId: 0
costInsightsEnabled: false
costOptimizationEnabled: false
password: string
privateKey: string
privateKeyPassphrase: string
role: string
user: string
warehouse: string
SnowflakePlatformMetadataCredential 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 SnowflakePlatformMetadataCredential resource accepts the following input properties:
- Auth
Type string - The authentication type. Must be 'password' or 'keypair'.
- Connection
Id int - The ID of the global connection this credential is associated with. Cannot be changed after creation.
- Role string
- The Snowflake role to use.
- User string
- The Snowflake user name.
- Warehouse string
- The Snowflake warehouse to use.
- Catalog
Ingestion boolEnabled - Whether catalog ingestion is enabled for this credential. When enabled, dbt Cloud will ingest metadata about tables, views, and other objects from your data warehouse.
- Cost
Insights boolEnabled - Whether cost insights is enabled for this credential.
- Cost
Optimization boolEnabled - Whether cost optimization data collection is enabled for this credential.
- Password string
- The password for password authentication. Required when authtype is 'password'. Cannot be used with privatekey or privatekeypassphrase.
- Private
Key string - The private key for keypair authentication. Required when auth_type is 'keypair'. Cannot be used with password.
- Private
Key stringPassphrase - The passphrase for the private key, if encrypted. Optional when auth_type is 'keypair'. Cannot be used with password.
- Auth
Type string - The authentication type. Must be 'password' or 'keypair'.
- Connection
Id int - The ID of the global connection this credential is associated with. Cannot be changed after creation.
- Role string
- The Snowflake role to use.
- User string
- The Snowflake user name.
- Warehouse string
- The Snowflake warehouse to use.
- Catalog
Ingestion boolEnabled - Whether catalog ingestion is enabled for this credential. When enabled, dbt Cloud will ingest metadata about tables, views, and other objects from your data warehouse.
- Cost
Insights boolEnabled - Whether cost insights is enabled for this credential.
- Cost
Optimization boolEnabled - Whether cost optimization data collection is enabled for this credential.
- Password string
- The password for password authentication. Required when authtype is 'password'. Cannot be used with privatekey or privatekeypassphrase.
- Private
Key string - The private key for keypair authentication. Required when auth_type is 'keypair'. Cannot be used with password.
- Private
Key stringPassphrase - The passphrase for the private key, if encrypted. Optional when auth_type is 'keypair'. Cannot be used with password.
- auth
Type String - The authentication type. Must be 'password' or 'keypair'.
- connection
Id Integer - The ID of the global connection this credential is associated with. Cannot be changed after creation.
- role String
- The Snowflake role to use.
- user String
- The Snowflake user name.
- warehouse String
- The Snowflake warehouse to use.
- catalog
Ingestion BooleanEnabled - Whether catalog ingestion is enabled for this credential. When enabled, dbt Cloud will ingest metadata about tables, views, and other objects from your data warehouse.
- cost
Insights BooleanEnabled - Whether cost insights is enabled for this credential.
- cost
Optimization BooleanEnabled - Whether cost optimization data collection is enabled for this credential.
- password String
- The password for password authentication. Required when authtype is 'password'. Cannot be used with privatekey or privatekeypassphrase.
- private
Key String - The private key for keypair authentication. Required when auth_type is 'keypair'. Cannot be used with password.
- private
Key StringPassphrase - The passphrase for the private key, if encrypted. Optional when auth_type is 'keypair'. Cannot be used with password.
- auth
Type string - The authentication type. Must be 'password' or 'keypair'.
- connection
Id number - The ID of the global connection this credential is associated with. Cannot be changed after creation.
- role string
- The Snowflake role to use.
- user string
- The Snowflake user name.
- warehouse string
- The Snowflake warehouse to use.
- catalog
Ingestion booleanEnabled - Whether catalog ingestion is enabled for this credential. When enabled, dbt Cloud will ingest metadata about tables, views, and other objects from your data warehouse.
- cost
Insights booleanEnabled - Whether cost insights is enabled for this credential.
- cost
Optimization booleanEnabled - Whether cost optimization data collection is enabled for this credential.
- password string
- The password for password authentication. Required when authtype is 'password'. Cannot be used with privatekey or privatekeypassphrase.
- private
Key string - The private key for keypair authentication. Required when auth_type is 'keypair'. Cannot be used with password.
- private
Key stringPassphrase - The passphrase for the private key, if encrypted. Optional when auth_type is 'keypair'. Cannot be used with password.
- auth_
type str - The authentication type. Must be 'password' or 'keypair'.
- connection_
id int - The ID of the global connection this credential is associated with. Cannot be changed after creation.
- role str
- The Snowflake role to use.
- user str
- The Snowflake user name.
- warehouse str
- The Snowflake warehouse to use.
- catalog_
ingestion_ boolenabled - Whether catalog ingestion is enabled for this credential. When enabled, dbt Cloud will ingest metadata about tables, views, and other objects from your data warehouse.
- cost_
insights_ boolenabled - Whether cost insights is enabled for this credential.
- cost_
optimization_ boolenabled - Whether cost optimization data collection is enabled for this credential.
- password str
- The password for password authentication. Required when authtype is 'password'. Cannot be used with privatekey or privatekeypassphrase.
- private_
key str - The private key for keypair authentication. Required when auth_type is 'keypair'. Cannot be used with password.
- private_
key_ strpassphrase - The passphrase for the private key, if encrypted. Optional when auth_type is 'keypair'. Cannot be used with password.
- auth
Type String - The authentication type. Must be 'password' or 'keypair'.
- connection
Id Number - The ID of the global connection this credential is associated with. Cannot be changed after creation.
- role String
- The Snowflake role to use.
- user String
- The Snowflake user name.
- warehouse String
- The Snowflake warehouse to use.
- catalog
Ingestion BooleanEnabled - Whether catalog ingestion is enabled for this credential. When enabled, dbt Cloud will ingest metadata about tables, views, and other objects from your data warehouse.
- cost
Insights BooleanEnabled - Whether cost insights is enabled for this credential.
- cost
Optimization BooleanEnabled - Whether cost optimization data collection is enabled for this credential.
- password String
- The password for password authentication. Required when authtype is 'password'. Cannot be used with privatekey or privatekeypassphrase.
- private
Key String - The private key for keypair authentication. Required when auth_type is 'keypair'. Cannot be used with password.
- private
Key StringPassphrase - The passphrase for the private key, if encrypted. Optional when auth_type is 'keypair'. Cannot be used with password.
Outputs
All input properties are implicitly available as output properties. Additionally, the SnowflakePlatformMetadataCredential resource produces the following output properties:
- Adapter
Version string - The adapter version derived from the connection (e.g., 'snowflakev0', 'databricksv0'). This is read-only and determined by the connection.
- Credential
Id int - The ID of the platform metadata credential.
- Id string
- The provider-assigned unique ID for this managed resource.
- Adapter
Version string - The adapter version derived from the connection (e.g., 'snowflakev0', 'databricksv0'). This is read-only and determined by the connection.
- Credential
Id int - The ID of the platform metadata credential.
- Id string
- The provider-assigned unique ID for this managed resource.
- adapter
Version String - The adapter version derived from the connection (e.g., 'snowflakev0', 'databricksv0'). This is read-only and determined by the connection.
- credential
Id Integer - The ID of the platform metadata credential.
- id String
- The provider-assigned unique ID for this managed resource.
- adapter
Version string - The adapter version derived from the connection (e.g., 'snowflakev0', 'databricksv0'). This is read-only and determined by the connection.
- credential
Id number - The ID of the platform metadata credential.
- id string
- The provider-assigned unique ID for this managed resource.
- adapter_
version str - The adapter version derived from the connection (e.g., 'snowflakev0', 'databricksv0'). This is read-only and determined by the connection.
- credential_
id int - The ID of the platform metadata credential.
- id str
- The provider-assigned unique ID for this managed resource.
- adapter
Version String - The adapter version derived from the connection (e.g., 'snowflakev0', 'databricksv0'). This is read-only and determined by the connection.
- credential
Id Number - The ID of the platform metadata credential.
- id String
- The provider-assigned unique ID for this managed resource.
Look up Existing SnowflakePlatformMetadataCredential Resource
Get an existing SnowflakePlatformMetadataCredential 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?: SnowflakePlatformMetadataCredentialState, opts?: CustomResourceOptions): SnowflakePlatformMetadataCredential@staticmethod
def get(resource_name: str,
id: str,
opts: Optional[ResourceOptions] = None,
adapter_version: Optional[str] = None,
auth_type: Optional[str] = None,
catalog_ingestion_enabled: Optional[bool] = None,
connection_id: Optional[int] = None,
cost_insights_enabled: Optional[bool] = None,
cost_optimization_enabled: Optional[bool] = None,
credential_id: Optional[int] = None,
password: Optional[str] = None,
private_key: Optional[str] = None,
private_key_passphrase: Optional[str] = None,
role: Optional[str] = None,
user: Optional[str] = None,
warehouse: Optional[str] = None) -> SnowflakePlatformMetadataCredentialfunc GetSnowflakePlatformMetadataCredential(ctx *Context, name string, id IDInput, state *SnowflakePlatformMetadataCredentialState, opts ...ResourceOption) (*SnowflakePlatformMetadataCredential, error)public static SnowflakePlatformMetadataCredential Get(string name, Input<string> id, SnowflakePlatformMetadataCredentialState? state, CustomResourceOptions? opts = null)public static SnowflakePlatformMetadataCredential get(String name, Output<String> id, SnowflakePlatformMetadataCredentialState state, CustomResourceOptions options)resources: _: type: dbtcloud:SnowflakePlatformMetadataCredential get: id: ${id}- name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- resource_name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- Adapter
Version string - The adapter version derived from the connection (e.g., 'snowflakev0', 'databricksv0'). This is read-only and determined by the connection.
- Auth
Type string - The authentication type. Must be 'password' or 'keypair'.
- Catalog
Ingestion boolEnabled - Whether catalog ingestion is enabled for this credential. When enabled, dbt Cloud will ingest metadata about tables, views, and other objects from your data warehouse.
- Connection
Id int - The ID of the global connection this credential is associated with. Cannot be changed after creation.
- Cost
Insights boolEnabled - Whether cost insights is enabled for this credential.
- Cost
Optimization boolEnabled - Whether cost optimization data collection is enabled for this credential.
- Credential
Id int - The ID of the platform metadata credential.
- Password string
- The password for password authentication. Required when authtype is 'password'. Cannot be used with privatekey or privatekeypassphrase.
- Private
Key string - The private key for keypair authentication. Required when auth_type is 'keypair'. Cannot be used with password.
- Private
Key stringPassphrase - The passphrase for the private key, if encrypted. Optional when auth_type is 'keypair'. Cannot be used with password.
- Role string
- The Snowflake role to use.
- User string
- The Snowflake user name.
- Warehouse string
- The Snowflake warehouse to use.
- Adapter
Version string - The adapter version derived from the connection (e.g., 'snowflakev0', 'databricksv0'). This is read-only and determined by the connection.
- Auth
Type string - The authentication type. Must be 'password' or 'keypair'.
- Catalog
Ingestion boolEnabled - Whether catalog ingestion is enabled for this credential. When enabled, dbt Cloud will ingest metadata about tables, views, and other objects from your data warehouse.
- Connection
Id int - The ID of the global connection this credential is associated with. Cannot be changed after creation.
- Cost
Insights boolEnabled - Whether cost insights is enabled for this credential.
- Cost
Optimization boolEnabled - Whether cost optimization data collection is enabled for this credential.
- Credential
Id int - The ID of the platform metadata credential.
- Password string
- The password for password authentication. Required when authtype is 'password'. Cannot be used with privatekey or privatekeypassphrase.
- Private
Key string - The private key for keypair authentication. Required when auth_type is 'keypair'. Cannot be used with password.
- Private
Key stringPassphrase - The passphrase for the private key, if encrypted. Optional when auth_type is 'keypair'. Cannot be used with password.
- Role string
- The Snowflake role to use.
- User string
- The Snowflake user name.
- Warehouse string
- The Snowflake warehouse to use.
- adapter
Version String - The adapter version derived from the connection (e.g., 'snowflakev0', 'databricksv0'). This is read-only and determined by the connection.
- auth
Type String - The authentication type. Must be 'password' or 'keypair'.
- catalog
Ingestion BooleanEnabled - Whether catalog ingestion is enabled for this credential. When enabled, dbt Cloud will ingest metadata about tables, views, and other objects from your data warehouse.
- connection
Id Integer - The ID of the global connection this credential is associated with. Cannot be changed after creation.
- cost
Insights BooleanEnabled - Whether cost insights is enabled for this credential.
- cost
Optimization BooleanEnabled - Whether cost optimization data collection is enabled for this credential.
- credential
Id Integer - The ID of the platform metadata credential.
- password String
- The password for password authentication. Required when authtype is 'password'. Cannot be used with privatekey or privatekeypassphrase.
- private
Key String - The private key for keypair authentication. Required when auth_type is 'keypair'. Cannot be used with password.
- private
Key StringPassphrase - The passphrase for the private key, if encrypted. Optional when auth_type is 'keypair'. Cannot be used with password.
- role String
- The Snowflake role to use.
- user String
- The Snowflake user name.
- warehouse String
- The Snowflake warehouse to use.
- adapter
Version string - The adapter version derived from the connection (e.g., 'snowflakev0', 'databricksv0'). This is read-only and determined by the connection.
- auth
Type string - The authentication type. Must be 'password' or 'keypair'.
- catalog
Ingestion booleanEnabled - Whether catalog ingestion is enabled for this credential. When enabled, dbt Cloud will ingest metadata about tables, views, and other objects from your data warehouse.
- connection
Id number - The ID of the global connection this credential is associated with. Cannot be changed after creation.
- cost
Insights booleanEnabled - Whether cost insights is enabled for this credential.
- cost
Optimization booleanEnabled - Whether cost optimization data collection is enabled for this credential.
- credential
Id number - The ID of the platform metadata credential.
- password string
- The password for password authentication. Required when authtype is 'password'. Cannot be used with privatekey or privatekeypassphrase.
- private
Key string - The private key for keypair authentication. Required when auth_type is 'keypair'. Cannot be used with password.
- private
Key stringPassphrase - The passphrase for the private key, if encrypted. Optional when auth_type is 'keypair'. Cannot be used with password.
- role string
- The Snowflake role to use.
- user string
- The Snowflake user name.
- warehouse string
- The Snowflake warehouse to use.
- adapter_
version str - The adapter version derived from the connection (e.g., 'snowflakev0', 'databricksv0'). This is read-only and determined by the connection.
- auth_
type str - The authentication type. Must be 'password' or 'keypair'.
- catalog_
ingestion_ boolenabled - Whether catalog ingestion is enabled for this credential. When enabled, dbt Cloud will ingest metadata about tables, views, and other objects from your data warehouse.
- connection_
id int - The ID of the global connection this credential is associated with. Cannot be changed after creation.
- cost_
insights_ boolenabled - Whether cost insights is enabled for this credential.
- cost_
optimization_ boolenabled - Whether cost optimization data collection is enabled for this credential.
- credential_
id int - The ID of the platform metadata credential.
- password str
- The password for password authentication. Required when authtype is 'password'. Cannot be used with privatekey or privatekeypassphrase.
- private_
key str - The private key for keypair authentication. Required when auth_type is 'keypair'. Cannot be used with password.
- private_
key_ strpassphrase - The passphrase for the private key, if encrypted. Optional when auth_type is 'keypair'. Cannot be used with password.
- role str
- The Snowflake role to use.
- user str
- The Snowflake user name.
- warehouse str
- The Snowflake warehouse to use.
- adapter
Version String - The adapter version derived from the connection (e.g., 'snowflakev0', 'databricksv0'). This is read-only and determined by the connection.
- auth
Type String - The authentication type. Must be 'password' or 'keypair'.
- catalog
Ingestion BooleanEnabled - Whether catalog ingestion is enabled for this credential. When enabled, dbt Cloud will ingest metadata about tables, views, and other objects from your data warehouse.
- connection
Id Number - The ID of the global connection this credential is associated with. Cannot be changed after creation.
- cost
Insights BooleanEnabled - Whether cost insights is enabled for this credential.
- cost
Optimization BooleanEnabled - Whether cost optimization data collection is enabled for this credential.
- credential
Id Number - The ID of the platform metadata credential.
- password String
- The password for password authentication. Required when authtype is 'password'. Cannot be used with privatekey or privatekeypassphrase.
- private
Key String - The private key for keypair authentication. Required when auth_type is 'keypair'. Cannot be used with password.
- private
Key StringPassphrase - The passphrase for the private key, if encrypted. Optional when auth_type is 'keypair'. Cannot be used with password.
- role String
- The Snowflake role to use.
- user String
- The Snowflake user name.
- warehouse String
- The Snowflake warehouse to use.
Package Details
- Repository
- dbtcloud pulumi/pulumi-dbtcloud
- License
- Apache-2.0
- Notes
- This Pulumi package is based on the
dbtcloudTerraform Provider.
