I have large sets of data in s3. In my Python glue job, I will be extracting data from those files in the form of a pandas data frame and apply necessary transformations on the data frame and then load it into Microsoft SQL database using PYMSSQL library. The final data frame contains an average of 100-200K rows and 180
Tag: pymssql
Is it possible to write a python list into a database with pymssql?
I am tyring to write a python list via pymssql into a database table. I am aiming to write each list entry into a different row of the same column. When trying this I am getting the error: ValueError: ‘params’ arg () can be only a tuple or a dictionary. Is there a way with pymssql or should I use
ImportError: No module named _mssql
I’m running Python 2.7.2 on OS 10.8.5 Trying to use pymssql, but I get the following error: I’ve tried installing mssql with pip and brew only to be told that there’s no package by that name. The docs don’t seem to cover installation. EDIT: When I try to pip install pymssql I get: So I try brew install freetds and