Lakehouse: Qwik Start Reviews

ran into a bug in the bigquery cli on the last step: "UnboundLocalError: local variable 'reference' referenced before assignment"

Dan Q. · Reviewed מעל 3 שנים ago

nice

VENKATESH P. · Reviewed מעל 3 שנים ago

Purnima P. · Reviewed מעל 3 שנים ago

Priya P. · Reviewed מעל 3 שנים ago

Sayandeep N. · Reviewed מעל 3 שנים ago

Tomasz W. · Reviewed מעל 3 שנים ago

Damini M. · Reviewed מעל 3 שנים ago

Chodipilli D. · Reviewed מעל 3 שנים ago

not satisfied

ARAVAPALLI S. · Reviewed מעל 3 שנים ago

but, It looked that connection id string is different

JeongKwon L. · Reviewed מעל 3 שנים ago

Godhuli D. · Reviewed מעל 3 שנים ago

JeongKwon L. · Reviewed מעל 3 שנים ago

Sarach S. · Reviewed מעל 3 שנים ago

Shruti A. · Reviewed מעל 3 שנים ago

There is an error happening at the last step, please look into it and then make this lab live. I was getting this: bq mk --connection --location=US --project_id=$DEVSHELL_PROJECT_ID \ --connection_type=CLOUD_RESOURCE my-connection SERVICE_ACCOUNT_ID=$(bq show --format=json --connection $DEVSHELL_PROJECT_ID.US.my-connection | jq -r '.cloudResource.serviceAccountId') gcloud projects add-iam-policy-binding $DEVSHELL_PROJECT_ID --member="serviceAccount:$SERVICE_ACCOUNT_ID" --role="roles/storage.objectViewer" bq mk demo_dataset bq mkdef --source_format=CSV --autodetect=true \ gs://$DEVSHELL_PROJECT_ID/customer.csv > mytable_def bq mk --table --external_table_definition=mytable_def \ demo_dataset.biglake_table bq mkdef --source_format=CSV --autodetect=true \ gs://$DEVSHELL_PROJECT_ID/invoice.csv > mytable_deff bq mk --table --external_table_definition=mytable_deff \ demo_dataset.external_table bq mkdef \ --autodetect \ --connection_id=$DEVSHELL_PROJECT_ID.US.my-connection \ --source_format=CSV \ "gs://$DEVSHELL_PROJECT_ID/invoice.csv" > /tmp/tabledef.json bq show --schema --format=prettyjson demo_dataset.external_table > /tmp/schema bq update --external_table_definition=/tmp/tabledef.json --schema=/tmp/schema demo_dataset.external_table

Dev I. · Reviewed מעל 3 שנים ago

Shruti A. · Reviewed מעל 3 שנים ago

ADARSH K. · Reviewed מעל 3 שנים ago

Pranab S. · Reviewed מעל 3 שנים ago

RAGHAVENDRA B. · Reviewed מעל 3 שנים ago

done

SHUBHAM W. · Reviewed מעל 3 שנים ago

Vadiraj P. · Reviewed מעל 3 שנים ago