SSIS Components for DigitalOcean

Build 20.0.7587

DatabaseFirewallRules

Retrieve information regarding the database firewall rules.

View Specific Information

Select

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.

Columns

Name Type References Description
UUID String A unique ID for the firewall rule itself.
DatabaseId String

DatabaseClusters.Id

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.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587