We are pleased to announce the release of Analytics Canvas Version 3.5.0! In this release we've dramatically increased the limits on the size of Data Studio datasets, introduced append and incremental load functionality to Data Studio exports, and prepared Canvas Desktop for the introduction of Analytics Canvas Online.
Append + Incremental Load = 2 Billion Rows in Google Data Studio!
As Data Studio evolved, Canvas kept pace, updating the connector to use BigQuery and Data Studio Advanced Services to significantly increase performance and increase the size of datasets.
Today we’re upping that limit even more to a level way beyond what most people need: 2 Billion rows! That’s right, there's no longer a GB limit and effectively no limit on number of rows. Throw all your data at Data Studio and watch it process with incredible speed.
If your desktop or server can’t handle the initial load, you can now upload in batches using the same Append features available for other database connectors in Analytics Canvas. For example with a very large dataset, you might do the initial load in monthly increments so that no single load is too big. If you’re into gardening, think of it as using a wheelbarrow to move soil from point A to point B in a series of steps instead of a dump truck doing it all at once.
You can also do a date-based incremental load. This means that you can first remove data from the table that matches a given time period before writing new data back in. This is especially helpful for web-analytics, advertising, and sales data that can be reprocessed within 1 or more days depending on the service. If you’re simply appending only the last day of data each day, you will be constantly falling out of sync with the original data source! Canvas now makes it easier than ever to account for that reprocessing and keep your Google Data Studio datasets up to date.
Read more about to get all your data and exceptional performance in Google Data Studio.
Analytics Canvas Cloud Datasets for Analytics Canvas Online
In March at SheetsCon 2020 we announced the upcoming release of Analytics Canvas Online! This new, Cloud Edition aims to make Canvas more accessible to more analysts across devices and operating systems.
Perhaps the most exciting part about being in the cloud is that processing can be handled centrally in a way that is both highly scalable and very affordable.
However, to work with data in Analytics Canvas Online, we first need to get data up into BigQuery where the processing can take place. Many of our enterprise customers have struggled with this as their data often lives behind firewalls and in databases that cannot be easily accessed remotely.
To solve for this, and to give customers a way to get data from the connectors exclusively in the Desktop Edition, we have introduced a new connector for publishing data from Analytics Canvas Desktop to Analytics Canvas Online. It allows users to bring internal data into the Desktop Edition where they can mask or filter out sensitive data before publishing the dataset to the Online Edition.
Once the data is accessible in the Online edition, it’s game on – any authorized user can access that dataset from their browser by simply logging-in. Better still, they can process that data, huge amounts of it, without writing a single line of SQL! Instead, Analytics Canvas Online provides many of the same expressions that analysts are used to seeing in Excel and Google Sheets. Simply type out the expression and Canvas will generate the equivalent SQL.
Data Limits? What Data Limits?
Since the introduction of our 64bit version for Desktop and Server, users have been able to process as much data as their machines could handle. However, processing large datasets often comes at the cost of system performance. If a machine has only 4GB or 8GB of RAM and lots of memory intensive programs running (like Chrome and Outlook), holding more than 10 million rows in a Canvas can really slow things down.
With Canvas Online, powered by BigQuery, you can load hundreds of billions of rows and process them at the speed of BigQuery. And don't worry too much about runaway BigQuery costs - there are a host of quota controls to ensure that doesn't happen!
The new Analytics Canvas Cloud Data Set connector is activated and available in the Desktop when you have enrolled in a trial of Online or have been accepted into the Private Beta Program.
Get Analytics Canvas Version 3.5
If you’re an existing user of Analytics Canvas, simply uninstall your current version through the Windows Control Panel, then download and install the latest version. All of your settings and authorizations will remain in-tact.
If you’re new to Analytics Canvas, sign-up to get your full featured, 30 day free trial. It even includes a generous cloud quota to ensure you can conduct a complete and thorough evaluation.
We’re here to help you get started with Canvas or with any of the new features. Email firstname.lastname@example.org with your questions or use our meeting planner to request a support call.