Sandy
New Contributor
Joined 4 years ago
User Profile
User Widgets
Contributions
Re: DateTime Milliseconds issue with AZURE bulk load
Hi Here is the sample date which goes from DB2 to Azure SQL. ‘2022-11-16 03:27:20.038261’. I am using this to extract the timestamp ($LAST_UPDT_TIMESTAMP != null) ? ( $LAST_UPDT_TIMESTAMP .toString().substr(0,10) +" "+ $LAST_UPDT_TIMESTAMP .toString().substr(11,8) + “.” + $LAST_UPDT_TIMESTAMP .toString().substr(14,7) ) : null Thank you.3.8KViews0likes0CommentsDateTime Milliseconds issue with AZURE bulk load
Hi, When migrating data from DB2 to Azure using Azure bulk load snap, the milliseconds are not populating in Azure SQL tables ( data type used is datetime2(7) ). For milliseconds the data is coming as ‘0000000’. On DB2 side the, timestamp format is yyyy-MM-dd HH:mm:ss.SSSSSS. I am using substring to extract the date time and I see date with milliseconds is coming thru the mapper but the same is not inserting into Azure tables. Itried hardcoding the milliseconds in the mapper and still it didnt work. Please let me know if there is any work around to populate the milliseconds.4KViews0likes3CommentsError message on snowflake bulkload
I am trying to migrate the data from MySQL to Snowflake DB. I am getting th following error message with snowflake bulk load snap. I have entered the data for all the columns but still getting the same error. “reason”: “The·input·to·the·SF·Bulk·Load·snap·should·contain·the·column·values·to·load·into·SF·database.” “resolution”: “All·columns·which·do·not·have·default·values·have·to·be·specified·in·the·input·document.” “status_code”: “error” “snap_details”:{ “label”:“Snowflake·-·Bulk·Load”,“instance_id”:“eb0986a2-ccf4-4c13-90d3-219924d9b3a8”,“class_id”:“com-snaplogic-snaps-snowflake-bulkload”,“build_tag”:“429patches16458”,“views”:{…}2KViews0likes1Comment