Skip to content

Instantly share code, notes, and snippets.

View ngoldenberg's full-sized avatar

Nicolas Goldenberg ngoldenberg

View GitHub Profile
@ngoldenberg
ngoldenberg / README.md
Last active October 18, 2022 14:21
Convert csv to feather file format - Download and upload from GCP bucket

Convert csv files to feather format files

Write and upload indicators file to GCP buckets

Install

Install python virtual env (or similar)

pip install virtualenv

Create python virtual env (or similar)

@ngoldenberg
ngoldenberg / drop_multiple_tables.sql
Created July 11, 2019 16:14
Delete/Drop multiple tables based on multiple prefixes - PostgreSQL
-- Inspect the generated statements before you actually execute: comment RAISE and uncomment the EXECUTE
DO
$do$
DECLARE
_tbl text;
BEGIN
FOR _tbl IN
SELECT c.oid::regclass::text -- escape identifier and schema-qualify!
FROM pg_catalog.pg_class c
JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace