--- title: Perform product analysis with generative AI and BigQuery description: This post discusses the challenges and benefits of working with unstructured data in the context of generative AI models and media asset companies. It outlines... canonical: https://daily.dev/posts/perform-product-analysis-with-generative-ai-and-bigquery-om7k4osu2 twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: Perform product analysis with generative AI and BigQuery | daily.dev og:description: This post discusses the challenges and benefits of working with unstructured data in the context of generative AI models and media asset companies. It outlines... og:url: https://daily.dev/posts/perform-product-analysis-with-generative-ai-and-bigquery-om7k4osu2 og:image: https://api.daily.dev/og/posts/Om7K4OsU2.png og:image:alt: Perform product analysis with generative AI and BigQuery og:image:width: 1200 og:image:height: 630 og:locale: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # Perform product analysis with generative AI and BigQuery **[Google Cloud](https://daily.dev/sources/gcp)** · 4 min read · 1 upvotes · 0 comments ## Summary This post discusses the challenges and benefits of working with unstructured data in the context of generative AI models and media asset companies. It outlines a solution using Cloud Storage and BigQuery to centralize and analyze unstructured data, emphasizing the use of object tables in BigQuery. The post also provides steps for creating an example dataset, creating object tables, referencing AI models and functions, and using the functions in queries. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: --- Tags: [#genai](https://daily.dev/tags/genai), [#google-bigquery](https://daily.dev/tags/google-bigquery) [View this post on daily.dev](https://daily.dev/posts/perform-product-analysis-with-generative-ai-and-bigquery-om7k4osu2) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"TechArticle","headline":"Perform product analysis with generative AI and BigQuery","url":"https://daily.dev/posts/perform-product-analysis-with-generative-ai-and-bigquery-om7k4osu2","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/perform-product-analysis-with-generative-ai-and-bigquery-om7k4osu2"},"datePublished":"2024-05-07T16:08:38.935Z","dateModified":"2024-05-09T08:07:00.500Z","description":"This post discusses the challenges and benefits of working with unstructured data in the context of generative AI models and media asset companies. It outlines...","image":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/5d0edbd826cf814251e2a73b5a95b91b?_a=AQAEuiZ","thumbnailUrl":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/5d0edbd826cf814251e2a73b5a95b91b?_a=AQAEuiZ","isAccessibleForFree":true,"articleSection":"Google Cloud","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"Google Cloud","logo":"https://media.daily.dev/image/upload/t_logo,f_auto/v1/logos/gcp","url":"https://daily.dev/sources/gcp"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/perform-product-analysis-with-generative-ai-and-bigquery-om7k4osu2","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":1},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"genai,google-bigquery","timeRequired":"PT4M"} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Google Cloud","item":"https://daily.dev/sources/gcp"},{"@type":"ListItem","position":3,"name":"Perform product analysis with generative AI and BigQuery"}]} ```