Snowflake v1.1.4, Mar 26 25

Snowflake v1.1.4 published on Wednesday, Mar 26, 2025 by Pulumi

snowflake.getDatabases

Explore with Pulumi AI

Snowflake v1.1.4 published on Wednesday, Mar 26, 2025 by Pulumi

Using getDatabases

Two invocation forms are available. The direct form accepts plain arguments and either blocks until the result value is available, or returns a Promise-wrapped result. The output form accepts Input-wrapped arguments and returns an Output-wrapped result.

TypeScript
Python
Go
C#
Java
YAML

function getDatabases(args: GetDatabasesArgs, opts?: InvokeOptions): Promise<GetDatabasesResult>
function getDatabasesOutput(args: GetDatabasesOutputArgs, opts?: InvokeOptions): Output<GetDatabasesResult>

def get_databases(like: Optional[str] = None,
                  limit: Optional[GetDatabasesLimit] = None,
                  starts_with: Optional[str] = None,
                  with_describe: Optional[bool] = None,
                  with_parameters: Optional[bool] = None,
                  opts: Optional[InvokeOptions] = None) -> GetDatabasesResult
def get_databases_output(like: Optional[pulumi.Input[str]] = None,
                  limit: Optional[pulumi.Input[GetDatabasesLimitArgs]] = None,
                  starts_with: Optional[pulumi.Input[str]] = None,
                  with_describe: Optional[pulumi.Input[bool]] = None,
                  with_parameters: Optional[pulumi.Input[bool]] = None,
                  opts: Optional[InvokeOptions] = None) -> Output[GetDatabasesResult]

func GetDatabases(ctx *Context, args *GetDatabasesArgs, opts ...InvokeOption) (*GetDatabasesResult, error)
func GetDatabasesOutput(ctx *Context, args *GetDatabasesOutputArgs, opts ...InvokeOption) GetDatabasesResultOutput

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

public static class GetDatabases 
{
    public static Task<GetDatabasesResult> InvokeAsync(GetDatabasesArgs args, InvokeOptions? opts = null)
    public static Output<GetDatabasesResult> Invoke(GetDatabasesInvokeArgs args, InvokeOptions? opts = null)
}

public static CompletableFuture<GetDatabasesResult> getDatabases(GetDatabasesArgs args, InvokeOptions options)
public static Output<GetDatabasesResult> getDatabases(GetDatabasesArgs args, InvokeOptions options)

fn::invoke:
  function: snowflake:index/getDatabases:getDatabases
  arguments:
    # arguments dictionary

The following arguments are supported:

Like string: Filters the output with case-insensitive pattern, with support for SQL wildcard characters (% and _).
Limit GetDatabasesLimit: Limits the number of rows returned. If the limit.from is set, then the limit wll start from the first element matched by the expression. The expression is only used to match with the first element, later on the elements are not matched by the prefix, but you can enforce a certain pattern with starts_with or like.
StartsWith string: Filters the output with case-sensitive characters indicating the beginning of the object name.
WithDescribe bool: Runs DESC DATABASE for each database returned by SHOW DATABASES. The output of describe is saved to the description field. By default this value is set to true.
WithParameters bool: Runs SHOW PARAMETERS FOR DATABASE for each database returned by SHOW DATABASES. The output of describe is saved to the parameters field as a map. By default this value is set to true.

Like string: Filters the output with case-insensitive pattern, with support for SQL wildcard characters (% and _).
Limit GetDatabasesLimit: Limits the number of rows returned. If the limit.from is set, then the limit wll start from the first element matched by the expression. The expression is only used to match with the first element, later on the elements are not matched by the prefix, but you can enforce a certain pattern with starts_with or like.
StartsWith string: Filters the output with case-sensitive characters indicating the beginning of the object name.
WithDescribe bool: Runs DESC DATABASE for each database returned by SHOW DATABASES. The output of describe is saved to the description field. By default this value is set to true.
WithParameters bool: Runs SHOW PARAMETERS FOR DATABASE for each database returned by SHOW DATABASES. The output of describe is saved to the parameters field as a map. By default this value is set to true.

