Skip to content

Instantly share code, notes, and snippets.

@lppier

lppier/connect_to_aws_rds_via_python_pyodbc.py

Created January 23, 2019 06:41
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save lppier/e3341f288c71e764962963436b3db260 to your computer and use it in GitHub Desktop.
Save lppier/e3341f288c71e764962963436b3db260 to your computer and use it in GitHub Desktop.
Download ZIP
pyodbc
Raw
connect_to_aws_rds_via_python_pyodbc.py
import pyodbc
import pandas as pd
# https://docs.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server?view=sql-server-2017
conn = pyodbc.connect(
r'DRIVER={ODBC Driver 17 for SQL Server};'
r'SERVER=mydbinstance.cazdl38iyoz0.ap-southeast-1.rds.amazonaws.com;'
r'DATABASE=testdb;'
r'UID=pier;'
r'PWD=password;'
)
sql = "SELECT TOP (1000) [PersonID], [LastName], [City] FROM[testdb].[dbo].[Persons]"
df = pd.read_sql(sql, conn)
conn.close()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment