Today, we are excited to announce the public preview of search indexes and related SQL SEARCH functions in BigQuery. This is a new capability in BigQuery that allows you to use standard BigQuery SQL to easily find unique data elements buried in unstructured text and semi-structured JSON, without having to know the table schemas in advance. By making row lookups in BigQuery efficient, you now have a powerful columnar store and text search in a single data platform.
Vaccine development became the top priority for the life sciences industry – delivering new vaccines at unprecedented speed and maneuvering large-scale production processes. Numerous factors helped accelerate the vaccine roll-out including prior research, genome sequencing, jumping the FDA approval queue and a plethora of testing volunteers. So now that we’ve experienced these advancements, how can the industry keep momentum to speed-up innovative solutions across healthcare?
A global leader in pharmaceuticals found themselves faced with a unique spin on a common challenge: Their biopharmaceutical division — responsible for producing vaccines and generating over $1 billion in annual sales — was struggling to turn raw data into trusted insights. Data underlies everything the global pharmaceutical company does, however, without data they can trust, they would be at risk of taking longer to get vaccines to market and incurring higher expenses along the way.
