Skip to content

Instantly share code, notes, and snippets.

View thisisbinod's full-sized avatar

thisisbinod

View GitHub Profile
@thisisbinod
thisisbinod / creating_a_date_dimension_table_in_postgresql.sql
Created October 17, 2018 20:01 — forked from mtucker/creating_a_date_dimension_table_in_postgresql.sql
Creating a date dimension table in PostgreSQL
DROP TABLE if exists d_date;
CREATE TABLE d_date
(
date_dim_id INT NOT NULL,
date_actual DATE NOT NULL,
epoch BIGINT NOT NULL,
day_suffix VARCHAR(4) NOT NULL,
day_name VARCHAR(9) NOT NULL,
day_of_week INT NOT NULL,
@thisisbinod
thisisbinod / README.md
Created September 26, 2018 03:10 — forked from onyxfish/README.md
Import the entire Bureau of Labor Statistics (BLS) Quarterly Census of Wages (QCEW) dataset into a PostgreSQL database

QCEW Data Loader

These scripts import the entire Bureau of Labor Statistics Quarterly Census of Employement and Wages (from 1990 to latest) into one giant PostgreSQL database.

The database created by this process will use about 100GB of disk space. Make sure you have enough space available before you start!

Configuration

Database name, table name, and more can be configured via config.sh.