like String: Filters the output with case-insensitive pattern, with support for SQL wildcard characters (% and _).
limit GetDatabasesLimit: Limits the number of rows returned. If the limit.from is set, then the limit wll start from the first element matched by the expression. The expression is only used to match with the first element, later on the elements are not matched by the prefix, but you can enforce a certain pattern with starts_with or like.
startsWith String: Filters the output with case-sensitive characters indicating the beginning of the object name.
withDescribe Boolean: Runs DESC DATABASE for each database returned by SHOW DATABASES. The output of describe is saved to the description field. By default this value is set to true.
withParameters Boolean: Runs SHOW PARAMETERS FOR DATABASE for each database returned by SHOW DATABASES. The output of describe is saved to the parameters field as a map. By default this value is set to true.

like string: Filters the output with case-insensitive pattern, with support for SQL wildcard characters (% and _).
limit GetDatabasesLimit: Limits the number of rows returned. If the limit.from is set, then the limit wll start from the first element matched by the expression. The expression is only used to match with the first element, later on the elements are not matched by the prefix, but you can enforce a certain pattern with starts_with or like.
startsWith string: Filters the output with case-sensitive characters indicating the beginning of the object name.
withDescribe boolean: Runs DESC DATABASE for each database returned by SHOW DATABASES. The output of describe is saved to the description field. By default this value is set to true.
withParameters boolean: Runs SHOW PARAMETERS FOR DATABASE for each database returned by SHOW DATABASES. The output of describe is saved to the parameters field as a map. By default this value is set to true.

like str: Filters the output with case-insensitive pattern, with support for SQL wildcard characters (% and _).
limit GetDatabasesLimit: Limits the number of rows returned. If the limit.from is set, then the limit wll start from the first element matched by the expression. The expression is only used to match with the first element, later on the elements are not matched by the prefix, but you can enforce a certain pattern with starts_with or like.
starts_with str: Filters the output with case-sensitive characters indicating the beginning of the object name.
with_describe bool: Runs DESC DATABASE for each database returned by SHOW DATABASES. The output of describe is saved to the description field. By default this value is set to true.
with_parameters bool: Runs SHOW PARAMETERS FOR DATABASE for each database returned by SHOW DATABASES. The output of describe is saved to the parameters field as a map. By default this value is set to true.

like String: Filters the output with case-insensitive pattern, with support for SQL wildcard characters (% and _).
limit Property Map: Limits the number of rows returned. If the limit.from is set, then the limit wll start from the first element matched by the expression. The expression is only used to match with the first element, later on the elements are not matched by the prefix, but you can enforce a certain pattern with starts_with or like.
startsWith String: Filters the output with case-sensitive characters indicating the beginning of the object name.
withDescribe Boolean: Runs DESC DATABASE for each database returned by SHOW DATABASES. The output of describe is saved to the description field. By default this value is set to true.
withParameters Boolean: Runs SHOW PARAMETERS FOR DATABASE for each database returned by SHOW DATABASES. The output of describe is saved to the parameters field as a map. By default this value is set to true.

getDatabases Result

The following output properties are available:

Databases List<GetDatabasesDatabase>: Holds the aggregated output of all database details queries.
Id string: The provider-assigned unique ID for this managed resource.
Like string: Filters the output with case-insensitive pattern, with support for SQL wildcard characters (% and _).
Limit GetDatabasesLimit: Limits the number of rows returned. If the limit.from is set, then the limit wll start from the first element matched by the expression. The expression is only used to match with the first element, later on the elements are not matched by the prefix, but you can enforce a certain pattern with starts_with or like.
StartsWith string: Filters the output with case-sensitive characters indicating the beginning of the object name.
WithDescribe bool: Runs DESC DATABASE for each database returned by SHOW DATABASES. The output of describe is saved to the description field. By default this value is set to true.
WithParameters bool: Runs SHOW PARAMETERS FOR DATABASE for each database returned by SHOW DATABASES. The output of describe is saved to the parameters field as a map. By default this value is set to true.

