Skip to content

Instantly share code, notes, and snippets.

View octavian-zarzu's full-sized avatar

Octavian Zarzu octavian-zarzu

View GitHub Profile
import collections
import csv
import dataclasses
import datetime
import io
import itertools
import logging
import os
import json
import random
import collections
import csv
import dataclasses
import datetime
import io
import itertools
import logging
import os
import json
import random
CREATE EXTERNAL TABLE ex_nyc_phil (
raw_data TEXT
)
URL = 's3://<your_bucket>/'
OBJECT_PATTERN = '*.json'
TYPE = (JSON PARSE_AS_TEXT = 'TRUE');
@octavian-zarzu
octavian-zarzu / app.py
Created March 31, 2023 17:45
Streamlit app code - db: Firebolt
import os
from dotenv import load_dotenv
from firebolt.client.auth import UsernamePassword
from firebolt.db import connect
import streamlit as st
import altair as alt
import pandas as pd
import matplotlib.pyplot as plt