Extract tables using Python with embedded SQL script

[MichaelBealATSU]

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?

[LeventeHunyadi]

If you are in the Python domain, I would recommend checking out the official DAP client library. This library, written in Python, interacts with the DAP API to fetch data. Specifically, you can run a snapshot or incremental query, and persist the result in CSV (or the more flexible but still tabular TSV) with a few lines of code. Relevant functions are in the module dap.api.