Closed PAPutzback closed 3 years ago
ssegal100
commented
3 years ago Hi @PAPutzback. If you are trying to only insert rows, then you can just leave those columns out. If you do that it will not explicitly set those columns to anything, so the defaults should work. You won't be able to do an insert and update in the same 'upload' function though. Let me know if this could work for you. If you can think of a behavior change that can help, let me know. Thanks.
ssegal100
commented
3 years ago @PAPutzback Is there any improvements that we can do to help? Maybe I'm not completely understanding the issue. Thanks.
ssegal100
commented
3 years ago @PAPutzback Was there anything I can help with on this issue? If not I'd like to close it out. Thanks. Steve
PAPutzback
commented
3 years ago Sorry for not getting back to you. I got pulled off to another project. Please close the ticket,
On Tue, Mar 23, 2021 at 11:37 AM Steven Segal @.***> wrote:
@PAPutzback https://github.com/PAPutzback Was there anything I can help with on this issue? If not I'd like to close it out. Thanks. Steve
— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/Snowflake-Labs/Excelerator/issues/8#issuecomment-805004728, or unsubscribe https://github.com/notifications/unsubscribe-auth/ACXNWYR4JKNGISEOXEP4WLDTFCYSTANCNFSM4VMNE6TA .
ssegal100
commented
3 years ago Thanks!
If I insert a row and leave the Primary key field empty since it is supposed to autogenerate the id on insert and\or I leave another column with the default set to CURRENT_TIMESTAMP(). Neither the ID or the date gets set. They end up being set to empty strings. Without the key this also makes deletes a bit of an issue and the user will need rules to add additional key fields. Great Addin though. I'll just have to add some instructions for the users to look up the last ID and increment it by 1 and type in the date and time for the CREATE DATE field.