Skip to content

v0.9 - Postgres, BigQuery Copy, VAN Upload Saved Lists

Compare
Choose a tag to compare
@jburchard jburchard released this 22 Dec 20:03
3e65128

Feature Additions

  • New Postgres Class
    • Postgres.copy() - Copy tables to Postgres
    • Postgres.query() - Query Postgres DB
  • GoogleBigQuery.copy() - Copy tables to BigQuery
  • VAN.upload_saved_list() - Upload saved lists to VAN.
  • ActionKit.create_generic_action() - Post a generic action.
  • Parsons Tables are now displayed in a pretty manner in Jupyter Notebook, similar to Pandas dataframes.
  • Redshift.alter_column_widths() - Method to auto-widen a Redshift table to match the width of a Parsons table. This is useful when trying to append data to an existing table.

Small Enhancements

  • GoogleSheets.append_to_sheet() and GoogleSheets.overwrite_sheet() now allow you to pass in formulas.
  • VAN.get_person(), VAN.get_event(), VAN.get_event() now return more fields.
  • Table.to_s3_csv() now have ability to specify access control to uploaded file.
  • GoogleCloudStorage.download_blob() no longer requires that the user be permissioned on the bucket.

Small Fixes

  • Improved documentation.
  • Bug fixes for Slack, Table and Airtable, Redshift
  • Improved Slack error handling
  • Improved contributors.md documentation.
  • Improved logging.
  • Updated dependencies.