PART 1: Analyze Cloud Logging logsTask 1: Open BigQueryTask 2: Create a datasetSELECT current_date Task 4: Set up log export from Cloud Logging Look for the entry that contains the word "jobcompleted". Create Sink Task 5: Run example queries   bq query --location=us --use_legacy_sql=false --use_cache=false \'SELECT fullName, AVG(CL.numberOfYears) avgyears FROM `qwiklabs-resources.qlbqsamples.per..

Task 1. Open BigQuery테스트 랩이라 이미 데이터셋 및 테이블이 작성되어있음 쿼리문에 쿼리 작성SELECT Events.playerId, (Players.firstName || ' ' || Players.lastName) AS playerName, SUM(IF(Tags2Name.Label = 'assist', 1, 0)) AS numAssistsFROM `soccer.events` Events, Events.tags TagsLEFT JOIN `soccer.tags2name` Tags2Name ON   Tags.id = Tags2Name.TagLEFT JOIN `soccer.players` Players ON   Events.playerId = Players.wyIdGROUP BY playe..

Task 1. Set the default region and zone for all resourcesgcloud config set compute/zone us-central1-agcloud config set compute/region us-central1 Task 2. Create multiple web server instancesgcloud compute instance-templates create nginx-template \         --metadata-from-file startup-script=startup.sh gcloud compute target-pools create nginx-pool   gcloud compute instance-groups managed create n..

Task 1. Locate your dataset and table in BigQuery   Task 2. Examine the billing dataTask 3. Analyze data using SQL queries  Query 1: Analyze your data based on costs SELECT * FROM `billing_dataset.enterprise_billing` WHERE Cost > 0 billing_dataset.enterprise_billing 테이블에서 비용(Cost)이 0보다 큰 모든 레코드를 조회  SELECT project.name as Project_Name, service.description as Service, location.country as Country,..

Task 1. Configuring Service Directory   Task 2. Configuring a Service Directory DNS zoneYou can create a Service Directory zone that allows your Google Cloud-based services to query your Service Directory namespace via DNS.DNS queries for the following record types are supported:A/AAAA/SRV records for a service or an endpointSOA/NS records for the private zone originA/AAAA queries must observe t..

Activate Cloud Shell gcloud auth list​gcloud config list project​gcloud config set compute/region us-west2   Task 1. Create and manage service accounts​ ​ gcloud iam service-accounts create my-sa-123 --display-name "my service account"  gcloud projects add-iam-policy-binding $DEVSHELL_PROJECT_ID \    --member serviceAccount:my-sa-123@$DEVSHELL_PROJECT_ID.iam.gserviceaccount.com --role roles/edit..