Google Cloud Platform BigQuery - Create Wtchlist with BigQuery Table Data

Browse: 🏠 · Solutions · Connectors · Methods · Tables · Content · Parsers · ASIM Parsers · ASIM Products · Logic Apps · 📊

↑ Back to Content Index

This playbook can be run from incident context manually or from automation rule to create a watchlist from GCP BigQuery table data.

Attribute Value
Type Playbook
Solution Google Cloud Platform BigQuery
Source View on GitHub

Logic App Connectors

This playbook uses 2 Logic App connectors / built-in actions:

Connector / Action Type Connections Actions
azuresentinel Managed 1 2
GCPBigQueryCustomConnector Custom 1 2
Action parameters (URLs, paths, function IDs)

azuresentinel (Managed)

Action Method Endpoint Other
Add_comment_to_incident_(V3) post /Incidents/Comment —
Watchlists_-Create_a_new_Watchlist_with_data(Raw_Content) put /Watchlists/subscriptions/@{encodeURIComponent(triggerBody()?['workspaceInfo']?['SubscriptionId'])}/resourceGroups/@{encodeURIComponent(triggerBody()?['workspaceInfo']?['ResourceGroupName'])}/workspaces/@{encodeURIComponent(triggerBody()?['workspaceId'])}/watchlists/@{encodeURIComponent(parameters('WatchlistName'))} —

GCPBigQueryCustomConnector (Custom)

Action Method Endpoint Other
Get_Table_Data get /projects/@{encodeURIComponent(parameters('ProjectID'))}/datasets/@{encodeURIComponent(parameters('DatasetID'))}/tables/@{encodeURIComponent(parameters('TableID'))}/data —
Get_Table_Details get /projects/@{encodeURIComponent(parameters('ProjectID'))}/datasets/@{encodeURIComponent(parameters('DatasetID'))}/tables/@{encodeURIComponent(parameters('TableID'))} —

Additional Documentation

📄 Source: GCPBigQueryPlaybooks/GCPBigQuery-CreateWatchlist-From-BigQueryTable/readme.md

GCPBigQuery-CreateWatchlist-From-BigQueryTable

Summary

This playbook can be run from incident context manually or from automation rule to create a watchlist from GCP BigQuery table data. The playbook performs following actions:

  1. Get the table details for the given table.
  2. Get the table data and parse the result.
  3. Create a watchlist with the parsed data.
  4. Add a comment to the incident of success/failure of action.



Prerequisites

  1. Prior to the deployment of this playbook, GCPBigQuery Logic App Custom Connector needs to be deployed under the same subscription.
  2. Refer to GCPBigQuery Logic App Custom Connector documentation for deployment instructions.

Deployment instructions

  1. To deploy the Playbook, click the Deploy to Azure button. This will launch the ARM Template deployment wizard.
  2. Fill in the required parameters:
    • Playbook Name
    • Custom Connector Name
    • GCP Project ID
    • SQL Query String

Deploy to Azure Deploy to Azure

Post-Deployment instructions

a. Authorize connections

Once deployment is complete, authorize each connection.

  1. Select the Microsoft Sentinel connection resource
  2. Click Edit API connection blade
  3. Click Authorize/Provide credentials
  4. Click Save
  5. Repeat these steps for other connections

b. Configurations in Sentinel

  1. In Microsoft Sentinel, configure the automation rule/analytical rule to trigger the playbook. Check the documentation to learn more about automation rules.

c. Assign Playbook Microsoft Sentinel Responder Role

  1. Select the Playbook (Logic App) resource
  2. Click on Identity Blade
  3. Choose System assigned tab
  4. Click on Azure role assignments
  5. Click on Add role assignments
  6. Select Scope - Resource group
  7. Select Subscription - where Playbook has been created
  8. Select Resource group - where Playbook has been created
  9. Select Role - Microsoft Sentinel Contributor
  10. Click Save

References

Browse: 🏠 · Solutions · Connectors · Methods · Tables · Content · Parsers · ASIM Parsers · ASIM Products · Logic Apps · 📊

↑ Back to Playbooks · Back to Google Cloud Platform BigQuery