Tag: data table

You can directly link to SQL Server to get a query table using following code.

1. Using a query file (*.sql)

import pyodbc
import pandas as pd

server = "your server name" 
database = "your database name"

conn = pyodbc.connect(DRIVER='{SQL Server}', host = server, DATABASE = database, Trusted_connection='yes')

sql = open("./your query file.sql", "r")

df = pd.read_sql_query(sql.read(), conn)

print(df)

2. Using a query inside python codes

import pyodbc
import pandas as pd
   
conn_str = (
        r'Driver=SQL Server;'
        r'Server=your server name;'
        r'Database=your database name;'
        r'Trusted_Connection=yes;'
        )
cnxn = pyodbc.connect(conn_str)

query = """

    # Enter your query here like below

    # SELECT *
    # FROM your table name


    """

df = pd.read_sql(query, cnxn)

print(df)