> ## Documentation Index > Fetch the complete documentation index at: https://insightsoftware-preview.mintlify.site/llms.txt > Use this file to discover all available pages before exploring further. # Data Types The Simba Athena ODBC Driver supports many common data formats, converting between Athena data types and SQL data types. The following table lists the supported data type mappings.
Athena TypeSQL Type

ARRAY

  • SQL\_VARCHAR if the Use SQL Unicode Types option (the `UseSQLUnicodeTypes` property) is disabled.
  • SQL\_WVARCHAR if the Use SQL Unicode Types option (the `UseSQLUnicodeTypes` property) is enabled.

BIGINT

SQL\_BIGINT

BINARY

SQL\_VARBINARY

BOOLEAN

SQL\_BIT

CHAR
  • SQL\_CHAR if the Use SQL Unicode Types option (the `UseSQLUnicodeTypes` property) is disabled.
  • SQL\_WCHAR if the Use SQL Unicode Types option (the `UseSQLUnicodeTypes` property) is enabled.

DATE

**Note:** Not supported for Parquet files.
  • SQL\_TYPE\_DATE if theapplication uses ODBC version3.00 or later.
  • SQL\_DATE if the application usesan ODBC version earlier than3.00.

DECIMAL (p, s)

SQL\_DECIMAL

DOUBLE

SQL\_DOUBLE

FLOATSQL\_REAL

INTEGER

**Note:** Although Athena reports integer data as type INT, the connector reports integer data as type INTEGER to ensure compatibility with standard BI tools. For more information, see [Integer Support](#integer_support).

SQL\_INTEGER

MAP

  • SQL\_VARCHAR if the Use SQL Unicode Types option (the `UseSQLUnicodeTypes` property) is disabled.
  • SQL\_WVARCHAR if the Use SQL Unicode Types option (the `UseSQLUnicodeTypes` property) is enabled.

SMALLINT

SQL\_SMALLINT

STRING

  • SQL\_VARCHAR if the Use SQL Unicode Types option (the `UseSQLUnicodeTypes` property) is disabled.
  • SQL\_WVARCHAR if the Use SQL Unicode Types option (the `UseSQLUnicodeTypes` property) is enabled.

STRUCT

  • SQL\_VARCHAR if the Use SQL Unicode Types option (the `UseSQLUnicodeTypes` property) is disabled.
  • SQL\_WVARCHAR if the Use SQL Unicode Types option (the `UseSQLUnicodeTypes` property) is enabled.

TIMESTAMP

  • SQL\_TYPE\_TIMESTAMP if theapplication uses ODBC version3.00 or later.
  • SQL\_TIMESTAMP if the application usesan ODBC version earlier than3.00.

TINYINT

SQL\_TINYINT

VARCHAR

  • SQL\_VARCHAR if the Use SQL Unicode Types option (the `UseSQLUnicodeTypes` property) is disabled.
  • SQL\_WVARCHAR if the Use SQL Unicode Types option (the `UseSQLUnicodeTypes` property) is enabled.
## Integer Support Athena combines two different implementations of the integer data type: * In Data Definition Language (DDL) queries, Athena uses the INT data type from Apache Hive. * In all other queries, Athena uses the INTEGER data type from Presto. To support the CAST queries that are used in many BI tools, the connector reports integer data as type INTEGER even though Athena reports the data as type INT. **Note:** Be aware that, when executing DDL queries, you must specify integer data using INT as the data type. Athena supports some but not all DDL statements. For a list of the supported DDL statements, see "SQL and HiveQL Reference" in the *Amazon Athena API Reference* : [http://docs.aws.amazon.com/athena/latest/ug/language-reference.html](http://docs.aws.amazon.com/athena/latest/ug/language-reference.html).