Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Which Module
#1
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?
Reply
#2
I'm not much of a microsoft user, but the following looks promising: https://docs.microsoft.com/en-us/sql/rel...rver-ver15
Reply


Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020