Im sure the data types on the table I'm inserting and the table in MySQL match, one thing I've noticed is dates are being shown as "Invalid Dates" on both my insert table and MySql table when displaying them on retool, don't know why but maybe lt can be an issue when inserting the data. If you know of anything else that could help I would really appreciate it and once again , Thanks for your response !
Hi @danielhurtado, ahh, it seems UNNEST is not the way to go since that seems to use records.map. Remove that and maybe try changing the data type of your date columns. As to how that is:
Click your table and look for the date column you want to change.
Change the Column Type to the same type of that in your database.
If it can't be done, you might want to do a JS transformer to align the data types before you bulk insert them in the database. I'm mostly touching the data layer and don't use insert quite often so apologies I provide limited help here.