pandas.read_sql() mssql

TN TN answered on July 30, 2022 Popularity 10/10 Helpfulness 5/10

answer pandas.read_sql() mssql

pandas.read_sql() mssql

Comment

import pandas as pd
from sqlalchemy import create_engine
import pyodbc

def mssql_engine(user = os.getenv('user'), password = os.getenv('password')
                 ,host = os.getenv('SERVER_ADDRESS'),db = os.getenv('DATABASE')):
    engine = create_engine(f'mssql+pyodbc://{user}:{password}@{host}/{db}?driver=SQL+Server')
    return engine

query = 'SELECT * FROM [Orders]'
df = pd.read_sql(query, mssql_engine())

Popularity 10/10 Helpfulness 5/10 Language python

Source: stackoverflow.com

Tags: python

Link to this answer
Share Copy Link

Contributed on Jul 30 2022

TN TN

0 Answers Avg Quality 2/10

pandas.read_sql() mssql

Contents

More Related Answers

pandas.read_sql() mssql

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.