Skip to content

thbar/kiba-blueprints

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

25 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

This repository contains a single blueprint (but I'll add more) showcasing the use of Kiba ETL and Kiba Pro.

Note that Kiba Pro is a commercial extension ; running bundle install requires an active subscription. Configuration instructions can be found here.

License for this repository: MIT.

Postgres bulk upsert (ON CONFLICT UPDATE)

A table is initially created, with a product_ref column with a unicity constraint.

Records are generated in memory using an enumerable, transformed to build rows as Hash instances, then upserted into the target table.

The destination is configured to:

  • Insert the row if none exist with the same product_ref
  • If a row exists with the same product_ref, update its price, quantity and description

Processing occurs in batches of 25k records, grouped as a single transactions.

A little DSLExtension is used to inject some form of feedback and measure.

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages