Connect to SQL server with python using sqlalchemy

This video shows how to establish connection between SQL server and python (Jupyter Notebook) using SQLAlchemy, extract the data, perform data manipulation and append the data to the table in SQL server database.

Prerequisite:
Microsoft SQL Server 2017 or later
Microsoft SQL Server Management Studio 18
Python 3.6.5

[ajinkyaponkshe]

what will be parameters for username and password if I have Windows Authentication to connect to the server,

[CaribouDataScience]

Fantastic! This was what I was working for!!

[Sheriff_Bones]

how did u get the information(server, database, driver, database connection

[rajathrshettigar]

Thanks for the video.It heps me lot and saved my time

[narveersingh]

Thanks for this man. Very well explained.

[devenshah]

Hi Vrajesh,

I have following code using sql server. Connection and data pull works perfectly but when I try using it with column names throwing an error of column header:

How can I modify it to include column headers from sql server

Exception has occurred: TypeError
'NoneType' object is not iterable
File "C:\temp\pythonCS50\list.py", line 29, in <module> columns = [column[0] for column in cursor.description]
.description]


def main():
flights=cursor.execute('''
SET NOCOUNT ON;
SELECT * FROM [PythonCS50].[dbo].[flights]
''')
for flight in flights:
print(flight)
print(f"{flights.origin_id} to {flights.destination_id}, duration {flights.duration} minutes.")

Obviously, your presentation is great and everything works as you demonstrated.

[matheusmoraes]

Great video. I have this huge database with lots of foreign keys, when I put df.to_sql it keeps deleting all of the FKs. How can I commit without losing the structure?

[devenshah]

All the flight data does get printed using print(flight).

[saravanakumar]

Hi, indeed it was a great video. Can we be able to create the table without SQL server (Just using SQL Alchemy)

[dikshyakasaju]

Getting the error: InterfaceError: (pyodbc.InterfaceError) ('28000', '[28000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Login failed for user


Although i followed the same exact steps

[contabilidad_del_futuro]

great video, how can I connect to a huge sql server database to not have memory error ?Do i have to add something like chunksize?

[wilianuhlmann]

Hi my brother
How to use inner joins?