Google BigQuery, a service for performing real-time analytics on your data, launched several exciting new features this morning. Part of the release is a new feature which enables you to import data from Google's experimental Datastore backup tool directly into BigQuery for analysis.
Also, Google is opening up this capability to a small group of trusted testers - if interested you sign up here.Here are the features launches today:
- Support for JSON lets you import data formatted in JSON directly to BigQuery without the hassle of writing extra code to convert the data format. "JSON is used to power most modern websites, is a native format for many NoSQL databases hosting large scale web applications, and is used as the primary data format in many REST APIs."
- Nested and Repeated Fields: If you're using App Engine Datastore or other NoSQL databases, it's likely you're taking advantage of nested and repeated data in your data model. For example, "a customer data entity might have multiple accounts, each storing a list of invoices. Now, instead of having to flatten that data, you can keep your data in a hierarchical format when you import to BigQuery," Google explains.
- Additional improvements:
- "Increased import quotas from 1000 jobs per day to 1000 jobs per table per day, and boosted the file size limit from 4GB to 100GB
- Faster data exports from BigQuery to Google Cloud Storage, by enabling large tables to be exported as multiple files in parallel
- Permanently save common queries in the BigQuery interfac," informs Google.
Gmail Advanced Labs Management of the administrator control panel now available to Google Apps, Google Apps for Business, Government and Education -- allows Apps admins to better control Gmail Labs.
"Gmail Labs are experimental, optional features of Gmail, and continue to be, even with these new advanced controls. They may change, break, or disappear at any time. Gmail Labs can also sometimes be "graduated" into full-fledged features, at which point they may cease to be optional or controllable."
Each lab can be individually:
- Enabled: The Lab is enabled for all users in the domain; users are not able to disable it
- Allowed: Users are allowed to enable the lab for their own account
- Disabled: Users are not allowed to enable the lab for their own account
In another blog post, Google also shared a few Google Doc templates created to help you stay organized and communicate with your donors, volunteers and team members.
- Donor thank-you cards: Remind your supporters that their contributions make a difference. You can print these cards, fold in half, and include a personal greeting inside. Use with the 'Donor Mailing Labels' template (below) to print out fun address labels for your envelopes.
- Donor mailing labels: Add your donors' names and addresses and print these out using label paper for encouraging and decorative mailing labels.
- Event invitations: Add your event details to this template and email to your supporters.
- Event RSVP: Stay organized by collecting RSVPs for your event online. Embed this form or email it to your invitees. Guests simply fill out the form with their information. Best of all, your attendee list will be organized in one spot, a Google Spreadsheet.
- Newsletter templates: Email newsletters are a great way to stay in touch with your supporters and donors. Whether you send weekly, monthly or quarterly newsletters, be sure to include breaking news about your organization and give supporters a peek inside the operations, with volunteer anecdotes and a note from your leader. Check following templates: here, here or here.