snowflake.LegacyServiceUser
Explore with Pulumi AI
Import
$ pulumi import snowflake:index/legacyServiceUser:LegacyServiceUser example '"<user_name>"'
Note: pulumi preview+apply may be needed after successful import to fill out all the missing fields (like password
) in state.
Create LegacyServiceUser Resource
Resources are created with functions called constructors. To learn more about declaring and configuring resources, see Resources.
Constructor syntax
new LegacyServiceUser(name: string, args?: LegacyServiceUserArgs, opts?: CustomResourceOptions);
@overload
def LegacyServiceUser(resource_name: str,
args: Optional[LegacyServiceUserArgs] = None,
opts: Optional[ResourceOptions] = None)
@overload
def LegacyServiceUser(resource_name: str,
opts: Optional[ResourceOptions] = None,
abort_detached_query: Optional[bool] = None,
autocommit: Optional[bool] = None,
binary_input_format: Optional[str] = None,
binary_output_format: Optional[str] = None,
client_memory_limit: Optional[int] = None,
client_metadata_request_use_connection_ctx: Optional[bool] = None,
client_prefetch_threads: Optional[int] = None,
client_result_chunk_size: Optional[int] = None,
client_result_column_case_insensitive: Optional[bool] = None,
client_session_keep_alive: Optional[bool] = None,
client_session_keep_alive_heartbeat_frequency: Optional[int] = None,
client_timestamp_type_mapping: Optional[str] = None,
comment: Optional[str] = None,
date_input_format: Optional[str] = None,
date_output_format: Optional[str] = None,
days_to_expiry: Optional[int] = None,
default_namespace: Optional[str] = None,
default_role: Optional[str] = None,
default_secondary_roles_option: Optional[str] = None,
default_warehouse: Optional[str] = None,
disabled: Optional[str] = None,
display_name: Optional[str] = None,
email: Optional[str] = None,
enable_unload_physical_type_optimization: Optional[bool] = None,
enable_unredacted_query_syntax_error: Optional[bool] = None,
error_on_nondeterministic_merge: Optional[bool] = None,
error_on_nondeterministic_update: Optional[bool] = None,
geography_output_format: Optional[str] = None,
geometry_output_format: Optional[str] = None,
jdbc_treat_decimal_as_int: Optional[bool] = None,
jdbc_treat_timestamp_ntz_as_utc: Optional[bool] = None,
jdbc_use_session_timezone: Optional[bool] = None,
json_indent: Optional[int] = None,
lock_timeout: Optional[int] = None,
log_level: Optional[str] = None,
login_name: Optional[str] = None,
mins_to_unlock: Optional[int] = None,
multi_statement_count: Optional[int] = None,
must_change_password: Optional[str] = None,
name: Optional[str] = None,
network_policy: Optional[str] = None,
noorder_sequence_as_default: Optional[bool] = None,
odbc_treat_decimal_as_int: Optional[bool] = None,
password: Optional[str] = None,
prevent_unload_to_internal_stages: Optional[bool] = None,
query_tag: Optional[str] = None,
quoted_identifiers_ignore_case: Optional[bool] = None,
rows_per_resultset: Optional[int] = None,
rsa_public_key: Optional[str] = None,
rsa_public_key2: Optional[str] = None,
s3_stage_vpce_dns_name: Optional[str] = None,
search_path: Optional[str] = None,
simulated_data_sharing_consumer: Optional[str] = None,
statement_queued_timeout_in_seconds: Optional[int] = None,
statement_timeout_in_seconds: Optional[int] = None,
strict_json_output: Optional[bool] = None,
time_input_format: Optional[str] = None,
time_output_format: Optional[str] = None,
timestamp_day_is_always24h: Optional[bool] = None,
timestamp_input_format: Optional[str] = None,
timestamp_ltz_output_format: Optional[str] = None,
timestamp_ntz_output_format: Optional[str] = None,
timestamp_output_format: Optional[str] = None,
timestamp_type_mapping: Optional[str] = None,
timestamp_tz_output_format: Optional[str] = None,
timezone: Optional[str] = None,
trace_level: Optional[str] = None,
transaction_abort_on_error: Optional[bool] = None,
transaction_default_isolation_level: Optional[str] = None,
two_digit_century_start: Optional[int] = None,
unsupported_ddl_action: Optional[str] = None,
use_cached_result: Optional[bool] = None,
week_of_year_policy: Optional[int] = None,
week_start: Optional[int] = None)
func NewLegacyServiceUser(ctx *Context, name string, args *LegacyServiceUserArgs, opts ...ResourceOption) (*LegacyServiceUser, error)
public LegacyServiceUser(string name, LegacyServiceUserArgs? args = null, CustomResourceOptions? opts = null)
public LegacyServiceUser(String name, LegacyServiceUserArgs args)
public LegacyServiceUser(String name, LegacyServiceUserArgs args, CustomResourceOptions options)
type: snowflake:LegacyServiceUser
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 LegacyServiceUserArgs
- 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 LegacyServiceUserArgs
- 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 LegacyServiceUserArgs
- The arguments to resource properties.
- opts ResourceOption
- Bag of options to control resource's behavior.
- name string
- The unique name of the resource.
- args LegacyServiceUserArgs
- The arguments to resource properties.
- opts CustomResourceOptions
- Bag of options to control resource's behavior.
- name String
- The unique name of the resource.
- args LegacyServiceUserArgs
- 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 legacyServiceUserResource = new Snowflake.LegacyServiceUser("legacyServiceUserResource", new()
{
AbortDetachedQuery = false,
Autocommit = false,
BinaryInputFormat = "string",
BinaryOutputFormat = "string",
ClientMemoryLimit = 0,
ClientMetadataRequestUseConnectionCtx = false,
ClientPrefetchThreads = 0,
ClientResultChunkSize = 0,
ClientResultColumnCaseInsensitive = false,
ClientSessionKeepAlive = false,
ClientSessionKeepAliveHeartbeatFrequency = 0,
ClientTimestampTypeMapping = "string",
Comment = "string",
DateInputFormat = "string",
DateOutputFormat = "string",
DaysToExpiry = 0,
DefaultNamespace = "string",
DefaultRole = "string",
DefaultSecondaryRolesOption = "string",
DefaultWarehouse = "string",
Disabled = "string",
DisplayName = "string",
Email = "string",
EnableUnloadPhysicalTypeOptimization = false,
EnableUnredactedQuerySyntaxError = false,
ErrorOnNondeterministicMerge = false,
ErrorOnNondeterministicUpdate = false,
GeographyOutputFormat = "string",
GeometryOutputFormat = "string",
JdbcTreatDecimalAsInt = false,
JdbcTreatTimestampNtzAsUtc = false,
JdbcUseSessionTimezone = false,
JsonIndent = 0,
LockTimeout = 0,
LogLevel = "string",
LoginName = "string",
MinsToUnlock = 0,
MultiStatementCount = 0,
MustChangePassword = "string",
Name = "string",
NetworkPolicy = "string",
NoorderSequenceAsDefault = false,
OdbcTreatDecimalAsInt = false,
Password = "string",
PreventUnloadToInternalStages = false,
QueryTag = "string",
QuotedIdentifiersIgnoreCase = false,
RowsPerResultset = 0,
RsaPublicKey = "string",
RsaPublicKey2 = "string",
S3StageVpceDnsName = "string",
SearchPath = "string",
SimulatedDataSharingConsumer = "string",
StatementQueuedTimeoutInSeconds = 0,
StatementTimeoutInSeconds = 0,
StrictJsonOutput = false,
TimeInputFormat = "string",
TimeOutputFormat = "string",
TimestampDayIsAlways24h = false,
TimestampInputFormat = "string",
TimestampLtzOutputFormat = "string",
TimestampNtzOutputFormat = "string",
TimestampOutputFormat = "string",
TimestampTypeMapping = "string",
TimestampTzOutputFormat = "string",
Timezone = "string",
TraceLevel = "string",
TransactionAbortOnError = false,
TransactionDefaultIsolationLevel = "string",
TwoDigitCenturyStart = 0,
UnsupportedDdlAction = "string",
UseCachedResult = false,
WeekOfYearPolicy = 0,
WeekStart = 0,
});
example, err := snowflake.NewLegacyServiceUser(ctx, "legacyServiceUserResource", &snowflake.LegacyServiceUserArgs{
AbortDetachedQuery: pulumi.Bool(false),
Autocommit: pulumi.Bool(false),
BinaryInputFormat: pulumi.String("string"),
BinaryOutputFormat: pulumi.String("string"),
ClientMemoryLimit: pulumi.Int(0),
ClientMetadataRequestUseConnectionCtx: pulumi.Bool(false),
ClientPrefetchThreads: pulumi.Int(0),
ClientResultChunkSize: pulumi.Int(0),
ClientResultColumnCaseInsensitive: pulumi.Bool(false),
ClientSessionKeepAlive: pulumi.Bool(false),
ClientSessionKeepAliveHeartbeatFrequency: pulumi.Int(0),
ClientTimestampTypeMapping: pulumi.String("string"),
Comment: pulumi.String("string"),
DateInputFormat: pulumi.String("string"),
DateOutputFormat: pulumi.String("string"),
DaysToExpiry: pulumi.Int(0),
DefaultNamespace: pulumi.String("string"),
DefaultRole: pulumi.String("string"),
DefaultSecondaryRolesOption: pulumi.String("string"),
DefaultWarehouse: pulumi.String("string"),
Disabled: pulumi.String("string"),
DisplayName: pulumi.String("string"),
Email: pulumi.String("string"),
EnableUnloadPhysicalTypeOptimization: pulumi.Bool(false),
EnableUnredactedQuerySyntaxError: pulumi.Bool(false),
ErrorOnNondeterministicMerge: pulumi.Bool(false),
ErrorOnNondeterministicUpdate: pulumi.Bool(false),
GeographyOutputFormat: pulumi.String("string"),
GeometryOutputFormat: pulumi.String("string"),
JdbcTreatDecimalAsInt: pulumi.Bool(false),
JdbcTreatTimestampNtzAsUtc: pulumi.Bool(false),
JdbcUseSessionTimezone: pulumi.Bool(false),
JsonIndent: pulumi.Int(0),
LockTimeout: pulumi.Int(0),
LogLevel: pulumi.String("string"),
LoginName: pulumi.String("string"),
MinsToUnlock: pulumi.Int(0),
MultiStatementCount: pulumi.Int(0),
MustChangePassword: pulumi.String("string"),
Name: pulumi.String("string"),
NetworkPolicy: pulumi.String("string"),
NoorderSequenceAsDefault: pulumi.Bool(false),
OdbcTreatDecimalAsInt: pulumi.Bool(false),
Password: pulumi.String("string"),
PreventUnloadToInternalStages: pulumi.Bool(false),
QueryTag: pulumi.String("string"),
QuotedIdentifiersIgnoreCase: pulumi.Bool(false),
RowsPerResultset: pulumi.Int(0),
RsaPublicKey: pulumi.String("string"),
RsaPublicKey2: pulumi.String("string"),
S3StageVpceDnsName: pulumi.String("string"),
SearchPath: pulumi.String("string"),
SimulatedDataSharingConsumer: pulumi.String("string"),
StatementQueuedTimeoutInSeconds: pulumi.Int(0),
StatementTimeoutInSeconds: pulumi.Int(0),
StrictJsonOutput: pulumi.Bool(false),
TimeInputFormat: pulumi.String("string"),
TimeOutputFormat: pulumi.String("string"),
TimestampDayIsAlways24h: pulumi.Bool(false),
TimestampInputFormat: pulumi.String("string"),
TimestampLtzOutputFormat: pulumi.String("string"),
TimestampNtzOutputFormat: pulumi.String("string"),
TimestampOutputFormat: pulumi.String("string"),
TimestampTypeMapping: pulumi.String("string"),
TimestampTzOutputFormat: pulumi.String("string"),
Timezone: pulumi.String("string"),
TraceLevel: pulumi.String("string"),
TransactionAbortOnError: pulumi.Bool(false),
TransactionDefaultIsolationLevel: pulumi.String("string"),
TwoDigitCenturyStart: pulumi.Int(0),
UnsupportedDdlAction: pulumi.String("string"),
UseCachedResult: pulumi.Bool(false),
WeekOfYearPolicy: pulumi.Int(0),
WeekStart: pulumi.Int(0),
})
var legacyServiceUserResource = new LegacyServiceUser("legacyServiceUserResource", LegacyServiceUserArgs.builder()
.abortDetachedQuery(false)
.autocommit(false)
.binaryInputFormat("string")
.binaryOutputFormat("string")
.clientMemoryLimit(0)
.clientMetadataRequestUseConnectionCtx(false)
.clientPrefetchThreads(0)
.clientResultChunkSize(0)
.clientResultColumnCaseInsensitive(false)
.clientSessionKeepAlive(false)
.clientSessionKeepAliveHeartbeatFrequency(0)
.clientTimestampTypeMapping("string")
.comment("string")
.dateInputFormat("string")
.dateOutputFormat("string")
.daysToExpiry(0)
.defaultNamespace("string")
.defaultRole("string")
.defaultSecondaryRolesOption("string")
.defaultWarehouse("string")
.disabled("string")
.displayName("string")
.email("string")
.enableUnloadPhysicalTypeOptimization(false)
.enableUnredactedQuerySyntaxError(false)
.errorOnNondeterministicMerge(false)
.errorOnNondeterministicUpdate(false)
.geographyOutputFormat("string")
.geometryOutputFormat("string")
.jdbcTreatDecimalAsInt(false)
.jdbcTreatTimestampNtzAsUtc(false)
.jdbcUseSessionTimezone(false)
.jsonIndent(0)
.lockTimeout(0)
.logLevel("string")
.loginName("string")
.minsToUnlock(0)
.multiStatementCount(0)
.mustChangePassword("string")
.name("string")
.networkPolicy("string")
.noorderSequenceAsDefault(false)
.odbcTreatDecimalAsInt(false)
.password("string")
.preventUnloadToInternalStages(false)
.queryTag("string")
.quotedIdentifiersIgnoreCase(false)
.rowsPerResultset(0)
.rsaPublicKey("string")
.rsaPublicKey2("string")
.s3StageVpceDnsName("string")
.searchPath("string")
.simulatedDataSharingConsumer("string")
.statementQueuedTimeoutInSeconds(0)
.statementTimeoutInSeconds(0)
.strictJsonOutput(false)
.timeInputFormat("string")
.timeOutputFormat("string")
.timestampDayIsAlways24h(false)
.timestampInputFormat("string")
.timestampLtzOutputFormat("string")
.timestampNtzOutputFormat("string")
.timestampOutputFormat("string")
.timestampTypeMapping("string")
.timestampTzOutputFormat("string")
.timezone("string")
.traceLevel("string")
.transactionAbortOnError(false)
.transactionDefaultIsolationLevel("string")
.twoDigitCenturyStart(0)
.unsupportedDdlAction("string")
.useCachedResult(false)
.weekOfYearPolicy(0)
.weekStart(0)
.build());
legacy_service_user_resource = snowflake.LegacyServiceUser("legacyServiceUserResource",
abort_detached_query=False,
autocommit=False,
binary_input_format="string",
binary_output_format="string",
client_memory_limit=0,
client_metadata_request_use_connection_ctx=False,
client_prefetch_threads=0,
client_result_chunk_size=0,
client_result_column_case_insensitive=False,
client_session_keep_alive=False,
client_session_keep_alive_heartbeat_frequency=0,
client_timestamp_type_mapping="string",
comment="string",
date_input_format="string",
date_output_format="string",
days_to_expiry=0,
default_namespace="string",
default_role="string",
default_secondary_roles_option="string",
default_warehouse="string",
disabled="string",
display_name="string",
email="string",
enable_unload_physical_type_optimization=False,
enable_unredacted_query_syntax_error=False,
error_on_nondeterministic_merge=False,
error_on_nondeterministic_update=False,
geography_output_format="string",
geometry_output_format="string",
jdbc_treat_decimal_as_int=False,
jdbc_treat_timestamp_ntz_as_utc=False,
jdbc_use_session_timezone=False,
json_indent=0,
lock_timeout=0,
log_level="string",
login_name="string",
mins_to_unlock=0,
multi_statement_count=0,
must_change_password="string",
name="string",
network_policy="string",
noorder_sequence_as_default=False,
odbc_treat_decimal_as_int=False,
password="string",
prevent_unload_to_internal_stages=False,
query_tag="string",
quoted_identifiers_ignore_case=False,
rows_per_resultset=0,
rsa_public_key="string",
rsa_public_key2="string",
s3_stage_vpce_dns_name="string",
search_path="string",
simulated_data_sharing_consumer="string",
statement_queued_timeout_in_seconds=0,
statement_timeout_in_seconds=0,
strict_json_output=False,
time_input_format="string",
time_output_format="string",
timestamp_day_is_always24h=False,
timestamp_input_format="string",
timestamp_ltz_output_format="string",
timestamp_ntz_output_format="string",
timestamp_output_format="string",
timestamp_type_mapping="string",
timestamp_tz_output_format="string",
timezone="string",
trace_level="string",
transaction_abort_on_error=False,
transaction_default_isolation_level="string",
two_digit_century_start=0,
unsupported_ddl_action="string",
use_cached_result=False,
week_of_year_policy=0,
week_start=0)
const legacyServiceUserResource = new snowflake.LegacyServiceUser("legacyServiceUserResource", {
abortDetachedQuery: false,
autocommit: false,
binaryInputFormat: "string",
binaryOutputFormat: "string",
clientMemoryLimit: 0,
clientMetadataRequestUseConnectionCtx: false,
clientPrefetchThreads: 0,
clientResultChunkSize: 0,
clientResultColumnCaseInsensitive: false,
clientSessionKeepAlive: false,
clientSessionKeepAliveHeartbeatFrequency: 0,
clientTimestampTypeMapping: "string",
comment: "string",
dateInputFormat: "string",
dateOutputFormat: "string",
daysToExpiry: 0,
defaultNamespace: "string",
defaultRole: "string",
defaultSecondaryRolesOption: "string",
defaultWarehouse: "string",
disabled: "string",
displayName: "string",
email: "string",
enableUnloadPhysicalTypeOptimization: false,
enableUnredactedQuerySyntaxError: false,
errorOnNondeterministicMerge: false,
errorOnNondeterministicUpdate: false,
geographyOutputFormat: "string",
geometryOutputFormat: "string",
jdbcTreatDecimalAsInt: false,
jdbcTreatTimestampNtzAsUtc: false,
jdbcUseSessionTimezone: false,
jsonIndent: 0,
lockTimeout: 0,
logLevel: "string",
loginName: "string",
minsToUnlock: 0,
multiStatementCount: 0,
mustChangePassword: "string",
name: "string",
networkPolicy: "string",
noorderSequenceAsDefault: false,
odbcTreatDecimalAsInt: false,
password: "string",
preventUnloadToInternalStages: false,
queryTag: "string",
quotedIdentifiersIgnoreCase: false,
rowsPerResultset: 0,
rsaPublicKey: "string",
rsaPublicKey2: "string",
s3StageVpceDnsName: "string",
searchPath: "string",
simulatedDataSharingConsumer: "string",
statementQueuedTimeoutInSeconds: 0,
statementTimeoutInSeconds: 0,
strictJsonOutput: false,
timeInputFormat: "string",
timeOutputFormat: "string",
timestampDayIsAlways24h: false,
timestampInputFormat: "string",
timestampLtzOutputFormat: "string",
timestampNtzOutputFormat: "string",
timestampOutputFormat: "string",
timestampTypeMapping: "string",
timestampTzOutputFormat: "string",
timezone: "string",
traceLevel: "string",
transactionAbortOnError: false,
transactionDefaultIsolationLevel: "string",
twoDigitCenturyStart: 0,
unsupportedDdlAction: "string",
useCachedResult: false,
weekOfYearPolicy: 0,
weekStart: 0,
});
type: snowflake:LegacyServiceUser
properties:
abortDetachedQuery: false
autocommit: false
binaryInputFormat: string
binaryOutputFormat: string
clientMemoryLimit: 0
clientMetadataRequestUseConnectionCtx: false
clientPrefetchThreads: 0
clientResultChunkSize: 0
clientResultColumnCaseInsensitive: false
clientSessionKeepAlive: false
clientSessionKeepAliveHeartbeatFrequency: 0
clientTimestampTypeMapping: string
comment: string
dateInputFormat: string
dateOutputFormat: string
daysToExpiry: 0
defaultNamespace: string
defaultRole: string
defaultSecondaryRolesOption: string
defaultWarehouse: string
disabled: string
displayName: string
email: string
enableUnloadPhysicalTypeOptimization: false
enableUnredactedQuerySyntaxError: false
errorOnNondeterministicMerge: false
errorOnNondeterministicUpdate: false
geographyOutputFormat: string
geometryOutputFormat: string
jdbcTreatDecimalAsInt: false
jdbcTreatTimestampNtzAsUtc: false
jdbcUseSessionTimezone: false
jsonIndent: 0
lockTimeout: 0
logLevel: string
loginName: string
minsToUnlock: 0
multiStatementCount: 0
mustChangePassword: string
name: string
networkPolicy: string
noorderSequenceAsDefault: false
odbcTreatDecimalAsInt: false
password: string
preventUnloadToInternalStages: false
queryTag: string
quotedIdentifiersIgnoreCase: false
rowsPerResultset: 0
rsaPublicKey: string
rsaPublicKey2: string
s3StageVpceDnsName: string
searchPath: string
simulatedDataSharingConsumer: string
statementQueuedTimeoutInSeconds: 0
statementTimeoutInSeconds: 0
strictJsonOutput: false
timeInputFormat: string
timeOutputFormat: string
timestampDayIsAlways24h: false
timestampInputFormat: string
timestampLtzOutputFormat: string
timestampNtzOutputFormat: string
timestampOutputFormat: string
timestampTypeMapping: string
timestampTzOutputFormat: string
timezone: string
traceLevel: string
transactionAbortOnError: false
transactionDefaultIsolationLevel: string
twoDigitCenturyStart: 0
unsupportedDdlAction: string
useCachedResult: false
weekOfYearPolicy: 0
weekStart: 0
LegacyServiceUser 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 LegacyServiceUser resource accepts the following input properties:
- Abort
Detached boolQuery - Specifies the action that Snowflake performs for in-progress queries if connectivity is lost due to abrupt termination of a session (e.g. network outage, browser termination, service interruption). For more information, check ABORTDETACHEDQUERY docs.
- Autocommit bool
- Specifies whether autocommit is enabled for the session. Autocommit determines whether a DML statement, when executed without an active transaction, is automatically committed after the statement successfully completes. For more information, see Transactions. For more information, check AUTOCOMMIT docs.
- Binary
Input stringFormat - The format of VARCHAR values passed as input to VARCHAR-to-BINARY conversion functions. For more information, see Binary input and output. For more information, check BINARYINPUTFORMAT docs.
- Binary
Output stringFormat - The format for VARCHAR values returned as output by BINARY-to-VARCHAR conversion functions. For more information, see Binary input and output. For more information, check BINARYOUTPUTFORMAT docs.
- Client
Memory intLimit - Parameter that specifies the maximum amount of memory the JDBC driver or ODBC driver should use for the result set from queries (in MB). For more information, check CLIENTMEMORYLIMIT docs.
- Client
Metadata boolRequest Use Connection Ctx - For specific ODBC functions and JDBC methods, this parameter can change the default search scope from all databases/schemas to the current database/schema. The narrower search typically returns fewer rows and executes more quickly. For more information, check CLIENTMETADATAREQUESTUSECONNECTION_CTX docs.
- Client
Prefetch intThreads - Parameter that specifies the number of threads used by the client to pre-fetch large result sets. The driver will attempt to honor the parameter value, but defines the minimum and maximum values (depending on your system’s resources) to improve performance. For more information, check CLIENTPREFETCHTHREADS docs.
- Client
Result intChunk Size - Parameter that specifies the maximum size of each set (or chunk) of query results to download (in MB). The JDBC driver downloads query results in chunks. For more information, check CLIENTRESULTCHUNK_SIZE docs.
- Client
Result boolColumn Case Insensitive - Parameter that indicates whether to match column name case-insensitively in ResultSet.get* methods in JDBC. For more information, check CLIENTRESULTCOLUMNCASEINSENSITIVE docs.
- Client
Session boolKeep Alive - Parameter that indicates whether to force a user to log in again after a period of inactivity in the session. For more information, check CLIENTSESSIONKEEP_ALIVE docs.
- Client
Session intKeep Alive Heartbeat Frequency - Number of seconds in-between client attempts to update the token for the session. For more information, check CLIENTSESSIONKEEPALIVEHEARTBEAT_FREQUENCY docs.
- Client
Timestamp stringType Mapping - Specifies the TIMESTAMP_* variation to use when binding timestamp variables for JDBC or ODBC applications that use the bind API to load data. For more information, check CLIENTTIMESTAMPTYPE_MAPPING docs.
- Comment string
- Specifies a comment for the user.
- Date
Input stringFormat - Specifies the input format for the DATE data type. For more information, see Date and time input and output formats. For more information, check DATEINPUTFORMAT docs.
- Date
Output stringFormat - Specifies the display format for the DATE data type. For more information, see Date and time input and output formats. For more information, check DATEOUTPUTFORMAT docs.
- Days
To intExpiry - Default
Namespace string - Specifies the namespace (database only or database and schema) that is active by default for the user’s session upon login. Note that the CREATE USER operation does not verify that the namespace exists.
- Default
Role string - Specifies the role that is active by default for the user’s session upon login. Note that specifying a default role for a user does not grant the role to the user. The role must be granted explicitly to the user using the GRANT ROLE command. In addition, the CREATE USER operation does not verify that the role exists.
- Default
Secondary stringRoles Option - Specifies the secondary roles that are active for the user’s session upon login. Valid values are (case-insensitive):
DEFAULT
|NONE
|ALL
. More information can be found in doc. - Default
Warehouse string - Specifies the virtual warehouse that is active by default for the user’s session upon login. Note that the CREATE USER operation does not verify that the warehouse exists.
- Disabled string
- Specifies whether the user is disabled, which prevents logging in and aborts all the currently-running queries for the user. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
- Display
Name string - Name displayed for the user in the Snowflake web interface.
- Email string
- Email address for the user.
- Enable
Unload boolPhysical Type Optimization - Specifies whether to set the schema for unloaded Parquet files based on the logical column data types (i.e. the types in the unload SQL query or source table) or on the unloaded column values (i.e. the smallest data types and precision that support the values in the output columns of the unload SQL statement or source table). For more information, check ENABLEUNLOADPHYSICALTYPEOPTIMIZATION docs.
- Enable
Unredacted boolQuery Syntax Error - Controls whether query text is redacted if a SQL query fails due to a syntax or parsing error. If
FALSE
, the content of a failed query is redacted in the views, pages, and functions that provide a query history. Only users with a role that is granted or inherits the AUDIT privilege can set the ENABLEUNREDACTEDQUERYSYNTAXERROR parameter. When using the ALTER USER command to set the parameter toTRUE
for a particular user, modify the user that you want to see the query text, not the user who executed the query (if those are different users). For more information, check UNREDACTEDQUERYSYNTAXERROR docsENABLE. - Error
On boolNondeterministic Merge - Specifies whether to return an error when the MERGE command is used to update or delete a target row that joins multiple source rows and the system cannot determine the action to perform on the target row. For more information, check ERRORONNONDETERMINISTIC_MERGE docs.
- Error
On boolNondeterministic Update - Specifies whether to return an error when the UPDATE command is used to update a target row that joins multiple source rows and the system cannot determine the action to perform on the target row. For more information, check ERRORONNONDETERMINISTIC_UPDATE docs.
- Geography
Output stringFormat - Display format for GEOGRAPHY values. For more information, check GEOGRAPHYOUTPUTFORMAT docs.
- Geometry
Output stringFormat - Display format for GEOMETRY values. For more information, check GEOMETRYOUTPUTFORMAT docs.
- Jdbc
Treat boolDecimal As Int - Specifies how JDBC processes columns that have a scale of zero (0). For more information, check JDBCTREATDECIMALASINT docs.
- Jdbc
Treat boolTimestamp Ntz As Utc - Specifies how JDBC processes TIMESTAMPNTZ values. For more information, check TREATTIMESTAMPNTZASUTC docsJDBC.
- Jdbc
Use boolSession Timezone - Specifies whether the JDBC Driver uses the time zone of the JVM or the time zone of the session (specified by the TIMEZONE parameter) for the getDate(), getTime(), and getTimestamp() methods of the ResultSet class. For more information, check JDBCUSESESSION_TIMEZONE docs.
- Json
Indent int - Specifies the number of blank spaces to indent each new element in JSON output in the session. Also specifies whether to insert newline characters after each element. For more information, check JSON_INDENT docs.
- Lock
Timeout int - Number of seconds to wait while trying to lock a resource, before timing out and aborting the statement. For more information, check LOCK_TIMEOUT docs.
- Log
Level string - Specifies the severity level of messages that should be ingested and made available in the active event table. Messages at the specified level (and at more severe levels) are ingested. For more information about log levels, see Setting log level. For more information, check LOG_LEVEL docs.
- Login
Name string - The name users use to log in. If not supplied, snowflake will use name instead. Login names are always case-insensitive.
- Mins
To intUnlock - Multi
Statement intCount - Number of statements to execute when using the multi-statement capability. For more information, check MULTISTATEMENTCOUNT docs.
- Must
Change stringPassword - Specifies whether the user is forced to change their password on next login (including their first/initial login) into the system. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
- Name string
- Name of the user. Note that if you do not supply loginname this will be used as loginname. Check the docs. Due to technical limitations (read more here), avoid using the following characters:
|
,.
,(
,)
,"
- Network
Policy string - Specifies the network policy to enforce for your account. Network policies enable restricting access to your account based on users’ IP address. For more details, see Controlling network traffic with network policies. Any existing network policy (created using CREATE NETWORK POLICY). For more information, check NETWORK_POLICY docs.
- Noorder
Sequence boolAs Default - Specifies whether the ORDER or NOORDER property is set by default when you create a new sequence or add a new table column. The ORDER and NOORDER properties determine whether or not the values are generated for the sequence or auto-incremented column in increasing or decreasing order. For more information, check NOORDERSEQUENCEAS_DEFAULT docs.
- Odbc
Treat boolDecimal As Int - Specifies how ODBC processes columns that have a scale of zero (0). For more information, check ODBCTREATDECIMALASINT docs.
- Password string
- Prevent
Unload boolTo Internal Stages - Specifies whether to prevent data unload operations to internal (Snowflake) stages using COPY INTO \n\n statements. For more information, check PREVENTUNLOADTOINTERNALSTAGES docs.
- Query
Tag string - Optional string that can be used to tag queries and other SQL statements executed within a session. The tags are displayed in the output of the QUERYHISTORY, QUERYHISTORY*BY** functions. For more information, check QUERY_TAG docs.
- Quoted
Identifiers boolIgnore Case - Specifies whether letters in double-quoted object identifiers are stored and resolved as uppercase letters. By default, Snowflake preserves the case of alphabetic characters when storing and resolving double-quoted identifiers (see Identifier resolution). You can use this parameter in situations in which third-party applications always use double quotes around identifiers. For more information, check QUOTEDIDENTIFIERSIGNORE_CASE docs.
- Rows
Per intResultset - Specifies the maximum number of rows returned in a result set. A value of 0 specifies no maximum. For more information, check ROWSPERRESULTSET docs.
- Rsa
Public stringKey - Specifies the user’s RSA public key; used for key-pair authentication. Must be on 1 line without header and trailer.
- Rsa
Public stringKey2 - Specifies the user’s second RSA public key; used to rotate the public and private keys for key-pair authentication based on an expiration schedule set by your organization. Must be on 1 line without header and trailer.
- S3Stage
Vpce stringDns Name - Specifies the DNS name of an Amazon S3 interface endpoint. Requests sent to the internal stage of an account via AWS PrivateLink for Amazon S3 use this endpoint to connect. For more information, see Accessing Internal stages with dedicated interface endpoints. For more information, check S3STAGEVPCEDNSNAME docs.
- Search
Path string - Specifies the path to search to resolve unqualified object names in queries. For more information, see Name resolution in queries. Comma-separated list of identifiers. An identifier can be a fully or partially qualified schema name. For more information, check SEARCH_PATH docs.
- Simulated
Data stringSharing Consumer - Specifies the name of a consumer account to simulate for testing/validating shared data, particularly shared secure views. When this parameter is set in a session, shared views return rows as if executed in the specified consumer account rather than the provider account. For more information, see Introduction to Secure Data Sharing and Working with shares. For more information, check SIMULATEDDATASHARING_CONSUMER docs.
- Statement
Queued intTimeout In Seconds - Amount of time, in seconds, a SQL statement (query, DDL, DML, etc.) remains queued for a warehouse before it is canceled by the system. This parameter can be used in conjunction with the MAXCONCURRENCYLEVEL parameter to ensure a warehouse is never backlogged. For more information, check STATEMENTQUEUEDTIMEOUTINSECONDS docs.
- Statement
Timeout intIn Seconds - Amount of time, in seconds, after which a running SQL statement (query, DDL, DML, etc.) is canceled by the system. For more information, check STATEMENTTIMEOUTIN_SECONDS docs.
- Strict
Json boolOutput - This parameter specifies whether JSON output in a session is compatible with the general standard (as described by http://json.org). By design, Snowflake allows JSON input that contains non-standard values; however, these non-standard values might result in Snowflake outputting JSON that is incompatible with other platforms and languages. This parameter, when enabled, ensures that Snowflake outputs valid/compatible JSON. For more information, check STRICTJSONOUTPUT docs.
- Time
Input stringFormat - Specifies the input format for the TIME data type. For more information, see Date and time input and output formats. Any valid, supported time format or AUTO (AUTO specifies that Snowflake attempts to automatically detect the format of times stored in the system during the session). For more information, check TIMEINPUTFORMAT docs.
- Time
Output stringFormat - Specifies the display format for the TIME data type. For more information, see Date and time input and output formats. For more information, check TIMEOUTPUTFORMAT docs.
- Timestamp
Day boolIs Always24h - Specifies whether the DATEADD function (and its aliases) always consider a day to be exactly 24 hours for expressions that span multiple days. For more information, check TIMESTAMPDAYISALWAYS24H docs.
- Timestamp
Input stringFormat - Specifies the input format for the TIMESTAMP data type alias. For more information, see Date and time input and output formats. Any valid, supported timestamp format or AUTO (AUTO specifies that Snowflake attempts to automatically detect the format of timestamps stored in the system during the session). For more information, check TIMESTAMPINPUTFORMAT docs.
- Timestamp
Ltz stringOutput Format - Specifies the display format for the TIMESTAMPLTZ data type. If no format is specified, defaults to OUTPUT*FORMATTIMESTAMP. For more information, see Date and time input and output formats. For more information, check TIMESTAMPLTZOUTPUT*FORMAT docs.
- Timestamp
Ntz stringOutput Format - Specifies the display format for the TIMESTAMPNTZ data type. For more information, check NTZOUTPUTFORMAT docsTIMESTAMP.
- Timestamp
Output stringFormat - Specifies the display format for the TIMESTAMP data type alias. For more information, see Date and time input and output formats. For more information, check TIMESTAMPOUTPUTFORMAT docs.
- Timestamp
Type stringMapping - Specifies the TIMESTAMP** variation that the TIMESTAMP data type alias maps to. For more information, check TIMESTAMP*TYPE_MAPPING docs.
- Timestamp
Tz stringOutput Format - Specifies the display format for the TIMESTAMPTZ data type. If no format is specified, defaults to OUTPUT*FORMATTIMESTAMP. For more information, see Date and time input and output formats. For more information, check TIMESTAMPTZOUTPUT*FORMAT docs.
- Timezone string
- Specifies the time zone for the session. You can specify a time zone name or a link name from release 2021a of the IANA Time Zone Database (e.g. America/Los_Angeles, Europe/London, UTC, Etc/GMT, etc.). For more information, check TIMEZONE docs.
- Trace
Level string - Controls how trace events are ingested into the event table. For more information about trace levels, see Setting trace level. For more information, check TRACE_LEVEL docs.
- Transaction
Abort boolOn Error - Specifies the action to perform when a statement issued within a non-autocommit transaction returns with an error. For more information, check TRANSACTIONABORTON_ERROR docs.
- Transaction
Default stringIsolation Level - Specifies the isolation level for transactions in the user session. For more information, check TRANSACTIONDEFAULTISOLATION_LEVEL docs.
- Two
Digit intCentury Start - Specifies the “century start” year for 2-digit years (i.e. the earliest year such dates can represent). This parameter prevents ambiguous dates when importing or converting data with the
YY
date format component (i.e. years represented as 2 digits). For more information, check TWODIGITCENTURY_START docs. - Unsupported
Ddl stringAction - Determines if an unsupported (i.e. non-default) value specified for a constraint property returns an error. For more information, check UNSUPPORTEDDDLACTION docs.
- Use
Cached boolResult - Specifies whether to reuse persisted query results, if available, when a matching query is submitted. For more information, check USECACHEDRESULT docs.
- Week
Of intYear Policy - Specifies how the weeks in a given year are computed.
0
: The semantics used are equivalent to the ISO semantics, in which a week belongs to a given year if at least 4 days of that week are in that year.1
: January 1 is included in the first week of the year and December 31 is included in the last week of the year. For more information, check WEEKOFYEAR_POLICY docs. - Week
Start int - Specifies the first day of the week (used by week-related date functions).
0
: Legacy Snowflake behavior is used (i.e. ISO-like semantics).1
(Monday) to7
(Sunday): All the week-related functions use weeks that start on the specified day of the week. For more information, check WEEK_START docs.
- Abort
Detached boolQuery - Specifies the action that Snowflake performs for in-progress queries if connectivity is lost due to abrupt termination of a session (e.g. network outage, browser termination, service interruption). For more information, check ABORTDETACHEDQUERY docs.
- Autocommit bool
- Specifies whether autocommit is enabled for the session. Autocommit determines whether a DML statement, when executed without an active transaction, is automatically committed after the statement successfully completes. For more information, see Transactions. For more information, check AUTOCOMMIT docs.
- Binary
Input stringFormat - The format of VARCHAR values passed as input to VARCHAR-to-BINARY conversion functions. For more information, see Binary input and output. For more information, check BINARYINPUTFORMAT docs.
- Binary
Output stringFormat - The format for VARCHAR values returned as output by BINARY-to-VARCHAR conversion functions. For more information, see Binary input and output. For more information, check BINARYOUTPUTFORMAT docs.
- Client
Memory intLimit - Parameter that specifies the maximum amount of memory the JDBC driver or ODBC driver should use for the result set from queries (in MB). For more information, check CLIENTMEMORYLIMIT docs.
- Client
Metadata boolRequest Use Connection Ctx - For specific ODBC functions and JDBC methods, this parameter can change the default search scope from all databases/schemas to the current database/schema. The narrower search typically returns fewer rows and executes more quickly. For more information, check CLIENTMETADATAREQUESTUSECONNECTION_CTX docs.
- Client
Prefetch intThreads - Parameter that specifies the number of threads used by the client to pre-fetch large result sets. The driver will attempt to honor the parameter value, but defines the minimum and maximum values (depending on your system’s resources) to improve performance. For more information, check CLIENTPREFETCHTHREADS docs.
- Client
Result intChunk Size - Parameter that specifies the maximum size of each set (or chunk) of query results to download (in MB). The JDBC driver downloads query results in chunks. For more information, check CLIENTRESULTCHUNK_SIZE docs.
- Client
Result boolColumn Case Insensitive - Parameter that indicates whether to match column name case-insensitively in ResultSet.get* methods in JDBC. For more information, check CLIENTRESULTCOLUMNCASEINSENSITIVE docs.
- Client
Session boolKeep Alive - Parameter that indicates whether to force a user to log in again after a period of inactivity in the session. For more information, check CLIENTSESSIONKEEP_ALIVE docs.
- Client
Session intKeep Alive Heartbeat Frequency - Number of seconds in-between client attempts to update the token for the session. For more information, check CLIENTSESSIONKEEPALIVEHEARTBEAT_FREQUENCY docs.
- Client
Timestamp stringType Mapping - Specifies the TIMESTAMP_* variation to use when binding timestamp variables for JDBC or ODBC applications that use the bind API to load data. For more information, check CLIENTTIMESTAMPTYPE_MAPPING docs.
- Comment string
- Specifies a comment for the user.
- Date
Input stringFormat - Specifies the input format for the DATE data type. For more information, see Date and time input and output formats. For more information, check DATEINPUTFORMAT docs.
- Date
Output stringFormat - Specifies the display format for the DATE data type. For more information, see Date and time input and output formats. For more information, check DATEOUTPUTFORMAT docs.
- Days
To intExpiry - Default
Namespace string - Specifies the namespace (database only or database and schema) that is active by default for the user’s session upon login. Note that the CREATE USER operation does not verify that the namespace exists.
- Default
Role string - Specifies the role that is active by default for the user’s session upon login. Note that specifying a default role for a user does not grant the role to the user. The role must be granted explicitly to the user using the GRANT ROLE command. In addition, the CREATE USER operation does not verify that the role exists.
- Default
Secondary stringRoles Option - Specifies the secondary roles that are active for the user’s session upon login. Valid values are (case-insensitive):
DEFAULT
|NONE
|ALL
. More information can be found in doc. - Default
Warehouse string - Specifies the virtual warehouse that is active by default for the user’s session upon login. Note that the CREATE USER operation does not verify that the warehouse exists.
- Disabled string
- Specifies whether the user is disabled, which prevents logging in and aborts all the currently-running queries for the user. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
- Display
Name string - Name displayed for the user in the Snowflake web interface.
- Email string
- Email address for the user.
- Enable
Unload boolPhysical Type Optimization - Specifies whether to set the schema for unloaded Parquet files based on the logical column data types (i.e. the types in the unload SQL query or source table) or on the unloaded column values (i.e. the smallest data types and precision that support the values in the output columns of the unload SQL statement or source table). For more information, check ENABLEUNLOADPHYSICALTYPEOPTIMIZATION docs.
- Enable
Unredacted boolQuery Syntax Error - Controls whether query text is redacted if a SQL query fails due to a syntax or parsing error. If
FALSE
, the content of a failed query is redacted in the views, pages, and functions that provide a query history. Only users with a role that is granted or inherits the AUDIT privilege can set the ENABLEUNREDACTEDQUERYSYNTAXERROR parameter. When using the ALTER USER command to set the parameter toTRUE
for a particular user, modify the user that you want to see the query text, not the user who executed the query (if those are different users). For more information, check UNREDACTEDQUERYSYNTAXERROR docsENABLE. - Error
On boolNondeterministic Merge - Specifies whether to return an error when the MERGE command is used to update or delete a target row that joins multiple source rows and the system cannot determine the action to perform on the target row. For more information, check ERRORONNONDETERMINISTIC_MERGE docs.
- Error
On boolNondeterministic Update - Specifies whether to return an error when the UPDATE command is used to update a target row that joins multiple source rows and the system cannot determine the action to perform on the target row. For more information, check ERRORONNONDETERMINISTIC_UPDATE docs.
- Geography
Output stringFormat - Display format for GEOGRAPHY values. For more information, check GEOGRAPHYOUTPUTFORMAT docs.
- Geometry
Output stringFormat - Display format for GEOMETRY values. For more information, check GEOMETRYOUTPUTFORMAT docs.
- Jdbc
Treat boolDecimal As Int - Specifies how JDBC processes columns that have a scale of zero (0). For more information, check JDBCTREATDECIMALASINT docs.
- Jdbc
Treat boolTimestamp Ntz As Utc - Specifies how JDBC processes TIMESTAMPNTZ values. For more information, check TREATTIMESTAMPNTZASUTC docsJDBC.
- Jdbc
Use boolSession Timezone - Specifies whether the JDBC Driver uses the time zone of the JVM or the time zone of the session (specified by the TIMEZONE parameter) for the getDate(), getTime(), and getTimestamp() methods of the ResultSet class. For more information, check JDBCUSESESSION_TIMEZONE docs.
- Json
Indent int - Specifies the number of blank spaces to indent each new element in JSON output in the session. Also specifies whether to insert newline characters after each element. For more information, check JSON_INDENT docs.
- Lock
Timeout int - Number of seconds to wait while trying to lock a resource, before timing out and aborting the statement. For more information, check LOCK_TIMEOUT docs.
- Log
Level string - Specifies the severity level of messages that should be ingested and made available in the active event table. Messages at the specified level (and at more severe levels) are ingested. For more information about log levels, see Setting log level. For more information, check LOG_LEVEL docs.
- Login
Name string - The name users use to log in. If not supplied, snowflake will use name instead. Login names are always case-insensitive.
- Mins
To intUnlock - Multi
Statement intCount - Number of statements to execute when using the multi-statement capability. For more information, check MULTISTATEMENTCOUNT docs.
- Must
Change stringPassword - Specifies whether the user is forced to change their password on next login (including their first/initial login) into the system. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
- Name string
- Name of the user. Note that if you do not supply loginname this will be used as loginname. Check the docs. Due to technical limitations (read more here), avoid using the following characters:
|
,.
,(
,)
,"
- Network
Policy string - Specifies the network policy to enforce for your account. Network policies enable restricting access to your account based on users’ IP address. For more details, see Controlling network traffic with network policies. Any existing network policy (created using CREATE NETWORK POLICY). For more information, check NETWORK_POLICY docs.
- Noorder
Sequence boolAs Default - Specifies whether the ORDER or NOORDER property is set by default when you create a new sequence or add a new table column. The ORDER and NOORDER properties determine whether or not the values are generated for the sequence or auto-incremented column in increasing or decreasing order. For more information, check NOORDERSEQUENCEAS_DEFAULT docs.
- Odbc
Treat boolDecimal As Int - Specifies how ODBC processes columns that have a scale of zero (0). For more information, check ODBCTREATDECIMALASINT docs.
- Password string
- Prevent
Unload boolTo Internal Stages - Specifies whether to prevent data unload operations to internal (Snowflake) stages using COPY INTO \n\n statements. For more information, check PREVENTUNLOADTOINTERNALSTAGES docs.
- Query
Tag string - Optional string that can be used to tag queries and other SQL statements executed within a session. The tags are displayed in the output of the QUERYHISTORY, QUERYHISTORY*BY** functions. For more information, check QUERY_TAG docs.
- Quoted
Identifiers boolIgnore Case - Specifies whether letters in double-quoted object identifiers are stored and resolved as uppercase letters. By default, Snowflake preserves the case of alphabetic characters when storing and resolving double-quoted identifiers (see Identifier resolution). You can use this parameter in situations in which third-party applications always use double quotes around identifiers. For more information, check QUOTEDIDENTIFIERSIGNORE_CASE docs.
- Rows
Per intResultset - Specifies the maximum number of rows returned in a result set. A value of 0 specifies no maximum. For more information, check ROWSPERRESULTSET docs.
- Rsa
Public stringKey - Specifies the user’s RSA public key; used for key-pair authentication. Must be on 1 line without header and trailer.
- Rsa
Public stringKey2 - Specifies the user’s second RSA public key; used to rotate the public and private keys for key-pair authentication based on an expiration schedule set by your organization. Must be on 1 line without header and trailer.
- S3Stage
Vpce stringDns Name - Specifies the DNS name of an Amazon S3 interface endpoint. Requests sent to the internal stage of an account via AWS PrivateLink for Amazon S3 use this endpoint to connect. For more information, see Accessing Internal stages with dedicated interface endpoints. For more information, check S3STAGEVPCEDNSNAME docs.
- Search
Path string - Specifies the path to search to resolve unqualified object names in queries. For more information, see Name resolution in queries. Comma-separated list of identifiers. An identifier can be a fully or partially qualified schema name. For more information, check SEARCH_PATH docs.
- Simulated
Data stringSharing Consumer - Specifies the name of a consumer account to simulate for testing/validating shared data, particularly shared secure views. When this parameter is set in a session, shared views return rows as if executed in the specified consumer account rather than the provider account. For more information, see Introduction to Secure Data Sharing and Working with shares. For more information, check SIMULATEDDATASHARING_CONSUMER docs.
- Statement
Queued intTimeout In Seconds - Amount of time, in seconds, a SQL statement (query, DDL, DML, etc.) remains queued for a warehouse before it is canceled by the system. This parameter can be used in conjunction with the MAXCONCURRENCYLEVEL parameter to ensure a warehouse is never backlogged. For more information, check STATEMENTQUEUEDTIMEOUTINSECONDS docs.
- Statement
Timeout intIn Seconds - Amount of time, in seconds, after which a running SQL statement (query, DDL, DML, etc.) is canceled by the system. For more information, check STATEMENTTIMEOUTIN_SECONDS docs.
- Strict
Json boolOutput - This parameter specifies whether JSON output in a session is compatible with the general standard (as described by http://json.org). By design, Snowflake allows JSON input that contains non-standard values; however, these non-standard values might result in Snowflake outputting JSON that is incompatible with other platforms and languages. This parameter, when enabled, ensures that Snowflake outputs valid/compatible JSON. For more information, check STRICTJSONOUTPUT docs.
- Time
Input stringFormat - Specifies the input format for the TIME data type. For more information, see Date and time input and output formats. Any valid, supported time format or AUTO (AUTO specifies that Snowflake attempts to automatically detect the format of times stored in the system during the session). For more information, check TIMEINPUTFORMAT docs.
- Time
Output stringFormat - Specifies the display format for the TIME data type. For more information, see Date and time input and output formats. For more information, check TIMEOUTPUTFORMAT docs.
- Timestamp
Day boolIs Always24h - Specifies whether the DATEADD function (and its aliases) always consider a day to be exactly 24 hours for expressions that span multiple days. For more information, check TIMESTAMPDAYISALWAYS24H docs.
- Timestamp
Input stringFormat - Specifies the input format for the TIMESTAMP data type alias. For more information, see Date and time input and output formats. Any valid, supported timestamp format or AUTO (AUTO specifies that Snowflake attempts to automatically detect the format of timestamps stored in the system during the session). For more information, check TIMESTAMPINPUTFORMAT docs.
- Timestamp
Ltz stringOutput Format - Specifies the display format for the TIMESTAMPLTZ data type. If no format is specified, defaults to OUTPUT*FORMATTIMESTAMP. For more information, see Date and time input and output formats. For more information, check TIMESTAMPLTZOUTPUT*FORMAT docs.
- Timestamp
Ntz stringOutput Format - Specifies the display format for the TIMESTAMPNTZ data type. For more information, check NTZOUTPUTFORMAT docsTIMESTAMP.
- Timestamp
Output stringFormat - Specifies the display format for the TIMESTAMP data type alias. For more information, see Date and time input and output formats. For more information, check TIMESTAMPOUTPUTFORMAT docs.
- Timestamp
Type stringMapping - Specifies the TIMESTAMP** variation that the TIMESTAMP data type alias maps to. For more information, check TIMESTAMP*TYPE_MAPPING docs.
- Timestamp
Tz stringOutput Format - Specifies the display format for the TIMESTAMPTZ data type. If no format is specified, defaults to OUTPUT*FORMATTIMESTAMP. For more information, see Date and time input and output formats. For more information, check TIMESTAMPTZOUTPUT*FORMAT docs.
- Timezone string
- Specifies the time zone for the session. You can specify a time zone name or a link name from release 2021a of the IANA Time Zone Database (e.g. America/Los_Angeles, Europe/London, UTC, Etc/GMT, etc.). For more information, check TIMEZONE docs.
- Trace
Level string - Controls how trace events are ingested into the event table. For more information about trace levels, see Setting trace level. For more information, check TRACE_LEVEL docs.
- Transaction
Abort boolOn Error - Specifies the action to perform when a statement issued within a non-autocommit transaction returns with an error. For more information, check TRANSACTIONABORTON_ERROR docs.
- Transaction
Default stringIsolation Level - Specifies the isolation level for transactions in the user session. For more information, check TRANSACTIONDEFAULTISOLATION_LEVEL docs.
- Two
Digit intCentury Start - Specifies the “century start” year for 2-digit years (i.e. the earliest year such dates can represent). This parameter prevents ambiguous dates when importing or converting data with the
YY
date format component (i.e. years represented as 2 digits). For more information, check TWODIGITCENTURY_START docs. - Unsupported
Ddl stringAction - Determines if an unsupported (i.e. non-default) value specified for a constraint property returns an error. For more information, check UNSUPPORTEDDDLACTION docs.
- Use
Cached boolResult - Specifies whether to reuse persisted query results, if available, when a matching query is submitted. For more information, check USECACHEDRESULT docs.
- Week
Of intYear Policy - Specifies how the weeks in a given year are computed.
0
: The semantics used are equivalent to the ISO semantics, in which a week belongs to a given year if at least 4 days of that week are in that year.1
: January 1 is included in the first week of the year and December 31 is included in the last week of the year. For more information, check WEEKOFYEAR_POLICY docs. - Week
Start int - Specifies the first day of the week (used by week-related date functions).
0
: Legacy Snowflake behavior is used (i.e. ISO-like semantics).1
(Monday) to7
(Sunday): All the week-related functions use weeks that start on the specified day of the week. For more information, check WEEK_START docs.
- abort
Detached BooleanQuery - Specifies the action that Snowflake performs for in-progress queries if connectivity is lost due to abrupt termination of a session (e.g. network outage, browser termination, service interruption). For more information, check ABORTDETACHEDQUERY docs.
- autocommit Boolean
- Specifies whether autocommit is enabled for the session. Autocommit determines whether a DML statement, when executed without an active transaction, is automatically committed after the statement successfully completes. For more information, see Transactions. For more information, check AUTOCOMMIT docs.
- binary
Input StringFormat - The format of VARCHAR values passed as input to VARCHAR-to-BINARY conversion functions. For more information, see Binary input and output. For more information, check BINARYINPUTFORMAT docs.
- binary
Output StringFormat - The format for VARCHAR values returned as output by BINARY-to-VARCHAR conversion functions. For more information, see Binary input and output. For more information, check BINARYOUTPUTFORMAT docs.
- client
Memory IntegerLimit - Parameter that specifies the maximum amount of memory the JDBC driver or ODBC driver should use for the result set from queries (in MB). For more information, check CLIENTMEMORYLIMIT docs.
- client
Metadata BooleanRequest Use Connection Ctx - For specific ODBC functions and JDBC methods, this parameter can change the default search scope from all databases/schemas to the current database/schema. The narrower search typically returns fewer rows and executes more quickly. For more information, check CLIENTMETADATAREQUESTUSECONNECTION_CTX docs.
- client
Prefetch IntegerThreads - Parameter that specifies the number of threads used by the client to pre-fetch large result sets. The driver will attempt to honor the parameter value, but defines the minimum and maximum values (depending on your system’s resources) to improve performance. For more information, check CLIENTPREFETCHTHREADS docs.
- client
Result IntegerChunk Size - Parameter that specifies the maximum size of each set (or chunk) of query results to download (in MB). The JDBC driver downloads query results in chunks. For more information, check CLIENTRESULTCHUNK_SIZE docs.
- client
Result BooleanColumn Case Insensitive - Parameter that indicates whether to match column name case-insensitively in ResultSet.get* methods in JDBC. For more information, check CLIENTRESULTCOLUMNCASEINSENSITIVE docs.
- client
Session BooleanKeep Alive - Parameter that indicates whether to force a user to log in again after a period of inactivity in the session. For more information, check CLIENTSESSIONKEEP_ALIVE docs.
- client
Session IntegerKeep Alive Heartbeat Frequency - Number of seconds in-between client attempts to update the token for the session. For more information, check CLIENTSESSIONKEEPALIVEHEARTBEAT_FREQUENCY docs.
- client
Timestamp StringType Mapping - Specifies the TIMESTAMP_* variation to use when binding timestamp variables for JDBC or ODBC applications that use the bind API to load data. For more information, check CLIENTTIMESTAMPTYPE_MAPPING docs.
- comment String
- Specifies a comment for the user.
- date
Input StringFormat - Specifies the input format for the DATE data type. For more information, see Date and time input and output formats. For more information, check DATEINPUTFORMAT docs.
- date
Output StringFormat - Specifies the display format for the DATE data type. For more information, see Date and time input and output formats. For more information, check DATEOUTPUTFORMAT docs.
- days
To IntegerExpiry - default
Namespace String - Specifies the namespace (database only or database and schema) that is active by default for the user’s session upon login. Note that the CREATE USER operation does not verify that the namespace exists.
- default
Role String - Specifies the role that is active by default for the user’s session upon login. Note that specifying a default role for a user does not grant the role to the user. The role must be granted explicitly to the user using the GRANT ROLE command. In addition, the CREATE USER operation does not verify that the role exists.
- default
Secondary StringRoles Option - Specifies the secondary roles that are active for the user’s session upon login. Valid values are (case-insensitive):
DEFAULT
|NONE
|ALL
. More information can be found in doc. - default
Warehouse String - Specifies the virtual warehouse that is active by default for the user’s session upon login. Note that the CREATE USER operation does not verify that the warehouse exists.
- disabled String
- Specifies whether the user is disabled, which prevents logging in and aborts all the currently-running queries for the user. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
- display
Name String - Name displayed for the user in the Snowflake web interface.
- email String
- Email address for the user.
- enable
Unload BooleanPhysical Type Optimization - Specifies whether to set the schema for unloaded Parquet files based on the logical column data types (i.e. the types in the unload SQL query or source table) or on the unloaded column values (i.e. the smallest data types and precision that support the values in the output columns of the unload SQL statement or source table). For more information, check ENABLEUNLOADPHYSICALTYPEOPTIMIZATION docs.
- enable
Unredacted BooleanQuery Syntax Error - Controls whether query text is redacted if a SQL query fails due to a syntax or parsing error. If
FALSE
, the content of a failed query is redacted in the views, pages, and functions that provide a query history. Only users with a role that is granted or inherits the AUDIT privilege can set the ENABLEUNREDACTEDQUERYSYNTAXERROR parameter. When using the ALTER USER command to set the parameter toTRUE
for a particular user, modify the user that you want to see the query text, not the user who executed the query (if those are different users). For more information, check UNREDACTEDQUERYSYNTAXERROR docsENABLE. - error
On BooleanNondeterministic Merge - Specifies whether to return an error when the MERGE command is used to update or delete a target row that joins multiple source rows and the system cannot determine the action to perform on the target row. For more information, check ERRORONNONDETERMINISTIC_MERGE docs.
- error
On BooleanNondeterministic Update - Specifies whether to return an error when the UPDATE command is used to update a target row that joins multiple source rows and the system cannot determine the action to perform on the target row. For more information, check ERRORONNONDETERMINISTIC_UPDATE docs.
- geography
Output StringFormat - Display format for GEOGRAPHY values. For more information, check GEOGRAPHYOUTPUTFORMAT docs.
- geometry
Output StringFormat - Display format for GEOMETRY values. For more information, check GEOMETRYOUTPUTFORMAT docs.
- jdbc
Treat BooleanDecimal As Int - Specifies how JDBC processes columns that have a scale of zero (0). For more information, check JDBCTREATDECIMALASINT docs.
- jdbc
Treat BooleanTimestamp Ntz As Utc - Specifies how JDBC processes TIMESTAMPNTZ values. For more information, check TREATTIMESTAMPNTZASUTC docsJDBC.
- jdbc
Use BooleanSession Timezone - Specifies whether the JDBC Driver uses the time zone of the JVM or the time zone of the session (specified by the TIMEZONE parameter) for the getDate(), getTime(), and getTimestamp() methods of the ResultSet class. For more information, check JDBCUSESESSION_TIMEZONE docs.
- json
Indent Integer - Specifies the number of blank spaces to indent each new element in JSON output in the session. Also specifies whether to insert newline characters after each element. For more information, check JSON_INDENT docs.
- lock
Timeout Integer - Number of seconds to wait while trying to lock a resource, before timing out and aborting the statement. For more information, check LOCK_TIMEOUT docs.
- log
Level String - Specifies the severity level of messages that should be ingested and made available in the active event table. Messages at the specified level (and at more severe levels) are ingested. For more information about log levels, see Setting log level. For more information, check LOG_LEVEL docs.
- login
Name String - The name users use to log in. If not supplied, snowflake will use name instead. Login names are always case-insensitive.
- mins
To IntegerUnlock - multi
Statement IntegerCount - Number of statements to execute when using the multi-statement capability. For more information, check MULTISTATEMENTCOUNT docs.
- must
Change StringPassword - Specifies whether the user is forced to change their password on next login (including their first/initial login) into the system. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
- name String
- Name of the user. Note that if you do not supply loginname this will be used as loginname. Check the docs. Due to technical limitations (read more here), avoid using the following characters:
|
,.
,(
,)
,"
- network
Policy String - Specifies the network policy to enforce for your account. Network policies enable restricting access to your account based on users’ IP address. For more details, see Controlling network traffic with network policies. Any existing network policy (created using CREATE NETWORK POLICY). For more information, check NETWORK_POLICY docs.
- noorder
Sequence BooleanAs Default - Specifies whether the ORDER or NOORDER property is set by default when you create a new sequence or add a new table column. The ORDER and NOORDER properties determine whether or not the values are generated for the sequence or auto-incremented column in increasing or decreasing order. For more information, check NOORDERSEQUENCEAS_DEFAULT docs.
- odbc
Treat BooleanDecimal As Int - Specifies how ODBC processes columns that have a scale of zero (0). For more information, check ODBCTREATDECIMALASINT docs.
- password String
- prevent
Unload BooleanTo Internal Stages - Specifies whether to prevent data unload operations to internal (Snowflake) stages using COPY INTO \n\n statements. For more information, check PREVENTUNLOADTOINTERNALSTAGES docs.
- query
Tag String - Optional string that can be used to tag queries and other SQL statements executed within a session. The tags are displayed in the output of the QUERYHISTORY, QUERYHISTORY*BY** functions. For more information, check QUERY_TAG docs.
- quoted
Identifiers BooleanIgnore Case - Specifies whether letters in double-quoted object identifiers are stored and resolved as uppercase letters. By default, Snowflake preserves the case of alphabetic characters when storing and resolving double-quoted identifiers (see Identifier resolution). You can use this parameter in situations in which third-party applications always use double quotes around identifiers. For more information, check QUOTEDIDENTIFIERSIGNORE_CASE docs.
- rows
Per IntegerResultset - Specifies the maximum number of rows returned in a result set. A value of 0 specifies no maximum. For more information, check ROWSPERRESULTSET docs.
- rsa
Public StringKey - Specifies the user’s RSA public key; used for key-pair authentication. Must be on 1 line without header and trailer.
- rsa
Public StringKey2 - Specifies the user’s second RSA public key; used to rotate the public and private keys for key-pair authentication based on an expiration schedule set by your organization. Must be on 1 line without header and trailer.
- s3Stage
Vpce StringDns Name - Specifies the DNS name of an Amazon S3 interface endpoint. Requests sent to the internal stage of an account via AWS PrivateLink for Amazon S3 use this endpoint to connect. For more information, see Accessing Internal stages with dedicated interface endpoints. For more information, check S3STAGEVPCEDNSNAME docs.
- search
Path String - Specifies the path to search to resolve unqualified object names in queries. For more information, see Name resolution in queries. Comma-separated list of identifiers. An identifier can be a fully or partially qualified schema name. For more information, check SEARCH_PATH docs.
- simulated
Data StringSharing Consumer - Specifies the name of a consumer account to simulate for testing/validating shared data, particularly shared secure views. When this parameter is set in a session, shared views return rows as if executed in the specified consumer account rather than the provider account. For more information, see Introduction to Secure Data Sharing and Working with shares. For more information, check SIMULATEDDATASHARING_CONSUMER docs.
- statement
Queued IntegerTimeout In Seconds - Amount of time, in seconds, a SQL statement (query, DDL, DML, etc.) remains queued for a warehouse before it is canceled by the system. This parameter can be used in conjunction with the MAXCONCURRENCYLEVEL parameter to ensure a warehouse is never backlogged. For more information, check STATEMENTQUEUEDTIMEOUTINSECONDS docs.
- statement
Timeout IntegerIn Seconds - Amount of time, in seconds, after which a running SQL statement (query, DDL, DML, etc.) is canceled by the system. For more information, check STATEMENTTIMEOUTIN_SECONDS docs.
- strict
Json BooleanOutput - This parameter specifies whether JSON output in a session is compatible with the general standard (as described by http://json.org). By design, Snowflake allows JSON input that contains non-standard values; however, these non-standard values might result in Snowflake outputting JSON that is incompatible with other platforms and languages. This parameter, when enabled, ensures that Snowflake outputs valid/compatible JSON. For more information, check STRICTJSONOUTPUT docs.
- time
Input StringFormat - Specifies the input format for the TIME data type. For more information, see Date and time input and output formats. Any valid, supported time format or AUTO (AUTO specifies that Snowflake attempts to automatically detect the format of times stored in the system during the session). For more information, check TIMEINPUTFORMAT docs.
- time
Output StringFormat - Specifies the display format for the TIME data type. For more information, see Date and time input and output formats. For more information, check TIMEOUTPUTFORMAT docs.
- timestamp
Day BooleanIs Always24h - Specifies whether the DATEADD function (and its aliases) always consider a day to be exactly 24 hours for expressions that span multiple days. For more information, check TIMESTAMPDAYISALWAYS24H docs.
- timestamp
Input StringFormat - Specifies the input format for the TIMESTAMP data type alias. For more information, see Date and time input and output formats. Any valid, supported timestamp format or AUTO (AUTO specifies that Snowflake attempts to automatically detect the format of timestamps stored in the system during the session). For more information, check TIMESTAMPINPUTFORMAT docs.
- timestamp
Ltz StringOutput Format - Specifies the display format for the TIMESTAMPLTZ data type. If no format is specified, defaults to OUTPUT*FORMATTIMESTAMP. For more information, see Date and time input and output formats. For more information, check TIMESTAMPLTZOUTPUT*FORMAT docs.
- timestamp
Ntz StringOutput Format - Specifies the display format for the TIMESTAMPNTZ data type. For more information, check NTZOUTPUTFORMAT docsTIMESTAMP.
- timestamp
Output StringFormat - Specifies the display format for the TIMESTAMP data type alias. For more information, see Date and time input and output formats. For more information, check TIMESTAMPOUTPUTFORMAT docs.
- timestamp
Type StringMapping - Specifies the TIMESTAMP** variation that the TIMESTAMP data type alias maps to. For more information, check TIMESTAMP*TYPE_MAPPING docs.
- timestamp
Tz StringOutput Format - Specifies the display format for the TIMESTAMPTZ data type. If no format is specified, defaults to OUTPUT*FORMATTIMESTAMP. For more information, see Date and time input and output formats. For more information, check TIMESTAMPTZOUTPUT*FORMAT docs.
- timezone String
- Specifies the time zone for the session. You can specify a time zone name or a link name from release 2021a of the IANA Time Zone Database (e.g. America/Los_Angeles, Europe/London, UTC, Etc/GMT, etc.). For more information, check TIMEZONE docs.
- trace
Level String - Controls how trace events are ingested into the event table. For more information about trace levels, see Setting trace level. For more information, check TRACE_LEVEL docs.
- transaction
Abort BooleanOn Error - Specifies the action to perform when a statement issued within a non-autocommit transaction returns with an error. For more information, check TRANSACTIONABORTON_ERROR docs.
- transaction
Default StringIsolation Level - Specifies the isolation level for transactions in the user session. For more information, check TRANSACTIONDEFAULTISOLATION_LEVEL docs.
- two
Digit IntegerCentury Start - Specifies the “century start” year for 2-digit years (i.e. the earliest year such dates can represent). This parameter prevents ambiguous dates when importing or converting data with the
YY
date format component (i.e. years represented as 2 digits). For more information, check TWODIGITCENTURY_START docs. - unsupported
Ddl StringAction - Determines if an unsupported (i.e. non-default) value specified for a constraint property returns an error. For more information, check UNSUPPORTEDDDLACTION docs.
- use
Cached BooleanResult - Specifies whether to reuse persisted query results, if available, when a matching query is submitted. For more information, check USECACHEDRESULT docs.
- week
Of IntegerYear Policy - Specifies how the weeks in a given year are computed.
0
: The semantics used are equivalent to the ISO semantics, in which a week belongs to a given year if at least 4 days of that week are in that year.1
: January 1 is included in the first week of the year and December 31 is included in the last week of the year. For more information, check WEEKOFYEAR_POLICY docs. - week
Start Integer - Specifies the first day of the week (used by week-related date functions).
0
: Legacy Snowflake behavior is used (i.e. ISO-like semantics).1
(Monday) to7
(Sunday): All the week-related functions use weeks that start on the specified day of the week. For more information, check WEEK_START docs.
- abort
Detached booleanQuery - Specifies the action that Snowflake performs for in-progress queries if connectivity is lost due to abrupt termination of a session (e.g. network outage, browser termination, service interruption). For more information, check ABORTDETACHEDQUERY docs.
- autocommit boolean
- Specifies whether autocommit is enabled for the session. Autocommit determines whether a DML statement, when executed without an active transaction, is automatically committed after the statement successfully completes. For more information, see Transactions. For more information, check AUTOCOMMIT docs.
- binary
Input stringFormat - The format of VARCHAR values passed as input to VARCHAR-to-BINARY conversion functions. For more information, see Binary input and output. For more information, check BINARYINPUTFORMAT docs.
- binary
Output stringFormat - The format for VARCHAR values returned as output by BINARY-to-VARCHAR conversion functions. For more information, see Binary input and output. For more information, check BINARYOUTPUTFORMAT docs.
- client
Memory numberLimit - Parameter that specifies the maximum amount of memory the JDBC driver or ODBC driver should use for the result set from queries (in MB). For more information, check CLIENTMEMORYLIMIT docs.
- client
Metadata booleanRequest Use Connection Ctx - For specific ODBC functions and JDBC methods, this parameter can change the default search scope from all databases/schemas to the current database/schema. The narrower search typically returns fewer rows and executes more quickly. For more information, check CLIENTMETADATAREQUESTUSECONNECTION_CTX docs.
- client
Prefetch numberThreads - Parameter that specifies the number of threads used by the client to pre-fetch large result sets. The driver will attempt to honor the parameter value, but defines the minimum and maximum values (depending on your system’s resources) to improve performance. For more information, check CLIENTPREFETCHTHREADS docs.
- client
Result numberChunk Size - Parameter that specifies the maximum size of each set (or chunk) of query results to download (in MB). The JDBC driver downloads query results in chunks. For more information, check CLIENTRESULTCHUNK_SIZE docs.
- client
Result booleanColumn Case Insensitive - Parameter that indicates whether to match column name case-insensitively in ResultSet.get* methods in JDBC. For more information, check CLIENTRESULTCOLUMNCASEINSENSITIVE docs.
- client
Session booleanKeep Alive - Parameter that indicates whether to force a user to log in again after a period of inactivity in the session. For more information, check CLIENTSESSIONKEEP_ALIVE docs.
- client
Session numberKeep Alive Heartbeat Frequency - Number of seconds in-between client attempts to update the token for the session. For more information, check CLIENTSESSIONKEEPALIVEHEARTBEAT_FREQUENCY docs.
- client
Timestamp stringType Mapping - Specifies the TIMESTAMP_* variation to use when binding timestamp variables for JDBC or ODBC applications that use the bind API to load data. For more information, check CLIENTTIMESTAMPTYPE_MAPPING docs.
- comment string
- Specifies a comment for the user.
- date
Input stringFormat - Specifies the input format for the DATE data type. For more information, see Date and time input and output formats. For more information, check DATEINPUTFORMAT docs.
- date
Output stringFormat - Specifies the display format for the DATE data type. For more information, see Date and time input and output formats. For more information, check DATEOUTPUTFORMAT docs.
- days
To numberExpiry - default
Namespace string - Specifies the namespace (database only or database and schema) that is active by default for the user’s session upon login. Note that the CREATE USER operation does not verify that the namespace exists.
- default
Role string - Specifies the role that is active by default for the user’s session upon login. Note that specifying a default role for a user does not grant the role to the user. The role must be granted explicitly to the user using the GRANT ROLE command. In addition, the CREATE USER operation does not verify that the role exists.
- default
Secondary stringRoles Option - Specifies the secondary roles that are active for the user’s session upon login. Valid values are (case-insensitive):
DEFAULT
|NONE
|ALL
. More information can be found in doc. - default
Warehouse string - Specifies the virtual warehouse that is active by default for the user’s session upon login. Note that the CREATE USER operation does not verify that the warehouse exists.
- disabled string
- Specifies whether the user is disabled, which prevents logging in and aborts all the currently-running queries for the user. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
- display
Name string - Name displayed for the user in the Snowflake web interface.
- email string
- Email address for the user.
- enable
Unload booleanPhysical Type Optimization - Specifies whether to set the schema for unloaded Parquet files based on the logical column data types (i.e. the types in the unload SQL query or source table) or on the unloaded column values (i.e. the smallest data types and precision that support the values in the output columns of the unload SQL statement or source table). For more information, check ENABLEUNLOADPHYSICALTYPEOPTIMIZATION docs.
- enable
Unredacted booleanQuery Syntax Error - Controls whether query text is redacted if a SQL query fails due to a syntax or parsing error. If
FALSE
, the content of a failed query is redacted in the views, pages, and functions that provide a query history. Only users with a role that is granted or inherits the AUDIT privilege can set the ENABLEUNREDACTEDQUERYSYNTAXERROR parameter. When using the ALTER USER command to set the parameter toTRUE
for a particular user, modify the user that you want to see the query text, not the user who executed the query (if those are different users). For more information, check UNREDACTEDQUERYSYNTAXERROR docsENABLE. - error
On booleanNondeterministic Merge - Specifies whether to return an error when the MERGE command is used to update or delete a target row that joins multiple source rows and the system cannot determine the action to perform on the target row. For more information, check ERRORONNONDETERMINISTIC_MERGE docs.
- error
On booleanNondeterministic Update - Specifies whether to return an error when the UPDATE command is used to update a target row that joins multiple source rows and the system cannot determine the action to perform on the target row. For more information, check ERRORONNONDETERMINISTIC_UPDATE docs.
- geography
Output stringFormat - Display format for GEOGRAPHY values. For more information, check GEOGRAPHYOUTPUTFORMAT docs.
- geometry
Output stringFormat - Display format for GEOMETRY values. For more information, check GEOMETRYOUTPUTFORMAT docs.
- jdbc
Treat booleanDecimal As Int - Specifies how JDBC processes columns that have a scale of zero (0). For more information, check JDBCTREATDECIMALASINT docs.
- jdbc
Treat booleanTimestamp Ntz As Utc - Specifies how JDBC processes TIMESTAMPNTZ values. For more information, check TREATTIMESTAMPNTZASUTC docsJDBC.
- jdbc
Use booleanSession Timezone - Specifies whether the JDBC Driver uses the time zone of the JVM or the time zone of the session (specified by the TIMEZONE parameter) for the getDate(), getTime(), and getTimestamp() methods of the ResultSet class. For more information, check JDBCUSESESSION_TIMEZONE docs.
- json
Indent number - Specifies the number of blank spaces to indent each new element in JSON output in the session. Also specifies whether to insert newline characters after each element. For more information, check JSON_INDENT docs.
- lock
Timeout number - Number of seconds to wait while trying to lock a resource, before timing out and aborting the statement. For more information, check LOCK_TIMEOUT docs.
- log
Level string - Specifies the severity level of messages that should be ingested and made available in the active event table. Messages at the specified level (and at more severe levels) are ingested. For more information about log levels, see Setting log level. For more information, check LOG_LEVEL docs.
- login
Name string - The name users use to log in. If not supplied, snowflake will use name instead. Login names are always case-insensitive.
- mins
To numberUnlock - multi
Statement numberCount - Number of statements to execute when using the multi-statement capability. For more information, check MULTISTATEMENTCOUNT docs.
- must
Change stringPassword - Specifies whether the user is forced to change their password on next login (including their first/initial login) into the system. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
- name string
- Name of the user. Note that if you do not supply loginname this will be used as loginname. Check the docs. Due to technical limitations (read more here), avoid using the following characters:
|
,.
,(
,)
,"
- network
Policy string - Specifies the network policy to enforce for your account. Network policies enable restricting access to your account based on users’ IP address. For more details, see Controlling network traffic with network policies. Any existing network policy (created using CREATE NETWORK POLICY). For more information, check NETWORK_POLICY docs.
- noorder
Sequence booleanAs Default - Specifies whether the ORDER or NOORDER property is set by default when you create a new sequence or add a new table column. The ORDER and NOORDER properties determine whether or not the values are generated for the sequence or auto-incremented column in increasing or decreasing order. For more information, check NOORDERSEQUENCEAS_DEFAULT docs.
- odbc
Treat booleanDecimal As Int - Specifies how ODBC processes columns that have a scale of zero (0). For more information, check ODBCTREATDECIMALASINT docs.
- password string
- prevent
Unload booleanTo Internal Stages - Specifies whether to prevent data unload operations to internal (Snowflake) stages using COPY INTO \n\n statements. For more information, check PREVENTUNLOADTOINTERNALSTAGES docs.
- query
Tag string - Optional string that can be used to tag queries and other SQL statements executed within a session. The tags are displayed in the output of the QUERYHISTORY, QUERYHISTORY*BY** functions. For more information, check QUERY_TAG docs.
- quoted
Identifiers booleanIgnore Case - Specifies whether letters in double-quoted object identifiers are stored and resolved as uppercase letters. By default, Snowflake preserves the case of alphabetic characters when storing and resolving double-quoted identifiers (see Identifier resolution). You can use this parameter in situations in which third-party applications always use double quotes around identifiers. For more information, check QUOTEDIDENTIFIERSIGNORE_CASE docs.
- rows
Per numberResultset - Specifies the maximum number of rows returned in a result set. A value of 0 specifies no maximum. For more information, check ROWSPERRESULTSET docs.
- rsa
Public stringKey - Specifies the user’s RSA public key; used for key-pair authentication. Must be on 1 line without header and trailer.
- rsa
Public stringKey2 - Specifies the user’s second RSA public key; used to rotate the public and private keys for key-pair authentication based on an expiration schedule set by your organization. Must be on 1 line without header and trailer.
- s3Stage
Vpce stringDns Name - Specifies the DNS name of an Amazon S3 interface endpoint. Requests sent to the internal stage of an account via AWS PrivateLink for Amazon S3 use this endpoint to connect. For more information, see Accessing Internal stages with dedicated interface endpoints. For more information, check S3STAGEVPCEDNSNAME docs.
- search
Path string - Specifies the path to search to resolve unqualified object names in queries. For more information, see Name resolution in queries. Comma-separated list of identifiers. An identifier can be a fully or partially qualified schema name. For more information, check SEARCH_PATH docs.
- simulated
Data stringSharing Consumer - Specifies the name of a consumer account to simulate for testing/validating shared data, particularly shared secure views. When this parameter is set in a session, shared views return rows as if executed in the specified consumer account rather than the provider account. For more information, see Introduction to Secure Data Sharing and Working with shares. For more information, check SIMULATEDDATASHARING_CONSUMER docs.
- statement
Queued numberTimeout In Seconds - Amount of time, in seconds, a SQL statement (query, DDL, DML, etc.) remains queued for a warehouse before it is canceled by the system. This parameter can be used in conjunction with the MAXCONCURRENCYLEVEL parameter to ensure a warehouse is never backlogged. For more information, check STATEMENTQUEUEDTIMEOUTINSECONDS docs.
- statement
Timeout numberIn Seconds - Amount of time, in seconds, after which a running SQL statement (query, DDL, DML, etc.) is canceled by the system. For more information, check STATEMENTTIMEOUTIN_SECONDS docs.
- strict
Json booleanOutput - This parameter specifies whether JSON output in a session is compatible with the general standard (as described by http://json.org). By design, Snowflake allows JSON input that contains non-standard values; however, these non-standard values might result in Snowflake outputting JSON that is incompatible with other platforms and languages. This parameter, when enabled, ensures that Snowflake outputs valid/compatible JSON. For more information, check STRICTJSONOUTPUT docs.
- time
Input stringFormat - Specifies the input format for the TIME data type. For more information, see Date and time input and output formats. Any valid, supported time format or AUTO (AUTO specifies that Snowflake attempts to automatically detect the format of times stored in the system during the session). For more information, check TIMEINPUTFORMAT docs.
- time
Output stringFormat - Specifies the display format for the TIME data type. For more information, see Date and time input and output formats. For more information, check TIMEOUTPUTFORMAT docs.
- timestamp
Day booleanIs Always24h - Specifies whether the DATEADD function (and its aliases) always consider a day to be exactly 24 hours for expressions that span multiple days. For more information, check TIMESTAMPDAYISALWAYS24H docs.
- timestamp
Input stringFormat - Specifies the input format for the TIMESTAMP data type alias. For more information, see Date and time input and output formats. Any valid, supported timestamp format or AUTO (AUTO specifies that Snowflake attempts to automatically detect the format of timestamps stored in the system during the session). For more information, check TIMESTAMPINPUTFORMAT docs.
- timestamp
Ltz stringOutput Format - Specifies the display format for the TIMESTAMPLTZ data type. If no format is specified, defaults to OUTPUT*FORMATTIMESTAMP. For more information, see Date and time input and output formats. For more information, check TIMESTAMPLTZOUTPUT*FORMAT docs.
- timestamp
Ntz stringOutput Format - Specifies the display format for the TIMESTAMPNTZ data type. For more information, check NTZOUTPUTFORMAT docsTIMESTAMP.
- timestamp
Output stringFormat - Specifies the display format for the TIMESTAMP data type alias. For more information, see Date and time input and output formats. For more information, check TIMESTAMPOUTPUTFORMAT docs.
- timestamp
Type stringMapping - Specifies the TIMESTAMP** variation that the TIMESTAMP data type alias maps to. For more information, check TIMESTAMP*TYPE_MAPPING docs.
- timestamp
Tz stringOutput Format - Specifies the display format for the TIMESTAMPTZ data type. If no format is specified, defaults to OUTPUT*FORMATTIMESTAMP. For more information, see Date and time input and output formats. For more information, check TIMESTAMPTZOUTPUT*FORMAT docs.
- timezone string
- Specifies the time zone for the session. You can specify a time zone name or a link name from release 2021a of the IANA Time Zone Database (e.g. America/Los_Angeles, Europe/London, UTC, Etc/GMT, etc.). For more information, check TIMEZONE docs.
- trace
Level string - Controls how trace events are ingested into the event table. For more information about trace levels, see Setting trace level. For more information, check TRACE_LEVEL docs.
- transaction
Abort booleanOn Error - Specifies the action to perform when a statement issued within a non-autocommit transaction returns with an error. For more information, check TRANSACTIONABORTON_ERROR docs.
- transaction
Default stringIsolation Level - Specifies the isolation level for transactions in the user session. For more information, check TRANSACTIONDEFAULTISOLATION_LEVEL docs.
- two
Digit numberCentury Start - Specifies the “century start” year for 2-digit years (i.e. the earliest year such dates can represent). This parameter prevents ambiguous dates when importing or converting data with the
YY
date format component (i.e. years represented as 2 digits). For more information, check TWODIGITCENTURY_START docs. - unsupported
Ddl stringAction - Determines if an unsupported (i.e. non-default) value specified for a constraint property returns an error. For more information, check UNSUPPORTEDDDLACTION docs.
- use
Cached booleanResult - Specifies whether to reuse persisted query results, if available, when a matching query is submitted. For more information, check USECACHEDRESULT docs.
- week
Of numberYear Policy - Specifies how the weeks in a given year are computed.
0
: The semantics used are equivalent to the ISO semantics, in which a week belongs to a given year if at least 4 days of that week are in that year.1
: January 1 is included in the first week of the year and December 31 is included in the last week of the year. For more information, check WEEKOFYEAR_POLICY docs. - week
Start number - Specifies the first day of the week (used by week-related date functions).
0
: Legacy Snowflake behavior is used (i.e. ISO-like semantics).1
(Monday) to7
(Sunday): All the week-related functions use weeks that start on the specified day of the week. For more information, check WEEK_START docs.
- abort_
detached_ boolquery - Specifies the action that Snowflake performs for in-progress queries if connectivity is lost due to abrupt termination of a session (e.g. network outage, browser termination, service interruption). For more information, check ABORTDETACHEDQUERY docs.
- autocommit bool
- Specifies whether autocommit is enabled for the session. Autocommit determines whether a DML statement, when executed without an active transaction, is automatically committed after the statement successfully completes. For more information, see Transactions. For more information, check AUTOCOMMIT docs.
- binary_
input_ strformat - The format of VARCHAR values passed as input to VARCHAR-to-BINARY conversion functions. For more information, see Binary input and output. For more information, check BINARYINPUTFORMAT docs.
- binary_
output_ strformat - The format for VARCHAR values returned as output by BINARY-to-VARCHAR conversion functions. For more information, see Binary input and output. For more information, check BINARYOUTPUTFORMAT docs.
- client_
memory_ intlimit - Parameter that specifies the maximum amount of memory the JDBC driver or ODBC driver should use for the result set from queries (in MB). For more information, check CLIENTMEMORYLIMIT docs.
- client_
metadata_ boolrequest_ use_ connection_ ctx - For specific ODBC functions and JDBC methods, this parameter can change the default search scope from all databases/schemas to the current database/schema. The narrower search typically returns fewer rows and executes more quickly. For more information, check CLIENTMETADATAREQUESTUSECONNECTION_CTX docs.
- client_
prefetch_ intthreads - Parameter that specifies the number of threads used by the client to pre-fetch large result sets. The driver will attempt to honor the parameter value, but defines the minimum and maximum values (depending on your system’s resources) to improve performance. For more information, check CLIENTPREFETCHTHREADS docs.
- client_
result_ intchunk_ size - Parameter that specifies the maximum size of each set (or chunk) of query results to download (in MB). The JDBC driver downloads query results in chunks. For more information, check CLIENTRESULTCHUNK_SIZE docs.
- client_
result_ boolcolumn_ case_ insensitive - Parameter that indicates whether to match column name case-insensitively in ResultSet.get* methods in JDBC. For more information, check CLIENTRESULTCOLUMNCASEINSENSITIVE docs.
- client_
session_ boolkeep_ alive - Parameter that indicates whether to force a user to log in again after a period of inactivity in the session. For more information, check CLIENTSESSIONKEEP_ALIVE docs.
- client_
session_ intkeep_ alive_ heartbeat_ frequency - Number of seconds in-between client attempts to update the token for the session. For more information, check CLIENTSESSIONKEEPALIVEHEARTBEAT_FREQUENCY docs.
- client_
timestamp_ strtype_ mapping - Specifies the TIMESTAMP_* variation to use when binding timestamp variables for JDBC or ODBC applications that use the bind API to load data. For more information, check CLIENTTIMESTAMPTYPE_MAPPING docs.
- comment str
- Specifies a comment for the user.
- date_
input_ strformat - Specifies the input format for the DATE data type. For more information, see Date and time input and output formats. For more information, check DATEINPUTFORMAT docs.
- date_
output_ strformat - Specifies the display format for the DATE data type. For more information, see Date and time input and output formats. For more information, check DATEOUTPUTFORMAT docs.
- days_
to_ intexpiry - default_
namespace str - Specifies the namespace (database only or database and schema) that is active by default for the user’s session upon login. Note that the CREATE USER operation does not verify that the namespace exists.
- default_
role str - Specifies the role that is active by default for the user’s session upon login. Note that specifying a default role for a user does not grant the role to the user. The role must be granted explicitly to the user using the GRANT ROLE command. In addition, the CREATE USER operation does not verify that the role exists.
- default_
secondary_ strroles_ option - Specifies the secondary roles that are active for the user’s session upon login. Valid values are (case-insensitive):
DEFAULT
|NONE
|ALL
. More information can be found in doc. - default_
warehouse str - Specifies the virtual warehouse that is active by default for the user’s session upon login. Note that the CREATE USER operation does not verify that the warehouse exists.
- disabled str
- Specifies whether the user is disabled, which prevents logging in and aborts all the currently-running queries for the user. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
- display_
name str - Name displayed for the user in the Snowflake web interface.
- email str
- Email address for the user.
- enable_
unload_ boolphysical_ type_ optimization - Specifies whether to set the schema for unloaded Parquet files based on the logical column data types (i.e. the types in the unload SQL query or source table) or on the unloaded column values (i.e. the smallest data types and precision that support the values in the output columns of the unload SQL statement or source table). For more information, check ENABLEUNLOADPHYSICALTYPEOPTIMIZATION docs.
- enable_
unredacted_ boolquery_ syntax_ error - Controls whether query text is redacted if a SQL query fails due to a syntax or parsing error. If
FALSE
, the content of a failed query is redacted in the views, pages, and functions that provide a query history. Only users with a role that is granted or inherits the AUDIT privilege can set the ENABLEUNREDACTEDQUERYSYNTAXERROR parameter. When using the ALTER USER command to set the parameter toTRUE
for a particular user, modify the user that you want to see the query text, not the user who executed the query (if those are different users). For more information, check UNREDACTEDQUERYSYNTAXERROR docsENABLE. - error_
on_ boolnondeterministic_ merge - Specifies whether to return an error when the MERGE command is used to update or delete a target row that joins multiple source rows and the system cannot determine the action to perform on the target row. For more information, check ERRORONNONDETERMINISTIC_MERGE docs.
- error_
on_ boolnondeterministic_ update - Specifies whether to return an error when the UPDATE command is used to update a target row that joins multiple source rows and the system cannot determine the action to perform on the target row. For more information, check ERRORONNONDETERMINISTIC_UPDATE docs.
- geography_
output_ strformat - Display format for GEOGRAPHY values. For more information, check GEOGRAPHYOUTPUTFORMAT docs.
- geometry_
output_ strformat - Display format for GEOMETRY values. For more information, check GEOMETRYOUTPUTFORMAT docs.
- jdbc_
treat_ booldecimal_ as_ int - Specifies how JDBC processes columns that have a scale of zero (0). For more information, check JDBCTREATDECIMALASINT docs.
- jdbc_
treat_ booltimestamp_ ntz_ as_ utc - Specifies how JDBC processes TIMESTAMPNTZ values. For more information, check TREATTIMESTAMPNTZASUTC docsJDBC.
- jdbc_
use_ boolsession_ timezone - Specifies whether the JDBC Driver uses the time zone of the JVM or the time zone of the session (specified by the TIMEZONE parameter) for the getDate(), getTime(), and getTimestamp() methods of the ResultSet class. For more information, check JDBCUSESESSION_TIMEZONE docs.
- json_
indent int - Specifies the number of blank spaces to indent each new element in JSON output in the session. Also specifies whether to insert newline characters after each element. For more information, check JSON_INDENT docs.
- lock_
timeout int - Number of seconds to wait while trying to lock a resource, before timing out and aborting the statement. For more information, check LOCK_TIMEOUT docs.
- log_
level str - Specifies the severity level of messages that should be ingested and made available in the active event table. Messages at the specified level (and at more severe levels) are ingested. For more information about log levels, see Setting log level. For more information, check LOG_LEVEL docs.
- login_
name str - The name users use to log in. If not supplied, snowflake will use name instead. Login names are always case-insensitive.
- mins_
to_ intunlock - multi_
statement_ intcount - Number of statements to execute when using the multi-statement capability. For more information, check MULTISTATEMENTCOUNT docs.
- must_
change_ strpassword - Specifies whether the user is forced to change their password on next login (including their first/initial login) into the system. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
- name str
- Name of the user. Note that if you do not supply loginname this will be used as loginname. Check the docs. Due to technical limitations (read more here), avoid using the following characters:
|
,.
,(
,)
,"
- network_
policy str - Specifies the network policy to enforce for your account. Network policies enable restricting access to your account based on users’ IP address. For more details, see Controlling network traffic with network policies. Any existing network policy (created using CREATE NETWORK POLICY). For more information, check NETWORK_POLICY docs.
- noorder_
sequence_ boolas_ default - Specifies whether the ORDER or NOORDER property is set by default when you create a new sequence or add a new table column. The ORDER and NOORDER properties determine whether or not the values are generated for the sequence or auto-incremented column in increasing or decreasing order. For more information, check NOORDERSEQUENCEAS_DEFAULT docs.
- odbc_
treat_ booldecimal_ as_ int - Specifies how ODBC processes columns that have a scale of zero (0). For more information, check ODBCTREATDECIMALASINT docs.
- password str
- prevent_
unload_ boolto_ internal_ stages - Specifies whether to prevent data unload operations to internal (Snowflake) stages using COPY INTO \n\n statements. For more information, check PREVENTUNLOADTOINTERNALSTAGES docs.
- query_
tag str - Optional string that can be used to tag queries and other SQL statements executed within a session. The tags are displayed in the output of the QUERYHISTORY, QUERYHISTORY*BY** functions. For more information, check QUERY_TAG docs.
- quoted_
identifiers_ boolignore_ case - Specifies whether letters in double-quoted object identifiers are stored and resolved as uppercase letters. By default, Snowflake preserves the case of alphabetic characters when storing and resolving double-quoted identifiers (see Identifier resolution). You can use this parameter in situations in which third-party applications always use double quotes around identifiers. For more information, check QUOTEDIDENTIFIERSIGNORE_CASE docs.
- rows_
per_ intresultset - Specifies the maximum number of rows returned in a result set. A value of 0 specifies no maximum. For more information, check ROWSPERRESULTSET docs.
- rsa_
public_ strkey - Specifies the user’s RSA public key; used for key-pair authentication. Must be on 1 line without header and trailer.
- rsa_
public_ strkey2 - Specifies the user’s second RSA public key; used to rotate the public and private keys for key-pair authentication based on an expiration schedule set by your organization. Must be on 1 line without header and trailer.
- s3_
stage_ strvpce_ dns_ name - Specifies the DNS name of an Amazon S3 interface endpoint. Requests sent to the internal stage of an account via AWS PrivateLink for Amazon S3 use this endpoint to connect. For more information, see Accessing Internal stages with dedicated interface endpoints. For more information, check S3STAGEVPCEDNSNAME docs.
- search_
path str - Specifies the path to search to resolve unqualified object names in queries. For more information, see Name resolution in queries. Comma-separated list of identifiers. An identifier can be a fully or partially qualified schema name. For more information, check SEARCH_PATH docs.
- simulated_
data_ strsharing_ consumer - Specifies the name of a consumer account to simulate for testing/validating shared data, particularly shared secure views. When this parameter is set in a session, shared views return rows as if executed in the specified consumer account rather than the provider account. For more information, see Introduction to Secure Data Sharing and Working with shares. For more information, check SIMULATEDDATASHARING_CONSUMER docs.
- statement_
queued_ inttimeout_ in_ seconds - Amount of time, in seconds, a SQL statement (query, DDL, DML, etc.) remains queued for a warehouse before it is canceled by the system. This parameter can be used in conjunction with the MAXCONCURRENCYLEVEL parameter to ensure a warehouse is never backlogged. For more information, check STATEMENTQUEUEDTIMEOUTINSECONDS docs.
- statement_
timeout_ intin_ seconds - Amount of time, in seconds, after which a running SQL statement (query, DDL, DML, etc.) is canceled by the system. For more information, check STATEMENTTIMEOUTIN_SECONDS docs.
- strict_
json_ booloutput - This parameter specifies whether JSON output in a session is compatible with the general standard (as described by http://json.org). By design, Snowflake allows JSON input that contains non-standard values; however, these non-standard values might result in Snowflake outputting JSON that is incompatible with other platforms and languages. This parameter, when enabled, ensures that Snowflake outputs valid/compatible JSON. For more information, check STRICTJSONOUTPUT docs.
- time_
input_ strformat - Specifies the input format for the TIME data type. For more information, see Date and time input and output formats. Any valid, supported time format or AUTO (AUTO specifies that Snowflake attempts to automatically detect the format of times stored in the system during the session). For more information, check TIMEINPUTFORMAT docs.
- time_
output_ strformat - Specifies the display format for the TIME data type. For more information, see Date and time input and output formats. For more information, check TIMEOUTPUTFORMAT docs.
- timestamp_
day_ boolis_ always24h - Specifies whether the DATEADD function (and its aliases) always consider a day to be exactly 24 hours for expressions that span multiple days. For more information, check TIMESTAMPDAYISALWAYS24H docs.
- timestamp_
input_ strformat - Specifies the input format for the TIMESTAMP data type alias. For more information, see Date and time input and output formats. Any valid, supported timestamp format or AUTO (AUTO specifies that Snowflake attempts to automatically detect the format of timestamps stored in the system during the session). For more information, check TIMESTAMPINPUTFORMAT docs.
- timestamp_
ltz_ stroutput_ format - Specifies the display format for the TIMESTAMPLTZ data type. If no format is specified, defaults to OUTPUT*FORMATTIMESTAMP. For more information, see Date and time input and output formats. For more information, check TIMESTAMPLTZOUTPUT*FORMAT docs.
- timestamp_
ntz_ stroutput_ format - Specifies the display format for the TIMESTAMPNTZ data type. For more information, check NTZOUTPUTFORMAT docsTIMESTAMP.
- timestamp_
output_ strformat - Specifies the display format for the TIMESTAMP data type alias. For more information, see Date and time input and output formats. For more information, check TIMESTAMPOUTPUTFORMAT docs.
- timestamp_
type_ strmapping - Specifies the TIMESTAMP** variation that the TIMESTAMP data type alias maps to. For more information, check TIMESTAMP*TYPE_MAPPING docs.
- timestamp_
tz_ stroutput_ format - Specifies the display format for the TIMESTAMPTZ data type. If no format is specified, defaults to OUTPUT*FORMATTIMESTAMP. For more information, see Date and time input and output formats. For more information, check TIMESTAMPTZOUTPUT*FORMAT docs.
- timezone str
- Specifies the time zone for the session. You can specify a time zone name or a link name from release 2021a of the IANA Time Zone Database (e.g. America/Los_Angeles, Europe/London, UTC, Etc/GMT, etc.). For more information, check TIMEZONE docs.
- trace_
level str - Controls how trace events are ingested into the event table. For more information about trace levels, see Setting trace level. For more information, check TRACE_LEVEL docs.
- transaction_
abort_ boolon_ error - Specifies the action to perform when a statement issued within a non-autocommit transaction returns with an error. For more information, check TRANSACTIONABORTON_ERROR docs.
- transaction_
default_ strisolation_ level - Specifies the isolation level for transactions in the user session. For more information, check TRANSACTIONDEFAULTISOLATION_LEVEL docs.
- two_
digit_ intcentury_ start - Specifies the “century start” year for 2-digit years (i.e. the earliest year such dates can represent). This parameter prevents ambiguous dates when importing or converting data with the
YY
date format component (i.e. years represented as 2 digits). For more information, check TWODIGITCENTURY_START docs. - unsupported_
ddl_ straction - Determines if an unsupported (i.e. non-default) value specified for a constraint property returns an error. For more information, check UNSUPPORTEDDDLACTION docs.
- use_
cached_ boolresult - Specifies whether to reuse persisted query results, if available, when a matching query is submitted. For more information, check USECACHEDRESULT docs.
- week_
of_ intyear_ policy - Specifies how the weeks in a given year are computed.
0
: The semantics used are equivalent to the ISO semantics, in which a week belongs to a given year if at least 4 days of that week are in that year.1
: January 1 is included in the first week of the year and December 31 is included in the last week of the year. For more information, check WEEKOFYEAR_POLICY docs. - week_
start int - Specifies the first day of the week (used by week-related date functions).
0
: Legacy Snowflake behavior is used (i.e. ISO-like semantics).1
(Monday) to7
(Sunday): All the week-related functions use weeks that start on the specified day of the week. For more information, check WEEK_START docs.
- abort
Detached BooleanQuery - Specifies the action that Snowflake performs for in-progress queries if connectivity is lost due to abrupt termination of a session (e.g. network outage, browser termination, service interruption). For more information, check ABORTDETACHEDQUERY docs.
- autocommit Boolean
- Specifies whether autocommit is enabled for the session. Autocommit determines whether a DML statement, when executed without an active transaction, is automatically committed after the statement successfully completes. For more information, see Transactions. For more information, check AUTOCOMMIT docs.
- binary
Input StringFormat - The format of VARCHAR values passed as input to VARCHAR-to-BINARY conversion functions. For more information, see Binary input and output. For more information, check BINARYINPUTFORMAT docs.
- binary
Output StringFormat - The format for VARCHAR values returned as output by BINARY-to-VARCHAR conversion functions. For more information, see Binary input and output. For more information, check BINARYOUTPUTFORMAT docs.
- client
Memory NumberLimit - Parameter that specifies the maximum amount of memory the JDBC driver or ODBC driver should use for the result set from queries (in MB). For more information, check CLIENTMEMORYLIMIT docs.
- client
Metadata BooleanRequest Use Connection Ctx - For specific ODBC functions and JDBC methods, this parameter can change the default search scope from all databases/schemas to the current database/schema. The narrower search typically returns fewer rows and executes more quickly. For more information, check CLIENTMETADATAREQUESTUSECONNECTION_CTX docs.
- client
Prefetch NumberThreads - Parameter that specifies the number of threads used by the client to pre-fetch large result sets. The driver will attempt to honor the parameter value, but defines the minimum and maximum values (depending on your system’s resources) to improve performance. For more information, check CLIENTPREFETCHTHREADS docs.
- client
Result NumberChunk Size - Parameter that specifies the maximum size of each set (or chunk) of query results to download (in MB). The JDBC driver downloads query results in chunks. For more information, check CLIENTRESULTCHUNK_SIZE docs.
- client
Result BooleanColumn Case Insensitive - Parameter that indicates whether to match column name case-insensitively in ResultSet.get* methods in JDBC. For more information, check CLIENTRESULTCOLUMNCASEINSENSITIVE docs.
- client
Session BooleanKeep Alive - Parameter that indicates whether to force a user to log in again after a period of inactivity in the session. For more information, check CLIENTSESSIONKEEP_ALIVE docs.
- client
Session NumberKeep Alive Heartbeat Frequency - Number of seconds in-between client attempts to update the token for the session. For more information, check CLIENTSESSIONKEEPALIVEHEARTBEAT_FREQUENCY docs.
- client
Timestamp StringType Mapping - Specifies the TIMESTAMP_* variation to use when binding timestamp variables for JDBC or ODBC applications that use the bind API to load data. For more information, check CLIENTTIMESTAMPTYPE_MAPPING docs.
- comment String
- Specifies a comment for the user.
- date
Input StringFormat - Specifies the input format for the DATE data type. For more information, see Date and time input and output formats. For more information, check DATEINPUTFORMAT docs.
- date
Output StringFormat - Specifies the display format for the DATE data type. For more information, see Date and time input and output formats. For more information, check DATEOUTPUTFORMAT docs.
- days
To NumberExpiry - default
Namespace String - Specifies the namespace (database only or database and schema) that is active by default for the user’s session upon login. Note that the CREATE USER operation does not verify that the namespace exists.
- default
Role String - Specifies the role that is active by default for the user’s session upon login. Note that specifying a default role for a user does not grant the role to the user. The role must be granted explicitly to the user using the GRANT ROLE command. In addition, the CREATE USER operation does not verify that the role exists.
- default
Secondary StringRoles Option - Specifies the secondary roles that are active for the user’s session upon login. Valid values are (case-insensitive):
DEFAULT
|NONE
|ALL
. More information can be found in doc. - default
Warehouse String - Specifies the virtual warehouse that is active by default for the user’s session upon login. Note that the CREATE USER operation does not verify that the warehouse exists.
- disabled String
- Specifies whether the user is disabled, which prevents logging in and aborts all the currently-running queries for the user. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
- display
Name String - Name displayed for the user in the Snowflake web interface.
- email String
- Email address for the user.
- enable
Unload BooleanPhysical Type Optimization - Specifies whether to set the schema for unloaded Parquet files based on the logical column data types (i.e. the types in the unload SQL query or source table) or on the unloaded column values (i.e. the smallest data types and precision that support the values in the output columns of the unload SQL statement or source table). For more information, check ENABLEUNLOADPHYSICALTYPEOPTIMIZATION docs.
- enable
Unredacted BooleanQuery Syntax Error - Controls whether query text is redacted if a SQL query fails due to a syntax or parsing error. If
FALSE
, the content of a failed query is redacted in the views, pages, and functions that provide a query history. Only users with a role that is granted or inherits the AUDIT privilege can set the ENABLEUNREDACTEDQUERYSYNTAXERROR parameter. When using the ALTER USER command to set the parameter toTRUE
for a particular user, modify the user that you want to see the query text, not the user who executed the query (if those are different users). For more information, check UNREDACTEDQUERYSYNTAXERROR docsENABLE. - error
On BooleanNondeterministic Merge - Specifies whether to return an error when the MERGE command is used to update or delete a target row that joins multiple source rows and the system cannot determine the action to perform on the target row. For more information, check ERRORONNONDETERMINISTIC_MERGE docs.
- error
On BooleanNondeterministic Update - Specifies whether to return an error when the UPDATE command is used to update a target row that joins multiple source rows and the system cannot determine the action to perform on the target row. For more information, check ERRORONNONDETERMINISTIC_UPDATE docs.
- geography
Output StringFormat - Display format for GEOGRAPHY values. For more information, check GEOGRAPHYOUTPUTFORMAT docs.
- geometry
Output StringFormat - Display format for GEOMETRY values. For more information, check GEOMETRYOUTPUTFORMAT docs.
- jdbc
Treat BooleanDecimal As Int - Specifies how JDBC processes columns that have a scale of zero (0). For more information, check JDBCTREATDECIMALASINT docs.
- jdbc
Treat BooleanTimestamp Ntz As Utc - Specifies how JDBC processes TIMESTAMPNTZ values. For more information, check TREATTIMESTAMPNTZASUTC docsJDBC.
- jdbc
Use BooleanSession Timezone - Specifies whether the JDBC Driver uses the time zone of the JVM or the time zone of the session (specified by the TIMEZONE parameter) for the getDate(), getTime(), and getTimestamp() methods of the ResultSet class. For more information, check JDBCUSESESSION_TIMEZONE docs.
- json
Indent Number - Specifies the number of blank spaces to indent each new element in JSON output in the session. Also specifies whether to insert newline characters after each element. For more information, check JSON_INDENT docs.
- lock
Timeout Number - Number of seconds to wait while trying to lock a resource, before timing out and aborting the statement. For more information, check LOCK_TIMEOUT docs.
- log
Level String - Specifies the severity level of messages that should be ingested and made available in the active event table. Messages at the specified level (and at more severe levels) are ingested. For more information about log levels, see Setting log level. For more information, check LOG_LEVEL docs.
- login
Name String - The name users use to log in. If not supplied, snowflake will use name instead. Login names are always case-insensitive.
- mins
To NumberUnlock - multi
Statement NumberCount - Number of statements to execute when using the multi-statement capability. For more information, check MULTISTATEMENTCOUNT docs.
- must
Change StringPassword - Specifies whether the user is forced to change their password on next login (including their first/initial login) into the system. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
- name String
- Name of the user. Note that if you do not supply loginname this will be used as loginname. Check the docs. Due to technical limitations (read more here), avoid using the following characters:
|
,.
,(
,)
,"
- network
Policy String - Specifies the network policy to enforce for your account. Network policies enable restricting access to your account based on users’ IP address. For more details, see Controlling network traffic with network policies. Any existing network policy (created using CREATE NETWORK POLICY). For more information, check NETWORK_POLICY docs.
- noorder
Sequence BooleanAs Default - Specifies whether the ORDER or NOORDER property is set by default when you create a new sequence or add a new table column. The ORDER and NOORDER properties determine whether or not the values are generated for the sequence or auto-incremented column in increasing or decreasing order. For more information, check NOORDERSEQUENCEAS_DEFAULT docs.
- odbc
Treat BooleanDecimal As Int - Specifies how ODBC processes columns that have a scale of zero (0). For more information, check ODBCTREATDECIMALASINT docs.
- password String
- prevent
Unload BooleanTo Internal Stages - Specifies whether to prevent data unload operations to internal (Snowflake) stages using COPY INTO \n\n statements. For more information, check PREVENTUNLOADTOINTERNALSTAGES docs.
- query
Tag String - Optional string that can be used to tag queries and other SQL statements executed within a session. The tags are displayed in the output of the QUERYHISTORY, QUERYHISTORY*BY** functions. For more information, check QUERY_TAG docs.
- quoted
Identifiers BooleanIgnore Case - Specifies whether letters in double-quoted object identifiers are stored and resolved as uppercase letters. By default, Snowflake preserves the case of alphabetic characters when storing and resolving double-quoted identifiers (see Identifier resolution). You can use this parameter in situations in which third-party applications always use double quotes around identifiers. For more information, check QUOTEDIDENTIFIERSIGNORE_CASE docs.
- rows
Per NumberResultset - Specifies the maximum number of rows returned in a result set. A value of 0 specifies no maximum. For more information, check ROWSPERRESULTSET docs.
- rsa
Public StringKey - Specifies the user’s RSA public key; used for key-pair authentication. Must be on 1 line without header and trailer.
- rsa
Public StringKey2 - Specifies the user’s second RSA public key; used to rotate the public and private keys for key-pair authentication based on an expiration schedule set by your organization. Must be on 1 line without header and trailer.
- s3Stage
Vpce StringDns Name - Specifies the DNS name of an Amazon S3 interface endpoint. Requests sent to the internal stage of an account via AWS PrivateLink for Amazon S3 use this endpoint to connect. For more information, see Accessing Internal stages with dedicated interface endpoints. For more information, check S3STAGEVPCEDNSNAME docs.
- search
Path String - Specifies the path to search to resolve unqualified object names in queries. For more information, see Name resolution in queries. Comma-separated list of identifiers. An identifier can be a fully or partially qualified schema name. For more information, check SEARCH_PATH docs.
- simulated
Data StringSharing Consumer - Specifies the name of a consumer account to simulate for testing/validating shared data, particularly shared secure views. When this parameter is set in a session, shared views return rows as if executed in the specified consumer account rather than the provider account. For more information, see Introduction to Secure Data Sharing and Working with shares. For more information, check SIMULATEDDATASHARING_CONSUMER docs.
- statement
Queued NumberTimeout In Seconds - Amount of time, in seconds, a SQL statement (query, DDL, DML, etc.) remains queued for a warehouse before it is canceled by the system. This parameter can be used in conjunction with the MAXCONCURRENCYLEVEL parameter to ensure a warehouse is never backlogged. For more information, check STATEMENTQUEUEDTIMEOUTINSECONDS docs.
- statement
Timeout NumberIn Seconds - Amount of time, in seconds, after which a running SQL statement (query, DDL, DML, etc.) is canceled by the system. For more information, check STATEMENTTIMEOUTIN_SECONDS docs.
- strict
Json BooleanOutput - This parameter specifies whether JSON output in a session is compatible with the general standard (as described by http://json.org). By design, Snowflake allows JSON input that contains non-standard values; however, these non-standard values might result in Snowflake outputting JSON that is incompatible with other platforms and languages. This parameter, when enabled, ensures that Snowflake outputs valid/compatible JSON. For more information, check STRICTJSONOUTPUT docs.
- time
Input StringFormat - Specifies the input format for the TIME data type. For more information, see Date and time input and output formats. Any valid, supported time format or AUTO (AUTO specifies that Snowflake attempts to automatically detect the format of times stored in the system during the session). For more information, check TIMEINPUTFORMAT docs.
- time
Output StringFormat - Specifies the display format for the TIME data type. For more information, see Date and time input and output formats. For more information, check TIMEOUTPUTFORMAT docs.
- timestamp
Day BooleanIs Always24h - Specifies whether the DATEADD function (and its aliases) always consider a day to be exactly 24 hours for expressions that span multiple days. For more information, check TIMESTAMPDAYISALWAYS24H docs.
- timestamp
Input StringFormat - Specifies the input format for the TIMESTAMP data type alias. For more information, see Date and time input and output formats. Any valid, supported timestamp format or AUTO (AUTO specifies that Snowflake attempts to automatically detect the format of timestamps stored in the system during the session). For more information, check TIMESTAMPINPUTFORMAT docs.
- timestamp
Ltz StringOutput Format - Specifies the display format for the TIMESTAMPLTZ data type. If no format is specified, defaults to OUTPUT*FORMATTIMESTAMP. For more information, see Date and time input and output formats. For more information, check TIMESTAMPLTZOUTPUT*FORMAT docs.
- timestamp
Ntz StringOutput Format - Specifies the display format for the TIMESTAMPNTZ data type. For more information, check NTZOUTPUTFORMAT docsTIMESTAMP.
- timestamp
Output StringFormat - Specifies the display format for the TIMESTAMP data type alias. For more information, see Date and time input and output formats. For more information, check TIMESTAMPOUTPUTFORMAT docs.
- timestamp
Type StringMapping - Specifies the TIMESTAMP** variation that the TIMESTAMP data type alias maps to. For more information, check TIMESTAMP*TYPE_MAPPING docs.
- timestamp
Tz StringOutput Format - Specifies the display format for the TIMESTAMPTZ data type. If no format is specified, defaults to OUTPUT*FORMATTIMESTAMP. For more information, see Date and time input and output formats. For more information, check TIMESTAMPTZOUTPUT*FORMAT docs.
- timezone String
- Specifies the time zone for the session. You can specify a time zone name or a link name from release 2021a of the IANA Time Zone Database (e.g. America/Los_Angeles, Europe/London, UTC, Etc/GMT, etc.). For more information, check TIMEZONE docs.
- trace
Level String - Controls how trace events are ingested into the event table. For more information about trace levels, see Setting trace level. For more information, check TRACE_LEVEL docs.
- transaction
Abort BooleanOn Error - Specifies the action to perform when a statement issued within a non-autocommit transaction returns with an error. For more information, check TRANSACTIONABORTON_ERROR docs.
- transaction
Default StringIsolation Level - Specifies the isolation level for transactions in the user session. For more information, check TRANSACTIONDEFAULTISOLATION_LEVEL docs.
- two
Digit NumberCentury Start - Specifies the “century start” year for 2-digit years (i.e. the earliest year such dates can represent). This parameter prevents ambiguous dates when importing or converting data with the
YY
date format component (i.e. years represented as 2 digits). For more information, check TWODIGITCENTURY_START docs. - unsupported
Ddl StringAction - Determines if an unsupported (i.e. non-default) value specified for a constraint property returns an error. For more information, check UNSUPPORTEDDDLACTION docs.
- use
Cached BooleanResult - Specifies whether to reuse persisted query results, if available, when a matching query is submitted. For more information, check USECACHEDRESULT docs.
- week
Of NumberYear Policy - Specifies how the weeks in a given year are computed.
0
: The semantics used are equivalent to the ISO semantics, in which a week belongs to a given year if at least 4 days of that week are in that year.1
: January 1 is included in the first week of the year and December 31 is included in the last week of the year. For more information, check WEEKOFYEAR_POLICY docs. - week
Start Number - Specifies the first day of the week (used by week-related date functions).
0
: Legacy Snowflake behavior is used (i.e. ISO-like semantics).1
(Monday) to7
(Sunday): All the week-related functions use weeks that start on the specified day of the week. For more information, check WEEK_START docs.
Outputs
All input properties are implicitly available as output properties. Additionally, the LegacyServiceUser resource produces the following output properties:
- Fully
Qualified stringName - Fully qualified name of the resource. For more information, see object name resolution.
- Id string
- The provider-assigned unique ID for this managed resource.
- Parameters
List<Legacy
Service User Parameter> - Outputs the result of
SHOW PARAMETERS IN USER
for the given user. - Show
Outputs List<LegacyService User Show Output> - Outputs the result of
SHOW USER
for the given user. - User
Type string - Specifies a type for the user.
- Fully
Qualified stringName - Fully qualified name of the resource. For more information, see object name resolution.
- Id string
- The provider-assigned unique ID for this managed resource.
- Parameters
[]Legacy
Service User Parameter - Outputs the result of
SHOW PARAMETERS IN USER
for the given user. - Show
Outputs []LegacyService User Show Output - Outputs the result of
SHOW USER
for the given user. - User
Type string - Specifies a type for the user.
- fully
Qualified StringName - Fully qualified name of the resource. For more information, see object name resolution.
- id String
- The provider-assigned unique ID for this managed resource.
- parameters
List<Legacy
Service User Parameter> - Outputs the result of
SHOW PARAMETERS IN USER
for the given user. - show
Outputs List<LegacyService User Show Output> - Outputs the result of
SHOW USER
for the given user. - user
Type String - Specifies a type for the user.
- fully
Qualified stringName - Fully qualified name of the resource. For more information, see object name resolution.
- id string
- The provider-assigned unique ID for this managed resource.
- parameters
Legacy
Service User Parameter[] - Outputs the result of
SHOW PARAMETERS IN USER
for the given user. - show
Outputs LegacyService User Show Output[] - Outputs the result of
SHOW USER
for the given user. - user
Type string - Specifies a type for the user.
- fully_
qualified_ strname - Fully qualified name of the resource. For more information, see object name resolution.
- id str
- The provider-assigned unique ID for this managed resource.
- parameters
Sequence[Legacy
Service User Parameter] - Outputs the result of
SHOW PARAMETERS IN USER
for the given user. - show_
outputs Sequence[LegacyService User Show Output] - Outputs the result of
SHOW USER
for the given user. - user_
type str - Specifies a type for the user.
- fully
Qualified StringName - Fully qualified name of the resource. For more information, see object name resolution.
- id String
- The provider-assigned unique ID for this managed resource.
- parameters List<Property Map>
- Outputs the result of
SHOW PARAMETERS IN USER
for the given user. - show
Outputs List<Property Map> - Outputs the result of
SHOW USER
for the given user. - user
Type String - Specifies a type for the user.
Look up Existing LegacyServiceUser Resource
Get an existing LegacyServiceUser 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?: LegacyServiceUserState, opts?: CustomResourceOptions): LegacyServiceUser
@staticmethod
def get(resource_name: str,
id: str,
opts: Optional[ResourceOptions] = None,
abort_detached_query: Optional[bool] = None,
autocommit: Optional[bool] = None,
binary_input_format: Optional[str] = None,
binary_output_format: Optional[str] = None,
client_memory_limit: Optional[int] = None,
client_metadata_request_use_connection_ctx: Optional[bool] = None,
client_prefetch_threads: Optional[int] = None,
client_result_chunk_size: Optional[int] = None,
client_result_column_case_insensitive: Optional[bool] = None,
client_session_keep_alive: Optional[bool] = None,
client_session_keep_alive_heartbeat_frequency: Optional[int] = None,
client_timestamp_type_mapping: Optional[str] = None,
comment: Optional[str] = None,
date_input_format: Optional[str] = None,
date_output_format: Optional[str] = None,
days_to_expiry: Optional[int] = None,
default_namespace: Optional[str] = None,
default_role: Optional[str] = None,
default_secondary_roles_option: Optional[str] = None,
default_warehouse: Optional[str] = None,
disabled: Optional[str] = None,
display_name: Optional[str] = None,
email: Optional[str] = None,
enable_unload_physical_type_optimization: Optional[bool] = None,
enable_unredacted_query_syntax_error: Optional[bool] = None,
error_on_nondeterministic_merge: Optional[bool] = None,
error_on_nondeterministic_update: Optional[bool] = None,
fully_qualified_name: Optional[str] = None,
geography_output_format: Optional[str] = None,
geometry_output_format: Optional[str] = None,
jdbc_treat_decimal_as_int: Optional[bool] = None,
jdbc_treat_timestamp_ntz_as_utc: Optional[bool] = None,
jdbc_use_session_timezone: Optional[bool] = None,
json_indent: Optional[int] = None,
lock_timeout: Optional[int] = None,
log_level: Optional[str] = None,
login_name: Optional[str] = None,
mins_to_unlock: Optional[int] = None,
multi_statement_count: Optional[int] = None,
must_change_password: Optional[str] = None,
name: Optional[str] = None,
network_policy: Optional[str] = None,
noorder_sequence_as_default: Optional[bool] = None,
odbc_treat_decimal_as_int: Optional[bool] = None,
parameters: Optional[Sequence[LegacyServiceUserParameterArgs]] = None,
password: Optional[str] = None,
prevent_unload_to_internal_stages: Optional[bool] = None,
query_tag: Optional[str] = None,
quoted_identifiers_ignore_case: Optional[bool] = None,
rows_per_resultset: Optional[int] = None,
rsa_public_key: Optional[str] = None,
rsa_public_key2: Optional[str] = None,
s3_stage_vpce_dns_name: Optional[str] = None,
search_path: Optional[str] = None,
show_outputs: Optional[Sequence[LegacyServiceUserShowOutputArgs]] = None,
simulated_data_sharing_consumer: Optional[str] = None,
statement_queued_timeout_in_seconds: Optional[int] = None,
statement_timeout_in_seconds: Optional[int] = None,
strict_json_output: Optional[bool] = None,
time_input_format: Optional[str] = None,
time_output_format: Optional[str] = None,
timestamp_day_is_always24h: Optional[bool] = None,
timestamp_input_format: Optional[str] = None,
timestamp_ltz_output_format: Optional[str] = None,
timestamp_ntz_output_format: Optional[str] = None,
timestamp_output_format: Optional[str] = None,
timestamp_type_mapping: Optional[str] = None,
timestamp_tz_output_format: Optional[str] = None,
timezone: Optional[str] = None,
trace_level: Optional[str] = None,
transaction_abort_on_error: Optional[bool] = None,
transaction_default_isolation_level: Optional[str] = None,
two_digit_century_start: Optional[int] = None,
unsupported_ddl_action: Optional[str] = None,
use_cached_result: Optional[bool] = None,
user_type: Optional[str] = None,
week_of_year_policy: Optional[int] = None,
week_start: Optional[int] = None) -> LegacyServiceUser
func GetLegacyServiceUser(ctx *Context, name string, id IDInput, state *LegacyServiceUserState, opts ...ResourceOption) (*LegacyServiceUser, error)
public static LegacyServiceUser Get(string name, Input<string> id, LegacyServiceUserState? state, CustomResourceOptions? opts = null)
public static LegacyServiceUser get(String name, Output<String> id, LegacyServiceUserState 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.
- Abort
Detached boolQuery - Specifies the action that Snowflake performs for in-progress queries if connectivity is lost due to abrupt termination of a session (e.g. network outage, browser termination, service interruption). For more information, check ABORTDETACHEDQUERY docs.
- Autocommit bool
- Specifies whether autocommit is enabled for the session. Autocommit determines whether a DML statement, when executed without an active transaction, is automatically committed after the statement successfully completes. For more information, see Transactions. For more information, check AUTOCOMMIT docs.
- Binary
Input stringFormat - The format of VARCHAR values passed as input to VARCHAR-to-BINARY conversion functions. For more information, see Binary input and output. For more information, check BINARYINPUTFORMAT docs.
- Binary
Output stringFormat - The format for VARCHAR values returned as output by BINARY-to-VARCHAR conversion functions. For more information, see Binary input and output. For more information, check BINARYOUTPUTFORMAT docs.
- Client
Memory intLimit - Parameter that specifies the maximum amount of memory the JDBC driver or ODBC driver should use for the result set from queries (in MB). For more information, check CLIENTMEMORYLIMIT docs.
- Client
Metadata boolRequest Use Connection Ctx - For specific ODBC functions and JDBC methods, this parameter can change the default search scope from all databases/schemas to the current database/schema. The narrower search typically returns fewer rows and executes more quickly. For more information, check CLIENTMETADATAREQUESTUSECONNECTION_CTX docs.
- Client
Prefetch intThreads - Parameter that specifies the number of threads used by the client to pre-fetch large result sets. The driver will attempt to honor the parameter value, but defines the minimum and maximum values (depending on your system’s resources) to improve performance. For more information, check CLIENTPREFETCHTHREADS docs.
- Client
Result intChunk Size - Parameter that specifies the maximum size of each set (or chunk) of query results to download (in MB). The JDBC driver downloads query results in chunks. For more information, check CLIENTRESULTCHUNK_SIZE docs.
- Client
Result boolColumn Case Insensitive - Parameter that indicates whether to match column name case-insensitively in ResultSet.get* methods in JDBC. For more information, check CLIENTRESULTCOLUMNCASEINSENSITIVE docs.
- Client
Session boolKeep Alive - Parameter that indicates whether to force a user to log in again after a period of inactivity in the session. For more information, check CLIENTSESSIONKEEP_ALIVE docs.
- Client
Session intKeep Alive Heartbeat Frequency - Number of seconds in-between client attempts to update the token for the session. For more information, check CLIENTSESSIONKEEPALIVEHEARTBEAT_FREQUENCY docs.
- Client
Timestamp stringType Mapping - Specifies the TIMESTAMP_* variation to use when binding timestamp variables for JDBC or ODBC applications that use the bind API to load data. For more information, check CLIENTTIMESTAMPTYPE_MAPPING docs.
- Comment string
- Specifies a comment for the user.
- Date
Input stringFormat - Specifies the input format for the DATE data type. For more information, see Date and time input and output formats. For more information, check DATEINPUTFORMAT docs.
- Date
Output stringFormat - Specifies the display format for the DATE data type. For more information, see Date and time input and output formats. For more information, check DATEOUTPUTFORMAT docs.
- Days
To intExpiry - Default
Namespace string - Specifies the namespace (database only or database and schema) that is active by default for the user’s session upon login. Note that the CREATE USER operation does not verify that the namespace exists.
- Default
Role string - Specifies the role that is active by default for the user’s session upon login. Note that specifying a default role for a user does not grant the role to the user. The role must be granted explicitly to the user using the GRANT ROLE command. In addition, the CREATE USER operation does not verify that the role exists.
- Default
Secondary stringRoles Option - Specifies the secondary roles that are active for the user’s session upon login. Valid values are (case-insensitive):
DEFAULT
|NONE
|ALL
. More information can be found in doc. - Default
Warehouse string - Specifies the virtual warehouse that is active by default for the user’s session upon login. Note that the CREATE USER operation does not verify that the warehouse exists.
- Disabled string
- Specifies whether the user is disabled, which prevents logging in and aborts all the currently-running queries for the user. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
- Display
Name string - Name displayed for the user in the Snowflake web interface.
- Email string
- Email address for the user.
- Enable
Unload boolPhysical Type Optimization - Specifies whether to set the schema for unloaded Parquet files based on the logical column data types (i.e. the types in the unload SQL query or source table) or on the unloaded column values (i.e. the smallest data types and precision that support the values in the output columns of the unload SQL statement or source table). For more information, check ENABLEUNLOADPHYSICALTYPEOPTIMIZATION docs.
- Enable
Unredacted boolQuery Syntax Error - Controls whether query text is redacted if a SQL query fails due to a syntax or parsing error. If
FALSE
, the content of a failed query is redacted in the views, pages, and functions that provide a query history. Only users with a role that is granted or inherits the AUDIT privilege can set the ENABLEUNREDACTEDQUERYSYNTAXERROR parameter. When using the ALTER USER command to set the parameter toTRUE
for a particular user, modify the user that you want to see the query text, not the user who executed the query (if those are different users). For more information, check UNREDACTEDQUERYSYNTAXERROR docsENABLE. - Error
On boolNondeterministic Merge - Specifies whether to return an error when the MERGE command is used to update or delete a target row that joins multiple source rows and the system cannot determine the action to perform on the target row. For more information, check ERRORONNONDETERMINISTIC_MERGE docs.
- Error
On boolNondeterministic Update - Specifies whether to return an error when the UPDATE command is used to update a target row that joins multiple source rows and the system cannot determine the action to perform on the target row. For more information, check ERRORONNONDETERMINISTIC_UPDATE docs.
- Fully
Qualified stringName - Fully qualified name of the resource. For more information, see object name resolution.
- Geography
Output stringFormat - Display format for GEOGRAPHY values. For more information, check GEOGRAPHYOUTPUTFORMAT docs.
- Geometry
Output stringFormat - Display format for GEOMETRY values. For more information, check GEOMETRYOUTPUTFORMAT docs.
- Jdbc
Treat boolDecimal As Int - Specifies how JDBC processes columns that have a scale of zero (0). For more information, check JDBCTREATDECIMALASINT docs.
- Jdbc
Treat boolTimestamp Ntz As Utc - Specifies how JDBC processes TIMESTAMPNTZ values. For more information, check TREATTIMESTAMPNTZASUTC docsJDBC.
- Jdbc
Use boolSession Timezone - Specifies whether the JDBC Driver uses the time zone of the JVM or the time zone of the session (specified by the TIMEZONE parameter) for the getDate(), getTime(), and getTimestamp() methods of the ResultSet class. For more information, check JDBCUSESESSION_TIMEZONE docs.
- Json
Indent int - Specifies the number of blank spaces to indent each new element in JSON output in the session. Also specifies whether to insert newline characters after each element. For more information, check JSON_INDENT docs.
- Lock
Timeout int - Number of seconds to wait while trying to lock a resource, before timing out and aborting the statement. For more information, check LOCK_TIMEOUT docs.
- Log
Level string - Specifies the severity level of messages that should be ingested and made available in the active event table. Messages at the specified level (and at more severe levels) are ingested. For more information about log levels, see Setting log level. For more information, check LOG_LEVEL docs.
- Login
Name string - The name users use to log in. If not supplied, snowflake will use name instead. Login names are always case-insensitive.
- Mins
To intUnlock - Multi
Statement intCount - Number of statements to execute when using the multi-statement capability. For more information, check MULTISTATEMENTCOUNT docs.
- Must
Change stringPassword - Specifies whether the user is forced to change their password on next login (including their first/initial login) into the system. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
- Name string
- Name of the user. Note that if you do not supply loginname this will be used as loginname. Check the docs. Due to technical limitations (read more here), avoid using the following characters:
|
,.
,(
,)
,"
- Network
Policy string - Specifies the network policy to enforce for your account. Network policies enable restricting access to your account based on users’ IP address. For more details, see Controlling network traffic with network policies. Any existing network policy (created using CREATE NETWORK POLICY). For more information, check NETWORK_POLICY docs.
- Noorder
Sequence boolAs Default - Specifies whether the ORDER or NOORDER property is set by default when you create a new sequence or add a new table column. The ORDER and NOORDER properties determine whether or not the values are generated for the sequence or auto-incremented column in increasing or decreasing order. For more information, check NOORDERSEQUENCEAS_DEFAULT docs.
- Odbc
Treat boolDecimal As Int - Specifies how ODBC processes columns that have a scale of zero (0). For more information, check ODBCTREATDECIMALASINT docs.
- Parameters
List<Legacy
Service User Parameter> - Outputs the result of
SHOW PARAMETERS IN USER
for the given user. - Password string
- Prevent
Unload boolTo Internal Stages - Specifies whether to prevent data unload operations to internal (Snowflake) stages using COPY INTO \n\n statements. For more information, check PREVENTUNLOADTOINTERNALSTAGES docs.
- Query
Tag string - Optional string that can be used to tag queries and other SQL statements executed within a session. The tags are displayed in the output of the QUERYHISTORY, QUERYHISTORY*BY** functions. For more information, check QUERY_TAG docs.
- Quoted
Identifiers boolIgnore Case - Specifies whether letters in double-quoted object identifiers are stored and resolved as uppercase letters. By default, Snowflake preserves the case of alphabetic characters when storing and resolving double-quoted identifiers (see Identifier resolution). You can use this parameter in situations in which third-party applications always use double quotes around identifiers. For more information, check QUOTEDIDENTIFIERSIGNORE_CASE docs.
- Rows
Per intResultset - Specifies the maximum number of rows returned in a result set. A value of 0 specifies no maximum. For more information, check ROWSPERRESULTSET docs.
- Rsa
Public stringKey - Specifies the user’s RSA public key; used for key-pair authentication. Must be on 1 line without header and trailer.
- Rsa
Public stringKey2 - Specifies the user’s second RSA public key; used to rotate the public and private keys for key-pair authentication based on an expiration schedule set by your organization. Must be on 1 line without header and trailer.
- S3Stage
Vpce stringDns Name - Specifies the DNS name of an Amazon S3 interface endpoint. Requests sent to the internal stage of an account via AWS PrivateLink for Amazon S3 use this endpoint to connect. For more information, see Accessing Internal stages with dedicated interface endpoints. For more information, check S3STAGEVPCEDNSNAME docs.
- Search
Path string - Specifies the path to search to resolve unqualified object names in queries. For more information, see Name resolution in queries. Comma-separated list of identifiers. An identifier can be a fully or partially qualified schema name. For more information, check SEARCH_PATH docs.
- Show
Outputs List<LegacyService User Show Output> - Outputs the result of
SHOW USER
for the given user. - Simulated
Data stringSharing Consumer - Specifies the name of a consumer account to simulate for testing/validating shared data, particularly shared secure views. When this parameter is set in a session, shared views return rows as if executed in the specified consumer account rather than the provider account. For more information, see Introduction to Secure Data Sharing and Working with shares. For more information, check SIMULATEDDATASHARING_CONSUMER docs.
- Statement
Queued intTimeout In Seconds - Amount of time, in seconds, a SQL statement (query, DDL, DML, etc.) remains queued for a warehouse before it is canceled by the system. This parameter can be used in conjunction with the MAXCONCURRENCYLEVEL parameter to ensure a warehouse is never backlogged. For more information, check STATEMENTQUEUEDTIMEOUTINSECONDS docs.
- Statement
Timeout intIn Seconds - Amount of time, in seconds, after which a running SQL statement (query, DDL, DML, etc.) is canceled by the system. For more information, check STATEMENTTIMEOUTIN_SECONDS docs.
- Strict
Json boolOutput - This parameter specifies whether JSON output in a session is compatible with the general standard (as described by http://json.org). By design, Snowflake allows JSON input that contains non-standard values; however, these non-standard values might result in Snowflake outputting JSON that is incompatible with other platforms and languages. This parameter, when enabled, ensures that Snowflake outputs valid/compatible JSON. For more information, check STRICTJSONOUTPUT docs.
- Time
Input stringFormat - Specifies the input format for the TIME data type. For more information, see Date and time input and output formats. Any valid, supported time format or AUTO (AUTO specifies that Snowflake attempts to automatically detect the format of times stored in the system during the session). For more information, check TIMEINPUTFORMAT docs.
- Time
Output stringFormat - Specifies the display format for the TIME data type. For more information, see Date and time input and output formats. For more information, check TIMEOUTPUTFORMAT docs.
- Timestamp
Day boolIs Always24h - Specifies whether the DATEADD function (and its aliases) always consider a day to be exactly 24 hours for expressions that span multiple days. For more information, check TIMESTAMPDAYISALWAYS24H docs.
- Timestamp
Input stringFormat - Specifies the input format for the TIMESTAMP data type alias. For more information, see Date and time input and output formats. Any valid, supported timestamp format or AUTO (AUTO specifies that Snowflake attempts to automatically detect the format of timestamps stored in the system during the session). For more information, check TIMESTAMPINPUTFORMAT docs.
- Timestamp
Ltz stringOutput Format - Specifies the display format for the TIMESTAMPLTZ data type. If no format is specified, defaults to OUTPUT*FORMATTIMESTAMP. For more information, see Date and time input and output formats. For more information, check TIMESTAMPLTZOUTPUT*FORMAT docs.
- Timestamp
Ntz stringOutput Format - Specifies the display format for the TIMESTAMPNTZ data type. For more information, check NTZOUTPUTFORMAT docsTIMESTAMP.
- Timestamp
Output stringFormat - Specifies the display format for the TIMESTAMP data type alias. For more information, see Date and time input and output formats. For more information, check TIMESTAMPOUTPUTFORMAT docs.
- Timestamp
Type stringMapping - Specifies the TIMESTAMP** variation that the TIMESTAMP data type alias maps to. For more information, check TIMESTAMP*TYPE_MAPPING docs.
- Timestamp
Tz stringOutput Format - Specifies the display format for the TIMESTAMPTZ data type. If no format is specified, defaults to OUTPUT*FORMATTIMESTAMP. For more information, see Date and time input and output formats. For more information, check TIMESTAMPTZOUTPUT*FORMAT docs.
- Timezone string
- Specifies the time zone for the session. You can specify a time zone name or a link name from release 2021a of the IANA Time Zone Database (e.g. America/Los_Angeles, Europe/London, UTC, Etc/GMT, etc.). For more information, check TIMEZONE docs.
- Trace
Level string - Controls how trace events are ingested into the event table. For more information about trace levels, see Setting trace level. For more information, check TRACE_LEVEL docs.
- Transaction
Abort boolOn Error - Specifies the action to perform when a statement issued within a non-autocommit transaction returns with an error. For more information, check TRANSACTIONABORTON_ERROR docs.
- Transaction
Default stringIsolation Level - Specifies the isolation level for transactions in the user session. For more information, check TRANSACTIONDEFAULTISOLATION_LEVEL docs.
- Two
Digit intCentury Start - Specifies the “century start” year for 2-digit years (i.e. the earliest year such dates can represent). This parameter prevents ambiguous dates when importing or converting data with the
YY
date format component (i.e. years represented as 2 digits). For more information, check TWODIGITCENTURY_START docs. - Unsupported
Ddl stringAction - Determines if an unsupported (i.e. non-default) value specified for a constraint property returns an error. For more information, check UNSUPPORTEDDDLACTION docs.
- Use
Cached boolResult - Specifies whether to reuse persisted query results, if available, when a matching query is submitted. For more information, check USECACHEDRESULT docs.
- User
Type string - Specifies a type for the user.
- Week
Of intYear Policy - Specifies how the weeks in a given year are computed.
0
: The semantics used are equivalent to the ISO semantics, in which a week belongs to a given year if at least 4 days of that week are in that year.1
: January 1 is included in the first week of the year and December 31 is included in the last week of the year. For more information, check WEEKOFYEAR_POLICY docs. - Week
Start int - Specifies the first day of the week (used by week-related date functions).
0
: Legacy Snowflake behavior is used (i.e. ISO-like semantics).1
(Monday) to7
(Sunday): All the week-related functions use weeks that start on the specified day of the week. For more information, check WEEK_START docs.
- Abort
Detached boolQuery - Specifies the action that Snowflake performs for in-progress queries if connectivity is lost due to abrupt termination of a session (e.g. network outage, browser termination, service interruption). For more information, check ABORTDETACHEDQUERY docs.
- Autocommit bool
- Specifies whether autocommit is enabled for the session. Autocommit determines whether a DML statement, when executed without an active transaction, is automatically committed after the statement successfully completes. For more information, see Transactions. For more information, check AUTOCOMMIT docs.
- Binary
Input stringFormat - The format of VARCHAR values passed as input to VARCHAR-to-BINARY conversion functions. For more information, see Binary input and output. For more information, check BINARYINPUTFORMAT docs.
- Binary
Output stringFormat - The format for VARCHAR values returned as output by BINARY-to-VARCHAR conversion functions. For more information, see Binary input and output. For more information, check BINARYOUTPUTFORMAT docs.
- Client
Memory intLimit - Parameter that specifies the maximum amount of memory the JDBC driver or ODBC driver should use for the result set from queries (in MB). For more information, check CLIENTMEMORYLIMIT docs.
- Client
Metadata boolRequest Use Connection Ctx - For specific ODBC functions and JDBC methods, this parameter can change the default search scope from all databases/schemas to the current database/schema. The narrower search typically returns fewer rows and executes more quickly. For more information, check CLIENTMETADATAREQUESTUSECONNECTION_CTX docs.
- Client
Prefetch intThreads - Parameter that specifies the number of threads used by the client to pre-fetch large result sets. The driver will attempt to honor the parameter value, but defines the minimum and maximum values (depending on your system’s resources) to improve performance. For more information, check CLIENTPREFETCHTHREADS docs.
- Client
Result intChunk Size - Parameter that specifies the maximum size of each set (or chunk) of query results to download (in MB). The JDBC driver downloads query results in chunks. For more information, check CLIENTRESULTCHUNK_SIZE docs.
- Client
Result boolColumn Case Insensitive - Parameter that indicates whether to match column name case-insensitively in ResultSet.get* methods in JDBC. For more information, check CLIENTRESULTCOLUMNCASEINSENSITIVE docs.
- Client
Session boolKeep Alive - Parameter that indicates whether to force a user to log in again after a period of inactivity in the session. For more information, check CLIENTSESSIONKEEP_ALIVE docs.
- Client
Session intKeep Alive Heartbeat Frequency - Number of seconds in-between client attempts to update the token for the session. For more information, check CLIENTSESSIONKEEPALIVEHEARTBEAT_FREQUENCY docs.
- Client
Timestamp stringType Mapping - Specifies the TIMESTAMP_* variation to use when binding timestamp variables for JDBC or ODBC applications that use the bind API to load data. For more information, check CLIENTTIMESTAMPTYPE_MAPPING docs.
- Comment string
- Specifies a comment for the user.
- Date
Input stringFormat - Specifies the input format for the DATE data type. For more information, see Date and time input and output formats. For more information, check DATEINPUTFORMAT docs.
- Date
Output stringFormat - Specifies the display format for the DATE data type. For more information, see Date and time input and output formats. For more information, check DATEOUTPUTFORMAT docs.
- Days
To intExpiry - Default
Namespace string - Specifies the namespace (database only or database and schema) that is active by default for the user’s session upon login. Note that the CREATE USER operation does not verify that the namespace exists.
- Default
Role string - Specifies the role that is active by default for the user’s session upon login. Note that specifying a default role for a user does not grant the role to the user. The role must be granted explicitly to the user using the GRANT ROLE command. In addition, the CREATE USER operation does not verify that the role exists.
- Default
Secondary stringRoles Option - Specifies the secondary roles that are active for the user’s session upon login. Valid values are (case-insensitive):
DEFAULT
|NONE
|ALL
. More information can be found in doc. - Default
Warehouse string - Specifies the virtual warehouse that is active by default for the user’s session upon login. Note that the CREATE USER operation does not verify that the warehouse exists.
- Disabled string
- Specifies whether the user is disabled, which prevents logging in and aborts all the currently-running queries for the user. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
- Display
Name string - Name displayed for the user in the Snowflake web interface.
- Email string
- Email address for the user.
- Enable
Unload boolPhysical Type Optimization - Specifies whether to set the schema for unloaded Parquet files based on the logical column data types (i.e. the types in the unload SQL query or source table) or on the unloaded column values (i.e. the smallest data types and precision that support the values in the output columns of the unload SQL statement or source table). For more information, check ENABLEUNLOADPHYSICALTYPEOPTIMIZATION docs.
- Enable
Unredacted boolQuery Syntax Error - Controls whether query text is redacted if a SQL query fails due to a syntax or parsing error. If
FALSE
, the content of a failed query is redacted in the views, pages, and functions that provide a query history. Only users with a role that is granted or inherits the AUDIT privilege can set the ENABLEUNREDACTEDQUERYSYNTAXERROR parameter. When using the ALTER USER command to set the parameter toTRUE
for a particular user, modify the user that you want to see the query text, not the user who executed the query (if those are different users). For more information, check UNREDACTEDQUERYSYNTAXERROR docsENABLE. - Error
On boolNondeterministic Merge - Specifies whether to return an error when the MERGE command is used to update or delete a target row that joins multiple source rows and the system cannot determine the action to perform on the target row. For more information, check ERRORONNONDETERMINISTIC_MERGE docs.
- Error
On boolNondeterministic Update - Specifies whether to return an error when the UPDATE command is used to update a target row that joins multiple source rows and the system cannot determine the action to perform on the target row. For more information, check ERRORONNONDETERMINISTIC_UPDATE docs.
- Fully
Qualified stringName - Fully qualified name of the resource. For more information, see object name resolution.
- Geography
Output stringFormat - Display format for GEOGRAPHY values. For more information, check GEOGRAPHYOUTPUTFORMAT docs.
- Geometry
Output stringFormat - Display format for GEOMETRY values. For more information, check GEOMETRYOUTPUTFORMAT docs.
- Jdbc
Treat boolDecimal As Int - Specifies how JDBC processes columns that have a scale of zero (0). For more information, check JDBCTREATDECIMALASINT docs.
- Jdbc
Treat boolTimestamp Ntz As Utc - Specifies how JDBC processes TIMESTAMPNTZ values. For more information, check TREATTIMESTAMPNTZASUTC docsJDBC.
- Jdbc
Use boolSession Timezone - Specifies whether the JDBC Driver uses the time zone of the JVM or the time zone of the session (specified by the TIMEZONE parameter) for the getDate(), getTime(), and getTimestamp() methods of the ResultSet class. For more information, check JDBCUSESESSION_TIMEZONE docs.
- Json
Indent int - Specifies the number of blank spaces to indent each new element in JSON output in the session. Also specifies whether to insert newline characters after each element. For more information, check JSON_INDENT docs.
- Lock
Timeout int - Number of seconds to wait while trying to lock a resource, before timing out and aborting the statement. For more information, check LOCK_TIMEOUT docs.
- Log
Level string - Specifies the severity level of messages that should be ingested and made available in the active event table. Messages at the specified level (and at more severe levels) are ingested. For more information about log levels, see Setting log level. For more information, check LOG_LEVEL docs.
- Login
Name string - The name users use to log in. If not supplied, snowflake will use name instead. Login names are always case-insensitive.
- Mins
To intUnlock - Multi
Statement intCount - Number of statements to execute when using the multi-statement capability. For more information, check MULTISTATEMENTCOUNT docs.
- Must
Change stringPassword - Specifies whether the user is forced to change their password on next login (including their first/initial login) into the system. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
- Name string
- Name of the user. Note that if you do not supply loginname this will be used as loginname. Check the docs. Due to technical limitations (read more here), avoid using the following characters:
|
,.
,(
,)
,"
- Network
Policy string - Specifies the network policy to enforce for your account. Network policies enable restricting access to your account based on users’ IP address. For more details, see Controlling network traffic with network policies. Any existing network policy (created using CREATE NETWORK POLICY). For more information, check NETWORK_POLICY docs.
- Noorder
Sequence boolAs Default - Specifies whether the ORDER or NOORDER property is set by default when you create a new sequence or add a new table column. The ORDER and NOORDER properties determine whether or not the values are generated for the sequence or auto-incremented column in increasing or decreasing order. For more information, check NOORDERSEQUENCEAS_DEFAULT docs.
- Odbc
Treat boolDecimal As Int - Specifies how ODBC processes columns that have a scale of zero (0). For more information, check ODBCTREATDECIMALASINT docs.
- Parameters
[]Legacy
Service User Parameter Args - Outputs the result of
SHOW PARAMETERS IN USER
for the given user. - Password string
- Prevent
Unload boolTo Internal Stages - Specifies whether to prevent data unload operations to internal (Snowflake) stages using COPY INTO \n\n statements. For more information, check PREVENTUNLOADTOINTERNALSTAGES docs.
- Query
Tag string - Optional string that can be used to tag queries and other SQL statements executed within a session. The tags are displayed in the output of the QUERYHISTORY, QUERYHISTORY*BY** functions. For more information, check QUERY_TAG docs.
- Quoted
Identifiers boolIgnore Case - Specifies whether letters in double-quoted object identifiers are stored and resolved as uppercase letters. By default, Snowflake preserves the case of alphabetic characters when storing and resolving double-quoted identifiers (see Identifier resolution). You can use this parameter in situations in which third-party applications always use double quotes around identifiers. For more information, check QUOTEDIDENTIFIERSIGNORE_CASE docs.
- Rows
Per intResultset - Specifies the maximum number of rows returned in a result set. A value of 0 specifies no maximum. For more information, check ROWSPERRESULTSET docs.
- Rsa
Public stringKey - Specifies the user’s RSA public key; used for key-pair authentication. Must be on 1 line without header and trailer.
- Rsa
Public stringKey2 - Specifies the user’s second RSA public key; used to rotate the public and private keys for key-pair authentication based on an expiration schedule set by your organization. Must be on 1 line without header and trailer.
- S3Stage
Vpce stringDns Name - Specifies the DNS name of an Amazon S3 interface endpoint. Requests sent to the internal stage of an account via AWS PrivateLink for Amazon S3 use this endpoint to connect. For more information, see Accessing Internal stages with dedicated interface endpoints. For more information, check S3STAGEVPCEDNSNAME docs.
- Search
Path string - Specifies the path to search to resolve unqualified object names in queries. For more information, see Name resolution in queries. Comma-separated list of identifiers. An identifier can be a fully or partially qualified schema name. For more information, check SEARCH_PATH docs.
- Show
Outputs []LegacyService User Show Output Args - Outputs the result of
SHOW USER
for the given user. - Simulated
Data stringSharing Consumer - Specifies the name of a consumer account to simulate for testing/validating shared data, particularly shared secure views. When this parameter is set in a session, shared views return rows as if executed in the specified consumer account rather than the provider account. For more information, see Introduction to Secure Data Sharing and Working with shares. For more information, check SIMULATEDDATASHARING_CONSUMER docs.
- Statement
Queued intTimeout In Seconds - Amount of time, in seconds, a SQL statement (query, DDL, DML, etc.) remains queued for a warehouse before it is canceled by the system. This parameter can be used in conjunction with the MAXCONCURRENCYLEVEL parameter to ensure a warehouse is never backlogged. For more information, check STATEMENTQUEUEDTIMEOUTINSECONDS docs.
- Statement
Timeout intIn Seconds - Amount of time, in seconds, after which a running SQL statement (query, DDL, DML, etc.) is canceled by the system. For more information, check STATEMENTTIMEOUTIN_SECONDS docs.
- Strict
Json boolOutput - This parameter specifies whether JSON output in a session is compatible with the general standard (as described by http://json.org). By design, Snowflake allows JSON input that contains non-standard values; however, these non-standard values might result in Snowflake outputting JSON that is incompatible with other platforms and languages. This parameter, when enabled, ensures that Snowflake outputs valid/compatible JSON. For more information, check STRICTJSONOUTPUT docs.
- Time
Input stringFormat - Specifies the input format for the TIME data type. For more information, see Date and time input and output formats. Any valid, supported time format or AUTO (AUTO specifies that Snowflake attempts to automatically detect the format of times stored in the system during the session). For more information, check TIMEINPUTFORMAT docs.
- Time
Output stringFormat - Specifies the display format for the TIME data type. For more information, see Date and time input and output formats. For more information, check TIMEOUTPUTFORMAT docs.
- Timestamp
Day boolIs Always24h - Specifies whether the DATEADD function (and its aliases) always consider a day to be exactly 24 hours for expressions that span multiple days. For more information, check TIMESTAMPDAYISALWAYS24H docs.
- Timestamp
Input stringFormat - Specifies the input format for the TIMESTAMP data type alias. For more information, see Date and time input and output formats. Any valid, supported timestamp format or AUTO (AUTO specifies that Snowflake attempts to automatically detect the format of timestamps stored in the system during the session). For more information, check TIMESTAMPINPUTFORMAT docs.
- Timestamp
Ltz stringOutput Format - Specifies the display format for the TIMESTAMPLTZ data type. If no format is specified, defaults to OUTPUT*FORMATTIMESTAMP. For more information, see Date and time input and output formats. For more information, check TIMESTAMPLTZOUTPUT*FORMAT docs.
- Timestamp
Ntz stringOutput Format - Specifies the display format for the TIMESTAMPNTZ data type. For more information, check NTZOUTPUTFORMAT docsTIMESTAMP.
- Timestamp
Output stringFormat - Specifies the display format for the TIMESTAMP data type alias. For more information, see Date and time input and output formats. For more information, check TIMESTAMPOUTPUTFORMAT docs.
- Timestamp
Type stringMapping - Specifies the TIMESTAMP** variation that the TIMESTAMP data type alias maps to. For more information, check TIMESTAMP*TYPE_MAPPING docs.
- Timestamp
Tz stringOutput Format - Specifies the display format for the TIMESTAMPTZ data type. If no format is specified, defaults to OUTPUT*FORMATTIMESTAMP. For more information, see Date and time input and output formats. For more information, check TIMESTAMPTZOUTPUT*FORMAT docs.
- Timezone string
- Specifies the time zone for the session. You can specify a time zone name or a link name from release 2021a of the IANA Time Zone Database (e.g. America/Los_Angeles, Europe/London, UTC, Etc/GMT, etc.). For more information, check TIMEZONE docs.
- Trace
Level string - Controls how trace events are ingested into the event table. For more information about trace levels, see Setting trace level. For more information, check TRACE_LEVEL docs.
- Transaction
Abort boolOn Error - Specifies the action to perform when a statement issued within a non-autocommit transaction returns with an error. For more information, check TRANSACTIONABORTON_ERROR docs.
- Transaction
Default stringIsolation Level - Specifies the isolation level for transactions in the user session. For more information, check TRANSACTIONDEFAULTISOLATION_LEVEL docs.
- Two
Digit intCentury Start - Specifies the “century start” year for 2-digit years (i.e. the earliest year such dates can represent). This parameter prevents ambiguous dates when importing or converting data with the
YY
date format component (i.e. years represented as 2 digits). For more information, check TWODIGITCENTURY_START docs. - Unsupported
Ddl stringAction - Determines if an unsupported (i.e. non-default) value specified for a constraint property returns an error. For more information, check UNSUPPORTEDDDLACTION docs.
- Use
Cached boolResult - Specifies whether to reuse persisted query results, if available, when a matching query is submitted. For more information, check USECACHEDRESULT docs.
- User
Type string - Specifies a type for the user.
- Week
Of intYear Policy - Specifies how the weeks in a given year are computed.
0
: The semantics used are equivalent to the ISO semantics, in which a week belongs to a given year if at least 4 days of that week are in that year.1
: January 1 is included in the first week of the year and December 31 is included in the last week of the year. For more information, check WEEKOFYEAR_POLICY docs. - Week
Start int - Specifies the first day of the week (used by week-related date functions).
0
: Legacy Snowflake behavior is used (i.e. ISO-like semantics).1
(Monday) to7
(Sunday): All the week-related functions use weeks that start on the specified day of the week. For more information, check WEEK_START docs.
- abort
Detached BooleanQuery - Specifies the action that Snowflake performs for in-progress queries if connectivity is lost due to abrupt termination of a session (e.g. network outage, browser termination, service interruption). For more information, check ABORTDETACHEDQUERY docs.
- autocommit Boolean
- Specifies whether autocommit is enabled for the session. Autocommit determines whether a DML statement, when executed without an active transaction, is automatically committed after the statement successfully completes. For more information, see Transactions. For more information, check AUTOCOMMIT docs.
- binary
Input StringFormat - The format of VARCHAR values passed as input to VARCHAR-to-BINARY conversion functions. For more information, see Binary input and output. For more information, check BINARYINPUTFORMAT docs.
- binary
Output StringFormat - The format for VARCHAR values returned as output by BINARY-to-VARCHAR conversion functions. For more information, see Binary input and output. For more information, check BINARYOUTPUTFORMAT docs.
- client
Memory IntegerLimit - Parameter that specifies the maximum amount of memory the JDBC driver or ODBC driver should use for the result set from queries (in MB). For more information, check CLIENTMEMORYLIMIT docs.
- client
Metadata BooleanRequest Use Connection Ctx - For specific ODBC functions and JDBC methods, this parameter can change the default search scope from all databases/schemas to the current database/schema. The narrower search typically returns fewer rows and executes more quickly. For more information, check CLIENTMETADATAREQUESTUSECONNECTION_CTX docs.
- client
Prefetch IntegerThreads - Parameter that specifies the number of threads used by the client to pre-fetch large result sets. The driver will attempt to honor the parameter value, but defines the minimum and maximum values (depending on your system’s resources) to improve performance. For more information, check CLIENTPREFETCHTHREADS docs.
- client
Result IntegerChunk Size - Parameter that specifies the maximum size of each set (or chunk) of query results to download (in MB). The JDBC driver downloads query results in chunks. For more information, check CLIENTRESULTCHUNK_SIZE docs.
- client
Result BooleanColumn Case Insensitive - Parameter that indicates whether to match column name case-insensitively in ResultSet.get* methods in JDBC. For more information, check CLIENTRESULTCOLUMNCASEINSENSITIVE docs.
- client
Session BooleanKeep Alive - Parameter that indicates whether to force a user to log in again after a period of inactivity in the session. For more information, check CLIENTSESSIONKEEP_ALIVE docs.
- client
Session IntegerKeep Alive Heartbeat Frequency - Number of seconds in-between client attempts to update the token for the session. For more information, check CLIENTSESSIONKEEPALIVEHEARTBEAT_FREQUENCY docs.
- client
Timestamp StringType Mapping - Specifies the TIMESTAMP_* variation to use when binding timestamp variables for JDBC or ODBC applications that use the bind API to load data. For more information, check CLIENTTIMESTAMPTYPE_MAPPING docs.
- comment String
- Specifies a comment for the user.
- date
Input StringFormat - Specifies the input format for the DATE data type. For more information, see Date and time input and output formats. For more information, check DATEINPUTFORMAT docs.
- date
Output StringFormat - Specifies the display format for the DATE data type. For more information, see Date and time input and output formats. For more information, check DATEOUTPUTFORMAT docs.
- days
To IntegerExpiry - default
Namespace String - Specifies the namespace (database only or database and schema) that is active by default for the user’s session upon login. Note that the CREATE USER operation does not verify that the namespace exists.
- default
Role String - Specifies the role that is active by default for the user’s session upon login. Note that specifying a default role for a user does not grant the role to the user. The role must be granted explicitly to the user using the GRANT ROLE command. In addition, the CREATE USER operation does not verify that the role exists.
- default
Secondary StringRoles Option - Specifies the secondary roles that are active for the user’s session upon login. Valid values are (case-insensitive):
DEFAULT
|NONE
|ALL
. More information can be found in doc. - default
Warehouse String - Specifies the virtual warehouse that is active by default for the user’s session upon login. Note that the CREATE USER operation does not verify that the warehouse exists.
- disabled String
- Specifies whether the user is disabled, which prevents logging in and aborts all the currently-running queries for the user. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
- display
Name String - Name displayed for the user in the Snowflake web interface.
- email String
- Email address for the user.
- enable
Unload BooleanPhysical Type Optimization - Specifies whether to set the schema for unloaded Parquet files based on the logical column data types (i.e. the types in the unload SQL query or source table) or on the unloaded column values (i.e. the smallest data types and precision that support the values in the output columns of the unload SQL statement or source table). For more information, check ENABLEUNLOADPHYSICALTYPEOPTIMIZATION docs.
- enable
Unredacted BooleanQuery Syntax Error - Controls whether query text is redacted if a SQL query fails due to a syntax or parsing error. If
FALSE
, the content of a failed query is redacted in the views, pages, and functions that provide a query history. Only users with a role that is granted or inherits the AUDIT privilege can set the ENABLEUNREDACTEDQUERYSYNTAXERROR parameter. When using the ALTER USER command to set the parameter toTRUE
for a particular user, modify the user that you want to see the query text, not the user who executed the query (if those are different users). For more information, check UNREDACTEDQUERYSYNTAXERROR docsENABLE. - error
On BooleanNondeterministic Merge - Specifies whether to return an error when the MERGE command is used to update or delete a target row that joins multiple source rows and the system cannot determine the action to perform on the target row. For more information, check ERRORONNONDETERMINISTIC_MERGE docs.
- error
On BooleanNondeterministic Update - Specifies whether to return an error when the UPDATE command is used to update a target row that joins multiple source rows and the system cannot determine the action to perform on the target row. For more information, check ERRORONNONDETERMINISTIC_UPDATE docs.
- fully
Qualified StringName - Fully qualified name of the resource. For more information, see object name resolution.
- geography
Output StringFormat - Display format for GEOGRAPHY values. For more information, check GEOGRAPHYOUTPUTFORMAT docs.
- geometry
Output StringFormat - Display format for GEOMETRY values. For more information, check GEOMETRYOUTPUTFORMAT docs.
- jdbc
Treat BooleanDecimal As Int - Specifies how JDBC processes columns that have a scale of zero (0). For more information, check JDBCTREATDECIMALASINT docs.
- jdbc
Treat BooleanTimestamp Ntz As Utc - Specifies how JDBC processes TIMESTAMPNTZ values. For more information, check TREATTIMESTAMPNTZASUTC docsJDBC.
- jdbc
Use BooleanSession Timezone - Specifies whether the JDBC Driver uses the time zone of the JVM or the time zone of the session (specified by the TIMEZONE parameter) for the getDate(), getTime(), and getTimestamp() methods of the ResultSet class. For more information, check JDBCUSESESSION_TIMEZONE docs.
- json
Indent Integer - Specifies the number of blank spaces to indent each new element in JSON output in the session. Also specifies whether to insert newline characters after each element. For more information, check JSON_INDENT docs.
- lock
Timeout Integer - Number of seconds to wait while trying to lock a resource, before timing out and aborting the statement. For more information, check LOCK_TIMEOUT docs.
- log
Level String - Specifies the severity level of messages that should be ingested and made available in the active event table. Messages at the specified level (and at more severe levels) are ingested. For more information about log levels, see Setting log level. For more information, check LOG_LEVEL docs.
- login
Name String - The name users use to log in. If not supplied, snowflake will use name instead. Login names are always case-insensitive.
- mins
To IntegerUnlock - multi
Statement IntegerCount - Number of statements to execute when using the multi-statement capability. For more information, check MULTISTATEMENTCOUNT docs.
- must
Change StringPassword - Specifies whether the user is forced to change their password on next login (including their first/initial login) into the system. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
- name String
- Name of the user. Note that if you do not supply loginname this will be used as loginname. Check the docs. Due to technical limitations (read more here), avoid using the following characters:
|
,.
,(
,)
,"
- network
Policy String - Specifies the network policy to enforce for your account. Network policies enable restricting access to your account based on users’ IP address. For more details, see Controlling network traffic with network policies. Any existing network policy (created using CREATE NETWORK POLICY). For more information, check NETWORK_POLICY docs.
- noorder
Sequence BooleanAs Default - Specifies whether the ORDER or NOORDER property is set by default when you create a new sequence or add a new table column. The ORDER and NOORDER properties determine whether or not the values are generated for the sequence or auto-incremented column in increasing or decreasing order. For more information, check NOORDERSEQUENCEAS_DEFAULT docs.
- odbc
Treat BooleanDecimal As Int - Specifies how ODBC processes columns that have a scale of zero (0). For more information, check ODBCTREATDECIMALASINT docs.
- parameters
List<Legacy
Service User Parameter> - Outputs the result of
SHOW PARAMETERS IN USER
for the given user. - password String
- prevent
Unload BooleanTo Internal Stages - Specifies whether to prevent data unload operations to internal (Snowflake) stages using COPY INTO \n\n statements. For more information, check PREVENTUNLOADTOINTERNALSTAGES docs.
- query
Tag String - Optional string that can be used to tag queries and other SQL statements executed within a session. The tags are displayed in the output of the QUERYHISTORY, QUERYHISTORY*BY** functions. For more information, check QUERY_TAG docs.
- quoted
Identifiers BooleanIgnore Case - Specifies whether letters in double-quoted object identifiers are stored and resolved as uppercase letters. By default, Snowflake preserves the case of alphabetic characters when storing and resolving double-quoted identifiers (see Identifier resolution). You can use this parameter in situations in which third-party applications always use double quotes around identifiers. For more information, check QUOTEDIDENTIFIERSIGNORE_CASE docs.
- rows
Per IntegerResultset - Specifies the maximum number of rows returned in a result set. A value of 0 specifies no maximum. For more information, check ROWSPERRESULTSET docs.
- rsa
Public StringKey - Specifies the user’s RSA public key; used for key-pair authentication. Must be on 1 line without header and trailer.
- rsa
Public StringKey2 - Specifies the user’s second RSA public key; used to rotate the public and private keys for key-pair authentication based on an expiration schedule set by your organization. Must be on 1 line without header and trailer.
- s3Stage
Vpce StringDns Name - Specifies the DNS name of an Amazon S3 interface endpoint. Requests sent to the internal stage of an account via AWS PrivateLink for Amazon S3 use this endpoint to connect. For more information, see Accessing Internal stages with dedicated interface endpoints. For more information, check S3STAGEVPCEDNSNAME docs.
- search
Path String - Specifies the path to search to resolve unqualified object names in queries. For more information, see Name resolution in queries. Comma-separated list of identifiers. An identifier can be a fully or partially qualified schema name. For more information, check SEARCH_PATH docs.
- show
Outputs List<LegacyService User Show Output> - Outputs the result of
SHOW USER
for the given user. - simulated
Data StringSharing Consumer - Specifies the name of a consumer account to simulate for testing/validating shared data, particularly shared secure views. When this parameter is set in a session, shared views return rows as if executed in the specified consumer account rather than the provider account. For more information, see Introduction to Secure Data Sharing and Working with shares. For more information, check SIMULATEDDATASHARING_CONSUMER docs.
- statement
Queued IntegerTimeout In Seconds - Amount of time, in seconds, a SQL statement (query, DDL, DML, etc.) remains queued for a warehouse before it is canceled by the system. This parameter can be used in conjunction with the MAXCONCURRENCYLEVEL parameter to ensure a warehouse is never backlogged. For more information, check STATEMENTQUEUEDTIMEOUTINSECONDS docs.
- statement
Timeout IntegerIn Seconds - Amount of time, in seconds, after which a running SQL statement (query, DDL, DML, etc.) is canceled by the system. For more information, check STATEMENTTIMEOUTIN_SECONDS docs.
- strict
Json BooleanOutput - This parameter specifies whether JSON output in a session is compatible with the general standard (as described by http://json.org). By design, Snowflake allows JSON input that contains non-standard values; however, these non-standard values might result in Snowflake outputting JSON that is incompatible with other platforms and languages. This parameter, when enabled, ensures that Snowflake outputs valid/compatible JSON. For more information, check STRICTJSONOUTPUT docs.
- time
Input StringFormat - Specifies the input format for the TIME data type. For more information, see Date and time input and output formats. Any valid, supported time format or AUTO (AUTO specifies that Snowflake attempts to automatically detect the format of times stored in the system during the session). For more information, check TIMEINPUTFORMAT docs.
- time
Output StringFormat - Specifies the display format for the TIME data type. For more information, see Date and time input and output formats. For more information, check TIMEOUTPUTFORMAT docs.
- timestamp
Day BooleanIs Always24h - Specifies whether the DATEADD function (and its aliases) always consider a day to be exactly 24 hours for expressions that span multiple days. For more information, check TIMESTAMPDAYISALWAYS24H docs.
- timestamp
Input StringFormat - Specifies the input format for the TIMESTAMP data type alias. For more information, see Date and time input and output formats. Any valid, supported timestamp format or AUTO (AUTO specifies that Snowflake attempts to automatically detect the format of timestamps stored in the system during the session). For more information, check TIMESTAMPINPUTFORMAT docs.
- timestamp
Ltz StringOutput Format - Specifies the display format for the TIMESTAMPLTZ data type. If no format is specified, defaults to OUTPUT*FORMATTIMESTAMP. For more information, see Date and time input and output formats. For more information, check TIMESTAMPLTZOUTPUT*FORMAT docs.
- timestamp
Ntz StringOutput Format - Specifies the display format for the TIMESTAMPNTZ data type. For more information, check NTZOUTPUTFORMAT docsTIMESTAMP.
- timestamp
Output StringFormat - Specifies the display format for the TIMESTAMP data type alias. For more information, see Date and time input and output formats. For more information, check TIMESTAMPOUTPUTFORMAT docs.
- timestamp
Type StringMapping - Specifies the TIMESTAMP** variation that the TIMESTAMP data type alias maps to. For more information, check TIMESTAMP*TYPE_MAPPING docs.
- timestamp
Tz StringOutput Format - Specifies the display format for the TIMESTAMPTZ data type. If no format is specified, defaults to OUTPUT*FORMATTIMESTAMP. For more information, see Date and time input and output formats. For more information, check TIMESTAMPTZOUTPUT*FORMAT docs.
- timezone String
- Specifies the time zone for the session. You can specify a time zone name or a link name from release 2021a of the IANA Time Zone Database (e.g. America/Los_Angeles, Europe/London, UTC, Etc/GMT, etc.). For more information, check TIMEZONE docs.
- trace
Level String - Controls how trace events are ingested into the event table. For more information about trace levels, see Setting trace level. For more information, check TRACE_LEVEL docs.
- transaction
Abort BooleanOn Error - Specifies the action to perform when a statement issued within a non-autocommit transaction returns with an error. For more information, check TRANSACTIONABORTON_ERROR docs.
- transaction
Default StringIsolation Level - Specifies the isolation level for transactions in the user session. For more information, check TRANSACTIONDEFAULTISOLATION_LEVEL docs.
- two
Digit IntegerCentury Start - Specifies the “century start” year for 2-digit years (i.e. the earliest year such dates can represent). This parameter prevents ambiguous dates when importing or converting data with the
YY
date format component (i.e. years represented as 2 digits). For more information, check TWODIGITCENTURY_START docs. - unsupported
Ddl StringAction - Determines if an unsupported (i.e. non-default) value specified for a constraint property returns an error. For more information, check UNSUPPORTEDDDLACTION docs.
- use
Cached BooleanResult - Specifies whether to reuse persisted query results, if available, when a matching query is submitted. For more information, check USECACHEDRESULT docs.
- user
Type String - Specifies a type for the user.
- week
Of IntegerYear Policy - Specifies how the weeks in a given year are computed.
0
: The semantics used are equivalent to the ISO semantics, in which a week belongs to a given year if at least 4 days of that week are in that year.1
: January 1 is included in the first week of the year and December 31 is included in the last week of the year. For more information, check WEEKOFYEAR_POLICY docs. - week
Start Integer - Specifies the first day of the week (used by week-related date functions).
0
: Legacy Snowflake behavior is used (i.e. ISO-like semantics).1
(Monday) to7
(Sunday): All the week-related functions use weeks that start on the specified day of the week. For more information, check WEEK_START docs.
- abort
Detached booleanQuery - Specifies the action that Snowflake performs for in-progress queries if connectivity is lost due to abrupt termination of a session (e.g. network outage, browser termination, service interruption). For more information, check ABORTDETACHEDQUERY docs.
- autocommit boolean
- Specifies whether autocommit is enabled for the session. Autocommit determines whether a DML statement, when executed without an active transaction, is automatically committed after the statement successfully completes. For more information, see Transactions. For more information, check AUTOCOMMIT docs.
- binary
Input stringFormat - The format of VARCHAR values passed as input to VARCHAR-to-BINARY conversion functions. For more information, see Binary input and output. For more information, check BINARYINPUTFORMAT docs.
- binary
Output stringFormat - The format for VARCHAR values returned as output by BINARY-to-VARCHAR conversion functions. For more information, see Binary input and output. For more information, check BINARYOUTPUTFORMAT docs.
- client
Memory numberLimit - Parameter that specifies the maximum amount of memory the JDBC driver or ODBC driver should use for the result set from queries (in MB). For more information, check CLIENTMEMORYLIMIT docs.
- client
Metadata booleanRequest Use Connection Ctx - For specific ODBC functions and JDBC methods, this parameter can change the default search scope from all databases/schemas to the current database/schema. The narrower search typically returns fewer rows and executes more quickly. For more information, check CLIENTMETADATAREQUESTUSECONNECTION_CTX docs.
- client
Prefetch numberThreads - Parameter that specifies the number of threads used by the client to pre-fetch large result sets. The driver will attempt to honor the parameter value, but defines the minimum and maximum values (depending on your system’s resources) to improve performance. For more information, check CLIENTPREFETCHTHREADS docs.
- client
Result numberChunk Size - Parameter that specifies the maximum size of each set (or chunk) of query results to download (in MB). The JDBC driver downloads query results in chunks. For more information, check CLIENTRESULTCHUNK_SIZE docs.
- client
Result booleanColumn Case Insensitive - Parameter that indicates whether to match column name case-insensitively in ResultSet.get* methods in JDBC. For more information, check CLIENTRESULTCOLUMNCASEINSENSITIVE docs.
- client
Session booleanKeep Alive - Parameter that indicates whether to force a user to log in again after a period of inactivity in the session. For more information, check CLIENTSESSIONKEEP_ALIVE docs.
- client
Session numberKeep Alive Heartbeat Frequency - Number of seconds in-between client attempts to update the token for the session. For more information, check CLIENTSESSIONKEEPALIVEHEARTBEAT_FREQUENCY docs.
- client
Timestamp stringType Mapping - Specifies the TIMESTAMP_* variation to use when binding timestamp variables for JDBC or ODBC applications that use the bind API to load data. For more information, check CLIENTTIMESTAMPTYPE_MAPPING docs.
- comment string
- Specifies a comment for the user.
- date
Input stringFormat - Specifies the input format for the DATE data type. For more information, see Date and time input and output formats. For more information, check DATEINPUTFORMAT docs.
- date
Output stringFormat - Specifies the display format for the DATE data type. For more information, see Date and time input and output formats. For more information, check DATEOUTPUTFORMAT docs.
- days
To numberExpiry - default
Namespace string - Specifies the namespace (database only or database and schema) that is active by default for the user’s session upon login. Note that the CREATE USER operation does not verify that the namespace exists.
- default
Role string - Specifies the role that is active by default for the user’s session upon login. Note that specifying a default role for a user does not grant the role to the user. The role must be granted explicitly to the user using the GRANT ROLE command. In addition, the CREATE USER operation does not verify that the role exists.
- default
Secondary stringRoles Option - Specifies the secondary roles that are active for the user’s session upon login. Valid values are (case-insensitive):
DEFAULT
|NONE
|ALL
. More information can be found in doc. - default
Warehouse string - Specifies the virtual warehouse that is active by default for the user’s session upon login. Note that the CREATE USER operation does not verify that the warehouse exists.
- disabled string
- Specifies whether the user is disabled, which prevents logging in and aborts all the currently-running queries for the user. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
- display
Name string - Name displayed for the user in the Snowflake web interface.
- email string
- Email address for the user.
- enable
Unload booleanPhysical Type Optimization - Specifies whether to set the schema for unloaded Parquet files based on the logical column data types (i.e. the types in the unload SQL query or source table) or on the unloaded column values (i.e. the smallest data types and precision that support the values in the output columns of the unload SQL statement or source table). For more information, check ENABLEUNLOADPHYSICALTYPEOPTIMIZATION docs.
- enable
Unredacted booleanQuery Syntax Error - Controls whether query text is redacted if a SQL query fails due to a syntax or parsing error. If
FALSE
, the content of a failed query is redacted in the views, pages, and functions that provide a query history. Only users with a role that is granted or inherits the AUDIT privilege can set the ENABLEUNREDACTEDQUERYSYNTAXERROR parameter. When using the ALTER USER command to set the parameter toTRUE
for a particular user, modify the user that you want to see the query text, not the user who executed the query (if those are different users). For more information, check UNREDACTEDQUERYSYNTAXERROR docsENABLE. - error
On booleanNondeterministic Merge - Specifies whether to return an error when the MERGE command is used to update or delete a target row that joins multiple source rows and the system cannot determine the action to perform on the target row. For more information, check ERRORONNONDETERMINISTIC_MERGE docs.
- error
On booleanNondeterministic Update - Specifies whether to return an error when the UPDATE command is used to update a target row that joins multiple source rows and the system cannot determine the action to perform on the target row. For more information, check ERRORONNONDETERMINISTIC_UPDATE docs.
- fully
Qualified stringName - Fully qualified name of the resource. For more information, see object name resolution.
- geography
Output stringFormat - Display format for GEOGRAPHY values. For more information, check GEOGRAPHYOUTPUTFORMAT docs.
- geometry
Output stringFormat - Display format for GEOMETRY values. For more information, check GEOMETRYOUTPUTFORMAT docs.
- jdbc
Treat booleanDecimal As Int - Specifies how JDBC processes columns that have a scale of zero (0). For more information, check JDBCTREATDECIMALASINT docs.
- jdbc
Treat booleanTimestamp Ntz As Utc - Specifies how JDBC processes TIMESTAMPNTZ values. For more information, check TREATTIMESTAMPNTZASUTC docsJDBC.
- jdbc
Use booleanSession Timezone - Specifies whether the JDBC Driver uses the time zone of the JVM or the time zone of the session (specified by the TIMEZONE parameter) for the getDate(), getTime(), and getTimestamp() methods of the ResultSet class. For more information, check JDBCUSESESSION_TIMEZONE docs.
- json
Indent number - Specifies the number of blank spaces to indent each new element in JSON output in the session. Also specifies whether to insert newline characters after each element. For more information, check JSON_INDENT docs.
- lock
Timeout number - Number of seconds to wait while trying to lock a resource, before timing out and aborting the statement. For more information, check LOCK_TIMEOUT docs.
- log
Level string - Specifies the severity level of messages that should be ingested and made available in the active event table. Messages at the specified level (and at more severe levels) are ingested. For more information about log levels, see Setting log level. For more information, check LOG_LEVEL docs.
- login
Name string - The name users use to log in. If not supplied, snowflake will use name instead. Login names are always case-insensitive.
- mins
To numberUnlock - multi
Statement numberCount - Number of statements to execute when using the multi-statement capability. For more information, check MULTISTATEMENTCOUNT docs.
- must
Change stringPassword - Specifies whether the user is forced to change their password on next login (including their first/initial login) into the system. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
- name string
- Name of the user. Note that if you do not supply loginname this will be used as loginname. Check the docs. Due to technical limitations (read more here), avoid using the following characters:
|
,.
,(
,)
,"
- network
Policy string - Specifies the network policy to enforce for your account. Network policies enable restricting access to your account based on users’ IP address. For more details, see Controlling network traffic with network policies. Any existing network policy (created using CREATE NETWORK POLICY). For more information, check NETWORK_POLICY docs.
- noorder
Sequence booleanAs Default - Specifies whether the ORDER or NOORDER property is set by default when you create a new sequence or add a new table column. The ORDER and NOORDER properties determine whether or not the values are generated for the sequence or auto-incremented column in increasing or decreasing order. For more information, check NOORDERSEQUENCEAS_DEFAULT docs.
- odbc
Treat booleanDecimal As Int - Specifies how ODBC processes columns that have a scale of zero (0). For more information, check ODBCTREATDECIMALASINT docs.
- parameters
Legacy
Service User Parameter[] - Outputs the result of
SHOW PARAMETERS IN USER
for the given user. - password string
- prevent
Unload booleanTo Internal Stages - Specifies whether to prevent data unload operations to internal (Snowflake) stages using COPY INTO \n\n statements. For more information, check PREVENTUNLOADTOINTERNALSTAGES docs.
- query
Tag string - Optional string that can be used to tag queries and other SQL statements executed within a session. The tags are displayed in the output of the QUERYHISTORY, QUERYHISTORY*BY** functions. For more information, check QUERY_TAG docs.
- quoted
Identifiers booleanIgnore Case - Specifies whether letters in double-quoted object identifiers are stored and resolved as uppercase letters. By default, Snowflake preserves the case of alphabetic characters when storing and resolving double-quoted identifiers (see Identifier resolution). You can use this parameter in situations in which third-party applications always use double quotes around identifiers. For more information, check QUOTEDIDENTIFIERSIGNORE_CASE docs.
- rows
Per numberResultset - Specifies the maximum number of rows returned in a result set. A value of 0 specifies no maximum. For more information, check ROWSPERRESULTSET docs.
- rsa
Public stringKey - Specifies the user’s RSA public key; used for key-pair authentication. Must be on 1 line without header and trailer.
- rsa
Public stringKey2 - Specifies the user’s second RSA public key; used to rotate the public and private keys for key-pair authentication based on an expiration schedule set by your organization. Must be on 1 line without header and trailer.
- s3Stage
Vpce stringDns Name - Specifies the DNS name of an Amazon S3 interface endpoint. Requests sent to the internal stage of an account via AWS PrivateLink for Amazon S3 use this endpoint to connect. For more information, see Accessing Internal stages with dedicated interface endpoints. For more information, check S3STAGEVPCEDNSNAME docs.
- search
Path string - Specifies the path to search to resolve unqualified object names in queries. For more information, see Name resolution in queries. Comma-separated list of identifiers. An identifier can be a fully or partially qualified schema name. For more information, check SEARCH_PATH docs.
- show
Outputs LegacyService User Show Output[] - Outputs the result of
SHOW USER
for the given user. - simulated
Data stringSharing Consumer - Specifies the name of a consumer account to simulate for testing/validating shared data, particularly shared secure views. When this parameter is set in a session, shared views return rows as if executed in the specified consumer account rather than the provider account. For more information, see Introduction to Secure Data Sharing and Working with shares. For more information, check SIMULATEDDATASHARING_CONSUMER docs.
- statement
Queued numberTimeout In Seconds - Amount of time, in seconds, a SQL statement (query, DDL, DML, etc.) remains queued for a warehouse before it is canceled by the system. This parameter can be used in conjunction with the MAXCONCURRENCYLEVEL parameter to ensure a warehouse is never backlogged. For more information, check STATEMENTQUEUEDTIMEOUTINSECONDS docs.
- statement
Timeout numberIn Seconds - Amount of time, in seconds, after which a running SQL statement (query, DDL, DML, etc.) is canceled by the system. For more information, check STATEMENTTIMEOUTIN_SECONDS docs.
- strict
Json booleanOutput - This parameter specifies whether JSON output in a session is compatible with the general standard (as described by http://json.org). By design, Snowflake allows JSON input that contains non-standard values; however, these non-standard values might result in Snowflake outputting JSON that is incompatible with other platforms and languages. This parameter, when enabled, ensures that Snowflake outputs valid/compatible JSON. For more information, check STRICTJSONOUTPUT docs.
- time
Input stringFormat - Specifies the input format for the TIME data type. For more information, see Date and time input and output formats. Any valid, supported time format or AUTO (AUTO specifies that Snowflake attempts to automatically detect the format of times stored in the system during the session). For more information, check TIMEINPUTFORMAT docs.
- time
Output stringFormat - Specifies the display format for the TIME data type. For more information, see Date and time input and output formats. For more information, check TIMEOUTPUTFORMAT docs.
- timestamp
Day booleanIs Always24h - Specifies whether the DATEADD function (and its aliases) always consider a day to be exactly 24 hours for expressions that span multiple days. For more information, check TIMESTAMPDAYISALWAYS24H docs.
- timestamp
Input stringFormat - Specifies the input format for the TIMESTAMP data type alias. For more information, see Date and time input and output formats. Any valid, supported timestamp format or AUTO (AUTO specifies that Snowflake attempts to automatically detect the format of timestamps stored in the system during the session). For more information, check TIMESTAMPINPUTFORMAT docs.
- timestamp
Ltz stringOutput Format - Specifies the display format for the TIMESTAMPLTZ data type. If no format is specified, defaults to OUTPUT*FORMATTIMESTAMP. For more information, see Date and time input and output formats. For more information, check TIMESTAMPLTZOUTPUT*FORMAT docs.
- timestamp
Ntz stringOutput Format - Specifies the display format for the TIMESTAMPNTZ data type. For more information, check NTZOUTPUTFORMAT docsTIMESTAMP.
- timestamp
Output stringFormat - Specifies the display format for the TIMESTAMP data type alias. For more information, see Date and time input and output formats. For more information, check TIMESTAMPOUTPUTFORMAT docs.
- timestamp
Type stringMapping - Specifies the TIMESTAMP** variation that the TIMESTAMP data type alias maps to. For more information, check TIMESTAMP*TYPE_MAPPING docs.
- timestamp
Tz stringOutput Format - Specifies the display format for the TIMESTAMPTZ data type. If no format is specified, defaults to OUTPUT*FORMATTIMESTAMP. For more information, see Date and time input and output formats. For more information, check TIMESTAMPTZOUTPUT*FORMAT docs.
- timezone string
- Specifies the time zone for the session. You can specify a time zone name or a link name from release 2021a of the IANA Time Zone Database (e.g. America/Los_Angeles, Europe/London, UTC, Etc/GMT, etc.). For more information, check TIMEZONE docs.
- trace
Level string - Controls how trace events are ingested into the event table. For more information about trace levels, see Setting trace level. For more information, check TRACE_LEVEL docs.
- transaction
Abort booleanOn Error - Specifies the action to perform when a statement issued within a non-autocommit transaction returns with an error. For more information, check TRANSACTIONABORTON_ERROR docs.
- transaction
Default stringIsolation Level - Specifies the isolation level for transactions in the user session. For more information, check TRANSACTIONDEFAULTISOLATION_LEVEL docs.
- two
Digit numberCentury Start - Specifies the “century start” year for 2-digit years (i.e. the earliest year such dates can represent). This parameter prevents ambiguous dates when importing or converting data with the
YY
date format component (i.e. years represented as 2 digits). For more information, check TWODIGITCENTURY_START docs. - unsupported
Ddl stringAction - Determines if an unsupported (i.e. non-default) value specified for a constraint property returns an error. For more information, check UNSUPPORTEDDDLACTION docs.
- use
Cached booleanResult - Specifies whether to reuse persisted query results, if available, when a matching query is submitted. For more information, check USECACHEDRESULT docs.
- user
Type string - Specifies a type for the user.
- week
Of numberYear Policy - Specifies how the weeks in a given year are computed.
0
: The semantics used are equivalent to the ISO semantics, in which a week belongs to a given year if at least 4 days of that week are in that year.1
: January 1 is included in the first week of the year and December 31 is included in the last week of the year. For more information, check WEEKOFYEAR_POLICY docs. - week
Start number - Specifies the first day of the week (used by week-related date functions).
0
: Legacy Snowflake behavior is used (i.e. ISO-like semantics).1
(Monday) to7
(Sunday): All the week-related functions use weeks that start on the specified day of the week. For more information, check WEEK_START docs.
- abort_
detached_ boolquery - Specifies the action that Snowflake performs for in-progress queries if connectivity is lost due to abrupt termination of a session (e.g. network outage, browser termination, service interruption). For more information, check ABORTDETACHEDQUERY docs.
- autocommit bool
- Specifies whether autocommit is enabled for the session. Autocommit determines whether a DML statement, when executed without an active transaction, is automatically committed after the statement successfully completes. For more information, see Transactions. For more information, check AUTOCOMMIT docs.
- binary_
input_ strformat - The format of VARCHAR values passed as input to VARCHAR-to-BINARY conversion functions. For more information, see Binary input and output. For more information, check BINARYINPUTFORMAT docs.
- binary_
output_ strformat - The format for VARCHAR values returned as output by BINARY-to-VARCHAR conversion functions. For more information, see Binary input and output. For more information, check BINARYOUTPUTFORMAT docs.
- client_
memory_ intlimit - Parameter that specifies the maximum amount of memory the JDBC driver or ODBC driver should use for the result set from queries (in MB). For more information, check CLIENTMEMORYLIMIT docs.
- client_
metadata_ boolrequest_ use_ connection_ ctx - For specific ODBC functions and JDBC methods, this parameter can change the default search scope from all databases/schemas to the current database/schema. The narrower search typically returns fewer rows and executes more quickly. For more information, check CLIENTMETADATAREQUESTUSECONNECTION_CTX docs.
- client_
prefetch_ intthreads - Parameter that specifies the number of threads used by the client to pre-fetch large result sets. The driver will attempt to honor the parameter value, but defines the minimum and maximum values (depending on your system’s resources) to improve performance. For more information, check CLIENTPREFETCHTHREADS docs.
- client_
result_ intchunk_ size - Parameter that specifies the maximum size of each set (or chunk) of query results to download (in MB). The JDBC driver downloads query results in chunks. For more information, check CLIENTRESULTCHUNK_SIZE docs.
- client_
result_ boolcolumn_ case_ insensitive - Parameter that indicates whether to match column name case-insensitively in ResultSet.get* methods in JDBC. For more information, check CLIENTRESULTCOLUMNCASEINSENSITIVE docs.
- client_
session_ boolkeep_ alive - Parameter that indicates whether to force a user to log in again after a period of inactivity in the session. For more information, check CLIENTSESSIONKEEP_ALIVE docs.
- client_
session_ intkeep_ alive_ heartbeat_ frequency - Number of seconds in-between client attempts to update the token for the session. For more information, check CLIENTSESSIONKEEPALIVEHEARTBEAT_FREQUENCY docs.
- client_
timestamp_ strtype_ mapping - Specifies the TIMESTAMP_* variation to use when binding timestamp variables for JDBC or ODBC applications that use the bind API to load data. For more information, check CLIENTTIMESTAMPTYPE_MAPPING docs.
- comment str
- Specifies a comment for the user.
- date_
input_ strformat - Specifies the input format for the DATE data type. For more information, see Date and time input and output formats. For more information, check DATEINPUTFORMAT docs.
- date_
output_ strformat - Specifies the display format for the DATE data type. For more information, see Date and time input and output formats. For more information, check DATEOUTPUTFORMAT docs.
- days_
to_ intexpiry - default_
namespace str - Specifies the namespace (database only or database and schema) that is active by default for the user’s session upon login. Note that the CREATE USER operation does not verify that the namespace exists.
- default_
role str - Specifies the role that is active by default for the user’s session upon login. Note that specifying a default role for a user does not grant the role to the user. The role must be granted explicitly to the user using the GRANT ROLE command. In addition, the CREATE USER operation does not verify that the role exists.
- default_
secondary_ strroles_ option - Specifies the secondary roles that are active for the user’s session upon login. Valid values are (case-insensitive):
DEFAULT
|NONE
|ALL
. More information can be found in doc. - default_
warehouse str - Specifies the virtual warehouse that is active by default for the user’s session upon login. Note that the CREATE USER operation does not verify that the warehouse exists.
- disabled str
- Specifies whether the user is disabled, which prevents logging in and aborts all the currently-running queries for the user. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
- display_
name str - Name displayed for the user in the Snowflake web interface.
- email str
- Email address for the user.
- enable_
unload_ boolphysical_ type_ optimization - Specifies whether to set the schema for unloaded Parquet files based on the logical column data types (i.e. the types in the unload SQL query or source table) or on the unloaded column values (i.e. the smallest data types and precision that support the values in the output columns of the unload SQL statement or source table). For more information, check ENABLEUNLOADPHYSICALTYPEOPTIMIZATION docs.
- enable_
unredacted_ boolquery_ syntax_ error - Controls whether query text is redacted if a SQL query fails due to a syntax or parsing error. If
FALSE
, the content of a failed query is redacted in the views, pages, and functions that provide a query history. Only users with a role that is granted or inherits the AUDIT privilege can set the ENABLEUNREDACTEDQUERYSYNTAXERROR parameter. When using the ALTER USER command to set the parameter toTRUE
for a particular user, modify the user that you want to see the query text, not the user who executed the query (if those are different users). For more information, check UNREDACTEDQUERYSYNTAXERROR docsENABLE. - error_
on_ boolnondeterministic_ merge - Specifies whether to return an error when the MERGE command is used to update or delete a target row that joins multiple source rows and the system cannot determine the action to perform on the target row. For more information, check ERRORONNONDETERMINISTIC_MERGE docs.
- error_
on_ boolnondeterministic_ update - Specifies whether to return an error when the UPDATE command is used to update a target row that joins multiple source rows and the system cannot determine the action to perform on the target row. For more information, check ERRORONNONDETERMINISTIC_UPDATE docs.
- fully_
qualified_ strname - Fully qualified name of the resource. For more information, see object name resolution.
- geography_
output_ strformat - Display format for GEOGRAPHY values. For more information, check GEOGRAPHYOUTPUTFORMAT docs.
- geometry_
output_ strformat - Display format for GEOMETRY values. For more information, check GEOMETRYOUTPUTFORMAT docs.
- jdbc_
treat_ booldecimal_ as_ int - Specifies how JDBC processes columns that have a scale of zero (0). For more information, check JDBCTREATDECIMALASINT docs.
- jdbc_
treat_ booltimestamp_ ntz_ as_ utc - Specifies how JDBC processes TIMESTAMPNTZ values. For more information, check TREATTIMESTAMPNTZASUTC docsJDBC.
- jdbc_
use_ boolsession_ timezone - Specifies whether the JDBC Driver uses the time zone of the JVM or the time zone of the session (specified by the TIMEZONE parameter) for the getDate(), getTime(), and getTimestamp() methods of the ResultSet class. For more information, check JDBCUSESESSION_TIMEZONE docs.
- json_
indent int - Specifies the number of blank spaces to indent each new element in JSON output in the session. Also specifies whether to insert newline characters after each element. For more information, check JSON_INDENT docs.
- lock_
timeout int - Number of seconds to wait while trying to lock a resource, before timing out and aborting the statement. For more information, check LOCK_TIMEOUT docs.
- log_
level str - Specifies the severity level of messages that should be ingested and made available in the active event table. Messages at the specified level (and at more severe levels) are ingested. For more information about log levels, see Setting log level. For more information, check LOG_LEVEL docs.
- login_
name str - The name users use to log in. If not supplied, snowflake will use name instead. Login names are always case-insensitive.
- mins_
to_ intunlock - multi_
statement_ intcount - Number of statements to execute when using the multi-statement capability. For more information, check MULTISTATEMENTCOUNT docs.
- must_
change_ strpassword - Specifies whether the user is forced to change their password on next login (including their first/initial login) into the system. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
- name str
- Name of the user. Note that if you do not supply loginname this will be used as loginname. Check the docs. Due to technical limitations (read more here), avoid using the following characters:
|
,.
,(
,)
,"
- network_
policy str - Specifies the network policy to enforce for your account. Network policies enable restricting access to your account based on users’ IP address. For more details, see Controlling network traffic with network policies. Any existing network policy (created using CREATE NETWORK POLICY). For more information, check NETWORK_POLICY docs.
- noorder_
sequence_ boolas_ default - Specifies whether the ORDER or NOORDER property is set by default when you create a new sequence or add a new table column. The ORDER and NOORDER properties determine whether or not the values are generated for the sequence or auto-incremented column in increasing or decreasing order. For more information, check NOORDERSEQUENCEAS_DEFAULT docs.
- odbc_
treat_ booldecimal_ as_ int - Specifies how ODBC processes columns that have a scale of zero (0). For more information, check ODBCTREATDECIMALASINT docs.
- parameters
Sequence[Legacy
Service User Parameter Args] - Outputs the result of
SHOW PARAMETERS IN USER
for the given user. - password str
- prevent_
unload_ boolto_ internal_ stages - Specifies whether to prevent data unload operations to internal (Snowflake) stages using COPY INTO \n\n statements. For more information, check PREVENTUNLOADTOINTERNALSTAGES docs.
- query_
tag str - Optional string that can be used to tag queries and other SQL statements executed within a session. The tags are displayed in the output of the QUERYHISTORY, QUERYHISTORY*BY** functions. For more information, check QUERY_TAG docs.
- quoted_
identifiers_ boolignore_ case - Specifies whether letters in double-quoted object identifiers are stored and resolved as uppercase letters. By default, Snowflake preserves the case of alphabetic characters when storing and resolving double-quoted identifiers (see Identifier resolution). You can use this parameter in situations in which third-party applications always use double quotes around identifiers. For more information, check QUOTEDIDENTIFIERSIGNORE_CASE docs.
- rows_
per_ intresultset - Specifies the maximum number of rows returned in a result set. A value of 0 specifies no maximum. For more information, check ROWSPERRESULTSET docs.
- rsa_
public_ strkey - Specifies the user’s RSA public key; used for key-pair authentication. Must be on 1 line without header and trailer.
- rsa_
public_ strkey2 - Specifies the user’s second RSA public key; used to rotate the public and private keys for key-pair authentication based on an expiration schedule set by your organization. Must be on 1 line without header and trailer.
- s3_
stage_ strvpce_ dns_ name - Specifies the DNS name of an Amazon S3 interface endpoint. Requests sent to the internal stage of an account via AWS PrivateLink for Amazon S3 use this endpoint to connect. For more information, see Accessing Internal stages with dedicated interface endpoints. For more information, check S3STAGEVPCEDNSNAME docs.
- search_
path str - Specifies the path to search to resolve unqualified object names in queries. For more information, see Name resolution in queries. Comma-separated list of identifiers. An identifier can be a fully or partially qualified schema name. For more information, check SEARCH_PATH docs.
- show_
outputs Sequence[LegacyService User Show Output Args] - Outputs the result of
SHOW USER
for the given user. - simulated_
data_ strsharing_ consumer - Specifies the name of a consumer account to simulate for testing/validating shared data, particularly shared secure views. When this parameter is set in a session, shared views return rows as if executed in the specified consumer account rather than the provider account. For more information, see Introduction to Secure Data Sharing and Working with shares. For more information, check SIMULATEDDATASHARING_CONSUMER docs.
- statement_
queued_ inttimeout_ in_ seconds - Amount of time, in seconds, a SQL statement (query, DDL, DML, etc.) remains queued for a warehouse before it is canceled by the system. This parameter can be used in conjunction with the MAXCONCURRENCYLEVEL parameter to ensure a warehouse is never backlogged. For more information, check STATEMENTQUEUEDTIMEOUTINSECONDS docs.
- statement_
timeout_ intin_ seconds - Amount of time, in seconds, after which a running SQL statement (query, DDL, DML, etc.) is canceled by the system. For more information, check STATEMENTTIMEOUTIN_SECONDS docs.
- strict_
json_ booloutput - This parameter specifies whether JSON output in a session is compatible with the general standard (as described by http://json.org). By design, Snowflake allows JSON input that contains non-standard values; however, these non-standard values might result in Snowflake outputting JSON that is incompatible with other platforms and languages. This parameter, when enabled, ensures that Snowflake outputs valid/compatible JSON. For more information, check STRICTJSONOUTPUT docs.
- time_
input_ strformat - Specifies the input format for the TIME data type. For more information, see Date and time input and output formats. Any valid, supported time format or AUTO (AUTO specifies that Snowflake attempts to automatically detect the format of times stored in the system during the session). For more information, check TIMEINPUTFORMAT docs.
- time_
output_ strformat - Specifies the display format for the TIME data type. For more information, see Date and time input and output formats. For more information, check TIMEOUTPUTFORMAT docs.
- timestamp_
day_ boolis_ always24h - Specifies whether the DATEADD function (and its aliases) always consider a day to be exactly 24 hours for expressions that span multiple days. For more information, check TIMESTAMPDAYISALWAYS24H docs.
- timestamp_
input_ strformat - Specifies the input format for the TIMESTAMP data type alias. For more information, see Date and time input and output formats. Any valid, supported timestamp format or AUTO (AUTO specifies that Snowflake attempts to automatically detect the format of timestamps stored in the system during the session). For more information, check TIMESTAMPINPUTFORMAT docs.
- timestamp_
ltz_ stroutput_ format - Specifies the display format for the TIMESTAMPLTZ data type. If no format is specified, defaults to OUTPUT*FORMATTIMESTAMP. For more information, see Date and time input and output formats. For more information, check TIMESTAMPLTZOUTPUT*FORMAT docs.
- timestamp_
ntz_ stroutput_ format - Specifies the display format for the TIMESTAMPNTZ data type. For more information, check NTZOUTPUTFORMAT docsTIMESTAMP.
- timestamp_
output_ strformat - Specifies the display format for the TIMESTAMP data type alias. For more information, see Date and time input and output formats. For more information, check TIMESTAMPOUTPUTFORMAT docs.
- timestamp_
type_ strmapping - Specifies the TIMESTAMP** variation that the TIMESTAMP data type alias maps to. For more information, check TIMESTAMP*TYPE_MAPPING docs.
- timestamp_
tz_ stroutput_ format - Specifies the display format for the TIMESTAMPTZ data type. If no format is specified, defaults to OUTPUT*FORMATTIMESTAMP. For more information, see Date and time input and output formats. For more information, check TIMESTAMPTZOUTPUT*FORMAT docs.
- timezone str
- Specifies the time zone for the session. You can specify a time zone name or a link name from release 2021a of the IANA Time Zone Database (e.g. America/Los_Angeles, Europe/London, UTC, Etc/GMT, etc.). For more information, check TIMEZONE docs.
- trace_
level str - Controls how trace events are ingested into the event table. For more information about trace levels, see Setting trace level. For more information, check TRACE_LEVEL docs.
- transaction_
abort_ boolon_ error - Specifies the action to perform when a statement issued within a non-autocommit transaction returns with an error. For more information, check TRANSACTIONABORTON_ERROR docs.
- transaction_
default_ strisolation_ level - Specifies the isolation level for transactions in the user session. For more information, check TRANSACTIONDEFAULTISOLATION_LEVEL docs.
- two_
digit_ intcentury_ start - Specifies the “century start” year for 2-digit years (i.e. the earliest year such dates can represent). This parameter prevents ambiguous dates when importing or converting data with the
YY
date format component (i.e. years represented as 2 digits). For more information, check TWODIGITCENTURY_START docs. - unsupported_
ddl_ straction - Determines if an unsupported (i.e. non-default) value specified for a constraint property returns an error. For more information, check UNSUPPORTEDDDLACTION docs.
- use_
cached_ boolresult - Specifies whether to reuse persisted query results, if available, when a matching query is submitted. For more information, check USECACHEDRESULT docs.
- user_
type str - Specifies a type for the user.
- week_
of_ intyear_ policy - Specifies how the weeks in a given year are computed.
0
: The semantics used are equivalent to the ISO semantics, in which a week belongs to a given year if at least 4 days of that week are in that year.1
: January 1 is included in the first week of the year and December 31 is included in the last week of the year. For more information, check WEEKOFYEAR_POLICY docs. - week_
start int - Specifies the first day of the week (used by week-related date functions).
0
: Legacy Snowflake behavior is used (i.e. ISO-like semantics).1
(Monday) to7
(Sunday): All the week-related functions use weeks that start on the specified day of the week. For more information, check WEEK_START docs.
- abort
Detached BooleanQuery - Specifies the action that Snowflake performs for in-progress queries if connectivity is lost due to abrupt termination of a session (e.g. network outage, browser termination, service interruption). For more information, check ABORTDETACHEDQUERY docs.
- autocommit Boolean
- Specifies whether autocommit is enabled for the session. Autocommit determines whether a DML statement, when executed without an active transaction, is automatically committed after the statement successfully completes. For more information, see Transactions. For more information, check AUTOCOMMIT docs.
- binary
Input StringFormat - The format of VARCHAR values passed as input to VARCHAR-to-BINARY conversion functions. For more information, see Binary input and output. For more information, check BINARYINPUTFORMAT docs.
- binary
Output StringFormat - The format for VARCHAR values returned as output by BINARY-to-VARCHAR conversion functions. For more information, see Binary input and output. For more information, check BINARYOUTPUTFORMAT docs.
- client
Memory NumberLimit - Parameter that specifies the maximum amount of memory the JDBC driver or ODBC driver should use for the result set from queries (in MB). For more information, check CLIENTMEMORYLIMIT docs.
- client
Metadata BooleanRequest Use Connection Ctx - For specific ODBC functions and JDBC methods, this parameter can change the default search scope from all databases/schemas to the current database/schema. The narrower search typically returns fewer rows and executes more quickly. For more information, check CLIENTMETADATAREQUESTUSECONNECTION_CTX docs.
- client
Prefetch NumberThreads - Parameter that specifies the number of threads used by the client to pre-fetch large result sets. The driver will attempt to honor the parameter value, but defines the minimum and maximum values (depending on your system’s resources) to improve performance. For more information, check CLIENTPREFETCHTHREADS docs.
- client
Result NumberChunk Size - Parameter that specifies the maximum size of each set (or chunk) of query results to download (in MB). The JDBC driver downloads query results in chunks. For more information, check CLIENTRESULTCHUNK_SIZE docs.
- client
Result BooleanColumn Case Insensitive - Parameter that indicates whether to match column name case-insensitively in ResultSet.get* methods in JDBC. For more information, check CLIENTRESULTCOLUMNCASEINSENSITIVE docs.
- client
Session BooleanKeep Alive - Parameter that indicates whether to force a user to log in again after a period of inactivity in the session. For more information, check CLIENTSESSIONKEEP_ALIVE docs.
- client
Session NumberKeep Alive Heartbeat Frequency - Number of seconds in-between client attempts to update the token for the session. For more information, check CLIENTSESSIONKEEPALIVEHEARTBEAT_FREQUENCY docs.
- client
Timestamp StringType Mapping - Specifies the TIMESTAMP_* variation to use when binding timestamp variables for JDBC or ODBC applications that use the bind API to load data. For more information, check CLIENTTIMESTAMPTYPE_MAPPING docs.
- comment String
- Specifies a comment for the user.
- date
Input StringFormat - Specifies the input format for the DATE data type. For more information, see Date and time input and output formats. For more information, check DATEINPUTFORMAT docs.
- date
Output StringFormat - Specifies the display format for the DATE data type. For more information, see Date and time input and output formats. For more information, check DATEOUTPUTFORMAT docs.
- days
To NumberExpiry - default
Namespace String - Specifies the namespace (database only or database and schema) that is active by default for the user’s session upon login. Note that the CREATE USER operation does not verify that the namespace exists.
- default
Role String - Specifies the role that is active by default for the user’s session upon login. Note that specifying a default role for a user does not grant the role to the user. The role must be granted explicitly to the user using the GRANT ROLE command. In addition, the CREATE USER operation does not verify that the role exists.
- default
Secondary StringRoles Option - Specifies the secondary roles that are active for the user’s session upon login. Valid values are (case-insensitive):
DEFAULT
|NONE
|ALL
. More information can be found in doc. - default
Warehouse String - Specifies the virtual warehouse that is active by default for the user’s session upon login. Note that the CREATE USER operation does not verify that the warehouse exists.
- disabled String
- Specifies whether the user is disabled, which prevents logging in and aborts all the currently-running queries for the user. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
- display
Name String - Name displayed for the user in the Snowflake web interface.
- email String
- Email address for the user.
- enable
Unload BooleanPhysical Type Optimization - Specifies whether to set the schema for unloaded Parquet files based on the logical column data types (i.e. the types in the unload SQL query or source table) or on the unloaded column values (i.e. the smallest data types and precision that support the values in the output columns of the unload SQL statement or source table). For more information, check ENABLEUNLOADPHYSICALTYPEOPTIMIZATION docs.
- enable
Unredacted BooleanQuery Syntax Error - Controls whether query text is redacted if a SQL query fails due to a syntax or parsing error. If
FALSE
, the content of a failed query is redacted in the views, pages, and functions that provide a query history. Only users with a role that is granted or inherits the AUDIT privilege can set the ENABLEUNREDACTEDQUERYSYNTAXERROR parameter. When using the ALTER USER command to set the parameter toTRUE
for a particular user, modify the user that you want to see the query text, not the user who executed the query (if those are different users). For more information, check UNREDACTEDQUERYSYNTAXERROR docsENABLE. - error
On BooleanNondeterministic Merge - Specifies whether to return an error when the MERGE command is used to update or delete a target row that joins multiple source rows and the system cannot determine the action to perform on the target row. For more information, check ERRORONNONDETERMINISTIC_MERGE docs.
- error
On BooleanNondeterministic Update - Specifies whether to return an error when the UPDATE command is used to update a target row that joins multiple source rows and the system cannot determine the action to perform on the target row. For more information, check ERRORONNONDETERMINISTIC_UPDATE docs.
- fully
Qualified StringName - Fully qualified name of the resource. For more information, see object name resolution.
- geography
Output StringFormat - Display format for GEOGRAPHY values. For more information, check GEOGRAPHYOUTPUTFORMAT docs.
- geometry
Output StringFormat - Display format for GEOMETRY values. For more information, check GEOMETRYOUTPUTFORMAT docs.
- jdbc
Treat BooleanDecimal As Int - Specifies how JDBC processes columns that have a scale of zero (0). For more information, check JDBCTREATDECIMALASINT docs.
- jdbc
Treat BooleanTimestamp Ntz As Utc - Specifies how JDBC processes TIMESTAMPNTZ values. For more information, check TREATTIMESTAMPNTZASUTC docsJDBC.
- jdbc
Use BooleanSession Timezone - Specifies whether the JDBC Driver uses the time zone of the JVM or the time zone of the session (specified by the TIMEZONE parameter) for the getDate(), getTime(), and getTimestamp() methods of the ResultSet class. For more information, check JDBCUSESESSION_TIMEZONE docs.
- json
Indent Number - Specifies the number of blank spaces to indent each new element in JSON output in the session. Also specifies whether to insert newline characters after each element. For more information, check JSON_INDENT docs.
- lock
Timeout Number - Number of seconds to wait while trying to lock a resource, before timing out and aborting the statement. For more information, check LOCK_TIMEOUT docs.
- log
Level String - Specifies the severity level of messages that should be ingested and made available in the active event table. Messages at the specified level (and at more severe levels) are ingested. For more information about log levels, see Setting log level. For more information, check LOG_LEVEL docs.
- login
Name String - The name users use to log in. If not supplied, snowflake will use name instead. Login names are always case-insensitive.
- mins
To NumberUnlock - multi
Statement NumberCount - Number of statements to execute when using the multi-statement capability. For more information, check MULTISTATEMENTCOUNT docs.
- must
Change StringPassword - Specifies whether the user is forced to change their password on next login (including their first/initial login) into the system. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
- name String
- Name of the user. Note that if you do not supply loginname this will be used as loginname. Check the docs. Due to technical limitations (read more here), avoid using the following characters:
|
,.
,(
,)
,"
- network
Policy String - Specifies the network policy to enforce for your account. Network policies enable restricting access to your account based on users’ IP address. For more details, see Controlling network traffic with network policies. Any existing network policy (created using CREATE NETWORK POLICY). For more information, check NETWORK_POLICY docs.
- noorder
Sequence BooleanAs Default - Specifies whether the ORDER or NOORDER property is set by default when you create a new sequence or add a new table column. The ORDER and NOORDER properties determine whether or not the values are generated for the sequence or auto-incremented column in increasing or decreasing order. For more information, check NOORDERSEQUENCEAS_DEFAULT docs.
- odbc
Treat BooleanDecimal As Int - Specifies how ODBC processes columns that have a scale of zero (0). For more information, check ODBCTREATDECIMALASINT docs.
- parameters List<Property Map>
- Outputs the result of
SHOW PARAMETERS IN USER
for the given user. - password String
- prevent
Unload BooleanTo Internal Stages - Specifies whether to prevent data unload operations to internal (Snowflake) stages using COPY INTO \n\n statements. For more information, check PREVENTUNLOADTOINTERNALSTAGES docs.
- query
Tag String - Optional string that can be used to tag queries and other SQL statements executed within a session. The tags are displayed in the output of the QUERYHISTORY, QUERYHISTORY*BY** functions. For more information, check QUERY_TAG docs.
- quoted
Identifiers BooleanIgnore Case - Specifies whether letters in double-quoted object identifiers are stored and resolved as uppercase letters. By default, Snowflake preserves the case of alphabetic characters when storing and resolving double-quoted identifiers (see Identifier resolution). You can use this parameter in situations in which third-party applications always use double quotes around identifiers. For more information, check QUOTEDIDENTIFIERSIGNORE_CASE docs.
- rows
Per NumberResultset - Specifies the maximum number of rows returned in a result set. A value of 0 specifies no maximum. For more information, check ROWSPERRESULTSET docs.
- rsa
Public StringKey - Specifies the user’s RSA public key; used for key-pair authentication. Must be on 1 line without header and trailer.
- rsa
Public StringKey2 - Specifies the user’s second RSA public key; used to rotate the public and private keys for key-pair authentication based on an expiration schedule set by your organization. Must be on 1 line without header and trailer.
- s3Stage
Vpce StringDns Name - Specifies the DNS name of an Amazon S3 interface endpoint. Requests sent to the internal stage of an account via AWS PrivateLink for Amazon S3 use this endpoint to connect. For more information, see Accessing Internal stages with dedicated interface endpoints. For more information, check S3STAGEVPCEDNSNAME docs.
- search
Path String - Specifies the path to search to resolve unqualified object names in queries. For more information, see Name resolution in queries. Comma-separated list of identifiers. An identifier can be a fully or partially qualified schema name. For more information, check SEARCH_PATH docs.
- show
Outputs List<Property Map> - Outputs the result of
SHOW USER
for the given user. - simulated
Data StringSharing Consumer - Specifies the name of a consumer account to simulate for testing/validating shared data, particularly shared secure views. When this parameter is set in a session, shared views return rows as if executed in the specified consumer account rather than the provider account. For more information, see Introduction to Secure Data Sharing and Working with shares. For more information, check SIMULATEDDATASHARING_CONSUMER docs.
- statement
Queued NumberTimeout In Seconds - Amount of time, in seconds, a SQL statement (query, DDL, DML, etc.) remains queued for a warehouse before it is canceled by the system. This parameter can be used in conjunction with the MAXCONCURRENCYLEVEL parameter to ensure a warehouse is never backlogged. For more information, check STATEMENTQUEUEDTIMEOUTINSECONDS docs.
- statement
Timeout NumberIn Seconds - Amount of time, in seconds, after which a running SQL statement (query, DDL, DML, etc.) is canceled by the system. For more information, check STATEMENTTIMEOUTIN_SECONDS docs.
- strict
Json BooleanOutput - This parameter specifies whether JSON output in a session is compatible with the general standard (as described by http://json.org). By design, Snowflake allows JSON input that contains non-standard values; however, these non-standard values might result in Snowflake outputting JSON that is incompatible with other platforms and languages. This parameter, when enabled, ensures that Snowflake outputs valid/compatible JSON. For more information, check STRICTJSONOUTPUT docs.
- time
Input StringFormat - Specifies the input format for the TIME data type. For more information, see Date and time input and output formats. Any valid, supported time format or AUTO (AUTO specifies that Snowflake attempts to automatically detect the format of times stored in the system during the session). For more information, check TIMEINPUTFORMAT docs.
- time
Output StringFormat - Specifies the display format for the TIME data type. For more information, see Date and time input and output formats. For more information, check TIMEOUTPUTFORMAT docs.
- timestamp
Day BooleanIs Always24h - Specifies whether the DATEADD function (and its aliases) always consider a day to be exactly 24 hours for expressions that span multiple days. For more information, check TIMESTAMPDAYISALWAYS24H docs.
- timestamp
Input StringFormat - Specifies the input format for the TIMESTAMP data type alias. For more information, see Date and time input and output formats. Any valid, supported timestamp format or AUTO (AUTO specifies that Snowflake attempts to automatically detect the format of timestamps stored in the system during the session). For more information, check TIMESTAMPINPUTFORMAT docs.
- timestamp
Ltz StringOutput Format - Specifies the display format for the TIMESTAMPLTZ data type. If no format is specified, defaults to OUTPUT*FORMATTIMESTAMP. For more information, see Date and time input and output formats. For more information, check TIMESTAMPLTZOUTPUT*FORMAT docs.
- timestamp
Ntz StringOutput Format - Specifies the display format for the TIMESTAMPNTZ data type. For more information, check NTZOUTPUTFORMAT docsTIMESTAMP.
- timestamp
Output StringFormat - Specifies the display format for the TIMESTAMP data type alias. For more information, see Date and time input and output formats. For more information, check TIMESTAMPOUTPUTFORMAT docs.
- timestamp
Type StringMapping - Specifies the TIMESTAMP** variation that the TIMESTAMP data type alias maps to. For more information, check TIMESTAMP*TYPE_MAPPING docs.
- timestamp
Tz StringOutput Format - Specifies the display format for the TIMESTAMPTZ data type. If no format is specified, defaults to OUTPUT*FORMATTIMESTAMP. For more information, see Date and time input and output formats. For more information, check TIMESTAMPTZOUTPUT*FORMAT docs.
- timezone String
- Specifies the time zone for the session. You can specify a time zone name or a link name from release 2021a of the IANA Time Zone Database (e.g. America/Los_Angeles, Europe/London, UTC, Etc/GMT, etc.). For more information, check TIMEZONE docs.
- trace
Level String - Controls how trace events are ingested into the event table. For more information about trace levels, see Setting trace level. For more information, check TRACE_LEVEL docs.
- transaction
Abort BooleanOn Error - Specifies the action to perform when a statement issued within a non-autocommit transaction returns with an error. For more information, check TRANSACTIONABORTON_ERROR docs.
- transaction
Default StringIsolation Level - Specifies the isolation level for transactions in the user session. For more information, check TRANSACTIONDEFAULTISOLATION_LEVEL docs.
- two
Digit NumberCentury Start - Specifies the “century start” year for 2-digit years (i.e. the earliest year such dates can represent). This parameter prevents ambiguous dates when importing or converting data with the
YY
date format component (i.e. years represented as 2 digits). For more information, check TWODIGITCENTURY_START docs. - unsupported
Ddl StringAction - Determines if an unsupported (i.e. non-default) value specified for a constraint property returns an error. For more information, check UNSUPPORTEDDDLACTION docs.
- use
Cached BooleanResult - Specifies whether to reuse persisted query results, if available, when a matching query is submitted. For more information, check USECACHEDRESULT docs.
- user
Type String - Specifies a type for the user.
- week
Of NumberYear Policy - Specifies how the weeks in a given year are computed.
0
: The semantics used are equivalent to the ISO semantics, in which a week belongs to a given year if at least 4 days of that week are in that year.1
: January 1 is included in the first week of the year and December 31 is included in the last week of the year. For more information, check WEEKOFYEAR_POLICY docs. - week
Start Number - Specifies the first day of the week (used by week-related date functions).
0
: Legacy Snowflake behavior is used (i.e. ISO-like semantics).1
(Monday) to7
(Sunday): All the week-related functions use weeks that start on the specified day of the week. For more information, check WEEK_START docs.
Supporting Types
LegacyServiceUserParameter, LegacyServiceUserParameterArgs
- Abort
Detached List<LegacyQueries Service User Parameter Abort Detached Query> - Autocommits
List<Legacy
Service User Parameter Autocommit> - Binary
Input List<LegacyFormats Service User Parameter Binary Input Format> - Binary
Output List<LegacyFormats Service User Parameter Binary Output Format> - Client
Memory List<LegacyLimits Service User Parameter Client Memory Limit> - Client
Metadata List<LegacyRequest Use Connection Ctxes Service User Parameter Client Metadata Request Use Connection Ctx> - Client
Prefetch List<LegacyThreads Service User Parameter Client Prefetch Thread> - Client
Result List<LegacyChunk Sizes Service User Parameter Client Result Chunk Size> - Client
Result List<LegacyColumn Case Insensitives Service User Parameter Client Result Column Case Insensitive> - Client
Session List<LegacyKeep Alive Heartbeat Frequencies Service User Parameter Client Session Keep Alive Heartbeat Frequency> - Client
Session List<LegacyKeep Alives Service User Parameter Client Session Keep Alife> - Client
Timestamp List<LegacyType Mappings Service User Parameter Client Timestamp Type Mapping> - Date
Input List<LegacyFormats Service User Parameter Date Input Format> - Date
Output List<LegacyFormats Service User Parameter Date Output Format> - Enable
Unload List<LegacyPhysical Type Optimizations Service User Parameter Enable Unload Physical Type Optimization> - Enable
Unredacted List<LegacyQuery Syntax Errors Service User Parameter Enable Unredacted Query Syntax Error> - Error
On List<LegacyNondeterministic Merges Service User Parameter Error On Nondeterministic Merge> - Error
On List<LegacyNondeterministic Updates Service User Parameter Error On Nondeterministic Update> - Geography
Output List<LegacyFormats Service User Parameter Geography Output Format> - Geometry
Output List<LegacyFormats Service User Parameter Geometry Output Format> - Jdbc
Treat List<LegacyDecimal As Ints Service User Parameter Jdbc Treat Decimal As Int> - Jdbc
Treat List<LegacyTimestamp Ntz As Utcs Service User Parameter Jdbc Treat Timestamp Ntz As Utc> - Jdbc
Use List<LegacySession Timezones Service User Parameter Jdbc Use Session Timezone> - Json
Indents List<LegacyService User Parameter Json Indent> - Lock
Timeouts List<LegacyService User Parameter Lock Timeout> - Log
Levels List<LegacyService User Parameter Log Level> - Multi
Statement List<LegacyCounts Service User Parameter Multi Statement Count> - Network
Policies List<LegacyService User Parameter Network Policy> - Noorder
Sequence List<LegacyAs Defaults Service User Parameter Noorder Sequence As Default> - Odbc
Treat List<LegacyDecimal As Ints Service User Parameter Odbc Treat Decimal As Int> - Prevent
Unload List<LegacyTo Internal Stages Service User Parameter Prevent Unload To Internal Stage> - List<Legacy
Service User Parameter Query Tag> - Quoted
Identifiers List<LegacyIgnore Cases Service User Parameter Quoted Identifiers Ignore Case> - Rows
Per List<LegacyResultsets Service User Parameter Rows Per Resultset> - S3Stage
Vpce List<LegacyDns Names Service User Parameter S3Stage Vpce Dns Name> - Search
Paths List<LegacyService User Parameter Search Path> - Simulated
Data List<LegacySharing Consumers Service User Parameter Simulated Data Sharing Consumer> - Statement
Queued List<LegacyTimeout In Seconds Service User Parameter Statement Queued Timeout In Second> - Statement
Timeout List<LegacyIn Seconds Service User Parameter Statement Timeout In Second> - Strict
Json List<LegacyOutputs Service User Parameter Strict Json Output> - Time
Input List<LegacyFormats Service User Parameter Time Input Format> - Time
Output List<LegacyFormats Service User Parameter Time Output Format> - Timestamp
Day List<LegacyIs Always24hs Service User Parameter Timestamp Day Is Always24h> - Timestamp
Input List<LegacyFormats Service User Parameter Timestamp Input Format> - Timestamp
Ltz List<LegacyOutput Formats Service User Parameter Timestamp Ltz Output Format> - Timestamp
Ntz List<LegacyOutput Formats Service User Parameter Timestamp Ntz Output Format> - Timestamp
Output List<LegacyFormats Service User Parameter Timestamp Output Format> - Timestamp
Type List<LegacyMappings Service User Parameter Timestamp Type Mapping> - Timestamp
Tz List<LegacyOutput Formats Service User Parameter Timestamp Tz Output Format> - Timezones
List<Legacy
Service User Parameter Timezone> - Trace
Levels List<LegacyService User Parameter Trace Level> - Transaction
Abort List<LegacyOn Errors Service User Parameter Transaction Abort On Error> - Transaction
Default List<LegacyIsolation Levels Service User Parameter Transaction Default Isolation Level> - Two
Digit List<LegacyCentury Starts Service User Parameter Two Digit Century Start> - Unsupported
Ddl List<LegacyActions Service User Parameter Unsupported Ddl Action> - Use
Cached List<LegacyResults Service User Parameter Use Cached Result> - Week
Of List<LegacyYear Policies Service User Parameter Week Of Year Policy> - Week
Starts List<LegacyService User Parameter Week Start>
- Abort
Detached []LegacyQueries Service User Parameter Abort Detached Query - Autocommits
[]Legacy
Service User Parameter Autocommit - Binary
Input []LegacyFormats Service User Parameter Binary Input Format - Binary
Output []LegacyFormats Service User Parameter Binary Output Format - Client
Memory []LegacyLimits Service User Parameter Client Memory Limit - Client
Metadata []LegacyRequest Use Connection Ctxes Service User Parameter Client Metadata Request Use Connection Ctx - Client
Prefetch []LegacyThreads Service User Parameter Client Prefetch Thread - Client
Result []LegacyChunk Sizes Service User Parameter Client Result Chunk Size - Client
Result []LegacyColumn Case Insensitives Service User Parameter Client Result Column Case Insensitive - Client
Session []LegacyKeep Alive Heartbeat Frequencies Service User Parameter Client Session Keep Alive Heartbeat Frequency - Client
Session []LegacyKeep Alives Service User Parameter Client Session Keep Alife - Client
Timestamp []LegacyType Mappings Service User Parameter Client Timestamp Type Mapping - Date
Input []LegacyFormats Service User Parameter Date Input Format - Date
Output []LegacyFormats Service User Parameter Date Output Format - Enable
Unload []LegacyPhysical Type Optimizations Service User Parameter Enable Unload Physical Type Optimization - Enable
Unredacted []LegacyQuery Syntax Errors Service User Parameter Enable Unredacted Query Syntax Error - Error
On []LegacyNondeterministic Merges Service User Parameter Error On Nondeterministic Merge - Error
On []LegacyNondeterministic Updates Service User Parameter Error On Nondeterministic Update - Geography
Output []LegacyFormats Service User Parameter Geography Output Format - Geometry
Output []LegacyFormats Service User Parameter Geometry Output Format - Jdbc
Treat []LegacyDecimal As Ints Service User Parameter Jdbc Treat Decimal As Int - Jdbc
Treat []LegacyTimestamp Ntz As Utcs Service User Parameter Jdbc Treat Timestamp Ntz As Utc - Jdbc
Use []LegacySession Timezones Service User Parameter Jdbc Use Session Timezone - Json
Indents []LegacyService User Parameter Json Indent - Lock
Timeouts []LegacyService User Parameter Lock Timeout - Log
Levels []LegacyService User Parameter Log Level - Multi
Statement []LegacyCounts Service User Parameter Multi Statement Count - Network
Policies []LegacyService User Parameter Network Policy - Noorder
Sequence []LegacyAs Defaults Service User Parameter Noorder Sequence As Default - Odbc
Treat []LegacyDecimal As Ints Service User Parameter Odbc Treat Decimal As Int - Prevent
Unload []LegacyTo Internal Stages Service User Parameter Prevent Unload To Internal Stage - []Legacy
Service User Parameter Query Tag - Quoted
Identifiers []LegacyIgnore Cases Service User Parameter Quoted Identifiers Ignore Case - Rows
Per []LegacyResultsets Service User Parameter Rows Per Resultset - S3Stage
Vpce []LegacyDns Names Service User Parameter S3Stage Vpce Dns Name - Search
Paths []LegacyService User Parameter Search Path - Simulated
Data []LegacySharing Consumers Service User Parameter Simulated Data Sharing Consumer - Statement
Queued []LegacyTimeout In Seconds Service User Parameter Statement Queued Timeout In Second - Statement
Timeout []LegacyIn Seconds Service User Parameter Statement Timeout In Second - Strict
Json []LegacyOutputs Service User Parameter Strict Json Output - Time
Input []LegacyFormats Service User Parameter Time Input Format - Time
Output []LegacyFormats Service User Parameter Time Output Format - Timestamp
Day []LegacyIs Always24hs Service User Parameter Timestamp Day Is Always24h - Timestamp
Input []LegacyFormats Service User Parameter Timestamp Input Format - Timestamp
Ltz []LegacyOutput Formats Service User Parameter Timestamp Ltz Output Format - Timestamp
Ntz []LegacyOutput Formats Service User Parameter Timestamp Ntz Output Format - Timestamp
Output []LegacyFormats Service User Parameter Timestamp Output Format - Timestamp
Type []LegacyMappings Service User Parameter Timestamp Type Mapping - Timestamp
Tz []LegacyOutput Formats Service User Parameter Timestamp Tz Output Format - Timezones
[]Legacy
Service User Parameter Timezone - Trace
Levels []LegacyService User Parameter Trace Level - Transaction
Abort []LegacyOn Errors Service User Parameter Transaction Abort On Error - Transaction
Default []LegacyIsolation Levels Service User Parameter Transaction Default Isolation Level - Two
Digit []LegacyCentury Starts Service User Parameter Two Digit Century Start - Unsupported
Ddl []LegacyActions Service User Parameter Unsupported Ddl Action - Use
Cached []LegacyResults Service User Parameter Use Cached Result - Week
Of []LegacyYear Policies Service User Parameter Week Of Year Policy - Week
Starts []LegacyService User Parameter Week Start
- abort
Detached List<LegacyQueries Service User Parameter Abort Detached Query> - autocommits
List<Legacy
Service User Parameter Autocommit> - binary
Input List<LegacyFormats Service User Parameter Binary Input Format> - binary
Output List<LegacyFormats Service User Parameter Binary Output Format> - client
Memory List<LegacyLimits Service User Parameter Client Memory Limit> - client
Metadata List<LegacyRequest Use Connection Ctxes Service User Parameter Client Metadata Request Use Connection Ctx> - client
Prefetch List<LegacyThreads Service User Parameter Client Prefetch Thread> - client
Result List<LegacyChunk Sizes Service User Parameter Client Result Chunk Size> - client
Result List<LegacyColumn Case Insensitives Service User Parameter Client Result Column Case Insensitive> - client
Session List<LegacyKeep Alive Heartbeat Frequencies Service User Parameter Client Session Keep Alive Heartbeat Frequency> - client
Session List<LegacyKeep Alives Service User Parameter Client Session Keep Alife> - client
Timestamp List<LegacyType Mappings Service User Parameter Client Timestamp Type Mapping> - date
Input List<LegacyFormats Service User Parameter Date Input Format> - date
Output List<LegacyFormats Service User Parameter Date Output Format> - enable
Unload List<LegacyPhysical Type Optimizations Service User Parameter Enable Unload Physical Type Optimization> - enable
Unredacted List<LegacyQuery Syntax Errors Service User Parameter Enable Unredacted Query Syntax Error> - error
On List<LegacyNondeterministic Merges Service User Parameter Error On Nondeterministic Merge> - error
On List<LegacyNondeterministic Updates Service User Parameter Error On Nondeterministic Update> - geography
Output List<LegacyFormats Service User Parameter Geography Output Format> - geometry
Output List<LegacyFormats Service User Parameter Geometry Output Format> - jdbc
Treat List<LegacyDecimal As Ints Service User Parameter Jdbc Treat Decimal As Int> - jdbc
Treat List<LegacyTimestamp Ntz As Utcs Service User Parameter Jdbc Treat Timestamp Ntz As Utc> - jdbc
Use List<LegacySession Timezones Service User Parameter Jdbc Use Session Timezone> - json
Indents List<LegacyService User Parameter Json Indent> - lock
Timeouts List<LegacyService User Parameter Lock Timeout> - log
Levels List<LegacyService User Parameter Log Level> - multi
Statement List<LegacyCounts Service User Parameter Multi Statement Count> - network
Policies List<LegacyService User Parameter Network Policy> - noorder
Sequence List<LegacyAs Defaults Service User Parameter Noorder Sequence As Default> - odbc
Treat List<LegacyDecimal As Ints Service User Parameter Odbc Treat Decimal As Int> - prevent
Unload List<LegacyTo Internal Stages Service User Parameter Prevent Unload To Internal Stage> - List<Legacy
Service User Parameter Query Tag> - quoted
Identifiers List<LegacyIgnore Cases Service User Parameter Quoted Identifiers Ignore Case> - rows
Per List<LegacyResultsets Service User Parameter Rows Per Resultset> - s3Stage
Vpce List<LegacyDns Names Service User Parameter S3Stage Vpce Dns Name> - search
Paths List<LegacyService User Parameter Search Path> - simulated
Data List<LegacySharing Consumers Service User Parameter Simulated Data Sharing Consumer> - statement
Queued List<LegacyTimeout In Seconds Service User Parameter Statement Queued Timeout In Second> - statement
Timeout List<LegacyIn Seconds Service User Parameter Statement Timeout In Second> - strict
Json List<LegacyOutputs Service User Parameter Strict Json Output> - time
Input List<LegacyFormats Service User Parameter Time Input Format> - time
Output List<LegacyFormats Service User Parameter Time Output Format> - timestamp
Day List<LegacyIs Always24hs Service User Parameter Timestamp Day Is Always24h> - timestamp
Input List<LegacyFormats Service User Parameter Timestamp Input Format> - timestamp
Ltz List<LegacyOutput Formats Service User Parameter Timestamp Ltz Output Format> - timestamp
Ntz List<LegacyOutput Formats Service User Parameter Timestamp Ntz Output Format> - timestamp
Output List<LegacyFormats Service User Parameter Timestamp Output Format> - timestamp
Type List<LegacyMappings Service User Parameter Timestamp Type Mapping> - timestamp
Tz List<LegacyOutput Formats Service User Parameter Timestamp Tz Output Format> - timezones
List<Legacy
Service User Parameter Timezone> - trace
Levels List<LegacyService User Parameter Trace Level> - transaction
Abort List<LegacyOn Errors Service User Parameter Transaction Abort On Error> - transaction
Default List<LegacyIsolation Levels Service User Parameter Transaction Default Isolation Level> - two
Digit List<LegacyCentury Starts Service User Parameter Two Digit Century Start> - unsupported
Ddl List<LegacyActions Service User Parameter Unsupported Ddl Action> - use
Cached List<LegacyResults Service User Parameter Use Cached Result> - week
Of List<LegacyYear Policies Service User Parameter Week Of Year Policy> - week
Starts List<LegacyService User Parameter Week Start>
- abort
Detached LegacyQueries Service User Parameter Abort Detached Query[] - autocommits
Legacy
Service User Parameter Autocommit[] - binary
Input LegacyFormats Service User Parameter Binary Input Format[] - binary
Output LegacyFormats Service User Parameter Binary Output Format[] - client
Memory LegacyLimits Service User Parameter Client Memory Limit[] - client
Metadata LegacyRequest Use Connection Ctxes Service User Parameter Client Metadata Request Use Connection Ctx[] - client
Prefetch LegacyThreads Service User Parameter Client Prefetch Thread[] - client
Result LegacyChunk Sizes Service User Parameter Client Result Chunk Size[] - client
Result LegacyColumn Case Insensitives Service User Parameter Client Result Column Case Insensitive[] - client
Session LegacyKeep Alive Heartbeat Frequencies Service User Parameter Client Session Keep Alive Heartbeat Frequency[] - client
Session LegacyKeep Alives Service User Parameter Client Session Keep Alife[] - client
Timestamp LegacyType Mappings Service User Parameter Client Timestamp Type Mapping[] - date
Input LegacyFormats Service User Parameter Date Input Format[] - date
Output LegacyFormats Service User Parameter Date Output Format[] - enable
Unload LegacyPhysical Type Optimizations Service User Parameter Enable Unload Physical Type Optimization[] - enable
Unredacted LegacyQuery Syntax Errors Service User Parameter Enable Unredacted Query Syntax Error[] - error
On LegacyNondeterministic Merges Service User Parameter Error On Nondeterministic Merge[] - error
On LegacyNondeterministic Updates Service User Parameter Error On Nondeterministic Update[] - geography
Output LegacyFormats Service User Parameter Geography Output Format[] - geometry
Output LegacyFormats Service User Parameter Geometry Output Format[] - jdbc
Treat LegacyDecimal As Ints Service User Parameter Jdbc Treat Decimal As Int[] - jdbc
Treat LegacyTimestamp Ntz As Utcs Service User Parameter Jdbc Treat Timestamp Ntz As Utc[] - jdbc
Use LegacySession Timezones Service User Parameter Jdbc Use Session Timezone[] - json
Indents LegacyService User Parameter Json Indent[] - lock
Timeouts LegacyService User Parameter Lock Timeout[] - log
Levels LegacyService User Parameter Log Level[] - multi
Statement LegacyCounts Service User Parameter Multi Statement Count[] - network
Policies LegacyService User Parameter Network Policy[] - noorder
Sequence LegacyAs Defaults Service User Parameter Noorder Sequence As Default[] - odbc
Treat LegacyDecimal As Ints Service User Parameter Odbc Treat Decimal As Int[] - prevent
Unload LegacyTo Internal Stages Service User Parameter Prevent Unload To Internal Stage[] - Legacy
Service User Parameter Query Tag[] - quoted
Identifiers LegacyIgnore Cases Service User Parameter Quoted Identifiers Ignore Case[] - rows
Per LegacyResultsets Service User Parameter Rows Per Resultset[] - s3Stage
Vpce LegacyDns Names Service User Parameter S3Stage Vpce Dns Name[] - search
Paths LegacyService User Parameter Search Path[] - simulated
Data LegacySharing Consumers Service User Parameter Simulated Data Sharing Consumer[] - statement
Queued LegacyTimeout In Seconds Service User Parameter Statement Queued Timeout In Second[] - statement
Timeout LegacyIn Seconds Service User Parameter Statement Timeout In Second[] - strict
Json LegacyOutputs Service User Parameter Strict Json Output[] - time
Input LegacyFormats Service User Parameter Time Input Format[] - time
Output LegacyFormats Service User Parameter Time Output Format[] - timestamp
Day LegacyIs Always24hs Service User Parameter Timestamp Day Is Always24h[] - timestamp
Input LegacyFormats Service User Parameter Timestamp Input Format[] - timestamp
Ltz LegacyOutput Formats Service User Parameter Timestamp Ltz Output Format[] - timestamp
Ntz LegacyOutput Formats Service User Parameter Timestamp Ntz Output Format[] - timestamp
Output LegacyFormats Service User Parameter Timestamp Output Format[] - timestamp
Type LegacyMappings Service User Parameter Timestamp Type Mapping[] - timestamp
Tz LegacyOutput Formats Service User Parameter Timestamp Tz Output Format[] - timezones
Legacy
Service User Parameter Timezone[] - trace
Levels LegacyService User Parameter Trace Level[] - transaction
Abort LegacyOn Errors Service User Parameter Transaction Abort On Error[] - transaction
Default LegacyIsolation Levels Service User Parameter Transaction Default Isolation Level[] - two
Digit LegacyCentury Starts Service User Parameter Two Digit Century Start[] - unsupported
Ddl LegacyActions Service User Parameter Unsupported Ddl Action[] - use
Cached LegacyResults Service User Parameter Use Cached Result[] - week
Of LegacyYear Policies Service User Parameter Week Of Year Policy[] - week
Starts LegacyService User Parameter Week Start[]
- abort_
detached_ Sequence[Legacyqueries Service User Parameter Abort Detached Query] - autocommits
Sequence[Legacy
Service User Parameter Autocommit] - binary_
input_ Sequence[Legacyformats Service User Parameter Binary Input Format] - binary_
output_ Sequence[Legacyformats Service User Parameter Binary Output Format] - client_
memory_ Sequence[Legacylimits Service User Parameter Client Memory Limit] - client_
metadata_ Sequence[Legacyrequest_ use_ connection_ ctxes Service User Parameter Client Metadata Request Use Connection Ctx] - client_
prefetch_ Sequence[Legacythreads Service User Parameter Client Prefetch Thread] - client_
result_ Sequence[Legacychunk_ sizes Service User Parameter Client Result Chunk Size] - client_
result_ Sequence[Legacycolumn_ case_ insensitives Service User Parameter Client Result Column Case Insensitive] - client_
session_ Sequence[Legacykeep_ alive_ heartbeat_ frequencies Service User Parameter Client Session Keep Alive Heartbeat Frequency] - client_
session_ Sequence[Legacykeep_ alives Service User Parameter Client Session Keep Alife] - client_
timestamp_ Sequence[Legacytype_ mappings Service User Parameter Client Timestamp Type Mapping] - date_
input_ Sequence[Legacyformats Service User Parameter Date Input Format] - date_
output_ Sequence[Legacyformats Service User Parameter Date Output Format] - enable_
unload_ Sequence[Legacyphysical_ type_ optimizations Service User Parameter Enable Unload Physical Type Optimization] - enable_
unredacted_ Sequence[Legacyquery_ syntax_ errors Service User Parameter Enable Unredacted Query Syntax Error] - error_
on_ Sequence[Legacynondeterministic_ merges Service User Parameter Error On Nondeterministic Merge] - error_
on_ Sequence[Legacynondeterministic_ updates Service User Parameter Error On Nondeterministic Update] - geography_
output_ Sequence[Legacyformats Service User Parameter Geography Output Format] - geometry_
output_ Sequence[Legacyformats Service User Parameter Geometry Output Format] - jdbc_
treat_ Sequence[Legacydecimal_ as_ ints Service User Parameter Jdbc Treat Decimal As Int] - jdbc_
treat_ Sequence[Legacytimestamp_ ntz_ as_ utcs Service User Parameter Jdbc Treat Timestamp Ntz As Utc] - jdbc_
use_ Sequence[Legacysession_ timezones Service User Parameter Jdbc Use Session Timezone] - json_
indents Sequence[LegacyService User Parameter Json Indent] - lock_
timeouts Sequence[LegacyService User Parameter Lock Timeout] - log_
levels Sequence[LegacyService User Parameter Log Level] - multi_
statement_ Sequence[Legacycounts Service User Parameter Multi Statement Count] - network_
policies Sequence[LegacyService User Parameter Network Policy] - noorder_
sequence_ Sequence[Legacyas_ defaults Service User Parameter Noorder Sequence As Default] - odbc_
treat_ Sequence[Legacydecimal_ as_ ints Service User Parameter Odbc Treat Decimal As Int] - prevent_
unload_ Sequence[Legacyto_ internal_ stages Service User Parameter Prevent Unload To Internal Stage] - Sequence[Legacy
Service User Parameter Query Tag] - quoted_
identifiers_ Sequence[Legacyignore_ cases Service User Parameter Quoted Identifiers Ignore Case] - rows_
per_ Sequence[Legacyresultsets Service User Parameter Rows Per Resultset] - s3_
stage_ Sequence[Legacyvpce_ dns_ names Service User Parameter S3Stage Vpce Dns Name] - search_
paths Sequence[LegacyService User Parameter Search Path] - simulated_
data_ Sequence[Legacysharing_ consumers Service User Parameter Simulated Data Sharing Consumer] - statement_
queued_ Sequence[Legacytimeout_ in_ seconds Service User Parameter Statement Queued Timeout In Second] - statement_
timeout_ Sequence[Legacyin_ seconds Service User Parameter Statement Timeout In Second] - strict_
json_ Sequence[Legacyoutputs Service User Parameter Strict Json Output] - time_
input_ Sequence[Legacyformats Service User Parameter Time Input Format] - time_
output_ Sequence[Legacyformats Service User Parameter Time Output Format] - timestamp_
day_ Sequence[Legacyis_ always24hs Service User Parameter Timestamp Day Is Always24h] - timestamp_
input_ Sequence[Legacyformats Service User Parameter Timestamp Input Format] - timestamp_
ltz_ Sequence[Legacyoutput_ formats Service User Parameter Timestamp Ltz Output Format] - timestamp_
ntz_ Sequence[Legacyoutput_ formats Service User Parameter Timestamp Ntz Output Format] - timestamp_
output_ Sequence[Legacyformats Service User Parameter Timestamp Output Format] - timestamp_
type_ Sequence[Legacymappings Service User Parameter Timestamp Type Mapping] - timestamp_
tz_ Sequence[Legacyoutput_ formats Service User Parameter Timestamp Tz Output Format] - timezones
Sequence[Legacy
Service User Parameter Timezone] - trace_
levels Sequence[LegacyService User Parameter Trace Level] - transaction_
abort_ Sequence[Legacyon_ errors Service User Parameter Transaction Abort On Error] - transaction_
default_ Sequence[Legacyisolation_ levels Service User Parameter Transaction Default Isolation Level] - two_
digit_ Sequence[Legacycentury_ starts Service User Parameter Two Digit Century Start] - unsupported_
ddl_ Sequence[Legacyactions Service User Parameter Unsupported Ddl Action] - use_
cached_ Sequence[Legacyresults Service User Parameter Use Cached Result] - week_
of_ Sequence[Legacyyear_ policies Service User Parameter Week Of Year Policy] - week_
starts Sequence[LegacyService User Parameter Week Start]
- abort
Detached List<Property Map>Queries - autocommits List<Property Map>
- binary
Input List<Property Map>Formats - binary
Output List<Property Map>Formats - client
Memory List<Property Map>Limits - client
Metadata List<Property Map>Request Use Connection Ctxes - client
Prefetch List<Property Map>Threads - client
Result List<Property Map>Chunk Sizes - client
Result List<Property Map>Column Case Insensitives - client
Session List<Property Map>Keep Alive Heartbeat Frequencies - client
Session List<Property Map>Keep Alives - client
Timestamp List<Property Map>Type Mappings - date
Input List<Property Map>Formats - date
Output List<Property Map>Formats - enable
Unload List<Property Map>Physical Type Optimizations - enable
Unredacted List<Property Map>Query Syntax Errors - error
On List<Property Map>Nondeterministic Merges - error
On List<Property Map>Nondeterministic Updates - geography
Output List<Property Map>Formats - geometry
Output List<Property Map>Formats - jdbc
Treat List<Property Map>Decimal As Ints - jdbc
Treat List<Property Map>Timestamp Ntz As Utcs - jdbc
Use List<Property Map>Session Timezones - json
Indents List<Property Map> - lock
Timeouts List<Property Map> - log
Levels List<Property Map> - multi
Statement List<Property Map>Counts - network
Policies List<Property Map> - noorder
Sequence List<Property Map>As Defaults - odbc
Treat List<Property Map>Decimal As Ints - prevent
Unload List<Property Map>To Internal Stages - List<Property Map>
- quoted
Identifiers List<Property Map>Ignore Cases - rows
Per List<Property Map>Resultsets - s3Stage
Vpce List<Property Map>Dns Names - search
Paths List<Property Map> - simulated
Data List<Property Map>Sharing Consumers - statement
Queued List<Property Map>Timeout In Seconds - statement
Timeout List<Property Map>In Seconds - strict
Json List<Property Map>Outputs - time
Input List<Property Map>Formats - time
Output List<Property Map>Formats - timestamp
Day List<Property Map>Is Always24hs - timestamp
Input List<Property Map>Formats - timestamp
Ltz List<Property Map>Output Formats - timestamp
Ntz List<Property Map>Output Formats - timestamp
Output List<Property Map>Formats - timestamp
Type List<Property Map>Mappings - timestamp
Tz List<Property Map>Output Formats - timezones List<Property Map>
- trace
Levels List<Property Map> - transaction
Abort List<Property Map>On Errors - transaction
Default List<Property Map>Isolation Levels - two
Digit List<Property Map>Century Starts - unsupported
Ddl List<Property Map>Actions - use
Cached List<Property Map>Results - week
Of List<Property Map>Year Policies - week
Starts List<Property Map>
LegacyServiceUserParameterAbortDetachedQuery, LegacyServiceUserParameterAbortDetachedQueryArgs
- 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
LegacyServiceUserParameterAutocommit, LegacyServiceUserParameterAutocommitArgs
- 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
LegacyServiceUserParameterBinaryInputFormat, LegacyServiceUserParameterBinaryInputFormatArgs
- 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
LegacyServiceUserParameterBinaryOutputFormat, LegacyServiceUserParameterBinaryOutputFormatArgs
- 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
LegacyServiceUserParameterClientMemoryLimit, LegacyServiceUserParameterClientMemoryLimitArgs
- 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
LegacyServiceUserParameterClientMetadataRequestUseConnectionCtx, LegacyServiceUserParameterClientMetadataRequestUseConnectionCtxArgs
- 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
LegacyServiceUserParameterClientPrefetchThread, LegacyServiceUserParameterClientPrefetchThreadArgs
- 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
LegacyServiceUserParameterClientResultChunkSize, LegacyServiceUserParameterClientResultChunkSizeArgs
- 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
LegacyServiceUserParameterClientResultColumnCaseInsensitive, LegacyServiceUserParameterClientResultColumnCaseInsensitiveArgs
- 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
LegacyServiceUserParameterClientSessionKeepAlife, LegacyServiceUserParameterClientSessionKeepAlifeArgs
- 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
LegacyServiceUserParameterClientSessionKeepAliveHeartbeatFrequency, LegacyServiceUserParameterClientSessionKeepAliveHeartbeatFrequencyArgs
- 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
LegacyServiceUserParameterClientTimestampTypeMapping, LegacyServiceUserParameterClientTimestampTypeMappingArgs
- 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
LegacyServiceUserParameterDateInputFormat, LegacyServiceUserParameterDateInputFormatArgs
- 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
LegacyServiceUserParameterDateOutputFormat, LegacyServiceUserParameterDateOutputFormatArgs
- 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
LegacyServiceUserParameterEnableUnloadPhysicalTypeOptimization, LegacyServiceUserParameterEnableUnloadPhysicalTypeOptimizationArgs
- 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
LegacyServiceUserParameterEnableUnredactedQuerySyntaxError, LegacyServiceUserParameterEnableUnredactedQuerySyntaxErrorArgs
- 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
LegacyServiceUserParameterErrorOnNondeterministicMerge, LegacyServiceUserParameterErrorOnNondeterministicMergeArgs
- 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
LegacyServiceUserParameterErrorOnNondeterministicUpdate, LegacyServiceUserParameterErrorOnNondeterministicUpdateArgs
- 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
LegacyServiceUserParameterGeographyOutputFormat, LegacyServiceUserParameterGeographyOutputFormatArgs
- 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
LegacyServiceUserParameterGeometryOutputFormat, LegacyServiceUserParameterGeometryOutputFormatArgs
- 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
LegacyServiceUserParameterJdbcTreatDecimalAsInt, LegacyServiceUserParameterJdbcTreatDecimalAsIntArgs
- 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
LegacyServiceUserParameterJdbcTreatTimestampNtzAsUtc, LegacyServiceUserParameterJdbcTreatTimestampNtzAsUtcArgs
- 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
LegacyServiceUserParameterJdbcUseSessionTimezone, LegacyServiceUserParameterJdbcUseSessionTimezoneArgs
- 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
LegacyServiceUserParameterJsonIndent, LegacyServiceUserParameterJsonIndentArgs
- 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
LegacyServiceUserParameterLockTimeout, LegacyServiceUserParameterLockTimeoutArgs
- 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
LegacyServiceUserParameterLogLevel, LegacyServiceUserParameterLogLevelArgs
- 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
LegacyServiceUserParameterMultiStatementCount, LegacyServiceUserParameterMultiStatementCountArgs
- 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
LegacyServiceUserParameterNetworkPolicy, LegacyServiceUserParameterNetworkPolicyArgs
- 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
LegacyServiceUserParameterNoorderSequenceAsDefault, LegacyServiceUserParameterNoorderSequenceAsDefaultArgs
- 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
LegacyServiceUserParameterOdbcTreatDecimalAsInt, LegacyServiceUserParameterOdbcTreatDecimalAsIntArgs
- 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
LegacyServiceUserParameterPreventUnloadToInternalStage, LegacyServiceUserParameterPreventUnloadToInternalStageArgs
- 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
LegacyServiceUserParameterQueryTag, LegacyServiceUserParameterQueryTagArgs
- 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
LegacyServiceUserParameterQuotedIdentifiersIgnoreCase, LegacyServiceUserParameterQuotedIdentifiersIgnoreCaseArgs
- 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
LegacyServiceUserParameterRowsPerResultset, LegacyServiceUserParameterRowsPerResultsetArgs
- 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
LegacyServiceUserParameterS3StageVpceDnsName, LegacyServiceUserParameterS3StageVpceDnsNameArgs
- 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
LegacyServiceUserParameterSearchPath, LegacyServiceUserParameterSearchPathArgs
- 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
LegacyServiceUserParameterSimulatedDataSharingConsumer, LegacyServiceUserParameterSimulatedDataSharingConsumerArgs
- 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
LegacyServiceUserParameterStatementQueuedTimeoutInSecond, LegacyServiceUserParameterStatementQueuedTimeoutInSecondArgs
- 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
LegacyServiceUserParameterStatementTimeoutInSecond, LegacyServiceUserParameterStatementTimeoutInSecondArgs
- 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
LegacyServiceUserParameterStrictJsonOutput, LegacyServiceUserParameterStrictJsonOutputArgs
- 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
LegacyServiceUserParameterTimeInputFormat, LegacyServiceUserParameterTimeInputFormatArgs
- 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
LegacyServiceUserParameterTimeOutputFormat, LegacyServiceUserParameterTimeOutputFormatArgs
- 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
LegacyServiceUserParameterTimestampDayIsAlways24h, LegacyServiceUserParameterTimestampDayIsAlways24hArgs
- 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
LegacyServiceUserParameterTimestampInputFormat, LegacyServiceUserParameterTimestampInputFormatArgs
- 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
LegacyServiceUserParameterTimestampLtzOutputFormat, LegacyServiceUserParameterTimestampLtzOutputFormatArgs
- 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
LegacyServiceUserParameterTimestampNtzOutputFormat, LegacyServiceUserParameterTimestampNtzOutputFormatArgs
- 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
LegacyServiceUserParameterTimestampOutputFormat, LegacyServiceUserParameterTimestampOutputFormatArgs
- 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
LegacyServiceUserParameterTimestampTypeMapping, LegacyServiceUserParameterTimestampTypeMappingArgs
- 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
LegacyServiceUserParameterTimestampTzOutputFormat, LegacyServiceUserParameterTimestampTzOutputFormatArgs
- 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
LegacyServiceUserParameterTimezone, LegacyServiceUserParameterTimezoneArgs
- 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
LegacyServiceUserParameterTraceLevel, LegacyServiceUserParameterTraceLevelArgs
- 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
LegacyServiceUserParameterTransactionAbortOnError, LegacyServiceUserParameterTransactionAbortOnErrorArgs
- 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
LegacyServiceUserParameterTransactionDefaultIsolationLevel, LegacyServiceUserParameterTransactionDefaultIsolationLevelArgs
- 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
LegacyServiceUserParameterTwoDigitCenturyStart, LegacyServiceUserParameterTwoDigitCenturyStartArgs
- 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
LegacyServiceUserParameterUnsupportedDdlAction, LegacyServiceUserParameterUnsupportedDdlActionArgs
- 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
LegacyServiceUserParameterUseCachedResult, LegacyServiceUserParameterUseCachedResultArgs
- 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
LegacyServiceUserParameterWeekOfYearPolicy, LegacyServiceUserParameterWeekOfYearPolicyArgs
- 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
LegacyServiceUserParameterWeekStart, LegacyServiceUserParameterWeekStartArgs
- 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
LegacyServiceUserShowOutput, LegacyServiceUserShowOutputArgs
- Comment string
- Created
On string - Days
To stringExpiry - Default
Namespace string - Default
Role string - Default
Secondary stringRoles - Default
Warehouse string - Disabled bool
- Display
Name string - Email string
- Expires
At stringTime - Ext
Authn boolDuo - Ext
Authn stringUid - First
Name string - Has
Mfa bool - Has
Password bool - Has
Rsa boolPublic Key - Last
Name string - Last
Success stringLogin - Locked
Until stringTime - Login
Name string - Mins
To stringBypass Mfa - Mins
To stringUnlock - Must
Change boolPassword - Name string
- Owner string
- Snowflake
Lock bool - Type string
- Comment string
- Created
On string - Days
To stringExpiry - Default
Namespace string - Default
Role string - Default
Secondary stringRoles - Default
Warehouse string - Disabled bool
- Display
Name string - Email string
- Expires
At stringTime - Ext
Authn boolDuo - Ext
Authn stringUid - First
Name string - Has
Mfa bool - Has
Password bool - Has
Rsa boolPublic Key - Last
Name string - Last
Success stringLogin - Locked
Until stringTime - Login
Name string - Mins
To stringBypass Mfa - Mins
To stringUnlock - Must
Change boolPassword - Name string
- Owner string
- Snowflake
Lock bool - Type string
- comment String
- created
On String - days
To StringExpiry - default
Namespace String - default
Role String - default
Secondary StringRoles - default
Warehouse String - disabled Boolean
- display
Name String - email String
- expires
At StringTime - ext
Authn BooleanDuo - ext
Authn StringUid - first
Name String - has
Mfa Boolean - has
Password Boolean - has
Rsa BooleanPublic Key - last
Name String - last
Success StringLogin - locked
Until StringTime - login
Name String - mins
To StringBypass Mfa - mins
To StringUnlock - must
Change BooleanPassword - name String
- owner String
- snowflake
Lock Boolean - type String
- comment string
- created
On string - days
To stringExpiry - default
Namespace string - default
Role string - default
Secondary stringRoles - default
Warehouse string - disabled boolean
- display
Name string - email string
- expires
At stringTime - ext
Authn booleanDuo - ext
Authn stringUid - first
Name string - has
Mfa boolean - has
Password boolean - has
Rsa booleanPublic Key - last
Name string - last
Success stringLogin - locked
Until stringTime - login
Name string - mins
To stringBypass Mfa - mins
To stringUnlock - must
Change booleanPassword - name string
- owner string
- snowflake
Lock boolean - type string
- comment str
- created_
on str - days_
to_ strexpiry - default_
namespace str - default_
role str - default_
secondary_ strroles - default_
warehouse str - disabled bool
- display_
name str - email str
- expires_
at_ strtime - ext_
authn_ boolduo - ext_
authn_ struid - first_
name str - has_
mfa bool - has_
password bool - has_
rsa_ boolpublic_ key - last_
name str - last_
success_ strlogin - locked_
until_ strtime - login_
name str - mins_
to_ strbypass_ mfa - mins_
to_ strunlock - must_
change_ boolpassword - name str
- owner str
- snowflake_
lock bool - type str
- comment String
- created
On String - days
To StringExpiry - default
Namespace String - default
Role String - default
Secondary StringRoles - default
Warehouse String - disabled Boolean
- display
Name String - email String
- expires
At StringTime - ext
Authn BooleanDuo - ext
Authn StringUid - first
Name String - has
Mfa Boolean - has
Password Boolean - has
Rsa BooleanPublic Key - last
Name String - last
Success StringLogin - locked
Until StringTime - login
Name String - mins
To StringBypass Mfa - mins
To StringUnlock - must
Change BooleanPassword - name String
- owner String
- snowflake
Lock Boolean - type String
Package Details
- Repository
- Snowflake pulumi/pulumi-snowflake
- License
- Apache-2.0
- Notes
- This Pulumi package is based on the
snowflake
Terraform Provider.