Avalanche on Google Cloud Delivers High-Speed and Pay-Only-for-What-You-Need By Adam Luciano May 6, 2021 The Actian Avalanche Hybrid Cloud Data Warehouse, with the fastest columnar analytics engine available in the market today, is now generally available on Google Cloud Platform (GCP) via Google Cloud and the Google Marketplace. For organizations that need the flexibility to scale dynamically yet pay only for the resources they need, that want an ultra-fast, MPP columnar database engine capable of delivering faster, deeper analytical insights while making it easier than ever for end users to self-access the data they need to do their jobs, this is big news. If ever you needed a good reason to embrace the power of the cloud, this is it. Google Cloud is the smallest of the big three providers but is growing fast. The experience of building on Google Cloud is hard to beat as well, Google has taken a lot of time in building a great developer experience and we expect given the great experience Actian has had in building on Google, many others will find similar benefits to using Google Cloud to facilitate their movement to the cloud. Use Cases – Where Actian Avalanche on GCP Shines Interest in data analysis only grows as organizations become more sophisticated and seek greater insights—into their customers’ inclinations, the efficiency of their business processes, and their ability to seize short-lived opportunities. Organizations of all sizes, in a wide range of geographies and industries — including financial services, automotive, healthcare, and retail/ecommerce — are taking advantage of the ultra-high performance and scalability that Avalanche on GCP offers right out of the virtual box. Some examples are below: A Fortune 10 financial data services company uses Avalanche on GCP alongside their trading applications to deliver an edge for its customers, enabling them to perform ad hoc analytics on significant amounts of data returning requested results with sub-second response time. A top Western European company in the automotive industry has used Avalanche on GCP to accelerate the delivery — and increase the accuracy — of price quotations for prospects and customers. Data involved in risk assessment, for example, accident reports, driving records, and so forth can change rapidly, so the ability to deliver quotations with up-to-the-moment data provides more accurate risk assessments, delivering a competitive advantage in a highly competitive industry. Service providers in the healthcare claims payment space leverage Avalanche operational analytics to extract insights from high volumes of claim data and provide decision-makers with the most up-to-date data for analytical review to eliminate errors, abuse and fraud. Elsewhere in the healthcare sector, innovative clinical trial service units rely on Avalanche on GCP to analyze large volumes of clinical trial data for patterns and trial performance insights. A leading French retailer relies on the highly performant analytics engine of Avalanche on GCP to increase marketing effectiveness and efficiency. The company’s ability to draw insights more rapidly from its own data enables it to optimize marketing spend and gain a better ROI. Ultra-High Performance GigaOM, a leading independent organization known for benchmarking database performance, recently put Actian Avalanche to the test against competing Cloud products, including AWS Redshift, Snowflake, Azure, and BigQuery. In terms of price/performance, Actian Avalanche beat every one of them. Handily. And you don’t need to take our word for it: Read the full GigaOM Report. So, What’s New About Avalanche? Under the hood, the Avalanche database and integration engines are tried and tested. They have been evolving for years in response to real-world demands. Actian Avalanche on GCP is the latest iteration of this proven platform, and it incorporates not only cutting-edge technological advances, including advances in security and user management. Some of the exciting new features just announced: Separation of Storage and Compute -> Users of Avalanche on GCP can scale compute and storage resources independently and automatically. Google Cloud Storage provides all the storage you need – and you only pay for the storage you need. Google Marketplace Integration -> Forget about complicated and time-consuming scripted installations. Avalanche is now containerized and available directly through Google Marketplace. This has some great benefits, including the ability to subscribe and set up Avalanche on GCP as a managed SaaS offering with just a few clicks. With the ability to procure Avalanche through Google, retirement of Google commits can be used for Avalanche. Google SSO -> Google Account users can gain rapid access to Avalanche on GCP via Google Single Sign On (SSO). Role-based User Management -> Avalanche now provides a GUI-based user management system that enables fine-grained, role-based permission management based on user roles. Avalanche administrators can use SQL to manage even more fine-grained permissions, but the GUI-based management system provides a fast and easy way to set up role-based user profiles. Kubernetes Containerization Management -> All backend Avalanche services are now containerized and managed by the Google Kubernetes Engine (GKE). GKE automatically handles the orchestration and management of its underlying pods/containers, which dramatically accelerates backend service execution. Operations such as deleting a warehouse from Avalanche on GCP can take only seconds—whereas the same operation on AWS or Azure would take minutes. Such optimizations ensure that organizations pay only for what they really need (and don’t prolong resource use unnecessarily). Kubernetes containerization also paves the way for an even better experience in Avalanche where patches/updates/upgrades are concerned. Read more about why Kubernetes is cool here: Take full advantage of the separation of compute and storage resources with Avalanche on GKE Query Result Caching -> Now enabled by default for all warehouses, query result caching accelerates access to insight. After a query is executed against persistent data, its result is placed in cache. If the same query is run again, Avalanche returns the cached result rather than re-running the query. This significantly improves data warehouse performance and frees up resources to support the execution of novel queries. REST API -> A new REST API enables users to load Avalanche warehouses directly. The API has a direct link to the underlying data warehouse engine, thus enabling ultra-fast loads to a warehouse. 1AU Instance Availability -> For testing purposes or those use cases that require only a single node (rather than a multi-node cluster), a single Avalanche Unit (1AU) instance of Actian Avalanche is available on GCP. The 1AU instance includes the full Avalanche feature set, including the recent enhancements described above. Current Features of Avalanche, and a few to come shortly Amidst the excitement about the new features and benefits Actian is announcing with the GA release of Avalanche on GCP, it’s worth stepping back to remember all the other exciting features that have recently been announced—including a robust user interface for managing the lifecycle of data warehouses (now available across Google Cloud, Azure, and AWS). Avalanche also recently saw a refreshed platform UI for its built-in Query Editor—as well as the ability to use multiple tabs, improved methods for viewing information about database tables, and a host of new charting capabilities. While Avalanche on GCP includes pre-installed sample data to help you kick-start the evaluation process, you can also load your own data using out-of-the–box templates designed to connect to data sources such as Salesforce or to data sources on your own desktop such as Excel spreadsheets. Getting data into Avalanche on GCP is easy, as is connecting to Avalanche on GCP from your favorite BI and visualization tools (such as Looker, Tableau, and Power BI) is even easier as Avalanche provides connectivity information directly in the platform. Try out a free trial of Actian Avalanche on GCP today: https://www.actian.com/avalanche-try-now/. Instructions for connecting Looker, Tableau, and Power BI are included with the trial. As mentioned earlier, Avalanche now utilizes Kubernetes in its backend and is a complete re-write of the backend infrastructure. The new backend enables both automation of management functions such as patching and updates while also enabling better utilization of resources. For example, deleting a warehouse in AWS and Azure would take a few minutes, while in Avalanche on Google Cloud, it takes only a few seconds. These small enhancements help our customers better pay for what they actually use. Stay tuned for more updates, as Actian is heavily investing in Avalanche and looking to bring even more great features to the platform very soon. Want to hear more, join our virtual Hybrid Data Conference on May 25th in North American Eastern and May 27th in Central European time zones from 11AM to 4PM, respectively. I’ll go into much of what was briefly touched on above in far more detail along with many of my Actian colleagues. You can find out more information here. About Adam Luciano Adam Luciano is currently Senior Director of Product Management at Actian Corporation. Adam is responsible for management of analytics products inclusive of Avalanche and Vector as well as AI/ML technologies. Adam previously worked at Liberty Mutual Insurance where he built a home grown Data Science Platform. Previous to Liberty Mutual, Adam worked in digital marketing analytics, product management / product marketing in healthcare technology, market research, and investment analytics on Wall Street.