simple_psycopg2_connect.py

import psycopg2 as pg
# import pymysql

query = """
SELECT 
report_campaign_id,
SUM(impressions) 
FROM
adobe_data.dat_daily_pivot
WHERE 
segment='ALL' 
AND sample_start_date = CURRENT_DATE -1 
GROUP BY 1
"""

conn = pg.connect("host=comcast.digitas.com user=gthomson password=<password> dbname=com_db")
cur = conn.cursor()
cur.execute(query)

results = cur.fetchall()
results = [list(row) for row in results]

conn.commit()
conn.close()