Skip to content

Instantly share code, notes, and snippets.

View adrianabreu's full-sized avatar

Adrian Abreu adrianabreu

View GitHub Profile
@adrianabreu
adrianabreu / databricks_query_history.py
Last active May 27, 2024 13:43
Build query history table in databricks
import os
import re
from datetime import datetime, timedelta
from pathlib import Path
import json
import requests
start_date = dbutils.widgets.get('start')
end_date = dbutils.widgets.get('end')
@adrianabreu
adrianabreu / reservoir.sc
Created May 26, 2024 17:51
Scala cli script that uses li haoyi ecosystem to fetch the reservoir level from Barcelona's SAU reservoir
//> using scala 2.13.14
//> using dep com.lihaoyi::requests:0.8.2
//> using dep com.lihaoyi::upickle:3.3.1
//> using dep com.lihaoyi::scalasql:0.1.2
//> using dep org.xerial:sqlite-jdbc:3.45.3.0
import java.time.format.DateTimeFormatter
import requests._
import upickle.default.read
INFO [2018-05-03 02:11:35Z]: Starting MonoDevelop 7.5 Preview (7.5)
INFO [2018-05-03 02:11:35Z]: Running on Mono 5.10.1 (makepkg/8eb8f7d5e74 Fri Apr 20 23:19:11 CEST 2018) (64-bit)
INFO [2018-05-03 02:11:35Z]: Operating System: Linux
Linux 4.14.36-1-MANJARO #1 SMP PREEMPT Tue Apr 24 19:16:26 UTC 2018 x86_64
INFO [2018-05-03 02:11:35Z]: Using GTK+ 2.24.32
INFO [2018-05-03 02:11:37Z]: Add-in loaded: MonoDevelop.Core
INFO [2018-05-03 02:11:37Z]: Add-in loaded: MonoDevelop.Ide
WARNING [2018-05-03 02:11:37Z]: No proxy credential provider was found
INFO [2018-05-03 02:11:37Z]: Initializing Runtime Mono 5.10.1
INFO [2018-05-03 02:11:37Z]: [0 (+0)] Finding custom frameworks