Class SnowflakeNodeData
- All Implemented Interfaces:
Serializable,SdkPojo,ToCopyableBuilder<SnowflakeNodeData.Builder,SnowflakeNodeData>
Specifies configuration for Snowflake nodes in Glue Studio.
- See Also:
-
Nested Class Summary
Nested Classes -
Method Summary
Modifier and TypeMethodDescriptionfinal Stringaction()Specifies what action to take when writing to a table with preexisting data.Specifies additional options passed to the Snowflake connector.final BooleanSpecifies whether automatic query pushdown is enabled.static SnowflakeNodeData.Builderbuilder()final OptionSpecifies a Glue Data Catalog Connection to a Snowflake endpoint.final Stringdatabase()Specifies a Snowflake database for your node to use.final booleanfinal booleanequalsBySdkFields(Object obj) Indicates whether some other object is "equal to" this one by SDK fields.final <T> Optional<T> getValueForField(String fieldName, Class<T> clazz) final booleanFor responses, this returns true if the service returned a value for the AdditionalOptions property.final inthashCode()final booleanFor responses, this returns true if the service returned a value for the SelectedColumns property.final booleanFor responses, this returns true if the service returned a value for the TableSchema property.final OptioniamRole()Not currently used.final StringSpecifies a merge action.final StringA SQL statement that specifies a custom merge behavior.final StringSpecifies how to resolve records that match preexisting data when merging.final StringSpecifies how to process records that do not match preexisting data when merging.final StringA SQL string run after the Snowflake connector performs its standard actions.final StringA SQL string run before the Snowflake connector performs its standard actions.final StringA SQL string used to retrieve data with thequerysourcetype.final Stringschema()Specifies a Snowflake database schema for your node to use.Specifies the columns combined to identify a record when detecting matches for merges and upserts.static Class<? extends SnowflakeNodeData.Builder> final StringSpecifies how retrieved data is specified.final StringThe name of a staging table used when performingmergeor upsertappendactions.final Stringtable()Specifies a Snowflake table for your node to use.Manually defines the target schema for the node.final StringtempDir()Not currently used.Take this object and create a builder that contains all of the current property values of this object.final StringtoString()Returns a string representation of this object.final Booleanupsert()Used when Action isappend.Methods inherited from interface software.amazon.awssdk.utils.builder.ToCopyableBuilder
copy
-
Method Details
-
sourceType
Specifies how retrieved data is specified. Valid values:
"table","query".- Returns:
- Specifies how retrieved data is specified. Valid values:
"table","query".
-
connection
Specifies a Glue Data Catalog Connection to a Snowflake endpoint.
- Returns:
- Specifies a Glue Data Catalog Connection to a Snowflake endpoint.
-
schema
Specifies a Snowflake database schema for your node to use.
- Returns:
- Specifies a Snowflake database schema for your node to use.
-
table
Specifies a Snowflake table for your node to use.
- Returns:
- Specifies a Snowflake table for your node to use.
-
database
Specifies a Snowflake database for your node to use.
- Returns:
- Specifies a Snowflake database for your node to use.
-
tempDir
-
iamRole
-
hasAdditionalOptions
public final boolean hasAdditionalOptions()For responses, this returns true if the service returned a value for the AdditionalOptions property. This DOES NOT check that the value is non-empty (for which, you should check theisEmpty()method on the property). This is useful because the SDK will never return a null collection or map, but you may need to differentiate between the service returning nothing (or null) and the service returning an empty collection or map. For requests, this returns true if a value for the property was specified in the request builder, and false if a value was not specified. -
additionalOptions
Specifies additional options passed to the Snowflake connector. If options are specified elsewhere in this node, this will take precedence.
Attempts to modify the collection returned by this method will result in an UnsupportedOperationException.
This method will never return null. If you would like to know whether the service returned this field (so that you can differentiate between null and empty), you can use the
hasAdditionalOptions()method.- Returns:
- Specifies additional options passed to the Snowflake connector. If options are specified elsewhere in this node, this will take precedence.
-
sampleQuery
A SQL string used to retrieve data with the
querysourcetype.- Returns:
- A SQL string used to retrieve data with the
querysourcetype.
-
preAction
A SQL string run before the Snowflake connector performs its standard actions.
- Returns:
- A SQL string run before the Snowflake connector performs its standard actions.
-
postAction
A SQL string run after the Snowflake connector performs its standard actions.
- Returns:
- A SQL string run after the Snowflake connector performs its standard actions.
-
action
Specifies what action to take when writing to a table with preexisting data. Valid values:
append,merge,truncate,drop.- Returns:
- Specifies what action to take when writing to a table with preexisting data. Valid values:
append,merge,truncate,drop.
-
upsert
Used when Action is
append. Specifies the resolution behavior when a row already exists. If true, preexisting rows will be updated. If false, those rows will be inserted.- Returns:
- Used when Action is
append. Specifies the resolution behavior when a row already exists. If true, preexisting rows will be updated. If false, those rows will be inserted.
-
mergeAction
Specifies a merge action. Valid values:
simple,custom. If simple, merge behavior is defined byMergeWhenMatchedandMergeWhenNotMatched. If custom, defined byMergeClause.- Returns:
- Specifies a merge action. Valid values:
simple,custom. If simple, merge behavior is defined byMergeWhenMatchedandMergeWhenNotMatched. If custom, defined byMergeClause.
-
mergeWhenMatched
Specifies how to resolve records that match preexisting data when merging. Valid values:
update,delete.- Returns:
- Specifies how to resolve records that match preexisting data when merging. Valid values:
update,delete.
-
mergeWhenNotMatched
Specifies how to process records that do not match preexisting data when merging. Valid values:
insert,none.- Returns:
- Specifies how to process records that do not match preexisting data when merging. Valid values:
insert,none.
-
mergeClause
A SQL statement that specifies a custom merge behavior.
- Returns:
- A SQL statement that specifies a custom merge behavior.
-
stagingTable
The name of a staging table used when performing
mergeor upsertappendactions. Data is written to this table, then moved totableby a generated postaction.- Returns:
- The name of a staging table used when performing
mergeor upsertappendactions. Data is written to this table, then moved totableby a generated postaction.
-
hasSelectedColumns
public final boolean hasSelectedColumns()For responses, this returns true if the service returned a value for the SelectedColumns property. This DOES NOT check that the value is non-empty (for which, you should check theisEmpty()method on the property). This is useful because the SDK will never return a null collection or map, but you may need to differentiate between the service returning nothing (or null) and the service returning an empty collection or map. For requests, this returns true if a value for the property was specified in the request builder, and false if a value was not specified. -
selectedColumns
Specifies the columns combined to identify a record when detecting matches for merges and upserts. A list of structures with
value,labelanddescriptionkeys. Each structure describes a column.Attempts to modify the collection returned by this method will result in an UnsupportedOperationException.
This method will never return null. If you would like to know whether the service returned this field (so that you can differentiate between null and empty), you can use the
hasSelectedColumns()method.- Returns:
- Specifies the columns combined to identify a record when detecting matches for merges and upserts. A list
of structures with
value,labelanddescriptionkeys. Each structure describes a column.
-
autoPushdown
Specifies whether automatic query pushdown is enabled. If pushdown is enabled, then when a query is run on Spark, if part of the query can be "pushed down" to the Snowflake server, it is pushed down. This improves performance of some queries.
- Returns:
- Specifies whether automatic query pushdown is enabled. If pushdown is enabled, then when a query is run on Spark, if part of the query can be "pushed down" to the Snowflake server, it is pushed down. This improves performance of some queries.
-
hasTableSchema
public final boolean hasTableSchema()For responses, this returns true if the service returned a value for the TableSchema property. This DOES NOT check that the value is non-empty (for which, you should check theisEmpty()method on the property). This is useful because the SDK will never return a null collection or map, but you may need to differentiate between the service returning nothing (or null) and the service returning an empty collection or map. For requests, this returns true if a value for the property was specified in the request builder, and false if a value was not specified. -
tableSchema
Manually defines the target schema for the node. A list of structures with
value,labelanddescriptionkeys. Each structure defines a column.Attempts to modify the collection returned by this method will result in an UnsupportedOperationException.
This method will never return null. If you would like to know whether the service returned this field (so that you can differentiate between null and empty), you can use the
hasTableSchema()method.- Returns:
- Manually defines the target schema for the node. A list of structures with
value,labelanddescriptionkeys. Each structure defines a column.
-
toBuilder
Description copied from interface:ToCopyableBuilderTake this object and create a builder that contains all of the current property values of this object.- Specified by:
toBuilderin interfaceToCopyableBuilder<SnowflakeNodeData.Builder,SnowflakeNodeData> - Returns:
- a builder for type T
-
builder
-
serializableBuilderClass
-
hashCode
-
equals
-
equalsBySdkFields
Description copied from interface:SdkPojoIndicates whether some other object is "equal to" this one by SDK fields. An SDK field is a modeled, non-inherited field in anSdkPojoclass, and is generated based on a service model.If an
SdkPojoclass does not have any inherited fields,equalsBySdkFieldsandequalsare essentially the same.- Specified by:
equalsBySdkFieldsin interfaceSdkPojo- Parameters:
obj- the object to be compared with- Returns:
- true if the other object equals to this object by sdk fields, false otherwise.
-
toString
-
getValueForField
-
sdkFields
-