Skip to main content
FieldDescriptionExample ValueData Type
hostThe hostname or IP address of the database server.localhostString
portThe port number through which the database server is accessible.5431Integer
databaseThe name of the target database to connect to.mainString
usernameThe username used for authenticating with the database.mainString
passwordThe password corresponding to the provided username for authentication.passwordString
jdbc_url_paramsA collection of additional JDBC URL parameters to fine-tune the connection.{}Object
sslSSL configuration for the database connection. Contains details such as the SSL mode.{"mode": "disable"}
{"mode": "allow"}
Object
update_methodSpecifies the mechanism for updating data. Includes properties for a replication slot and an initial wait time.{"replication_slot": "postgres_slot", "intial_wait_time": 10}Object
reader_batch_sizeThe maximum number of records processed per batch during reading operations.100000Integer
max_threadsThe maximum number of threads allocated for parallel processing tasks.5Integer


πŸ’‘ Join the OLake Community!

Got questions, ideas, or just want to connect with other data engineers?
πŸ‘‰ Join our Slack Community to get real-time support, share feedback, and shape the future of OLake together. πŸš€

Your success with OLake is our priority. Don’t hesitate to contact us if you need any help or further clarification!