varchar(1) data type in AWS Athena

[buldozek]

Which Type of data should I set in the Select Tool so it will appear as varchar(1) in Athena table? For example Int64 in Alteryx is bigint in Athena etc

Thank you,

[Thableaus]

Hi @buldozek 

I'd ask you take a look at the Amazon Athena documentation, but there's nothing there.

I'd try using V_WString (1) - support for UTF-8 Characters. If it does not work as expected, try V_String(1). It should be one of these.

Cheers,

[apathetichell]

Are you creating a new table in the output data tool - TBH Alteryx doesn't provide much customization for DDL - I'd love to see some kind of "custom" like we get in the filter tool with datastream in/write-in-db etc - that would allow you to get into the real specifics of the SQL being generated. - I'd also like more generalized DDL  tool (like say a DDL/CLI tool)...