Desafios e solução de problemas da mesclagem de dados avaliações

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. · Revisado há almost 4 years

Kittima K. · Revisado há almost 4 years

Chanont C. · Revisado há almost 4 years

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. · Revisado há almost 4 years

Youssef D. · Revisado há almost 4 years

Garima A. · Revisado há almost 4 years

Akeporn P. · Revisado há almost 4 years

Luis Alberto M. · Revisado há almost 4 years

Madson C. · Revisado há almost 4 years

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. · Revisado há almost 4 years

MANUEL L. · Revisado há almost 4 years

Rim E. · Revisado há almost 4 years

Roman Z. · Revisado há almost 4 years

Leonardo P. · Revisado há almost 4 years

SHANKAR S. · Revisado há almost 4 years

Kep B. · Revisado há almost 4 years

Askri M. · Revisado há almost 4 years

Napat 'Air' S. · Revisado há almost 4 years

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. · Revisado há almost 4 years

Apichet K. · Revisado há almost 4 years

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

Martin H. · Revisado há almost 4 years

Alexandr Z. · Revisado há almost 4 years

Sachin S. · Revisado há almost 4 years

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. · Revisado há almost 4 years

Sid Ahmed M. · Revisado há almost 4 years