Skip to main content

BigQuery Working with Array Structures

On a companies table where you can have multiple websites per company:

SELECT * 
	FROM 
    	project_namespace.dataset.companies as companies, 
    	UNNEST (companies.websites) as website 
    LIMIT 1000

The above would produce a flattened table structure where company id is repeated per website.