0

enter image description here

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?

1 Answer 1

0

Currently, there is no API or method to batch-trigger the "Generate Insights for free" feature for multiple BigQuery tables. You can try filing this as a feature request in Google Cloud. They might consider adding this for future updates.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.