v0.8.1 - New BigQuery and Twilio connectors, VAN features and bug fixes
BigQuery
A new connector that allows you to query BigQuery databases. Future releases will include the ability to copy data into BigQuery.
BigQuery.query()
Twilio
A new connector allows you to access account usage and messages that you have sent from your account.
Twilio.get_messages()
Twilio.get_account()
Twilio.get_accounts()
Twilio.get_account_usage()
VAN
VAN.upload_scores()
- New method that significantly simplifies the loading and approving of scores to VAN.- Various bug fixes to improve the stability of the connector. Under the hood, all of the connectors have been refactored to make the code more rational and the responses more standardized.
Table
Table.first
is a new attribute that returns the first value in a Parsons table. This is useful for database queries that only return a single value and keeps you from having to index the table directly.
tbl = rs.query("select count(*) from schema.table")
tbl.first
>>> 10
my_count = rs.query("select count(*) from schema.table").first
>>> 10
Table.from_csv()
Improved the error handling with this to raise an exception if you are trying to load in any empty CSV file.
Windows Usage
There was a bug in the handling of temporary files which prohibited Windows users from running many Parsons methods. This has been resolved.