Use SEARCH with unstructured data

If you only need to find specific values within unstructured data, then you don't need to go through the work of un-nesting your data. You can search inside unstructured data using the SEARCH function from BigQuery.

Bu egzersiz

Introduction to BigQuery

kursunun bir parçasıdır

Kursu Görüntüle

Egzersiz talimatları

Finish the query to run the SEARCH function to look for a value containing '0da9ffd92214425d880de3f94e74ce39' in the order_items column in the ecommerce.ecomm_orders table.

Uygulamalı interaktif egzersiz

Bu örnek kodu tamamlayarak bu egzersizi bitirin.

-- Finish the query to search across the unstructured data

SELECT 
    -- Complete the SEARCH function
	___(___, ___) as results   
-- Add the correct table name
FROM ___
LIMIT 5

Kodu Düzenle ve Çalıştır