Troubleshooting and Solving Data Join Pitfalls Reviews

Cannot complete all the queries, the INSERT query for the discount table throws a billing error

Daniel W. · Reviewed over 3 years ago

Pierre L. · Reviewed over 3 years ago

Consultor E. · Reviewed over 3 years ago

INSERT INTO ecommerce.site_wide_promotion (discount) VALUES (.04), (.03); 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.

Gerald M. · Reviewed over 3 years ago

Kittima K. · Reviewed over 3 years ago

Chanont C. · Reviewed over 3 years ago

Lab is broken - even on 2nd try: Warning is shown in BigQuery: SANDBOX Set up billing to upgrade to the full BigQuery experience So this query does not work: INSERT INTO ecommerce.site_wide_promotion (discount) VALUES (.04), (.03); Error message: 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. Additionally the following question does not work: A FULL JOIN returns what? No Answers can be selected

Axel E. · Reviewed over 3 years ago

Youssef D. · Reviewed over 3 years ago

Garima A. · Reviewed over 3 years ago

Akeporn P. · Reviewed over 3 years ago

Luis Alberto M. · Reviewed over 3 years ago

Madson C. · Reviewed over 3 years ago

In the last task, the inserts couldn't be executed because of 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.

Santiago T. · Reviewed over 3 years ago

MANUEL L. · Reviewed over 3 years ago

Rim E. · Reviewed over 3 years ago

Roman Z. · Reviewed over 3 years ago

Leonardo P. · Reviewed over 3 years ago

SHANKAR S. · Reviewed over 3 years ago

Kep B. · Reviewed over 3 years ago

Askri M. · Reviewed over 3 years ago

Napat 'Air' S. · Reviewed over 3 years ago

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