Class SnowflakeIO.Read<T>
- All Implemented Interfaces:
Serializable,HasDisplayData
- Enclosing class:
SnowflakeIO
SnowflakeIO.read().- See Also:
-
Nested Class Summary
Nested ClassesModifier and TypeClassDescriptionstatic classRemoves temporary staged files after reading.static classParsesStringfrom incoming data inPCollectionto 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 thisPTransformshould 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) voidpopulateDisplayData(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.DataSourceConfigurationin 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.DataSourceConfigurationin 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:PTransformOverride this method to specify how thisPTransformshould be expanded on the givenInputT.NOTE: This method should not be called directly. Instead apply the
PTransformshould be applied to theInputTusing theapplymethod.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:
expandin classPTransform<PBegin,PCollection<T>>
-
populateDisplayData
Description copied from class:PTransformRegister 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:
populateDisplayDatain interfaceHasDisplayData- Overrides:
populateDisplayDatain classPTransform<PBegin,PCollection<T>> - Parameters:
builder- The builder to populate with display data.- See Also:
-