DB Reader
The DB reader is a spark-based reader which gives you capability to read data from multiple database sources.
Last updated
The DB reader is a spark-based reader which gives you capability to read data from multiple database sources.
Last updated
All component configurations are classified broadly into the following sections:
Basic
Metadata
Drivers Available:
MySQL
Oracle
PostgreSQL
MS-SQL
ClickHouse
Snowflake
Fetch Size: Provide the maximum number of records to be processed in one execution cycle.
Create Partition: This is used for performance enhancement. It's going to create the sequence of indexing.
Auto Increment: The number of partitions will be incremented automatically.
Index: The number of partitions will be incremented based on the specified Partition column.
Partition Column: specify a unique column name, whose value is a number.
Check out the given demonstration of the DB Reader component with the Snowflake driver.