Cloud SQL for PostgreSQL 인스턴스에 앱 연결(애플리케이션이 데이터베이스에 쓰고 읽을 수 있는지 확인) Task 1. Initialize APIs and create a Cloud IAM service account1.In Cloud Shell, run the following command to enable the Artifact Registry API:gcloud services enable artifactregistry.googleapis.com Create a Service Account for Cloud SQL1.In Cloud Shell, create a Service Account and bind it to the Cloud SQL admin role in the lab p..

Task 1. Prepare the source database for migration sudo apt install postgresql-13-pglogical sudo su - postgres -c "gsutil cp gs://cloud-training/gsp918/pg_hba_append.conf ."sudo su - postgres -c "gsutil cp gs://cloud-training/gsp918/postgresql_append.conf ."sudo su - postgres -c "cat pg_hba_append.conf >> /etc/postgresql/13/main/pg_hba.conf"sudo su - postgres -c "cat postgresql_append.conf >> /et..

'다른 리전에서 bigquery 테이블을 복사하기' 인데 composer에 대해 공부하고 싶어서 수행했다. Task 1. Create a Cloud Composer environment  수행 과제 :Click the dropdown for Show Advanced Configuration and select Airflow database zone as us-east4-b. Task 2. Create Cloud Storage bucketscomposer 생성시 자동으로 storage 생성됨 Create a bucket in US Create a bucket in EU  Task 3. Create the BigQuery destination dataset Task 4. Airflow and core con..

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..

이 책을 살까말까 망설이던 와중에.. https://www.thecloudgirl.dev/data-analytics Data Analytics — The Cloud Girl www.thecloudgirl.dev 작가의 홈페이지를 발견했다. 책의 내용이 나와있다. https://youtube.com/playlist?list=PLTWE_lmu2InBzuPmOcgAYP7U80a87cpJd&feature=shared GCP SketchnotesIf you are looking to become a Google Cloud Engineer , then you are at the right place. GCP Sketchnotes is series where I share Google Cloud concepts in..

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..