Databases []GetDatabasesDatabase: Holds the aggregated output of all database details queries.
Id string: The provider-assigned unique ID for this managed resource.
Like string: Filters the output with case-insensitive pattern, with support for SQL wildcard characters (% and _).
Limit GetDatabasesLimit: Limits the number of rows returned. If the limit.from is set, then the limit wll start from the first element matched by the expression. The expression is only used to match with the first element, later on the elements are not matched by the prefix, but you can enforce a certain pattern with starts_with or like.
StartsWith string: Filters the output with case-sensitive characters indicating the beginning of the object name.
WithDescribe bool: Runs DESC DATABASE for each database returned by SHOW DATABASES. The output of describe is saved to the description field. By default this value is set to true.
WithParameters bool: Runs SHOW PARAMETERS FOR DATABASE for each database returned by SHOW DATABASES. The output of describe is saved to the parameters field as a map. By default this value is set to true.

databases List<GetDatabasesDatabase>: Holds the aggregated output of all database details queries.
id String: The provider-assigned unique ID for this managed resource.
like String: Filters the output with case-insensitive pattern, with support for SQL wildcard characters (% and _).
limit GetDatabasesLimit: Limits the number of rows returned. If the limit.from is set, then the limit wll start from the first element matched by the expression. The expression is only used to match with the first element, later on the elements are not matched by the prefix, but you can enforce a certain pattern with starts_with or like.
startsWith String: Filters the output with case-sensitive characters indicating the beginning of the object name.
withDescribe Boolean: Runs DESC DATABASE for each database returned by SHOW DATABASES. The output of describe is saved to the description field. By default this value is set to true.
withParameters Boolean: Runs SHOW PARAMETERS FOR DATABASE for each database returned by SHOW DATABASES. The output of describe is saved to the parameters field as a map. By default this value is set to true.

databases GetDatabasesDatabase[]: Holds the aggregated output of all database details queries.
id string: The provider-assigned unique ID for this managed resource.
like string: Filters the output with case-insensitive pattern, with support for SQL wildcard characters (% and _).
limit GetDatabasesLimit: Limits the number of rows returned. If the limit.from is set, then the limit wll start from the first element matched by the expression. The expression is only used to match with the first element, later on the elements are not matched by the prefix, but you can enforce a certain pattern with starts_with or like.
startsWith string: Filters the output with case-sensitive characters indicating the beginning of the object name.
withDescribe boolean: Runs DESC DATABASE for each database returned by SHOW DATABASES. The output of describe is saved to the description field. By default this value is set to true.
withParameters boolean: Runs SHOW PARAMETERS FOR DATABASE for each database returned by SHOW DATABASES. The output of describe is saved to the parameters field as a map. By default this value is set to true.

databases Sequence[GetDatabasesDatabase]: Holds the aggregated output of all database details queries.
id str: The provider-assigned unique ID for this managed resource.
like str: Filters the output with case-insensitive pattern, with support for SQL wildcard characters (% and _).
limit GetDatabasesLimit: Limits the number of rows returned. If the limit.from is set, then the limit wll start from the first element matched by the expression. The expression is only used to match with the first element, later on the elements are not matched by the prefix, but you can enforce a certain pattern with starts_with or like.
starts_with str: Filters the output with case-sensitive characters indicating the beginning of the object name.
with_describe bool: Runs DESC DATABASE for each database returned by SHOW DATABASES. The output of describe is saved to the description field. By default this value is set to true.
with_parameters bool: Runs SHOW PARAMETERS FOR DATABASE for each database returned by SHOW DATABASES. The output of describe is saved to the parameters field as a map. By default this value is set to true.

databases List<Property Map>: Holds the aggregated output of all database details queries.
id String: The provider-assigned unique ID for this managed resource.
like String: Filters the output with case-insensitive pattern, with support for SQL wildcard characters (% and _).
limit Property Map: Limits the number of rows returned. If the limit.from is set, then the limit wll start from the first element matched by the expression. The expression is only used to match with the first element, later on the elements are not matched by the prefix, but you can enforce a certain pattern with starts_with or like.
startsWith String: Filters the output with case-sensitive characters indicating the beginning of the object name.
withDescribe Boolean: Runs DESC DATABASE for each database returned by SHOW DATABASES. The output of describe is saved to the description field. By default this value is set to true.
withParameters Boolean: Runs SHOW PARAMETERS FOR DATABASE for each database returned by SHOW DATABASES. The output of describe is saved to the parameters field as a map. By default this value is set to true.

