Retrieve information regarding the database firewall rules.
View Specific Information
Digital Ocean supports only DatabaseId column with "=" operator as filter criteria for this view.
Note: The DatabaseId column is a required filter. The driver will fetch a list of all database clusters if this filter is not present as part of the criteria.
SELECT * FROM DatabaseFirewallRules WHERE DatabaseId='9cc10173-e9ea-4176-9dbc-a4cee4c4ff30'
You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any other search criteria will be ignored and an unfiltered response will be returned.
|UUID||String||A unique ID for the firewall rule itself.|
|DatabaseId||String||A unique ID that can be used to identify and reference a database cluster.|
|ClusterUUID||String||A unique ID for the database cluster to which the rule is applied.|
|CreatedAt||String||Represents when the firewall rule was created.|
|Type||String||The type of resource that the firewall rule allows to access the database cluster.|
|Value||String||The ID of the specific resource, the name of a tag applied to a group of resources, or the IP address that the firewall rule allows to access the database cluster.|