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()