Supporting Types

GetDatabasesDatabase

DescribeOutputs List<GetDatabasesDatabaseDescribeOutput>: Holds the output of DESCRIBE DATABASE.
Parameters List<GetDatabasesDatabaseParameter>: Holds the output of SHOW PARAMETERS FOR DATABASE.
ShowOutputs List<GetDatabasesDatabaseShowOutput>: Holds the output of SHOW DATABASES.

DescribeOutputs []GetDatabasesDatabaseDescribeOutput: Holds the output of DESCRIBE DATABASE.
Parameters []GetDatabasesDatabaseParameter: Holds the output of SHOW PARAMETERS FOR DATABASE.
ShowOutputs []GetDatabasesDatabaseShowOutput: Holds the output of SHOW DATABASES.

describeOutputs List<GetDatabasesDatabaseDescribeOutput>: Holds the output of DESCRIBE DATABASE.
parameters List<GetDatabasesDatabaseParameter>: Holds the output of SHOW PARAMETERS FOR DATABASE.
showOutputs List<GetDatabasesDatabaseShowOutput>: Holds the output of SHOW DATABASES.

describeOutputs GetDatabasesDatabaseDescribeOutput[]: Holds the output of DESCRIBE DATABASE.
parameters GetDatabasesDatabaseParameter[]: Holds the output of SHOW PARAMETERS FOR DATABASE.
showOutputs GetDatabasesDatabaseShowOutput[]: Holds the output of SHOW DATABASES.

describe_outputs Sequence[GetDatabasesDatabaseDescribeOutput]: Holds the output of DESCRIBE DATABASE.
parameters Sequence[GetDatabasesDatabaseParameter]: Holds the output of SHOW PARAMETERS FOR DATABASE.
show_outputs Sequence[GetDatabasesDatabaseShowOutput]: Holds the output of SHOW DATABASES.

describeOutputs List<Property Map>: Holds the output of DESCRIBE DATABASE.
parameters List<Property Map>: Holds the output of SHOW PARAMETERS FOR DATABASE.
showOutputs List<Property Map>: Holds the output of SHOW DATABASES.

GetDatabasesDatabaseDescribeOutput

CreatedOn string
Kind string
Name string

CreatedOn string
Kind string
Name string

createdOn String
kind String
name String

createdOn string
kind string
name string

created_on str
kind str
name str

createdOn String
kind String
name String

GetDatabasesDatabaseParameter

Catalogs List<GetDatabasesDatabaseParameterCatalog>
DataRetentionTimeInDays List<GetDatabasesDatabaseParameterDataRetentionTimeInDay>
DefaultDdlCollations List<GetDatabasesDatabaseParameterDefaultDdlCollation>
EnableConsoleOutputs List<GetDatabasesDatabaseParameterEnableConsoleOutput>
ExternalVolumes List<GetDatabasesDatabaseParameterExternalVolume>
LogLevels List<GetDatabasesDatabaseParameterLogLevel>
MaxDataExtensionTimeInDays List<GetDatabasesDatabaseParameterMaxDataExtensionTimeInDay>
QuotedIdentifiersIgnoreCases List<GetDatabasesDatabaseParameterQuotedIdentifiersIgnoreCase>
ReplaceInvalidCharacters List<GetDatabasesDatabaseParameterReplaceInvalidCharacter>
StorageSerializationPolicies List<GetDatabasesDatabaseParameterStorageSerializationPolicy>
SuspendTaskAfterNumFailures List<GetDatabasesDatabaseParameterSuspendTaskAfterNumFailure>
TaskAutoRetryAttempts List<GetDatabasesDatabaseParameterTaskAutoRetryAttempt>
TraceLevels List<GetDatabasesDatabaseParameterTraceLevel>
UserTaskManagedInitialWarehouseSizes List<GetDatabasesDatabaseParameterUserTaskManagedInitialWarehouseSize>
UserTaskMinimumTriggerIntervalInSeconds List<GetDatabasesDatabaseParameterUserTaskMinimumTriggerIntervalInSecond>
UserTaskTimeoutMs List<GetDatabasesDatabaseParameterUserTaskTimeoutM>

