Close httplib2 connections.
Use this method to create a connection profile in a project and location.
delete(name, requestId=None, x__xgafv=None)
Use this method to delete a connection profile.
discover(parent, body=None, x__xgafv=None)
Use this method to discover a connection profile. The discover API call exposes the data objects and metadata belonging to the profile. Typically, a request returns children data objects of a parent data object that's optionally supplied in the request.
Use this method to get details about a connection profile.
list(parent, filter=None, orderBy=None, pageSize=None, pageToken=None, x__xgafv=None)
Use this method to list connection profiles created in a project and location.
Retrieves the next page of results.
Use this method to update the parameters of a connection profile.
close()
Close httplib2 connections.
create(parent, body=None, connectionProfileId=None, force=None, requestId=None, validateOnly=None, x__xgafv=None)
Use this method to create a connection profile in a project and location.
Args:
parent: string, Required. The parent that owns the collection of ConnectionProfiles. (required)
body: object, The request body.
The object takes the form of:
{ # A set of reusable connection configurations to be used as a source or destination for a stream.
"bigqueryProfile": { # BigQuery warehouse profile. # BigQuery Connection Profile configuration.
},
"createTime": "A String", # Output only. The create time of the resource.
"displayName": "A String", # Required. Display name.
"forwardSshConnectivity": { # Forward SSH Tunnel connectivity. # Forward SSH tunnel connectivity.
"hostname": "A String", # Required. Hostname for the SSH tunnel.
"password": "A String", # Input only. SSH password.
"port": 42, # Port for the SSH tunnel, default value is 22.
"privateKey": "A String", # Input only. SSH private key.
"username": "A String", # Required. Username for the SSH tunnel.
},
"gcsProfile": { # Cloud Storage bucket profile. # Cloud Storage ConnectionProfile configuration.
"bucket": "A String", # Required. The Cloud Storage bucket name.
"rootPath": "A String", # The root path inside the Cloud Storage bucket.
},
"labels": { # Labels.
"a_key": "A String",
},
"mysqlProfile": { # MySQL database profile. # MySQL ConnectionProfile configuration.
"hostname": "A String", # Required. Hostname for the MySQL connection.
"password": "A String", # Required. Input only. Password for the MySQL connection.
"port": 42, # Port for the MySQL connection, default value is 3306.
"sslConfig": { # MySQL SSL configuration information. # SSL configuration for the MySQL connection.
"caCertificate": "A String", # Input only. PEM-encoded certificate of the CA that signed the source database server's certificate.
"caCertificateSet": True or False, # Output only. Indicates whether the ca_certificate field is set.
"clientCertificate": "A String", # Input only. PEM-encoded certificate that will be used by the replica to authenticate against the source database server. If this field is used then the 'client_key' and the 'ca_certificate' fields are mandatory.
"clientCertificateSet": True or False, # Output only. Indicates whether the client_certificate field is set.
"clientKey": "A String", # Input only. PEM-encoded private key associated with the Client Certificate. If this field is used then the 'client_certificate' and the 'ca_certificate' fields are mandatory.
"clientKeySet": True or False, # Output only. Indicates whether the client_key field is set.
},
"username": "A String", # Required. Username for the MySQL connection.
},
"name": "A String", # Output only. The resource's name.
"oracleProfile": { # Oracle database profile. # Oracle ConnectionProfile configuration.
"connectionAttributes": { # Connection string attributes
"a_key": "A String",
},
"databaseService": "A String", # Required. Database for the Oracle connection.
"hostname": "A String", # Required. Hostname for the Oracle connection.
"oracleSslConfig": { # Oracle SSL configuration information. # Optional. SSL configuration for the Oracle connection.
"caCertificate": "A String", # Input only. PEM-encoded certificate of the CA that signed the source database server's certificate.
"caCertificateSet": True or False, # Output only. Indicates whether the ca_certificate field has been set for this Connection-Profile.
},
"password": "A String", # Required. Password for the Oracle connection.
"port": 42, # Port for the Oracle connection, default value is 1521.
"username": "A String", # Required. Username for the Oracle connection.
},
"postgresqlProfile": { # PostgreSQL database profile. # PostgreSQL Connection Profile configuration.
"database": "A String", # Required. Database for the PostgreSQL connection.
"hostname": "A String", # Required. Hostname for the PostgreSQL connection.
"password": "A String", # Required. Password for the PostgreSQL connection.
"port": 42, # Port for the PostgreSQL connection, default value is 5432.
"username": "A String", # Required. Username for the PostgreSQL connection.
},
"privateConnectivity": { # Private Connectivity # Private connectivity.
"privateConnection": "A String", # Required. A reference to a private connection resource. Format: `projects/{project}/locations/{location}/privateConnections/{name}`
},
"sqlServerProfile": { # SQLServer database profile # SQLServer Connection Profile configuration.
"database": "A String", # Required. Database for the SQLServer connection.
"hostname": "A String", # Required. Hostname for the SQLServer connection.
"password": "A String", # Required. Password for the SQLServer connection.
"port": 42, # Port for the SQLServer connection, default value is 1433.
"username": "A String", # Required. Username for the SQLServer connection.
},
"staticServiceIpConnectivity": { # Static IP address connectivity. Used when the source database is configured to allow incoming connections from the Datastream public IP addresses for the region specified in the connection profile. # Static Service IP connectivity.
},
"updateTime": "A String", # Output only. The update time of the resource.
}
connectionProfileId: string, Required. The connection profile identifier.
force: boolean, Optional. Create the connection profile without validating it.
requestId: string, Optional. A request ID to identify requests. Specify a unique request ID so that if you must retry your request, the server will know to ignore the request if it has already been completed. The server will guarantee that for at least 60 minutes since the first request. For example, consider a situation where you make an initial request and the request times out. If you make the request again with the same request ID, the server can check if original operation with the same request ID was received, and if so, will ignore the second request. This prevents clients from accidentally creating duplicate commitments. The request ID must be a valid UUID with the exception that zero UUID is not supported (00000000-0000-0000-0000-000000000000).
validateOnly: boolean, Optional. Only validate the connection profile, but don't create any resources. The default is false.
x__xgafv: string, V1 error format.
Allowed values
1 - v1 error format
2 - v2 error format
Returns:
An object of the form:
{ # This resource represents a long-running operation that is the result of a network API call.
"done": True or False, # If the value is `false`, it means the operation is still in progress. If `true`, the operation is completed, and either `error` or `response` is available.
"error": { # The `Status` type defines a logical error model that is suitable for different programming environments, including REST APIs and RPC APIs. It is used by [gRPC](https://github.com/grpc). Each `Status` message contains three pieces of data: error code, error message, and error details. You can find out more about this error model and how to work with it in the [API Design Guide](https://cloud.google.com/apis/design/errors). # The error result of the operation in case of failure or cancellation.
"code": 42, # The status code, which should be an enum value of google.rpc.Code.
"details": [ # A list of messages that carry the error details. There is a common set of message types for APIs to use.
{
"a_key": "", # Properties of the object. Contains field @type with type URL.
},
],
"message": "A String", # A developer-facing error message, which should be in English. Any user-facing error message should be localized and sent in the google.rpc.Status.details field, or localized by the client.
},
"metadata": { # Service-specific metadata associated with the operation. It typically contains progress information and common metadata such as create time. Some services might not provide such metadata. Any method that returns a long-running operation should document the metadata type, if any.
"a_key": "", # Properties of the object. Contains field @type with type URL.
},
"name": "A String", # The server-assigned name, which is only unique within the same service that originally returns it. If you use the default HTTP mapping, the `name` should be a resource name ending with `operations/{unique_id}`.
"response": { # The normal, successful response of the operation. If the original method returns no data on success, such as `Delete`, the response is `google.protobuf.Empty`. If the original method is standard `Get`/`Create`/`Update`, the response should be the resource. For other methods, the response should have the type `XxxResponse`, where `Xxx` is the original method name. For example, if the original method name is `TakeSnapshot()`, the inferred response type is `TakeSnapshotResponse`.
"a_key": "", # Properties of the object. Contains field @type with type URL.
},
}
delete(name, requestId=None, x__xgafv=None)
Use this method to delete a connection profile.
Args:
name: string, Required. The name of the connection profile resource to delete. (required)
requestId: string, Optional. A request ID to identify requests. Specify a unique request ID so that if you must retry your request, the server will know to ignore the request if it has already been completed. The server will guarantee that for at least 60 minutes after the first request. For example, consider a situation where you make an initial request and the request times out. If you make the request again with the same request ID, the server can check if original operation with the same request ID was received, and if so, will ignore the second request. This prevents clients from accidentally creating duplicate commitments. The request ID must be a valid UUID with the exception that zero UUID is not supported (00000000-0000-0000-0000-000000000000).
x__xgafv: string, V1 error format.
Allowed values
1 - v1 error format
2 - v2 error format
Returns:
An object of the form:
{ # This resource represents a long-running operation that is the result of a network API call.
"done": True or False, # If the value is `false`, it means the operation is still in progress. If `true`, the operation is completed, and either `error` or `response` is available.
"error": { # The `Status` type defines a logical error model that is suitable for different programming environments, including REST APIs and RPC APIs. It is used by [gRPC](https://github.com/grpc). Each `Status` message contains three pieces of data: error code, error message, and error details. You can find out more about this error model and how to work with it in the [API Design Guide](https://cloud.google.com/apis/design/errors). # The error result of the operation in case of failure or cancellation.
"code": 42, # The status code, which should be an enum value of google.rpc.Code.
"details": [ # A list of messages that carry the error details. There is a common set of message types for APIs to use.
{
"a_key": "", # Properties of the object. Contains field @type with type URL.
},
],
"message": "A String", # A developer-facing error message, which should be in English. Any user-facing error message should be localized and sent in the google.rpc.Status.details field, or localized by the client.
},
"metadata": { # Service-specific metadata associated with the operation. It typically contains progress information and common metadata such as create time. Some services might not provide such metadata. Any method that returns a long-running operation should document the metadata type, if any.
"a_key": "", # Properties of the object. Contains field @type with type URL.
},
"name": "A String", # The server-assigned name, which is only unique within the same service that originally returns it. If you use the default HTTP mapping, the `name` should be a resource name ending with `operations/{unique_id}`.
"response": { # The normal, successful response of the operation. If the original method returns no data on success, such as `Delete`, the response is `google.protobuf.Empty`. If the original method is standard `Get`/`Create`/`Update`, the response should be the resource. For other methods, the response should have the type `XxxResponse`, where `Xxx` is the original method name. For example, if the original method name is `TakeSnapshot()`, the inferred response type is `TakeSnapshotResponse`.
"a_key": "", # Properties of the object. Contains field @type with type URL.
},
}
discover(parent, body=None, x__xgafv=None)
Use this method to discover a connection profile. The discover API call exposes the data objects and metadata belonging to the profile. Typically, a request returns children data objects of a parent data object that's optionally supplied in the request.
Args:
parent: string, Required. The parent resource of the connection profile type. Must be in the format `projects/*/locations/*`. (required)
body: object, The request body.
The object takes the form of:
{ # Request message for 'discover' ConnectionProfile request.
"connectionProfile": { # A set of reusable connection configurations to be used as a source or destination for a stream. # An ad-hoc connection profile configuration.
"bigqueryProfile": { # BigQuery warehouse profile. # BigQuery Connection Profile configuration.
},
"createTime": "A String", # Output only. The create time of the resource.
"displayName": "A String", # Required. Display name.
"forwardSshConnectivity": { # Forward SSH Tunnel connectivity. # Forward SSH tunnel connectivity.
"hostname": "A String", # Required. Hostname for the SSH tunnel.
"password": "A String", # Input only. SSH password.
"port": 42, # Port for the SSH tunnel, default value is 22.
"privateKey": "A String", # Input only. SSH private key.
"username": "A String", # Required. Username for the SSH tunnel.
},
"gcsProfile": { # Cloud Storage bucket profile. # Cloud Storage ConnectionProfile configuration.
"bucket": "A String", # Required. The Cloud Storage bucket name.
"rootPath": "A String", # The root path inside the Cloud Storage bucket.
},
"labels": { # Labels.
"a_key": "A String",
},
"mysqlProfile": { # MySQL database profile. # MySQL ConnectionProfile configuration.
"hostname": "A String", # Required. Hostname for the MySQL connection.
"password": "A String", # Required. Input only. Password for the MySQL connection.
"port": 42, # Port for the MySQL connection, default value is 3306.
"sslConfig": { # MySQL SSL configuration information. # SSL configuration for the MySQL connection.
"caCertificate": "A String", # Input only. PEM-encoded certificate of the CA that signed the source database server's certificate.
"caCertificateSet": True or False, # Output only. Indicates whether the ca_certificate field is set.
"clientCertificate": "A String", # Input only. PEM-encoded certificate that will be used by the replica to authenticate against the source database server. If this field is used then the 'client_key' and the 'ca_certificate' fields are mandatory.
"clientCertificateSet": True or False, # Output only. Indicates whether the client_certificate field is set.
"clientKey": "A String", # Input only. PEM-encoded private key associated with the Client Certificate. If this field is used then the 'client_certificate' and the 'ca_certificate' fields are mandatory.
"clientKeySet": True or False, # Output only. Indicates whether the client_key field is set.
},
"username": "A String", # Required. Username for the MySQL connection.
},
"name": "A String", # Output only. The resource's name.
"oracleProfile": { # Oracle database profile. # Oracle ConnectionProfile configuration.
"connectionAttributes": { # Connection string attributes
"a_key": "A String",
},
"databaseService": "A String", # Required. Database for the Oracle connection.
"hostname": "A String", # Required. Hostname for the Oracle connection.
"oracleSslConfig": { # Oracle SSL configuration information. # Optional. SSL configuration for the Oracle connection.
"caCertificate": "A String", # Input only. PEM-encoded certificate of the CA that signed the source database server's certificate.
"caCertificateSet": True or False, # Output only. Indicates whether the ca_certificate field has been set for this Connection-Profile.
},
"password": "A String", # Required. Password for the Oracle connection.
"port": 42, # Port for the Oracle connection, default value is 1521.
"username": "A String", # Required. Username for the Oracle connection.
},
"postgresqlProfile": { # PostgreSQL database profile. # PostgreSQL Connection Profile configuration.
"database": "A String", # Required. Database for the PostgreSQL connection.
"hostname": "A String", # Required. Hostname for the PostgreSQL connection.
"password": "A String", # Required. Password for the PostgreSQL connection.
"port": 42, # Port for the PostgreSQL connection, default value is 5432.
"username": "A String", # Required. Username for the PostgreSQL connection.
},
"privateConnectivity": { # Private Connectivity # Private connectivity.
"privateConnection": "A String", # Required. A reference to a private connection resource. Format: `projects/{project}/locations/{location}/privateConnections/{name}`
},
"sqlServerProfile": { # SQLServer database profile # SQLServer Connection Profile configuration.
"database": "A String", # Required. Database for the SQLServer connection.
"hostname": "A String", # Required. Hostname for the SQLServer connection.
"password": "A String", # Required. Password for the SQLServer connection.
"port": 42, # Port for the SQLServer connection, default value is 1433.
"username": "A String", # Required. Username for the SQLServer connection.
},
"staticServiceIpConnectivity": { # Static IP address connectivity. Used when the source database is configured to allow incoming connections from the Datastream public IP addresses for the region specified in the connection profile. # Static Service IP connectivity.
},
"updateTime": "A String", # Output only. The update time of the resource.
},
"connectionProfileName": "A String", # A reference to an existing connection profile.
"fullHierarchy": True or False, # Whether to retrieve the full hierarchy of data objects (TRUE) or only the current level (FALSE).
"hierarchyDepth": 42, # The number of hierarchy levels below the current level to be retrieved.
"mysqlRdbms": { # MySQL database structure # MySQL RDBMS to enrich with child data objects and metadata.
"mysqlDatabases": [ # Mysql databases on the server
{ # MySQL database.
"database": "A String", # Database name.
"mysqlTables": [ # Tables in the database.
{ # MySQL table.
"mysqlColumns": [ # MySQL columns in the database. When unspecified as part of include/exclude objects, includes/excludes everything.
{ # MySQL Column.
"collation": "A String", # Column collation.
"column": "A String", # Column name.
"dataType": "A String", # The MySQL data type. Full data types list can be found here: https://dev.mysql.com/doc/refman/8.0/en/data-types.html
"length": 42, # Column length.
"nullable": True or False, # Whether or not the column can accept a null value.
"ordinalPosition": 42, # The ordinal position of the column in the table.
"precision": 42, # Column precision.
"primaryKey": True or False, # Whether or not the column represents a primary key.
"scale": 42, # Column scale.
},
],
"table": "A String", # Table name.
},
],
},
],
},
"oracleRdbms": { # Oracle database structure. # Oracle RDBMS to enrich with child data objects and metadata.
"oracleSchemas": [ # Oracle schemas/databases in the database server.
{ # Oracle schema.
"oracleTables": [ # Tables in the schema.
{ # Oracle table.
"oracleColumns": [ # Oracle columns in the schema. When unspecified as part of include/exclude objects, includes/excludes everything.
{ # Oracle Column.
"column": "A String", # Column name.
"dataType": "A String", # The Oracle data type.
"encoding": "A String", # Column encoding.
"length": 42, # Column length.
"nullable": True or False, # Whether or not the column can accept a null value.
"ordinalPosition": 42, # The ordinal position of the column in the table.
"precision": 42, # Column precision.
"primaryKey": True or False, # Whether or not the column represents a primary key.
"scale": 42, # Column scale.
},
],
"table": "A String", # Table name.
},
],
"schema": "A String", # Schema name.
},
],
},
"postgresqlRdbms": { # PostgreSQL database structure. # PostgreSQL RDBMS to enrich with child data objects and metadata.
"postgresqlSchemas": [ # PostgreSQL schemas in the database server.
{ # PostgreSQL schema.
"postgresqlTables": [ # Tables in the schema.
{ # PostgreSQL table.
"postgresqlColumns": [ # PostgreSQL columns in the schema. When unspecified as part of include/exclude objects, includes/excludes everything.
{ # PostgreSQL Column.
"column": "A String", # Column name.
"dataType": "A String", # The PostgreSQL data type.
"length": 42, # Column length.
"nullable": True or False, # Whether or not the column can accept a null value.
"ordinalPosition": 42, # The ordinal position of the column in the table.
"precision": 42, # Column precision.
"primaryKey": True or False, # Whether or not the column represents a primary key.
"scale": 42, # Column scale.
},
],
"table": "A String", # Table name.
},
],
"schema": "A String", # Schema name.
},
],
},
}
x__xgafv: string, V1 error format.
Allowed values
1 - v1 error format
2 - v2 error format
Returns:
An object of the form:
{ # Response from a discover request.
"mysqlRdbms": { # MySQL database structure # Enriched MySQL RDBMS object.
"mysqlDatabases": [ # Mysql databases on the server
{ # MySQL database.
"database": "A String", # Database name.
"mysqlTables": [ # Tables in the database.
{ # MySQL table.
"mysqlColumns": [ # MySQL columns in the database. When unspecified as part of include/exclude objects, includes/excludes everything.
{ # MySQL Column.
"collation": "A String", # Column collation.
"column": "A String", # Column name.
"dataType": "A String", # The MySQL data type. Full data types list can be found here: https://dev.mysql.com/doc/refman/8.0/en/data-types.html
"length": 42, # Column length.
"nullable": True or False, # Whether or not the column can accept a null value.
"ordinalPosition": 42, # The ordinal position of the column in the table.
"precision": 42, # Column precision.
"primaryKey": True or False, # Whether or not the column represents a primary key.
"scale": 42, # Column scale.
},
],
"table": "A String", # Table name.
},
],
},
],
},
"oracleRdbms": { # Oracle database structure. # Enriched Oracle RDBMS object.
"oracleSchemas": [ # Oracle schemas/databases in the database server.
{ # Oracle schema.
"oracleTables": [ # Tables in the schema.
{ # Oracle table.
"oracleColumns": [ # Oracle columns in the schema. When unspecified as part of include/exclude objects, includes/excludes everything.
{ # Oracle Column.
"column": "A String", # Column name.
"dataType": "A String", # The Oracle data type.
"encoding": "A String", # Column encoding.
"length": 42, # Column length.
"nullable": True or False, # Whether or not the column can accept a null value.
"ordinalPosition": 42, # The ordinal position of the column in the table.
"precision": 42, # Column precision.
"primaryKey": True or False, # Whether or not the column represents a primary key.
"scale": 42, # Column scale.
},
],
"table": "A String", # Table name.
},
],
"schema": "A String", # Schema name.
},
],
},
"postgresqlRdbms": { # PostgreSQL database structure. # Enriched PostgreSQL RDBMS object.
"postgresqlSchemas": [ # PostgreSQL schemas in the database server.
{ # PostgreSQL schema.
"postgresqlTables": [ # Tables in the schema.
{ # PostgreSQL table.
"postgresqlColumns": [ # PostgreSQL columns in the schema. When unspecified as part of include/exclude objects, includes/excludes everything.
{ # PostgreSQL Column.
"column": "A String", # Column name.
"dataType": "A String", # The PostgreSQL data type.
"length": 42, # Column length.
"nullable": True or False, # Whether or not the column can accept a null value.
"ordinalPosition": 42, # The ordinal position of the column in the table.
"precision": 42, # Column precision.
"primaryKey": True or False, # Whether or not the column represents a primary key.
"scale": 42, # Column scale.
},
],
"table": "A String", # Table name.
},
],
"schema": "A String", # Schema name.
},
],
},
}
get(name, x__xgafv=None)
Use this method to get details about a connection profile.
Args:
name: string, Required. The name of the connection profile resource to get. (required)
x__xgafv: string, V1 error format.
Allowed values
1 - v1 error format
2 - v2 error format
Returns:
An object of the form:
{ # A set of reusable connection configurations to be used as a source or destination for a stream.
"bigqueryProfile": { # BigQuery warehouse profile. # BigQuery Connection Profile configuration.
},
"createTime": "A String", # Output only. The create time of the resource.
"displayName": "A String", # Required. Display name.
"forwardSshConnectivity": { # Forward SSH Tunnel connectivity. # Forward SSH tunnel connectivity.
"hostname": "A String", # Required. Hostname for the SSH tunnel.
"password": "A String", # Input only. SSH password.
"port": 42, # Port for the SSH tunnel, default value is 22.
"privateKey": "A String", # Input only. SSH private key.
"username": "A String", # Required. Username for the SSH tunnel.
},
"gcsProfile": { # Cloud Storage bucket profile. # Cloud Storage ConnectionProfile configuration.
"bucket": "A String", # Required. The Cloud Storage bucket name.
"rootPath": "A String", # The root path inside the Cloud Storage bucket.
},
"labels": { # Labels.
"a_key": "A String",
},
"mysqlProfile": { # MySQL database profile. # MySQL ConnectionProfile configuration.
"hostname": "A String", # Required. Hostname for the MySQL connection.
"password": "A String", # Required. Input only. Password for the MySQL connection.
"port": 42, # Port for the MySQL connection, default value is 3306.
"sslConfig": { # MySQL SSL configuration information. # SSL configuration for the MySQL connection.
"caCertificate": "A String", # Input only. PEM-encoded certificate of the CA that signed the source database server's certificate.
"caCertificateSet": True or False, # Output only. Indicates whether the ca_certificate field is set.
"clientCertificate": "A String", # Input only. PEM-encoded certificate that will be used by the replica to authenticate against the source database server. If this field is used then the 'client_key' and the 'ca_certificate' fields are mandatory.
"clientCertificateSet": True or False, # Output only. Indicates whether the client_certificate field is set.
"clientKey": "A String", # Input only. PEM-encoded private key associated with the Client Certificate. If this field is used then the 'client_certificate' and the 'ca_certificate' fields are mandatory.
"clientKeySet": True or False, # Output only. Indicates whether the client_key field is set.
},
"username": "A String", # Required. Username for the MySQL connection.
},
"name": "A String", # Output only. The resource's name.
"oracleProfile": { # Oracle database profile. # Oracle ConnectionProfile configuration.
"connectionAttributes": { # Connection string attributes
"a_key": "A String",
},
"databaseService": "A String", # Required. Database for the Oracle connection.
"hostname": "A String", # Required. Hostname for the Oracle connection.
"oracleSslConfig": { # Oracle SSL configuration information. # Optional. SSL configuration for the Oracle connection.
"caCertificate": "A String", # Input only. PEM-encoded certificate of the CA that signed the source database server's certificate.
"caCertificateSet": True or False, # Output only. Indicates whether the ca_certificate field has been set for this Connection-Profile.
},
"password": "A String", # Required. Password for the Oracle connection.
"port": 42, # Port for the Oracle connection, default value is 1521.
"username": "A String", # Required. Username for the Oracle connection.
},
"postgresqlProfile": { # PostgreSQL database profile. # PostgreSQL Connection Profile configuration.
"database": "A String", # Required. Database for the PostgreSQL connection.
"hostname": "A String", # Required. Hostname for the PostgreSQL connection.
"password": "A String", # Required. Password for the PostgreSQL connection.
"port": 42, # Port for the PostgreSQL connection, default value is 5432.
"username": "A String", # Required. Username for the PostgreSQL connection.
},
"privateConnectivity": { # Private Connectivity # Private connectivity.
"privateConnection": "A String", # Required. A reference to a private connection resource. Format: `projects/{project}/locations/{location}/privateConnections/{name}`
},
"sqlServerProfile": { # SQLServer database profile # SQLServer Connection Profile configuration.
"database": "A String", # Required. Database for the SQLServer connection.
"hostname": "A String", # Required. Hostname for the SQLServer connection.
"password": "A String", # Required. Password for the SQLServer connection.
"port": 42, # Port for the SQLServer connection, default value is 1433.
"username": "A String", # Required. Username for the SQLServer connection.
},
"staticServiceIpConnectivity": { # Static IP address connectivity. Used when the source database is configured to allow incoming connections from the Datastream public IP addresses for the region specified in the connection profile. # Static Service IP connectivity.
},
"updateTime": "A String", # Output only. The update time of the resource.
}
list(parent, filter=None, orderBy=None, pageSize=None, pageToken=None, x__xgafv=None)
Use this method to list connection profiles created in a project and location.
Args:
parent: string, Required. The parent that owns the collection of connection profiles. (required)
filter: string, Filter request.
orderBy: string, Order by fields for the result.
pageSize: integer, Maximum number of connection profiles to return. If unspecified, at most 50 connection profiles will be returned. The maximum value is 1000; values above 1000 will be coerced to 1000.
pageToken: string, Page token received from a previous `ListConnectionProfiles` call. Provide this to retrieve the subsequent page. When paginating, all other parameters provided to `ListConnectionProfiles` must match the call that provided the page token.
x__xgafv: string, V1 error format.
Allowed values
1 - v1 error format
2 - v2 error format
Returns:
An object of the form:
{ # Response message for listing connection profiles.
"connectionProfiles": [ # List of connection profiles.
{ # A set of reusable connection configurations to be used as a source or destination for a stream.
"bigqueryProfile": { # BigQuery warehouse profile. # BigQuery Connection Profile configuration.
},
"createTime": "A String", # Output only. The create time of the resource.
"displayName": "A String", # Required. Display name.
"forwardSshConnectivity": { # Forward SSH Tunnel connectivity. # Forward SSH tunnel connectivity.
"hostname": "A String", # Required. Hostname for the SSH tunnel.
"password": "A String", # Input only. SSH password.
"port": 42, # Port for the SSH tunnel, default value is 22.
"privateKey": "A String", # Input only. SSH private key.
"username": "A String", # Required. Username for the SSH tunnel.
},
"gcsProfile": { # Cloud Storage bucket profile. # Cloud Storage ConnectionProfile configuration.
"bucket": "A String", # Required. The Cloud Storage bucket name.
"rootPath": "A String", # The root path inside the Cloud Storage bucket.
},
"labels": { # Labels.
"a_key": "A String",
},
"mysqlProfile": { # MySQL database profile. # MySQL ConnectionProfile configuration.
"hostname": "A String", # Required. Hostname for the MySQL connection.
"password": "A String", # Required. Input only. Password for the MySQL connection.
"port": 42, # Port for the MySQL connection, default value is 3306.
"sslConfig": { # MySQL SSL configuration information. # SSL configuration for the MySQL connection.
"caCertificate": "A String", # Input only. PEM-encoded certificate of the CA that signed the source database server's certificate.
"caCertificateSet": True or False, # Output only. Indicates whether the ca_certificate field is set.
"clientCertificate": "A String", # Input only. PEM-encoded certificate that will be used by the replica to authenticate against the source database server. If this field is used then the 'client_key' and the 'ca_certificate' fields are mandatory.
"clientCertificateSet": True or False, # Output only. Indicates whether the client_certificate field is set.
"clientKey": "A String", # Input only. PEM-encoded private key associated with the Client Certificate. If this field is used then the 'client_certificate' and the 'ca_certificate' fields are mandatory.
"clientKeySet": True or False, # Output only. Indicates whether the client_key field is set.
},
"username": "A String", # Required. Username for the MySQL connection.
},
"name": "A String", # Output only. The resource's name.
"oracleProfile": { # Oracle database profile. # Oracle ConnectionProfile configuration.
"connectionAttributes": { # Connection string attributes
"a_key": "A String",
},
"databaseService": "A String", # Required. Database for the Oracle connection.
"hostname": "A String", # Required. Hostname for the Oracle connection.
"oracleSslConfig": { # Oracle SSL configuration information. # Optional. SSL configuration for the Oracle connection.
"caCertificate": "A String", # Input only. PEM-encoded certificate of the CA that signed the source database server's certificate.
"caCertificateSet": True or False, # Output only. Indicates whether the ca_certificate field has been set for this Connection-Profile.
},
"password": "A String", # Required. Password for the Oracle connection.
"port": 42, # Port for the Oracle connection, default value is 1521.
"username": "A String", # Required. Username for the Oracle connection.
},
"postgresqlProfile": { # PostgreSQL database profile. # PostgreSQL Connection Profile configuration.
"database": "A String", # Required. Database for the PostgreSQL connection.
"hostname": "A String", # Required. Hostname for the PostgreSQL connection.
"password": "A String", # Required. Password for the PostgreSQL connection.
"port": 42, # Port for the PostgreSQL connection, default value is 5432.
"username": "A String", # Required. Username for the PostgreSQL connection.
},
"privateConnectivity": { # Private Connectivity # Private connectivity.
"privateConnection": "A String", # Required. A reference to a private connection resource. Format: `projects/{project}/locations/{location}/privateConnections/{name}`
},
"sqlServerProfile": { # SQLServer database profile # SQLServer Connection Profile configuration.
"database": "A String", # Required. Database for the SQLServer connection.
"hostname": "A String", # Required. Hostname for the SQLServer connection.
"password": "A String", # Required. Password for the SQLServer connection.
"port": 42, # Port for the SQLServer connection, default value is 1433.
"username": "A String", # Required. Username for the SQLServer connection.
},
"staticServiceIpConnectivity": { # Static IP address connectivity. Used when the source database is configured to allow incoming connections from the Datastream public IP addresses for the region specified in the connection profile. # Static Service IP connectivity.
},
"updateTime": "A String", # Output only. The update time of the resource.
},
],
"nextPageToken": "A String", # A token, which can be sent as `page_token` to retrieve the next page. If this field is omitted, there are no subsequent pages.
"unreachable": [ # Locations that could not be reached.
"A String",
],
}
list_next()
Retrieves the next page of results.
Args:
previous_request: The request for the previous page. (required)
previous_response: The response from the request for the previous page. (required)
Returns:
A request object that you can call 'execute()' on to request the next
page. Returns None if there are no more items in the collection.
patch(name, body=None, force=None, requestId=None, updateMask=None, validateOnly=None, x__xgafv=None)
Use this method to update the parameters of a connection profile.
Args:
name: string, Output only. The resource's name. (required)
body: object, The request body.
The object takes the form of:
{ # A set of reusable connection configurations to be used as a source or destination for a stream.
"bigqueryProfile": { # BigQuery warehouse profile. # BigQuery Connection Profile configuration.
},
"createTime": "A String", # Output only. The create time of the resource.
"displayName": "A String", # Required. Display name.
"forwardSshConnectivity": { # Forward SSH Tunnel connectivity. # Forward SSH tunnel connectivity.
"hostname": "A String", # Required. Hostname for the SSH tunnel.
"password": "A String", # Input only. SSH password.
"port": 42, # Port for the SSH tunnel, default value is 22.
"privateKey": "A String", # Input only. SSH private key.
"username": "A String", # Required. Username for the SSH tunnel.
},
"gcsProfile": { # Cloud Storage bucket profile. # Cloud Storage ConnectionProfile configuration.
"bucket": "A String", # Required. The Cloud Storage bucket name.
"rootPath": "A String", # The root path inside the Cloud Storage bucket.
},
"labels": { # Labels.
"a_key": "A String",
},
"mysqlProfile": { # MySQL database profile. # MySQL ConnectionProfile configuration.
"hostname": "A String", # Required. Hostname for the MySQL connection.
"password": "A String", # Required. Input only. Password for the MySQL connection.
"port": 42, # Port for the MySQL connection, default value is 3306.
"sslConfig": { # MySQL SSL configuration information. # SSL configuration for the MySQL connection.
"caCertificate": "A String", # Input only. PEM-encoded certificate of the CA that signed the source database server's certificate.
"caCertificateSet": True or False, # Output only. Indicates whether the ca_certificate field is set.
"clientCertificate": "A String", # Input only. PEM-encoded certificate that will be used by the replica to authenticate against the source database server. If this field is used then the 'client_key' and the 'ca_certificate' fields are mandatory.
"clientCertificateSet": True or False, # Output only. Indicates whether the client_certificate field is set.
"clientKey": "A String", # Input only. PEM-encoded private key associated with the Client Certificate. If this field is used then the 'client_certificate' and the 'ca_certificate' fields are mandatory.
"clientKeySet": True or False, # Output only. Indicates whether the client_key field is set.
},
"username": "A String", # Required. Username for the MySQL connection.
},
"name": "A String", # Output only. The resource's name.
"oracleProfile": { # Oracle database profile. # Oracle ConnectionProfile configuration.
"connectionAttributes": { # Connection string attributes
"a_key": "A String",
},
"databaseService": "A String", # Required. Database for the Oracle connection.
"hostname": "A String", # Required. Hostname for the Oracle connection.
"oracleSslConfig": { # Oracle SSL configuration information. # Optional. SSL configuration for the Oracle connection.
"caCertificate": "A String", # Input only. PEM-encoded certificate of the CA that signed the source database server's certificate.
"caCertificateSet": True or False, # Output only. Indicates whether the ca_certificate field has been set for this Connection-Profile.
},
"password": "A String", # Required. Password for the Oracle connection.
"port": 42, # Port for the Oracle connection, default value is 1521.
"username": "A String", # Required. Username for the Oracle connection.
},
"postgresqlProfile": { # PostgreSQL database profile. # PostgreSQL Connection Profile configuration.
"database": "A String", # Required. Database for the PostgreSQL connection.
"hostname": "A String", # Required. Hostname for the PostgreSQL connection.
"password": "A String", # Required. Password for the PostgreSQL connection.
"port": 42, # Port for the PostgreSQL connection, default value is 5432.
"username": "A String", # Required. Username for the PostgreSQL connection.
},
"privateConnectivity": { # Private Connectivity # Private connectivity.
"privateConnection": "A String", # Required. A reference to a private connection resource. Format: `projects/{project}/locations/{location}/privateConnections/{name}`
},
"sqlServerProfile": { # SQLServer database profile # SQLServer Connection Profile configuration.
"database": "A String", # Required. Database for the SQLServer connection.
"hostname": "A String", # Required. Hostname for the SQLServer connection.
"password": "A String", # Required. Password for the SQLServer connection.
"port": 42, # Port for the SQLServer connection, default value is 1433.
"username": "A String", # Required. Username for the SQLServer connection.
},
"staticServiceIpConnectivity": { # Static IP address connectivity. Used when the source database is configured to allow incoming connections from the Datastream public IP addresses for the region specified in the connection profile. # Static Service IP connectivity.
},
"updateTime": "A String", # Output only. The update time of the resource.
}
force: boolean, Optional. Update the connection profile without validating it.
requestId: string, Optional. A request ID to identify requests. Specify a unique request ID so that if you must retry your request, the server will know to ignore the request if it has already been completed. The server will guarantee that for at least 60 minutes since the first request. For example, consider a situation where you make an initial request and the request times out. If you make the request again with the same request ID, the server can check if original operation with the same request ID was received, and if so, will ignore the second request. This prevents clients from accidentally creating duplicate commitments. The request ID must be a valid UUID with the exception that zero UUID is not supported (00000000-0000-0000-0000-000000000000).
updateMask: string, Optional. Field mask is used to specify the fields to be overwritten in the ConnectionProfile resource by the update. The fields specified in the update_mask are relative to the resource, not the full request. A field will be overwritten if it is in the mask. If the user does not provide a mask then all fields will be overwritten.
validateOnly: boolean, Optional. Only validate the connection profile, but don't update any resources. The default is false.
x__xgafv: string, V1 error format.
Allowed values
1 - v1 error format
2 - v2 error format
Returns:
An object of the form:
{ # This resource represents a long-running operation that is the result of a network API call.
"done": True or False, # If the value is `false`, it means the operation is still in progress. If `true`, the operation is completed, and either `error` or `response` is available.
"error": { # The `Status` type defines a logical error model that is suitable for different programming environments, including REST APIs and RPC APIs. It is used by [gRPC](https://github.com/grpc). Each `Status` message contains three pieces of data: error code, error message, and error details. You can find out more about this error model and how to work with it in the [API Design Guide](https://cloud.google.com/apis/design/errors). # The error result of the operation in case of failure or cancellation.
"code": 42, # The status code, which should be an enum value of google.rpc.Code.
"details": [ # A list of messages that carry the error details. There is a common set of message types for APIs to use.
{
"a_key": "", # Properties of the object. Contains field @type with type URL.
},
],
"message": "A String", # A developer-facing error message, which should be in English. Any user-facing error message should be localized and sent in the google.rpc.Status.details field, or localized by the client.
},
"metadata": { # Service-specific metadata associated with the operation. It typically contains progress information and common metadata such as create time. Some services might not provide such metadata. Any method that returns a long-running operation should document the metadata type, if any.
"a_key": "", # Properties of the object. Contains field @type with type URL.
},
"name": "A String", # The server-assigned name, which is only unique within the same service that originally returns it. If you use the default HTTP mapping, the `name` should be a resource name ending with `operations/{unique_id}`.
"response": { # The normal, successful response of the operation. If the original method returns no data on success, such as `Delete`, the response is `google.protobuf.Empty`. If the original method is standard `Get`/`Create`/`Update`, the response should be the resource. For other methods, the response should have the type `XxxResponse`, where `Xxx` is the original method name. For example, if the original method name is `TakeSnapshot()`, the inferred response type is `TakeSnapshotResponse`.
"a_key": "", # Properties of the object. Contains field @type with type URL.
},
}