I'm exporting my GCP logs to BigQuery to view them better. From here, it seems like fields in the jsonPayload of my logEntry, would be turned into a jsonPayload. field in the BigQuery table. One of the fields in the jsonPayload is an internal log ID.
Since BigQuery now allows adding indexes to tables, I want to add an index on this jsonPayload.logId field in the table for improved query performance. How do I do that? Or should I be only depending on partitioning and/or clustering for better performance?