chunked_db_query.py

q = text(
        '''
        SELECT *
        FROM "facebook-timeline" ft
        LIMIT 10000
        '''
        )
df = pd.DataFrame()

for idx, chunk in enumerate(
                        pd.read_sql_query(q, con=db.engine,
                        chunksize=1000
                      ), start=1):
    
    print (f"Retrieving chunk {idx}")    
    df = df.append(chunk)
    
print("Complete")