Limiting the amount of data
First, you will need to find the correct way to optimize this simple query by using only the required columns you need.
Bu egzersiz
Introduction to BigQuery
kursunun bir parçasıdırEgzersiz talimatları
- Reduce the amount of data being queried in the final query to include only the
order_idandpayment_type.
Uygulamalı interaktif egzersiz
Bu örnek kodu tamamlayarak bu egzersizi bitirin.
-- Write the most efficient query that uses only the required data
SELECT ___, ___
FROM ecommerce.ecomm_payments
LIMIT 10;