Class SnowflakeIO.Read<T>
- All Implemented Interfaces:
Serializable
,HasDisplayData
- Enclosing class:
SnowflakeIO
SnowflakeIO.read()
.- See Also:
-
Nested Class Summary
Nested ClassesModifier and TypeClassDescriptionstatic class
Removes temporary staged files after reading.static class
ParsesString
from incoming data inPCollection
to have proper format for CSV files. -
Field Summary
Fields inherited from class org.apache.beam.sdk.transforms.PTransform
annotations, displayData, name, resourceHints
-
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionOverride this method to specify how thisPTransform
should be expanded on the givenInputT
.A query to be executed in Snowflake.fromQuery
(ValueProvider<String> query) A table name to be read in Snowflake.fromTable
(ValueProvider<String> table) void
populateDisplayData
(DisplayData.Builder builder) Register display data for the given transform or component.A Coder to be used by the output PCollection generated by the source.withCsvMapper
(SnowflakeIO.CsvMapper<T> csvMapper) User-defined function mapping CSV lines into user data.Setting information about Snowflake server.withDataSourceProviderFn
(SerializableFunction<Void, DataSource> dataSourceProviderFn) Setting function that will provideSnowflakeIO.DataSourceConfiguration
in runtime.withQuotationMark
(String quotationMark) Sets Snowflake-specific quotations around strings.withQuotationMark
(ValueProvider<String> quotationMark) withStagingBucketName
(String stagingBucketName) Name of the cloud bucket (GCS by now) to use as tmp location of CSVs during COPY statement.withStagingBucketName
(ValueProvider<String> stagingBucketName) withStorageIntegrationName
(String integrationName) Name of the Storage Integration in Snowflake to be used.withStorageIntegrationName
(ValueProvider<String> integrationName) Methods inherited from class org.apache.beam.sdk.transforms.PTransform
addAnnotation, compose, compose, getAdditionalInputs, getAnnotations, getDefaultOutputCoder, getDefaultOutputCoder, getDefaultOutputCoder, getKindString, getName, getResourceHints, setDisplayData, setResourceHints, toString, validate, validate
-
Constructor Details
-
Read
public Read()
-
-
Method Details
-
withDataSourceConfiguration
Setting information about Snowflake server.- Parameters:
config
- An instance ofSnowflakeIO.DataSourceConfiguration
.
-
withDataSourceProviderFn
public SnowflakeIO.Read<T> withDataSourceProviderFn(SerializableFunction<Void, DataSource> dataSourceProviderFn) Setting function that will provideSnowflakeIO.DataSourceConfiguration
in runtime.- Parameters:
dataSourceProviderFn
- aSerializableFunction
.
-
fromQuery
A query to be executed in Snowflake.- Parameters:
query
- String with query.
-
fromQuery
-
fromTable
A table name to be read in Snowflake.- Parameters:
table
- String with the name of the table.
-
fromTable
-
withStagingBucketName
Name of the cloud bucket (GCS by now) to use as tmp location of CSVs during COPY statement.- Parameters:
stagingBucketName
- String with the name of the bucket.
-
withStagingBucketName
-
withStorageIntegrationName
Name of the Storage Integration in Snowflake to be used. See https://docs.snowflake.com/en/sql-reference/sql/create-storage-integration.html for reference.- Parameters:
integrationName
- String with the name of the Storage Integration.
-
withStorageIntegrationName
-
withCsvMapper
User-defined function mapping CSV lines into user data.- Parameters:
csvMapper
- an instance ofSnowflakeIO.CsvMapper
.
-
withCoder
A Coder to be used by the output PCollection generated by the source.- Parameters:
coder
- an instance ofCoder
.
-
withQuotationMark
Sets Snowflake-specific quotations around strings.- Parameters:
quotationMark
- with possible single quote'
, double quote"
or nothing. Default value is single quotation'
.- Returns:
-
withQuotationMark
-
expand
Description copied from class:PTransform
Override this method to specify how thisPTransform
should be expanded on the givenInputT
.NOTE: This method should not be called directly. Instead apply the
PTransform
should be applied to theInputT
using theapply
method.Composite transforms, which are defined in terms of other transforms, should return the output of one of the composed transforms. Non-composite transforms, which do not apply any transforms internally, should return a new unbound output and register evaluators (via backend-specific registration methods).
- Specified by:
expand
in classPTransform<PBegin,
PCollection<T>>
-
populateDisplayData
Description copied from class:PTransform
Register display data for the given transform or component.populateDisplayData(DisplayData.Builder)
is invoked by Pipeline runners to collect display data viaDisplayData.from(HasDisplayData)
. Implementations may callsuper.populateDisplayData(builder)
in order to register display data in the current namespace, but should otherwise usesubcomponent.populateDisplayData(builder)
to use the namespace of the subcomponent.By default, does not register any display data. Implementors may override this method to provide their own display data.
- Specified by:
populateDisplayData
in interfaceHasDisplayData
- Overrides:
populateDisplayData
in classPTransform<PBegin,
PCollection<T>> - Parameters:
builder
- The builder to populate with display data.- See Also:
-