Company_Info_Reader
Reads 300+ CompanyInformation JSON files, flattens to normalized schema, separates officer roster, and loads to stg.stg_company_info and stg.stg_company_officers.
Reads 300+ CompanyInformation JSON files, flattens to normalized schema, separates officer roster, and loads to stg.stg_company_info and stg.stg_company_officers.
Nodes
- CSV Reader1 ×
- Column Filter1 ×
- Column Renamer1 ×
- DB SQL Executor (Labs)1 ×
- DB Writer1 ×
- List Files/Folders1 ×
- Loop End1 ×
- Round Double1 ×
- Path to String1 ×
- PostgreSQL Connector1 ×
- Rule Engine1 ×
- String to Date&Time1 ×
- Table Row to Variable Loop Start1 ×
Extensions
Links
- No links available