Ever Upward
For this task, I would like get data from my database & output to an Excel workbook. The first page of the workbook will contain the output from a query. The second page will contain aggregated data. In the following
I’m very excited about these 6 lines of code. Using Airflow Hooks & Pandas Dataframes, I am able to export the contents of a database table to a CSV file in an AWS S3 bucket. Also, by using StringIO, the
This exercise is similar to Experiment 1, but with a bit more complexity. Once again, I am creating an SSIS package & then replicating the functionality using Python for a PostgreSQL database. In Experiment 1, the task was to read
As a fun exercise, I decided to create an SSIS package & then replicate the functionality using Python for a PostgreSQL database. I had a lot of fun with this. While the packages perform fairly simple operations, there were some
This site is a collection of helpful code.