BigQuery: How to achieve contextual awareness of available data.

zbrak

I was thinking about how to seed more context into a standard bigquery action. I think about the Salesforce SOQL query experience - which is quite good! Part of why it's good is that the system knows the underlying objects and context like salesforce.

How will the BigQuery implementation look? Will we be able to feed it context about our database? Will it look at our field descriptions and table metadata to achieve context?

For authentication in BigQuery actions, we have user auth currently. Will the BigQuery connection auth to the user and know what tables they have access to in order to prevent invalid queries? All things I would love to know.

jesikaharia

Hi, we're actually using the BigQuery Conversational Analytics API to do the text-to-sql conversion, where you can create either provide more context in-line, use pre-created Data Agents or your Looker models so that we are schema and context aware!