Qwiklabs - Merging Results from Different Explores in Looker [GSP856] | Google Cloud Platform Demo
#Qwiklabs #googlecloudplatform #GCP
Qwiklabs - Merging Results from Different Explores in Looker [GSP856] | Google Cloud Platform Demo
Explores in Looker are designed by your Looker developers to combine the data from your database tables in the best way, using defined relationships between data fields and tables. Because of this, it is best to use a single Explore to examine your data.
However, there may be times when your Looker developers haven’t created the relationships you need, or they faced technical limitations. In these cases, Looker lets you combine data from different Explores (even from different models or projects) to create data tables and visualizations.
Using the Merged Results feature, you can create a query from an Explore and then add queries from other Explores to display the merged results in a single table. From there, you can examine the data, pivot fields, and create visualizations.
The Merged Results feature has a limit of 5,000 rows of data for each of the merged queries. If you include queries that return more than 5,000 rows of data, only the first 5,000 rows returned are included in the merged results.
When you merge queries, you start out by creating a single query from a single Explore, and then you combine other queries with that first query.
By default, that first query is considered the primary query. This is an important concept because when Looker matches the data to create the merged results, it matches each added query to the primary query (not to any other added query). So, whenever you add a query, you need to include a dimension that can be matched to a dimension in the primary query.
To understand more about merged results, please see documentation about merged results.
Objectives
In this lab, you learn how to merge results from different explores by doing the following:
Create a primary query and a next source query
Check merge results and run a merge
Edit the merged results
Save your merged results to a dashboard
My Presentation
https://docs.google.com/presentation/d/1Z5NIQlKg5fPJwCp8nioFVr0hROukSh_hNmHZIzGrF00/edit#slide=id.g100d8305ea6_0_0
Qwiklabs:
https://www.qwiklabs.com/focuses/17881?locale=en&parent=catalog
Subscribe to Latest Technologies → https://www.youtube.com/channel/UCEcagvWisJq2Bnk4r309lCw
Видео Qwiklabs - Merging Results from Different Explores in Looker [GSP856] | Google Cloud Platform Demo канала Latest Technologies
Qwiklabs - Merging Results from Different Explores in Looker [GSP856] | Google Cloud Platform Demo
Explores in Looker are designed by your Looker developers to combine the data from your database tables in the best way, using defined relationships between data fields and tables. Because of this, it is best to use a single Explore to examine your data.
However, there may be times when your Looker developers haven’t created the relationships you need, or they faced technical limitations. In these cases, Looker lets you combine data from different Explores (even from different models or projects) to create data tables and visualizations.
Using the Merged Results feature, you can create a query from an Explore and then add queries from other Explores to display the merged results in a single table. From there, you can examine the data, pivot fields, and create visualizations.
The Merged Results feature has a limit of 5,000 rows of data for each of the merged queries. If you include queries that return more than 5,000 rows of data, only the first 5,000 rows returned are included in the merged results.
When you merge queries, you start out by creating a single query from a single Explore, and then you combine other queries with that first query.
By default, that first query is considered the primary query. This is an important concept because when Looker matches the data to create the merged results, it matches each added query to the primary query (not to any other added query). So, whenever you add a query, you need to include a dimension that can be matched to a dimension in the primary query.
To understand more about merged results, please see documentation about merged results.
Objectives
In this lab, you learn how to merge results from different explores by doing the following:
Create a primary query and a next source query
Check merge results and run a merge
Edit the merged results
Save your merged results to a dashboard
My Presentation
https://docs.google.com/presentation/d/1Z5NIQlKg5fPJwCp8nioFVr0hROukSh_hNmHZIzGrF00/edit#slide=id.g100d8305ea6_0_0
Qwiklabs:
https://www.qwiklabs.com/focuses/17881?locale=en&parent=catalog
Subscribe to Latest Technologies → https://www.youtube.com/channel/UCEcagvWisJq2Bnk4r309lCw
Видео Qwiklabs - Merging Results from Different Explores in Looker [GSP856] | Google Cloud Platform Demo канала Latest Technologies
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
#cloud#google Google Cloud Storage Demo via console Google Cloud Platform for Beginners 2021 -Qwiklabs - Exploring Your Ecommerce Dataset with SQL in Google BigQuery [GSP407] | GCP Free Credits#cloud#GCP Google Compute Engine Modifying VM (Part 5) | Google Cloud Platform for Beginners 2021#cloud#GCP Google Cloud Datalab Demo Using commands | Google Cloud Platform for Beginners 2021#cloud#GCP Cloud Pub/Sub Demo Using commands (Part 3) | Google Cloud Platform for Beginners 2021Google Cloud Platform Certification Exam Model Questions with Answers 2021 | Associate Cloud Eng#cloud#GCP Google Cloud Functions Concepts (Part 1) | Google Cloud Platform for Beginners 2021Google Cloud Data Fusion Concepts | Google Cloud Platform | Cloud Data Fusion instance#cloud#google Google App Engine Demo (Part 2) | Google Cloud Platform for Beginners 2021Qwiklabs - Creating a Modeled Query and Working with Quick Start [GSP984] | GCP Demo Free CreditsGoogle VPC Demo - Auto Mode & Custom Mode (Part 3)#cloud#google Google BigQuery (Part 1) Google Cloud Platform for Beginners 2021#cloud#GCP Google Cloud Dataflow Demo (Part 3) | Google Cloud Platform for Beginners 2021#cloud#GCP Cloud Dataproc Demo using console (Part 2) | Google Cloud Platform for Beginners 2021Google Cloud Anthos Concepts | Google Cloud Platform#GCP Launching website using Automation Script (Part 4) | Google Cloud Platform for Beginners 2021Installing Terraform Latest Version(v1.1.5) on Google Cloud Platform on Cloud Shell#cloud Storage Transfer Service for cloud data (Part 1) | Google Cloud Platform for Beginners 2021Associate Google Cloud Engineer Sample Questions with answers | Google Cloud Platform Certification#cloud Storage Transfer Service Demo (Part 3) | Google Cloud Platform for Beginners 2021