Skip to content

simpledotorg/simple-etl

BranchesTags

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

5 Commits

informational_tables

informational_tables

 
 

questions

questions

 
 

.gitignore

.gitignore

 
 

README.md

README.md

 
 

__generated_dwh_full_fill.sql

__generated_dwh_full_fill.sql

 
 

create_dwh_tables.sql

create_dwh_tables.sql

 
 

create_info_tables.sql

create_info_tables.sql

 
 

generate_dwh_fill.py

generate_dwh_fill.py

 
 

Repository files navigation

  1. Run create_info_tables.sql to create and fill informational tables from CSVs in the informational_tables folder
  2. Run create_dwh_tables.sql to create the tables in the database
  3. Run generate_dwh_fill.py to create SQL output to backfill the tables
  4. Run SQL output from step 3 (this is included as __generated_dwh_full_fill.sql)
  5. Run queries as desired from questions folder

About

ETL pipeline draft code for simple-server

Resources

Readme
Activity
Custom properties

Stars

0 stars

Watchers

2 watching

Forks

1 fork
Report repository

Releases

No releases published

Packages

No packages published

Languages