Skip to content

VynFi/dbt-vynfi

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

1 Commit
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

dbt-vynfi: Synthetic Financial Data Seeds

Pre-built dbt seed package with VynFi-generated financial test data. Drop it into any dbt project for instant test fixtures — journal entries, document flows, and banking transactions with fraud labels.

Quick Start

# Add to your dbt project
cp -r seeds/ your-dbt-project/seeds/vynfi/

# Or install as a dbt package (add to packages.yml)
packages:
  - git: "https://github.com/VynFi/dbt-vynfi"
    revision: main
dbt seed          # Load VynFi test data
dbt test          # Run included tests (Benford, balance, referential integrity)

Seeds

Seed Rows Description
journal_entries 500 Balanced JEs with fraud labels, GL accounts
purchase_orders 50 P2P procurement documents
goods_receipts 55 GR records linked to POs
vendor_invoices 50 Invoices with three-way matching
payments 75 Settlement records

Included Tests

# tests/test_je_balance.sql
-- Every non-fraud JE should balance (debits = credits)
select document_id, sum(debit_amount) - sum(credit_amount) as imbalance
from {{ ref('journal_entries') }}
where not is_fraud
group by document_id
having abs(sum(debit_amount) - sum(credit_amount)) > 0.01

Generate Fresh Seeds

pip install vynfi
python generate_seeds.py  # Writes CSV seeds from VynFi API

Links

About

dbt seed package with VynFi synthetic financial test data — journal entries, document flows, fraud labels

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors

Languages