DatabaseInputDefinitionProperty Struct
Connection information for dataset input files stored in a database.
Example
ts
// The code below shows an example of how to instantiate this type.
// The values are placeholders you should change.
import { aws_databrew as databrew } from 'aws-cdk-lib';
const databaseInputDefinitionProperty: databrew.CfnDataset.DatabaseInputDefinitionProperty = {
glueConnectionName: 'glueConnectionName',
// the properties below are optional
databaseTableName: 'databaseTableName',
queryString: 'queryString',
tempDirectory: {
bucket: 'bucket',
// the properties below are optional
bucketOwner: 'bucketOwner',
key: 'key',
},
};
python
# The code below shows an example of how to instantiate this type.
# The values are placeholders you should change.
from aws_cdk import aws_databrew as databrew
database_input_definition_property = databrew.CfnDataset.DatabaseInputDefinitionProperty(
glue_connection_name="glueConnectionName",
# the properties below are optional
database_table_name="databaseTableName",
query_string="queryString",
temp_directory=databrew.CfnDataset.S3LocationProperty(
bucket="bucket",
# the properties below are optional
bucket_owner="bucketOwner",
key="key"
)
)
java
// The code below shows an example of how to instantiate this type.
// The values are placeholders you should change.
import software.amazon.awscdk.services.databrew.*;
DatabaseInputDefinitionProperty databaseInputDefinitionProperty = DatabaseInputDefinitionProperty.builder()
.glueConnectionName("glueConnectionName")
// the properties below are optional
.databaseTableName("databaseTableName")
.queryString("queryString")
.tempDirectory(S3LocationProperty.builder()
.bucket("bucket")
// the properties below are optional
.bucketOwner("bucketOwner")
.key("key")
.build())
.build();
csharp
// Install: dotnet add package Amazon.CDK.Lib
// The code below shows an example of how to instantiate this type.
// The values are placeholders you should change.
using Amazon.CDK.AWS.DataBrew;
var databaseInputDefinitionProperty = new DatabaseInputDefinitionProperty {
GlueConnectionName = "glueConnectionName",
// the properties below are optional
DatabaseTableName = "databaseTableName",
QueryString = "queryString",
TempDirectory = new S3LocationProperty {
Bucket = "bucket",
// the properties below are optional
BucketOwner = "bucketOwner",
Key = "key"
}
};
go
// Install: go get github.com/aws/aws-cdk-go/awscdk/v2
// The code below shows an example of how to instantiate this type.
// The values are placeholders you should change.
import "github.com/aws/aws-cdk-go/awscdk"
databaseInputDefinitionProperty := &DatabaseInputDefinitionProperty{
GlueConnectionName: jsii.String("glueConnectionName"),
// the properties below are optional
DatabaseTableName: jsii.String("databaseTableName"),
QueryString: jsii.String("queryString"),
TempDirectory: &S3LocationProperty{
Bucket: jsii.String("bucket"),
// the properties below are optional
BucketOwner: jsii.String("bucketOwner"),
Key: jsii.String("key"),
},
}
Properties
databaseTableNameoptionalstringdatabase_table_nameoptionalstrdatabaseTableNameoptionalStringDatabaseTableNameoptionalstringDatabaseTableNameoptional*string#The table within the target database.
glueConnectionNamestringglue_connection_namestrglueConnectionNameStringGlueConnectionNamestringGlueConnectionName*stringrequired#The AWS Glue Connection that stores the connection information for the target database.
queryStringoptionalstringquery_stringoptionalstrqueryStringoptionalStringQueryStringoptionalstringQueryStringoptional*string#Custom SQL to run against the provided AWS Glue connection.
This SQL will be used as the input for DataBrew projects and jobs.
tempDirectoryoptionalIResolvable | CfnDataset.S3LocationPropertytemp_directoryoptionaltyping.Union[IResolvable, S3LocationProperty]tempDirectoryoptionalIResolvableTempDirectoryoptionalIResolvableTempDirectoryoptionalinterface{}#An Amazon location that AWS Glue Data Catalog can use as a temporary directory.