How to optimize Tableau and Google BigQuery
Customers have been using Tableau and Google BigQuery to store and analyze large volumes of data for years. As volumes grow and use cases expand, our engineering team is hard at work to ensure that the technologies work together to continue to exceed the demands of our customers. Optimizing the two technologies together will yield significant performance gains, shorten design cycles, and help people and organizations become more successful.
In the wake of the latest wave of updates from Google BigQuery, we are excited to share the latest version of the Tableau-Google BigQuery Best Practices whitepaper. The goal of this paper is to impart awareness of techniques to optimize data modeling and query formation to maximize the responsiveness of visualizations. It also discusses techniques to get the best cost efficiency when using Tableau and BigQuery together.
This iteration of the whitepaper features a discussion of several new improvements that’ll benefit our customers. Probably the most game-changing one is that BigQuery is moving from BigQuery Language to standard SQL! That’s right, Google BigQuery upgraded its APIs to use standard SQL in addition to BigQuery SQL (now called legacy SQL). And we've upgraded our Google BigQuery connector to support this change and give you a richer analytical experience.
With standard SQL come the following benefits:
- Level of Detail calculations: Now you can leverage Level of Detail calculations directly in BigQuery!
- Faster custom SQL: Validating custom SQL could take several minutes depending on the complexity of the sql statement. Google has released new features that allow us to validate custom SQL in seconds!
- Choice on where to bill your work: After connecting to BigQuery, you have the option to choose which BigQuery project to charge your queries to. This is great if you want to charge database costs of team projects to different departments and programs.
To dive deeper into these best practices, download the whitepaper here.
And if you’re headed to Google Cloud Next in San Francisco, be sure to stop by the Tableau-Google joint session where we’ll share live demonstrations on how Tableau and GBQ work together to drive value in the cloud. We also invite you to visit us on the expo floor to meet with our team and learn how customers like Spotify and The University of Colorado at Denver are using Tableau on GBQ to generate meaningful impact across the enterprise.
관련 스토리
블로그 구독
Tableau에서는 날마다 데이터, 분석 및 비주얼리제이션에 관한 흥미로운 소식을 찾고 있습니다. 블로그에서 그러한 소식을 공유하는 것은 사람들이 자신의 데이터를 보고 이해할 수 있도록 지원한다는 Tableau의 사명에서 매우 중요한 부분입니다. Tableau를 더 효과적으로 사용하는 요령부터 사람들이 일상에서 데이터 관련 문제를 어떻게 해결하는지 모두 찾아볼 수 있는 Tableau 블로그는 데이터 애호가들을 위한 곳입니다.