pulumi-gcp-kotlin/com.pulumi.gcp.bigquery.kotlin/ConnectionArgs

ConnectionArgs

data class ConnectionArgs(val aws: Output<ConnectionAwsArgs>? = null, val azure: Output<ConnectionAzureArgs>? = null, val cloudResource: Output<ConnectionCloudResourceArgs>? = null, val cloudSpanner: Output<ConnectionCloudSpannerArgs>? = null, val cloudSql: Output<ConnectionCloudSqlArgs>? = null, val connectionId: Output<String>? = null, val description: Output<String>? = null, val friendlyName: Output<String>? = null, val location: Output<String>? = null, val project: Output<String>? = null) : ConvertibleToJava<ConnectionArgs>

A connection allows BigQuery connections to external data sources.. To get more information about Connection, see:

API documentation
How-to Guides

Cloud SQL federated queries

Warning: All arguments including the following potentially sensitive values will be stored in the raw state as plain text: cloud_sql.credential.password. Read more about sensitive data in state.

Example Usage

Bigquery Connection Cloud Resource

package generated_program;
import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.gcp.bigquery.Connection;
import com.pulumi.gcp.bigquery.ConnectionArgs;
import com.pulumi.gcp.bigquery.inputs.ConnectionCloudResourceArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;
public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }
    public static void stack(Context ctx) {
        var connection = new Connection("connection", ConnectionArgs.builder()
            .cloudResource()
            .connectionId("my-connection")
            .description("a riveting description")
            .friendlyName("👋")
            .location("US")
            .build());
    }
}

Bigquery Connection Basic

package generated_program;
import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.gcp.sql.DatabaseInstance;
import com.pulumi.gcp.sql.DatabaseInstanceArgs;
import com.pulumi.gcp.sql.inputs.DatabaseInstanceSettingsArgs;
import com.pulumi.gcp.sql.Database;
import com.pulumi.gcp.sql.DatabaseArgs;
import com.pulumi.random.RandomPassword;
import com.pulumi.random.RandomPasswordArgs;
import com.pulumi.gcp.sql.User;
import com.pulumi.gcp.sql.UserArgs;
import com.pulumi.gcp.bigquery.Connection;
import com.pulumi.gcp.bigquery.ConnectionArgs;
import com.pulumi.gcp.bigquery.inputs.ConnectionCloudSqlArgs;
import com.pulumi.gcp.bigquery.inputs.ConnectionCloudSqlCredentialArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;
public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }
    public static void stack(Context ctx) {
        var instance = new DatabaseInstance("instance", DatabaseInstanceArgs.builder()
            .databaseVersion("POSTGRES_11")
            .region("us-central1")
            .settings(DatabaseInstanceSettingsArgs.builder()
                .tier("db-f1-micro")
                .build())
            .deletionProtection("true")
            .build());
        var db = new Database("db", DatabaseArgs.builder()
            .instance(instance.name())
            .build());
        var pwd = new RandomPassword("pwd", RandomPasswordArgs.builder()
            .length(16)
            .special(false)
            .build());
        var user = new User("user", UserArgs.builder()
            .instance(instance.name())
            .password(pwd.result())
            .build());
        var connection = new Connection("connection", ConnectionArgs.builder()
            .friendlyName("👋")
            .description("a riveting description")
            .location("US")
            .cloudSql(ConnectionCloudSqlArgs.builder()
                .instanceId(instance.connectionName())
                .database(db.name())
                .type("POSTGRES")
                .credential(ConnectionCloudSqlCredentialArgs.builder()
                    .username(user.name())
                    .password(user.password())
                    .build())
                .build())
            .build());
    }
}

Bigquery Connection Full

package generated_program;
import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.gcp.sql.DatabaseInstance;
import com.pulumi.gcp.sql.DatabaseInstanceArgs;
import com.pulumi.gcp.sql.inputs.DatabaseInstanceSettingsArgs;
import com.pulumi.gcp.sql.Database;
import com.pulumi.gcp.sql.DatabaseArgs;
import com.pulumi.random.RandomPassword;
import com.pulumi.random.RandomPasswordArgs;
import com.pulumi.gcp.sql.User;
import com.pulumi.gcp.sql.UserArgs;
import com.pulumi.gcp.bigquery.Connection;
import com.pulumi.gcp.bigquery.ConnectionArgs;
import com.pulumi.gcp.bigquery.inputs.ConnectionCloudSqlArgs;
import com.pulumi.gcp.bigquery.inputs.ConnectionCloudSqlCredentialArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;
public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }
    public static void stack(Context ctx) {
        var instance = new DatabaseInstance("instance", DatabaseInstanceArgs.builder()
            .databaseVersion("POSTGRES_11")
            .region("us-central1")
            .settings(DatabaseInstanceSettingsArgs.builder()
                .tier("db-f1-micro")
                .build())
            .deletionProtection("true")
            .build());
        var db = new Database("db", DatabaseArgs.builder()
            .instance(instance.name())
            .build());
        var pwd = new RandomPassword("pwd", RandomPasswordArgs.builder()
            .length(16)
            .special(false)
            .build());
        var user = new User("user", UserArgs.builder()
            .instance(instance.name())
            .password(pwd.result())
            .build());
        var connection = new Connection("connection", ConnectionArgs.builder()
            .connectionId("my-connection")
            .location("US")
            .friendlyName("👋")
            .description("a riveting description")
            .cloudSql(ConnectionCloudSqlArgs.builder()
                .instanceId(instance.connectionName())
                .database(db.name())
                .type("POSTGRES")
                .credential(ConnectionCloudSqlCredentialArgs.builder()
                    .username(user.name())
                    .password(user.password())
                    .build())
                .build())
            .build());
    }
}