Catalogs []GetDatabasesDatabaseParameterCatalog
DataRetentionTimeInDays []GetDatabasesDatabaseParameterDataRetentionTimeInDay
DefaultDdlCollations []GetDatabasesDatabaseParameterDefaultDdlCollation
EnableConsoleOutputs []GetDatabasesDatabaseParameterEnableConsoleOutput
ExternalVolumes []GetDatabasesDatabaseParameterExternalVolume
LogLevels []GetDatabasesDatabaseParameterLogLevel
MaxDataExtensionTimeInDays []GetDatabasesDatabaseParameterMaxDataExtensionTimeInDay
QuotedIdentifiersIgnoreCases []GetDatabasesDatabaseParameterQuotedIdentifiersIgnoreCase
ReplaceInvalidCharacters []GetDatabasesDatabaseParameterReplaceInvalidCharacter
StorageSerializationPolicies []GetDatabasesDatabaseParameterStorageSerializationPolicy
SuspendTaskAfterNumFailures []GetDatabasesDatabaseParameterSuspendTaskAfterNumFailure
TaskAutoRetryAttempts []GetDatabasesDatabaseParameterTaskAutoRetryAttempt
TraceLevels []GetDatabasesDatabaseParameterTraceLevel
UserTaskManagedInitialWarehouseSizes []GetDatabasesDatabaseParameterUserTaskManagedInitialWarehouseSize
UserTaskMinimumTriggerIntervalInSeconds []GetDatabasesDatabaseParameterUserTaskMinimumTriggerIntervalInSecond
UserTaskTimeoutMs []GetDatabasesDatabaseParameterUserTaskTimeoutM

catalogs List<GetDatabasesDatabaseParameterCatalog>
dataRetentionTimeInDays List<GetDatabasesDatabaseParameterDataRetentionTimeInDay>
defaultDdlCollations List<GetDatabasesDatabaseParameterDefaultDdlCollation>
enableConsoleOutputs List<GetDatabasesDatabaseParameterEnableConsoleOutput>
externalVolumes List<GetDatabasesDatabaseParameterExternalVolume>
logLevels List<GetDatabasesDatabaseParameterLogLevel>
maxDataExtensionTimeInDays List<GetDatabasesDatabaseParameterMaxDataExtensionTimeInDay>
quotedIdentifiersIgnoreCases List<GetDatabasesDatabaseParameterQuotedIdentifiersIgnoreCase>
replaceInvalidCharacters List<GetDatabasesDatabaseParameterReplaceInvalidCharacter>
storageSerializationPolicies List<GetDatabasesDatabaseParameterStorageSerializationPolicy>
suspendTaskAfterNumFailures List<GetDatabasesDatabaseParameterSuspendTaskAfterNumFailure>
taskAutoRetryAttempts List<GetDatabasesDatabaseParameterTaskAutoRetryAttempt>
traceLevels List<GetDatabasesDatabaseParameterTraceLevel>
userTaskManagedInitialWarehouseSizes List<GetDatabasesDatabaseParameterUserTaskManagedInitialWarehouseSize>
userTaskMinimumTriggerIntervalInSeconds List<GetDatabasesDatabaseParameterUserTaskMinimumTriggerIntervalInSecond>
userTaskTimeoutMs List<GetDatabasesDatabaseParameterUserTaskTimeoutM>

catalogs GetDatabasesDatabaseParameterCatalog[]
dataRetentionTimeInDays GetDatabasesDatabaseParameterDataRetentionTimeInDay[]
defaultDdlCollations GetDatabasesDatabaseParameterDefaultDdlCollation[]
enableConsoleOutputs GetDatabasesDatabaseParameterEnableConsoleOutput[]
externalVolumes GetDatabasesDatabaseParameterExternalVolume[]
logLevels GetDatabasesDatabaseParameterLogLevel[]
maxDataExtensionTimeInDays GetDatabasesDatabaseParameterMaxDataExtensionTimeInDay[]
quotedIdentifiersIgnoreCases GetDatabasesDatabaseParameterQuotedIdentifiersIgnoreCase[]
replaceInvalidCharacters GetDatabasesDatabaseParameterReplaceInvalidCharacter[]
storageSerializationPolicies GetDatabasesDatabaseParameterStorageSerializationPolicy[]
suspendTaskAfterNumFailures GetDatabasesDatabaseParameterSuspendTaskAfterNumFailure[]
taskAutoRetryAttempts GetDatabasesDatabaseParameterTaskAutoRetryAttempt[]
traceLevels GetDatabasesDatabaseParameterTraceLevel[]
userTaskManagedInitialWarehouseSizes GetDatabasesDatabaseParameterUserTaskManagedInitialWarehouseSize[]
userTaskMinimumTriggerIntervalInSeconds GetDatabasesDatabaseParameterUserTaskMinimumTriggerIntervalInSecond[]
userTaskTimeoutMs GetDatabasesDatabaseParameterUserTaskTimeoutM[]

