ezoic

Friday, January 5, 2018

connect python to redshift

connect python to redshift

import psycopg2
import os
import pandas as pd
import operator
import re
from sqlalchemy import create_engine
import numpy as np

engine = create_engine(postgresql+psycopg2://USername:Password@analytics-rs.cmt1xypzh9sm.us-west-1.redshift.amazonaws.com:5439/consumerdata')

campaign_table = pd.read_sql_query("select * from stg.dcm2_campaigns",engine)

campaign_table[:20]


looking for a man

 I am a mid aged woman. I live in southern california.  I was born in 1980. I do not have any kid. no compliacted dating.  I am looking for ...