Skip to content

Instantly share code, notes, and snippets.

View umarhussain88's full-sized avatar

Umar Hussain umarhussain88

  • CurrencyCloud
  • Birmingham, UK.
View GitHub Profile
@deinspanjer
deinspanjer / date_and_time_dimensions.sql
Created June 29, 2016 20:08
Magic Date and Time dimensions in PostgreSQL for a data warehouse
BEGIN;
CREATE TABLE dwh.d_date
(
date_key CHAR(10) PRIMARY KEY NOT NULL,
full_date DATE NOT NULL
);
CREATE UNIQUE INDEX d_date_full_date_uindex ON dwh.d_date (full_date);
INSERT INTO dwh.d_date
@thsutton
thsutton / log4j4py.py
Created January 11, 2021 00:41
Forward Python logging module to Spark log4j
import logging
import time
from contextlib import AbstractContextManager
from logging import Handler, LogRecord
from typing import Any, List, Optional
from pyspark.sql import SparkSession
logging.basicConfig(level=logging.INFO)