Output Data : date is now datetime, making my output crashing

Question

Hello all,

I try to ouput a flow in a MonetDB SQL database. As you can see, I only take very simple field types

However I get this error message :

Error: Output Data (3): Error creating table "exemplecomparetable.toto": [MonetDB][ODBC Driver 11.44.0][MONETDB_SAU]Type (datetime) unknown in: "create  table "exemplecomparetable"."toto" ("ID" int,"Libellé" char(50),"Date d"
syntax error in: ""Prix""
CREATE  TABLE "exemplecomparetable"."toto" ("ID" int,"Libellé" char(50),"Date de Maj" datetime,"Prix" float,"PMP" float)

I really don't understand why the hell would Alteryx  change my date into datetime. This doesn't make sense at all. Any idea ?

Best regards,

Simon

simonaubert_bd · Answer

Hello @Samantha_Jayne

Done here : https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Generic-in-memory-odbc-connection-please-stop-inventing-and/idi-p/977722#M17458

I found the same issue with informix too.

Samantha_Jayne · Answer

No problem @simonaubert_bd.

You may have already done this, but if you haven't it may be worth adding an idea to the ideas page to get your database supported. Ideas is where product looks first and you can link this discussion to it, if you have a larger user base internally get them to support your idea so we can know how many people this affects.

simonaubert_bd · Answer

Hello @Samantha_Jayne  No, it's not on the supported list, that's why I haven't create a ticket ;)

However, even if not officially supported, it still be an ODBC/SQL database which follows the norm (at least the basics). And there is no reason, even in this case, that a date is migrated to a datetime. Interoperability is key to provide high value to customer.

Best regards,

Simon