paulochf

Keybase proof

I hereby claim:

• I am paulochf on github.
• I am paulochf (https://keybase.io/paulochf) on keybase.
• I have a public key ASAOc7a0jtp1VV99W7ZCdrqADfYcmh9Oge1p5fFsTVv-VAo

To claim this, I am signing this object:

paulochf

-- Heavily inspired by this StackOverflow thread 
-- https://stackoverflow.com/questions/47230534/how-do-i-create-a-dates-table-in-redshift
-- and tired of bumping my head in the wall after getting the generate_series() error.

DROP VIEW IF EXISTS public.dim_date;
CREATE VIEW public.dim_date AS
  WITH
    digit AS (
      SELECT
        0 AS D

paulochf

paulochf

paulochf

import pandas as pd

pd.set_option("display.max_rows", 200)
pd.set_option("display.max_columns", 100)
pd.set_option("display.max_colwidth", 200)

## Reset to defaults
# pd.reset_option("^display")

paulochf

# After Ubuntu 16.04, Systemd becomes the default.
# It is simpler than https://gist.github.com/Doowon/38910829898a6624ce4ed554f082c4dd
# https://gist.github.com/whophil/5a2eab328d2f8c16bb31c9ceaf23164f
# PUT THIS IN /usr/lib/systemd/system

[Unit]
Description=Jupyter Notebook

[Service]
Type=simple

paulochf

from s3fs.core import S3FileSystem

s3 = S3FileSystem(anon=False, profile_name="your-profile-name")

print(s3.ls("s3://your-bucket/some-folder"))

paulochf

#!/usr/bin/env bash

# Doesn't fix the icon to have the right appearance, but stop the top bar from being ridiculously big.

cd /usr/share/pritunl_client && for f in `ls *svg`; do sudo sed -i -E -e 's/200([ "])/24\1/g' $f; done && cd -

paulochf

paulochf