Troubleshooting and Solving Data Join Pitfalls Reviews

Couldn't answer last question - buttons not activated. Couldn't add additional discounts to site_wide_promotion table, got error about not having permission to perform INSERT.

Scott S. · Reviewed over 3 years ago

Apichet K. · Reviewed over 3 years ago

Inserting is not allowed without payment so I can't do the insert of additional discounts.

Martin H. · Reviewed over 3 years ago

Alexandr Z. · Reviewed over 3 years ago

Sachin S. · Reviewed over 3 years ago

I had the following error " Billing has not been enabled for this project. Enable billing at https://console.cloud.google.com/billing. DML queries are not allowed in the free tier. Set up a billing account to remove this restriction" in the "INSERT INTO ecommerce.site_wide_promotion (discount) VALUES (.04), (.03); " step. I hat to use this instead: "#standardSQL CREATE OR REPLACE TABLE ecommerce.site_wide_promotion AS ( SELECT .05 AS discount UNION ALL SELECT .04 AS discount UNION ALL SELECT .03 AS discount ) "

BC G. · Reviewed over 3 years ago

Sid Ahmed M. · Reviewed over 3 years ago

Yogesh P. · Reviewed over 3 years ago

local h. · Reviewed over 3 years ago

Abdul R. · Reviewed over 3 years ago

ok

Carlos Simon N. · Reviewed over 3 years ago

Westley D. · Reviewed over 3 years ago

so good

Takdanai S. · Reviewed over 3 years ago

Task 6 question 3 has a problem Error is: Billing has not been enabled for this project. Enable billing at console.cloud.google.com/billing. DML queries are not allowed in the free tier. Set up a billing account to remove this restriction. "3. Clear the previous query and run the below query to insert two more records into the promotion table: INSERT INTO ecommerce.site_wide_promotion (discount) VALUES (.04), (.03);"

Meredith O. · Reviewed over 3 years ago

Task 6 question 3 has a problem Error is: Billing has not been enabled for this project. Enable billing at https://console.cloud.google.com/billing. DML queries are not allowed in the free tier. Set up a billing account to remove this restriction. "3. Clear the previous query and run the below query to insert two more records into the promotion table: INSERT INTO ecommerce.site_wide_promotion (discount) VALUES (.04), (.03);"

Jeffrey W. · Reviewed over 3 years ago

Had trouble inserting data

Yamini F. · Reviewed over 3 years ago

yago s. · Reviewed over 3 years ago

no sirve el link de el dataset

César R. · Reviewed over 3 years ago

no sirve el link de el dataset

César R. · Reviewed over 3 years ago

Ayoub E. · Reviewed over 3 years ago

HARSH KUMAR V. · Reviewed over 3 years ago

no sirve el link de el dataset

César R. · Reviewed over 3 years ago

IVAN C. · Reviewed over 3 years ago

only the last part was not possible to complete due to billing

Christian J. · Reviewed over 3 years ago

manel a. · Reviewed over 3 years ago