Dec-28-2020, 11:31 PM
I'm trying to extract bulk data from Teradata to a text file
I used teradata and csv module, but there seems to be a limitation for extracting millions of records
I can see sqlalchemy is another option to extract data, but I don't need to use pandas
I tried using teradatasql with a sample of fastexport module, but I get an error stating "OSError: [WinError 1114] A dynamic link library (DLL) initialization routine failed"
Any other modules? or at least a module like importing csv, but which can extract data from a sql server as bulk?
I used teradata and csv module, but there seems to be a limitation for extracting millions of records
I can see sqlalchemy is another option to extract data, but I don't need to use pandas
I tried using teradatasql with a sample of fastexport module, but I get an error stating "OSError: [WinError 1114] A dynamic link library (DLL) initialization routine failed"
Any other modules? or at least a module like importing csv, but which can extract data from a sql server as bulk?