Troubleshooting and Solving Data Join Pitfalls Reviews

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 almost 4 years ago

Sid Ahmed M. · Reviewed almost 4 years ago

Yogesh P. · Reviewed almost 4 years ago

local h. · Reviewed almost 4 years ago

Abdul R. · Reviewed almost 4 years ago

ok

Carlos Simon N. · Reviewed almost 4 years ago

Westley D. · Reviewed almost 4 years ago

so good

Takdanai S. · Reviewed almost 4 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 almost 4 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 almost 4 years ago

Had trouble inserting data

Yamini F. · Reviewed almost 4 years ago

yago s. · Reviewed almost 4 years ago

no sirve el link de el dataset

César R. · Reviewed almost 4 years ago

no sirve el link de el dataset

César R. · Reviewed almost 4 years ago

Ayoub E. · Reviewed almost 4 years ago

HARSH KUMAR V. · Reviewed almost 4 years ago

no sirve el link de el dataset

César R. · Reviewed almost 4 years ago

IVAN C. · Reviewed almost 4 years ago

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

Christian J. · Reviewed almost 4 years ago

manel a. · Reviewed almost 4 years ago

When I tried to do the step of inserting data in discounts, it showed this result and couldn't continue "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."

SEBASTIAN . I. · Reviewed almost 4 years ago

bug on final part cannot insert that show message about billing

สิทธิ์เสวก ส. · Reviewed almost 4 years ago

Vittaya C. · Reviewed almost 4 years ago

Sandeep K. · Reviewed almost 4 years ago

SITTIPONG M. · Reviewed almost 4 years ago