Extract tables using Python with embedded SQL script

MichaelBealATSU
Community Member

Full transparency, I am a SQL DBA.  My predecessor has created a Python script with an embedded SQL script to extract data from numerous tables and saved the data to a CSV file.  This is being done weekly from CD1 but now that CD1 is going away it needs to be replicated to accommodate the new table structure in CD2 and frequency by which the data can be accessed (reportedly 4 hour increments).  Oh, and I know nothing of Canvas GUI, Postman, etc.

Recently, with the help of other colleagues, we have successfully connected to CD2 using Postman but I cannot yet see the relevance unless we are running one off requests?

I can provide the existing Python script with the revised table/field naming for the embedded SQL script but I am completely lost.  Anyone care to offer a bull in the unlit China shop a flashlight?

Users who also had this question