Exercise

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.

Instructions

100 XP

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.

.css-6su6fj{-webkit-flex-shrink:0;-ms-flex-negative:0;flex-shrink:0;}Exercise

Instructions

Exercise