I'm looking for a way to programmatically trigger "Generate Insights for free" for all tables within a specific BigQuery INFORMATION_SCHEMA.
Currently, the only method I've found is to manually navigate to each table in the BigQuery UI and select ""Generate Insights for free" which is inefficient for schemas with a large number of tables. I've reviewed the Dataplex and BigQuery API documentation but haven't found a method for initiating these scans in a single bulk API call.
Is there a recommended approach or an API endpoint that allows for batch submission of ""Generate Insights for free" for multiple tables? Or is the intended method to iterate through a list of tables and create an individual profiling scan for each one via the API?