Anson Chan
- Total activity 70
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 0
- Subscriptions 24
Comments
Recent activity by Anson Chan-
Good morning Konsta - Yes, Absolutely. I will list my workflow and logic here. Step 1 - Using JSON_ELEMENTS, JSON_KEYS, and JSON_VALUE parsing a JSON document that describes the inventory of a Clou...
-
Hello Konsta, Yes. you are correct. the data type of the policyStatementAction column is STRING The final goal for the transformation is to have the list of policy elements in a single column. Hope...
-
Thank you Konsta, it worked! much appreciated for your guidance, always. Kind Regards, Anson
-
Hello Konsta, Please find the below SHIFTTIMEZONE(#Attachment_AttachTime_UTC_DATE;"Asia/Manila";"Etc/UTC") Thanks, Anson
-
Hello Konsta, the formula I was using from Attachment_AttachTime_Asia_DATE was SHIFTTIMEZONE. Shifting time from UTC to Asia time thanks, Anson
-
Hello Alan, Much appreciated for yours and Datameer's support. thanks, Anson
-
Hello Konsta, good morning, we are using Datameer version 10.1.3 Connection for export is via a connection to Snowflake
-
Hello Konsta, Alan, Many thanks for the response. Yes, I've returned your enquiry and provided the information required. Happy new year! Anson
-
Hello Konsta, thanks for coming back. This is what I have in mind and I seek your professional guidance on the best approach to deal with this Many thanks! happy new year!
-
Hello Konsta, please find our version used below. Although I have Admin Access into Datameer but I do not have access to the AWS enviornment. I have attempted to try a few scheduled import jobs whi...