Skip to content

Instantly share code, notes, and snippets.

View elcolumbio's full-sized avatar

Florian Benkö elcolumbio

View GitHub Profile
@kriwil
kriwil / hello_pyodbc.py
Last active June 11, 2021 16:24 — forked from rduplain/README.md
ubuntu connect to mssql server using pyodbc
"Proof connection at pyodbc level."
# Test pyodbc connection. Result is 42.
# Note parameters in connection string, <PARAMETER>.
import pyodbc
conn = pyodbc.connect('DRIVER=FreeTDS;SERVER=<IP_OR_HOSTNAME>;PORT=1433;DATABASE=<DATABASE_NAME>;UID=<USERNAME>;PWD=<PASSWORD>;TDS_Version=8.0;')
cursor = conn.cursor()
for row in cursor.execute('select 6 * 7 as [Result];'):
@tonywhittaker
tonywhittaker / Query Copy Example.py
Last active February 24, 2022 02:01
Move data from MSSQL to Redshift with Luigi
class SomeExport(luigi.Task):
date = luigi.DateParameter(default=datetime.date.today())
def output(self):
return luigi.s3.S3Target(self.date.strftime('s3://mybucket/%Y%m%d.txt.gz'))
def requires(self):
return None
def run(self):