Class SnowflakeNodeData
- All Implemented Interfaces:
Serializable
,SdkPojo
,ToCopyableBuilder<SnowflakeNodeData.Builder,
SnowflakeNodeData>
Specifies configuration for Snowflake nodes in Glue Studio.
- See Also:
-
Nested Class Summary
-
Method Summary
Modifier and TypeMethodDescriptionfinal String
action()
Specifies what action to take when writing to a table with preexisting data.Specifies additional options passed to the Snowflake connector.final Boolean
Specifies whether automatic query pushdown is enabled.static SnowflakeNodeData.Builder
builder()
final Option
Specifies a Glue Data Catalog Connection to a Snowflake endpoint.final String
database()
Specifies a Snowflake database for your node to use.final boolean
final boolean
equalsBySdkFields
(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 boolean
For responses, this returns true if the service returned a value for the AdditionalOptions property.final int
hashCode()
final boolean
For responses, this returns true if the service returned a value for the SelectedColumns property.final boolean
For responses, this returns true if the service returned a value for the TableSchema property.final Option
iamRole()
Not currently used.final String
Specifies a merge action.final String
A SQL statement that specifies a custom merge behavior.final String
Specifies how to resolve records that match preexisting data when merging.final String
Specifies how to process records that do not match preexisting data when merging.final String
A SQL string run after the Snowflake connector performs its standard actions.final String
A SQL string run before the Snowflake connector performs its standard actions.final String
A SQL string used to retrieve data with thequery
sourcetype.final String
schema()
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 String
Specifies how retrieved data is specified.final String
The name of a staging table used when performingmerge
or upsertappend
actions.final String
table()
Specifies a Snowflake table for your node to use.Manually defines the target schema for the node.final String
tempDir()
Not currently used.Take this object and create a builder that contains all of the current property values of this object.final String
toString()
Returns a string representation of this object.final Boolean
upsert()
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
Not currently used.
- Returns:
- Not currently used.
-
iamRole
Not currently used.
- Returns:
- Not currently used.
-
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
query
sourcetype.- Returns:
- A SQL string used to retrieve data with the
query
sourcetype.
-
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 byMergeWhenMatched
andMergeWhenNotMatched
. If custom, defined byMergeClause
.- Returns:
- Specifies a merge action. Valid values:
simple
,custom
. If simple, merge behavior is defined byMergeWhenMatched
andMergeWhenNotMatched
. 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
merge
or upsertappend
actions. Data is written to this table, then moved totable
by a generated postaction.- Returns:
- The name of a staging table used when performing
merge
or upsertappend
actions. Data is written to this table, then moved totable
by 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
,label
anddescription
keys. 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
,label
anddescription
keys. 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
,label
anddescription
keys. 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
,label
anddescription
keys. Each structure defines a column.
-
toBuilder
Description copied from interface:ToCopyableBuilder
Take this object and create a builder that contains all of the current property values of this object.- Specified by:
toBuilder
in interfaceToCopyableBuilder<SnowflakeNodeData.Builder,
SnowflakeNodeData> - Returns:
- a builder for type T
-
builder
-
serializableBuilderClass
-
hashCode
public final int hashCode() -
equals
-
equalsBySdkFields
Description copied from interface:SdkPojo
Indicates whether some other object is "equal to" this one by SDK fields. An SDK field is a modeled, non-inherited field in anSdkPojo
class, and is generated based on a service model.If an
SdkPojo
class does not have any inherited fields,equalsBySdkFields
andequals
are essentially the same.- Specified by:
equalsBySdkFields
in 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
Returns a string representation of this object. This is useful for testing and debugging. Sensitive data will be redacted from this string using a placeholder value. -
getValueForField
-
sdkFields
-