search

Accenture-Data-Engineer / Trabalho-final-grupo2

1 stars 3 forks source link

Conexão com BD #1

Open jonesamandajones opened 1 year ago

jonesamandajones commented 1 year ago

instalar o pyodbc:

sudo su curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add -

curl https://packages.microsoft.com/config/ubuntu/$(lsb_release -rs)/prod.list > /etc/apt/sources.list.d/mssql-release.list

exit

sudo apt-get update

sudo ACCEPT_EULA=Y apt-get install -y msodbcsql18

optional: for bcp and sqlcmd sudo ACCEPT_EULA=Y apt-get install -y mssql-tools18 echo 'export PATH="$PATH:/opt/mssql-tools18/bin"' >> ~/.bashrc source ~/.bashrc

optional: for unixODBC development headers sudo apt-get install -y unixodbc-dev

jonesamandajones commented 1 year ago

import pyodbc import pandas as pd

server = # datalake database = # bd username = # usuario do bd password = # senha

cnxn = pyodbc.connect('DRIVER={ODBC Driver 18 for SQL Server};SERVER='+server+';DATABASE='+database+';ENCRYPT=yes;UID='+username+';PWD='+ password) cursor = cnxn.cursor()

'''Sample select query cursor.execute("SELECT * from clientes;") row = cursor.fetchall() while row: print(row) row = cursor.fetchone() '''