Dec-08-2022, 08:31 PM
mg24 Wrote:1) is sqlite3 Support for extracting data from Microsoft SQL Server.[/b]No, sqlite3 is only for sqlite database.
I don't use SQL Server, but connection should be similar.
mg24 Wrote:2) I want to extract sql data in chunk size , Want to avoid memory full issue. SQL Tables are big in Big in sizesee: https://stackoverflow.com/a/29522443
mg24 Wrote:3) I want data to be written in CSV with delimiter "|"pandas calls the delimiter 'sep' so look for this in the docs.
https://pandas.pydata.org/pandas-docs/st...o_csv.html
change:
df.to_csv('output.csv', index=False)
to:
df.to_csv('output.csv', sep='|', index=False)