Copyright | (c) 2013-2023 Brendan Hay |
---|---|
License | Mozilla Public License, v. 2.0. |
Maintainer | Brendan Hay |
Stability | auto-generated |
Portability | non-portable (GHC extensions) |
Safe Haskell | Safe-Inferred |
Language | Haskell2010 |
Documentation
data SqlConfiguration Source #
Provides the configuration information to use a SQL database.
See: newSqlConfiguration
smart constructor.
SqlConfiguration' | |
|
Instances
newSqlConfiguration :: SqlConfiguration Source #
Create a value of SqlConfiguration
with all optional fields omitted.
Use generic-lens or optics to modify other optional fields.
The following record fields are available, with the corresponding lenses provided for backwards compatibility:
$sel:queryIdentifiersEnclosingOption:SqlConfiguration'
, sqlConfiguration_queryIdentifiersEnclosingOption
- 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
.
sqlConfiguration_queryIdentifiersEnclosingOption :: Lens' SqlConfiguration (Maybe QueryIdentifiersEnclosingOption) Source #
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
.