목록Python/Python ETC (57)

달나라 노트

Python psycopg2 : access redshift and run query using python, python으로 redshift에서 쿼리 돌리기

import psycopg2 import pandas as pd def query_runner(query): dbname = 'sandbox' host = 'test_host' port = 1111 # port_number user_id = 'redshift_user_id' password = 'redshift_user_name' connection_info = "dbname='{}' host='{}' port={} user='{}' password='{}'".format(dbname, host, port, user_id, password) connection = psycopg2.connect(connection_info) cursor = connection.cursor() cursor.execute(q..
Python/Python ETC 2020. 12. 23. 00:20
Prev 1 ··· 12 13 14 15 Next