Here to bring you the latest news in the Cloud is Debi Cabrera.

Has your data team outgrown its on-premise traditional data warehouse? Are you looking for a system to store data that is secure, scalable, and cost effective? In this episode of Architecting with Google Cloud, Priyanka Vergadia speaks with Gary Morreale, the Director of Data Services from Independence Blue Cross about how his team migrated from Terradata to Bigquery on Google Cloud Platform. Listen as Gary Morreale discusses his team’s giant undertaking on migrating dataware to BigQuery.

Have you ever been asked to prepare a slide deck containing many data points? Maybe you sifted through the data yourself along with copying and pasting the data over and over again—talk about a huge time commitment. In this video, Leigha Jarett discusses how you can use Google Apps Scripts to automate data-driven slide development and save yourself a lot of time.

Want to ensure that your BigQuery environment stays cost effective and secure? In this episode of BigQuery Spotlight, we’ll examine how monitoring your data warehouse can optimize costs, help you pinpoint which queries need to be optimized, and audit both data-sharing and access. Watch to learn how BigQuery gives you the flexibility to export any of these data sources back into your data warehouse for custom reporting.

Want to become more scalable with programmatic data workflows? In this episode of BigQuery Spotlight, we’ll examine BigQuery APIs so you can manage data warehousing resources, and take action on your data, programmatically and effectively.

Data harnessed through tools such as BigQuery allow organizations to deliver personalized experiences, make data-driven business decisions, and unlock new streams of revenue. In this video, we go through the challenges of putting data into action and show how APIs can help. Watch to learn how Apigee makes it simple and easy to package your business data as APIs!

Want everyone in your organization to be able to easily find the data they need, while minimizing overall risk, and ensuring regulatory compliance? In this episode of BigQuery Spotlight, we’ll examine BigQuery data governance so you can ensure your data is secure. We’ll also go over Cloud Data Loss Prevention and an open-source framework for data quality validation.

Did you know that optimizing SQL queries can be cost efficient? In this episode of BigQuery Spotlight, we speak to some strategies for optimizing your BigQuery queries. We’ll walk through what happens behind the scenes for more complex queries, and show you specific tactics you can use to optimize your SQL. Watch to learn some great techniques on how to make your queries more performant!

How does BigQuery’s internal storage work? In this episode of BigQuery Spotlight, we share how BigQuery stores data so you can make informed decisions on how to optimize your BigQuery storage. We’ll also talk about partitioning, as well as clustering and how it allows for efficient lookups.

What are jobs in BigQuery and how does the reservation model work? In this episode of BigQuery Spotlight, we’ll review jobs, reservations, and best practices for managing workload in BigQuery. We’ll also walk you through the difference between BI Engine reservations and standard reservations, so you can decide what will work best for you.