catalogs Sequence[GetDatabasesDatabaseParameterCatalog]
data_retention_time_in_days Sequence[GetDatabasesDatabaseParameterDataRetentionTimeInDay]
default_ddl_collations Sequence[GetDatabasesDatabaseParameterDefaultDdlCollation]
enable_console_outputs Sequence[GetDatabasesDatabaseParameterEnableConsoleOutput]
external_volumes Sequence[GetDatabasesDatabaseParameterExternalVolume]
log_levels Sequence[GetDatabasesDatabaseParameterLogLevel]
max_data_extension_time_in_days Sequence[GetDatabasesDatabaseParameterMaxDataExtensionTimeInDay]
quoted_identifiers_ignore_cases Sequence[GetDatabasesDatabaseParameterQuotedIdentifiersIgnoreCase]
replace_invalid_characters Sequence[GetDatabasesDatabaseParameterReplaceInvalidCharacter]
storage_serialization_policies Sequence[GetDatabasesDatabaseParameterStorageSerializationPolicy]
suspend_task_after_num_failures Sequence[GetDatabasesDatabaseParameterSuspendTaskAfterNumFailure]
task_auto_retry_attempts Sequence[GetDatabasesDatabaseParameterTaskAutoRetryAttempt]
trace_levels Sequence[GetDatabasesDatabaseParameterTraceLevel]
user_task_managed_initial_warehouse_sizes Sequence[GetDatabasesDatabaseParameterUserTaskManagedInitialWarehouseSize]
user_task_minimum_trigger_interval_in_seconds Sequence[GetDatabasesDatabaseParameterUserTaskMinimumTriggerIntervalInSecond]
user_task_timeout_ms Sequence[GetDatabasesDatabaseParameterUserTaskTimeoutM]

catalogs List<Property Map>
dataRetentionTimeInDays List<Property Map>
defaultDdlCollations List<Property Map>
enableConsoleOutputs List<Property Map>
externalVolumes List<Property Map>
logLevels List<Property Map>
maxDataExtensionTimeInDays List<Property Map>
quotedIdentifiersIgnoreCases List<Property Map>
replaceInvalidCharacters List<Property Map>
storageSerializationPolicies List<Property Map>
suspendTaskAfterNumFailures List<Property Map>
taskAutoRetryAttempts List<Property Map>
traceLevels List<Property Map>
userTaskManagedInitialWarehouseSizes List<Property Map>
userTaskMinimumTriggerIntervalInSeconds List<Property Map>
userTaskTimeoutMs List<Property Map>

GetDatabasesDatabaseParameterCatalog

Default string
Description string
Key string
Level string
Value string

Default string
Description string
Key string
Level string
Value string

default_ String
description String
key String
level String
value String

default string
description string
key string
level string
value string

default str
description str
key str
level str
value str

default String
description String
key String
level String
value String

GetDatabasesDatabaseParameterDataRetentionTimeInDay

Default string
Description string
Key string
Level string
Value string

Default string
Description string
Key string
Level string
Value string

default_ String
description String
key String
level String
value String

default string
description string
key string
level string
value string

default str
description str
key str
level str
value str

default String
description String
key String
level String
value String

GetDatabasesDatabaseParameterDefaultDdlCollation

Default string
Description string
Key string
Level string
Value string

Default string
Description string
Key string
Level string
Value string

default_ String
description String
key String
level String
value String

default string
description string
key string
level string
value string

default str
description str
key str
level str
value str

