workflows-final
This directory contains 5 workflows.
Company_Info_Reader
Reads 300+ CompanyInformation JSON files, flattens to normalized schema, separates officer roster, and loads to stg.stg_company_info and […]
CSV_Reader
CSV Reader & Loader
DB_Loader
End-to-End ETL Orchestrator - Orchestrates the full KNIME to PostgreSQL pipeline: truncate stg, run all reader workflows, promote to dw, refresh analytics […]
Financial_Statement_Reader
Reads _financial_statements.json files from dataset/*/Financial Statement Data/. Extracts income_statement, balance_sheet, cashflow via JSON Path -> JSON to […]
Industry_Avg_Reader
Industry Average Reader - reads industry_avg_df.csv files from all 15 sector folders, adds sector/date_key/daily_return columns, and appends to […]