Class CfnDataSourcePropsMixin.SqlConfigurationProperty

Provides information that configures Amazon Kendra to use a SQL database.

Inheritance
object
CfnDataSourcePropsMixin.SqlConfigurationProperty
Inherited Members
Namespace: Amazon.CDK.Mixins.Preview.AWS.Kendra.Mixins
Assembly: Amazon.CDK.Mixins.Preview.dll
Syntax (csharp)
public class CfnDataSourcePropsMixin.SqlConfigurationProperty : CfnDataSourcePropsMixin.ISqlConfigurationProperty
Syntax (vb)
Public Class CfnDataSourcePropsMixin.SqlConfigurationProperty Implements CfnDataSourcePropsMixin.ISqlConfigurationProperty
Remarks

See: http://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-properties-kendra-datasource-sqlconfiguration.html

ExampleMetadata: fixture=_generated

Examples
// The code below shows an example of how to instantiate this type.
             // The values are placeholders you should change.
             using Amazon.CDK.Mixins.Preview.AWS.Kendra.Mixins;

             var sqlConfigurationProperty = new SqlConfigurationProperty {
                 QueryIdentifiersEnclosingOption = "queryIdentifiersEnclosingOption"
             };

Synopsis

Constructors

SqlConfigurationProperty()

Provides information that configures Amazon Kendra to use a SQL database.

Properties

QueryIdentifiersEnclosingOption

Determines whether Amazon Kendra encloses SQL identifiers for tables and column names in double quotes (") when making a database query.

Constructors

SqlConfigurationProperty()

Provides information that configures Amazon Kendra to use a SQL database.

public SqlConfigurationProperty()
Remarks

See: http://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-properties-kendra-datasource-sqlconfiguration.html

ExampleMetadata: fixture=_generated

Examples
// The code below shows an example of how to instantiate this type.
             // The values are placeholders you should change.
             using Amazon.CDK.Mixins.Preview.AWS.Kendra.Mixins;

             var sqlConfigurationProperty = new SqlConfigurationProperty {
                 QueryIdentifiersEnclosingOption = "queryIdentifiersEnclosingOption"
             };

Properties

QueryIdentifiersEnclosingOption

Determines whether Amazon Kendra encloses SQL identifiers for tables and column names in double quotes (") when making a database query.

public string? QueryIdentifiersEnclosingOption { get; set; }
Property Value

string

Remarks

You can set the value to DOUBLE_QUOTES or NONE .

By default, Amazon Kendra passes SQL identifiers the way that they are entered into the data source configuration. It does not change the case of identifiers or enclose them in quotes.

PostgreSQL internally converts uppercase characters to lower case characters in identifiers unless they are quoted. Choosing this option encloses identifiers in quotes so that PostgreSQL does not convert the character's case.

For MySQL databases, you must enable the ansi_quotes option when you set this field to DOUBLE_QUOTES .

See: http://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-properties-kendra-datasource-sqlconfiguration.html#cfn-kendra-datasource-sqlconfiguration-queryidentifiersenclosingoption

Implements