def main(project_id: str = "your-project-id", location: str = "US") -> None:
"""Prints details and summary information about connections for a given admin project and location"""
client = bq_connection.ConnectionServiceClient()
print(
f"List of connections in project {project_id} in location {location}")
req = bq_connection.ListConnectionsRequest(
parent=client.common_location_path(project_id, location))
for connection in client.list_connections(request=req):
print(f"\tConnection {connection.friendly_name} ({connection.name})")
def sample_delete_connection():
# Create a client
client = bigquery_connection_v1.ConnectionServiceClient()
# Initialize request argument(s)
request = bigquery_connection_v1.DeleteConnectionRequest(
name="name_value", )
# Make the request
client.delete_connection(request=request)
def sample_set_iam_policy():
# Create a client
client = bigquery_connection_v1.ConnectionServiceClient()
# Initialize request argument(s)
request = iam_policy_pb2.SetIamPolicyRequest(resource="resource_value", )
# Make the request
response = client.set_iam_policy(request=request)
# Handle the response
print(response)
def sample_get_connection():
# Create a client
client = bigquery_connection_v1.ConnectionServiceClient()
# Initialize request argument(s)
request = bigquery_connection_v1.GetConnectionRequest(name="name_value", )
# Make the request
response = client.get_connection(request=request)
# Handle the response
print(response)
def sample_create_connection():
# Create a client
client = bigquery_connection_v1.ConnectionServiceClient()
# Initialize request argument(s)
request = bigquery_connection_v1.CreateConnectionRequest(
parent="parent_value", )
# Make the request
response = client.create_connection(request=request)
# Handle the response
print(response)
def sample_test_iam_permissions():
# Create a client
client = bigquery_connection_v1.ConnectionServiceClient()
# Initialize request argument(s)
request = iam_policy_pb2.TestIamPermissionsRequest(
resource="resource_value",
permissions=['permissions_value_1', 'permissions_value_2'],
)
# Make the request
response = client.test_iam_permissions(request=request)
# Handle the response
print(response)
def create_mysql_connection(
project_id: str,
location: str,
cloud_sql_properties: bq_connection.CloudSqlProperties,
) -> None:
connection = bq_connection.types.Connection(
{"cloud_sql": cloud_sql_properties})
client = bq_connection.ConnectionServiceClient()
parent = client.common_location_path(project_id, location)
request = bq_connection.CreateConnectionRequest({
"parent": parent,
"connection": connection
})
response = client.create_connection(request)
print(f"Created connection successfully: {response.name}")
def sample_list_connections():
# Create a client
client = bigquery_connection_v1.ConnectionServiceClient()
# Initialize request argument(s)
request = bigquery_connection_v1.ListConnectionsRequest(
parent="parent_value",
page_size=951,
)
# Make the request
page_result = client.list_connections(request=request)
# Handle the response
for response in page_result:
print(response)