Class: Aws::Kendra::Types::SqlConfiguration

Inherits:
Struct
  • Object
show all
Includes:
Structure
Defined in:
lib/aws-sdk-kendra/types.rb

Overview

Note:

When making an API call, you may pass SqlConfiguration data as a hash:

{
  query_identifiers_enclosing_option: "DOUBLE_QUOTES", # accepts DOUBLE_QUOTES, NONE
}

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

Constant Summary collapse

SENSITIVE =
[]

Instance Attribute Summary collapse

Instance Attribute Details

#query_identifiers_enclosing_optionString

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

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`.

Returns:

  • (String)

5903
5904
5905
5906
5907
# File 'lib/aws-sdk-kendra/types.rb', line 5903

class SqlConfiguration < Struct.new(
  :query_identifiers_enclosing_option)
  SENSITIVE = []
  include Aws::Structure
end