default String
description String
key String
level String
value String

GetDatabasesDatabaseParameterEnableConsoleOutput

Default string
Description string
Key string
Level string
Value string

Default string
Description string
Key string
Level string
Value string

default_ String
description String
key String
level String
value String

default string
description string
key string
level string
value string

default str
description str
key str
level str
value str

default String
description String
key String
level String
value String

GetDatabasesDatabaseParameterExternalVolume

Default string
Description string
Key string
Level string
Value string

Default string
Description string
Key string
Level string
Value string

default_ String
description String
key String
level String
value String

default string
description string
key string
level string
value string

default str
description str
key str
level str
value str

default String
description String
key String
level String
value String

GetDatabasesDatabaseParameterLogLevel

Default string
Description string
Key string
Level string
Value string

Default string
Description string
Key string
Level string
Value string

default_ String
description String
key String
level String
value String

default string
description string
key string
level string
value string

default str
description str
key str
level str
value str

default String
description String
key String
level String
value String

GetDatabasesDatabaseParameterMaxDataExtensionTimeInDay

Default string
Description string
Key string
Level string
Value string

Default string
Description string
Key string
Level string
Value string

default_ String
description String
key String
level String
value String

default string
description string
key string
level string
value string

default str
description str
key str
level str
value str

default String
description String
key String
level String
value String

GetDatabasesDatabaseParameterQuotedIdentifiersIgnoreCase

Default string
Description string
Key string
Level string
Value string

Default string
Description string
Key string
Level string
Value string

default_ String
description String
key String
level String
value String

default string
description string
key string
level string
value string

default str
description str
key str
level str
value str

default String
description String
key String
level String
value String

GetDatabasesDatabaseParameterReplaceInvalidCharacter

Default string
Description string
Key string
Level string
Value string

Default string
Description string
Key string
Level string
Value string

default_ String
description String
key String
level String
value String

default string
description string
key string
level string
value string

default str
description str
key str
level str
value str

default String
description String
key String
level String
value String

GetDatabasesDatabaseParameterStorageSerializationPolicy

Default string
Description string
Key string
Level string
Value string

Default string
Description string
Key string
Level string
Value string

default_ String
description String
key String
level String
value String

default string
description string
key string
level string
value string

default str
description str
key str
level str
value str

default String
description String
key String
level String
value String

GetDatabasesDatabaseParameterSuspendTaskAfterNumFailure

Default string
Description string
Key string
Level string
Value string

Default string
Description string
Key string
Level string
Value string

default_ String
description String
key String
level String
value String

default string
description string
key string
level string
value string

default str
description str
key str
level str
value str

default String
description String
key String
level String
value String

GetDatabasesDatabaseParameterTaskAutoRetryAttempt

Default string
Description string
Key string
Level string
Value string

Default string
Description string
Key string
Level string
Value string

default_ String
description String
key String
level String
value String

default string
description string
key string
level string
value string

default str
description str
key str
level str
value str

default String
description String
key String
level String
value String

GetDatabasesDatabaseParameterTraceLevel

Default string
Description string
Key string
Level string
Value string

Default string
Description string
Key string
Level string
Value string

default_ String
description String
key String
level String
value String

default string
description string
key string
level string
value string

default str
description str
key str
level str
value str

default String
description String
key String
level String
value String

GetDatabasesDatabaseParameterUserTaskManagedInitialWarehouseSize

Default string
Description string
Key string
Level string
Value string

Default string
Description string
Key string
Level string
Value string

default_ String
description String
key String
level String
value String

default string
description string
key string
level string
value string

default str
description str
key str
level str
value str

default String
description String
key String
level String
value String

GetDatabasesDatabaseParameterUserTaskMinimumTriggerIntervalInSecond

Default string
Description string
Key string
Level string
Value string

Default string
Description string
Key string
Level string
Value string

default_ String
description String
key String
level String
value String

default string
description string
key string
level string
value string

default str
description str
key str
level str
value str

default String
description String
key String
level String
value String

GetDatabasesDatabaseParameterUserTaskTimeoutM

Default string
Description string
Key string
Level string
Value string

Default string
Description string
Key string
Level string
Value string

default_ String
description String
key String
level String
value String

