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

Last query asking for upgrade to billing, cannot run.

Wayne Z. · Revisado há almost 3 years

Vladyslav V. · Revisado há almost 3 years

Good lab! But for some reason my billing got unlinked in the process:(

Alina D. · Revisado há almost 3 years

Влада Ш. · Revisado há almost 3 years

HIMBLER R. · Revisado há almost 3 years

Vitor B. · Revisado há almost 3 years

Rafael P. · Revisado há almost 3 years

Omkar D. · Revisado há almost 3 years

Suzana G. · Revisado há almost 3 years

Vaibhav R. · Revisado há almost 3 years

Dmytro S. · Revisado há almost 3 years

Wipada W. · Revisado há almost 3 years

Divya G. · Revisado há almost 3 years

Daniel V. · Revisado há almost 3 years

Bagoes Suryo N. · Revisado há almost 3 years

Adam N. · Revisado há almost 3 years

Suni T. · Revisado há almost 3 years

Unable to run the DML query 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.

DALILA A. · Revisado há almost 3 years

Aditya S. · Revisado há almost 3 years

Angela V. · Revisado há almost 3 years

G p. · Revisado há almost 3 years

I like the lab, but there were issues... After the line: Write a query using a different join type to investigate, we have a join: #standardSQL # reverse the join # find records in website but not in inventory ... FROM `data-to-insights.ecommerce.all_sessions_raw` AS website RIGHT JOIN `data-to-insights.ecommerce.products` AS inventory Surely the comment should say: # find records in inventory but not in website When I ran: INSERT INTO ecommerce.site_wide_promotion (discount) VALUES (.04), (.03); It says "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." I have 10 minutes left on the lab. So I was not able to insert these two records. Finally, in response to the question: How many products are missing? The answer required is "Some SKUs could be digital products", but I think the correct answer should be "All of the above" Best regards Darren (darren_lester@epam.com)

Darren L. · Revisado há almost 3 years

Gabriel C. · Revisado há almost 3 years

Aurelien L. · Revisado há almost 3 years