software.amazon.awscdk.services.kendra

Interface CfnDataSource.SqlConfigurationProperty

All Known Implementing Classes:

CfnDataSource.SqlConfigurationProperty.Jsii$Proxy

Enclosing class:

CfnDataSource

public static interface CfnDataSource.SqlConfigurationProperty

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

Example:

 // The code below shows an example of how to instantiate this type.
 // The values are placeholders you should change.
 import software.amazon.awscdk.services.kendra.*;
 SqlConfigurationProperty sqlConfigurationProperty = SqlConfigurationProperty.builder()
         .queryIdentifiersEnclosingOption("queryIdentifiersEnclosingOption")
         .build();
 

Nested Class Summary

Nested Classes

Modifier and Type	Interface and Description
static class	CfnDataSource.SqlConfigurationProperty.Builder A builder for CfnDataSource.SqlConfigurationProperty
static class	CfnDataSource.SqlConfigurationProperty.Jsii$Proxy An implementation for CfnDataSource.SqlConfigurationProperty

Method Summary

Modifier and Type	Method and Description
static CfnDataSource.SqlConfigurationProperty.Builder	builder()
default java.lang.String	getQueryIdentifiersEnclosingOption() Determines whether Amazon Kendra encloses SQL identifiers for tables and column names in double quotes (") when making a database query.

Method Detail

getQueryIdentifiersEnclosingOption

default java.lang.String getQueryIdentifiersEnclosingOption()

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

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 .

builder

static CfnDataSource.SqlConfigurationProperty.Builder builder()

Returns:

a CfnDataSource.SqlConfigurationProperty.Builder of CfnDataSource.SqlConfigurationProperty