Could you submit a ticket for that? It should ideally contain the table’s schema, a sample input document, and any errors that show the generated sql.
For background we perform a database metadata query to learn what the database expects or provides and have a few dozen classes that convert between the database types and Document field types. In theory it should be easy to make the correct choice but even in the standard field types there are subtle differences, sometimes even between different major versions of a single product, that can cause problems with the conversions.
Off the top of my head the only reason we would try to use a varchar instead of a date or int is if the database metadata is reporting an unrecognized field type. That might be due to a new field type in a recently released version, a locally installed extension (e.g., postgis) that defines its own types, or simply an oversight. In some of those cases we can add that value to the internal lookup tables in the next release but we need to know what we need to add.
Thanks
@Vladimir, i want to upload a file into a blob container with REST snap and SAS (SharedAccessSignature). How to do it? There is no such example in Snaplogic document. Thanks.