default string
description string
key string
level string
value string

default str
description str
key str
level str
value str

default String
description String
key String
level String
value String

GetDatabasesDatabaseShowOutput

Comment string
CreatedOn string
DroppedOn string
IsCurrent bool
IsDefault bool
Kind string
Name string
Options string
Origin string
Owner string
OwnerRoleType string
ResourceGroup string
RetentionTime int
Transient bool

Comment string
CreatedOn string
DroppedOn string
IsCurrent bool
IsDefault bool
Kind string
Name string
Options string
Origin string
Owner string
OwnerRoleType string
ResourceGroup string
RetentionTime int
Transient bool

comment String
createdOn String
droppedOn String
isCurrent Boolean
isDefault Boolean
kind String
name String
options String
origin String
owner String
ownerRoleType String
resourceGroup String
retentionTime Integer
transient_ Boolean

comment string
createdOn string
droppedOn string
isCurrent boolean
isDefault boolean
kind string
name string
options string
origin string
owner string
ownerRoleType string
resourceGroup string
retentionTime number
transient boolean

comment str
created_on str
dropped_on str
is_current bool
is_default bool
kind str
name str
options str
origin str
owner str
owner_role_type str
resource_group str
retention_time int
transient bool

comment String
createdOn String
droppedOn String
isCurrent Boolean
isDefault Boolean
kind String
name String
options String
origin String
owner String
ownerRoleType String
resourceGroup String
retentionTime Number
transient Boolean

GetDatabasesLimit

Rows int: The maximum number of rows to return.
From string: Specifies a case-sensitive pattern that is used to match object name. After the first match, the limit on the number of rows will be applied.

Rows int: The maximum number of rows to return.
From string: Specifies a case-sensitive pattern that is used to match object name. After the first match, the limit on the number of rows will be applied.

rows Integer: The maximum number of rows to return.
from String: Specifies a case-sensitive pattern that is used to match object name. After the first match, the limit on the number of rows will be applied.

rows number: The maximum number of rows to return.
from string: Specifies a case-sensitive pattern that is used to match object name. After the first match, the limit on the number of rows will be applied.

rows int: The maximum number of rows to return.
from_ str: Specifies a case-sensitive pattern that is used to match object name. After the first match, the limit on the number of rows will be applied.

rows Number: The maximum number of rows to return.
from String: Specifies a case-sensitive pattern that is used to match object name. After the first match, the limit on the number of rows will be applied.

Package Details

Repository: Snowflake pulumi/pulumi-snowflake
License: Apache-2.0
Notes: This Pulumi package is based on the snowflake Terraform Provider.

Snowflake v1.1.4 published on Wednesday, Mar 26, 2025 by Pulumi

pulumi/pulumi-snowflake

snowflake.getDatabases

On this page

On this page

Using getDatabases

getDatabases Result

Supporting Types

GetDatabasesDatabase

GetDatabasesDatabaseDescribeOutput

GetDatabasesDatabaseParameter

GetDatabasesDatabaseParameterCatalog

GetDatabasesDatabaseParameterDataRetentionTimeInDay

GetDatabasesDatabaseParameterDefaultDdlCollation

GetDatabasesDatabaseParameterEnableConsoleOutput

GetDatabasesDatabaseParameterExternalVolume

GetDatabasesDatabaseParameterLogLevel

GetDatabasesDatabaseParameterMaxDataExtensionTimeInDay

GetDatabasesDatabaseParameterQuotedIdentifiersIgnoreCase

GetDatabasesDatabaseParameterReplaceInvalidCharacter

GetDatabasesDatabaseParameterStorageSerializationPolicy

GetDatabasesDatabaseParameterSuspendTaskAfterNumFailure

GetDatabasesDatabaseParameterTaskAutoRetryAttempt

GetDatabasesDatabaseParameterTraceLevel

GetDatabasesDatabaseParameterUserTaskManagedInitialWarehouseSize

GetDatabasesDatabaseParameterUserTaskMinimumTriggerIntervalInSecond

GetDatabasesDatabaseParameterUserTaskTimeoutM

GetDatabasesDatabaseShowOutput

GetDatabasesLimit

Package Details

On this page

On this page