Bigquery Connection Aws

package generated_program;
import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.gcp.bigquery.Connection;
import com.pulumi.gcp.bigquery.ConnectionArgs;
import com.pulumi.gcp.bigquery.inputs.ConnectionAwsArgs;
import com.pulumi.gcp.bigquery.inputs.ConnectionAwsAccessRoleArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;
public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }
    public static void stack(Context ctx) {
        var connection = new Connection("connection", ConnectionArgs.builder()
            .aws(ConnectionAwsArgs.builder()
                .accessRole(ConnectionAwsAccessRoleArgs.builder()
                    .iamRoleId("arn:aws:iam::999999999999:role/omnirole")
                    .build())
                .build())
            .connectionId("my-connection")
            .description("a riveting description")
            .friendlyName("👋")
            .location("aws-us-east-1")
            .build());
    }
}

Bigquery Connection Azure

package generated_program;
import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.gcp.bigquery.Connection;
import com.pulumi.gcp.bigquery.ConnectionArgs;
import com.pulumi.gcp.bigquery.inputs.ConnectionAzureArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;
public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }
    public static void stack(Context ctx) {
        var connection = new Connection("connection", ConnectionArgs.builder()
            .azure(ConnectionAzureArgs.builder()
                .customerTenantId("customer-tenant-id")
                .federatedApplicationClientId("b43eeeee-eeee-eeee-eeee-a480155501ce")
                .build())
            .connectionId("my-connection")
            .description("a riveting description")
            .friendlyName("👋")
            .location("azure-eastus2")
            .build());
    }
}

Bigquery Connection Cloudspanner

package generated_program;
import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.gcp.bigquery.Connection;
import com.pulumi.gcp.bigquery.ConnectionArgs;
import com.pulumi.gcp.bigquery.inputs.ConnectionCloudSpannerArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;
public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }
    public static void stack(Context ctx) {
        var connection = new Connection("connection", ConnectionArgs.builder()
            .cloudSpanner(ConnectionCloudSpannerArgs.builder()
                .database("projects/project/instances/instance/databases/database")
                .build())
            .connectionId("my-connection")
            .description("a riveting description")
            .friendlyName("👋")
            .location("US")
            .build());
    }
}

Import

Connection can be imported using any of these accepted formats

$ pulumi import gcp:bigquery/connection:Connection default projects/{{project}}/locations/{{location}}/connections/{{connection_id}}

$ pulumi import gcp:bigquery/connection:Connection default {{project}}/{{location}}/{{connection_id}}

$ pulumi import gcp:bigquery/connection:Connection default {{location}}/{{connection_id}}

Constructors

ConnectionArgs

constructor(aws: Output<ConnectionAwsArgs>? = null, azure: Output<ConnectionAzureArgs>? = null, cloudResource: Output<ConnectionCloudResourceArgs>? = null, cloudSpanner: Output<ConnectionCloudSpannerArgs>? = null, cloudSql: Output<ConnectionCloudSqlArgs>? = null, connectionId: Output<String>? = null, description: Output<String>? = null, friendlyName: Output<String>? = null, location: Output<String>? = null, project: Output<String>? = null)

Properties

aws

val aws: Output<ConnectionAwsArgs>? = null

Connection properties specific to Amazon Web Services. Structure is documented below.

azure

val azure: Output<ConnectionAzureArgs>? = null

Container for connection properties specific to Azure. Structure is documented below.

cloudResource

val cloudResource: Output<ConnectionCloudResourceArgs>? = null

Container for connection properties for delegation of access to GCP resources. Structure is documented below.

cloudSpanner

val cloudSpanner: Output<ConnectionCloudSpannerArgs>? = null

Connection properties specific to Cloud Spanner Structure is documented below.

cloudSql

val cloudSql: Output<ConnectionCloudSqlArgs>? = null

Connection properties specific to the Cloud SQL. Structure is documented below.

connectionId

val connectionId: Output<String>? = null

Optional connection id that should be assigned to the created connection.

description

val description: Output<String>? = null

A descriptive description for the connection

friendlyName

val friendlyName: Output<String>? = null

A descriptive name for the connection

location

val location: Output<String>? = null

The geographic location where the connection should reside. Cloud SQL instance must be in the same location as the connection with following exceptions: Cloud SQL us-central1 maps to BigQuery US, Cloud SQL europe-west1 maps to BigQuery EU. Examples: US, EU, asia-northeast1, us-central1, europe-west1. Spanner Connections same as spanner region AWS allowed regions are aws-us-east-1 Azure allowed regions are azure-eastus2

project

val project: Output<String>? = null

The ID of the project in which the resource belongs. If it is not provided, the provider project is used.

Functions

toJava

open override fun toJava(): ConnectionArgs