Skip to content

Instantly share code, notes, and snippets.

@ilkkapeltola
ilkkapeltola / athena_boto3.py
Last active July 17, 2024 04:31
query Athena using boto3
import boto3
import pandas as pd
import io
import re
import time
params = {
'region': 'eu-central-1',
'database': 'databasename',
'bucket': 'your-bucket-name',
@ilkkapeltola
ilkkapeltola / launch_hue.py
Last active May 29, 2018 11:41
Launch Hue in a sandbox
import os
import configparser
import platform
import json
import subprocess as sp
import tempfile
config = configparser.ConfigParser()
config.read('config.ini')
settings = config['DEFAULT']
from apiclient.discovery import build
from oauth2client.service_account import ServiceAccountCredentials
import pandas as pd
import datetime
#SCOPES = ['https://www.googleapis.com/auth/analytics.readonly']
SCOPES = []
KEY_FILE_LOCATION = './path-to-your-private-key-file.json'
VIEW_ID = '123456789'