Re: FW: Data lake missing Wellsky data from yesterday 5/9/24

--00000000000036363b06181dcdeb Content-Type: multipart/alternative; boundary="00000000000036363b06181dcdea" --00000000000036363b06181dcdea Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable The team is still working on ingesting the Clearcare data into the warehouse ( Canada data is included in that same dataset). Once the data is loaded, the customer integration can be executed again. On Fri, May 10, 2024 at 9:47=E2=80=AFAM wrote: > Good Morning- > > > > It seems this delay has impacted Canada NetSuite Integration prep, as som= e > things Alyson was expecting to integrate today. If there is anything we c= an > do or request to expedite resolution, please let us know. > > > > Elizabeth Clark > > Director > > > > > > > > *From:* Monica Johnston > *Sent:* Friday, May 10, 2024 9:31 AM > *To:* Dart Team ; Data Engineering dataengineering@thekey.com> > *Subject:* Data lake missing Wellsky data from yesterday 5/9/24 > > > > This morning we did not receive any of the Canadian data from Wellsky. > This also caused an issue with our ability to load the US data into our > reporting tables in the data lake. > > > > *What is the Impact?* > > > > *Analytics Portal / Tableau Reports: *SoC, billed hours, revenue and > other metrics relying on Clearcare data are missing yesterday's totals. > > - ETA to have reports refreshed for US is 1 hour > - ETA for Canadian data is 4 hours > > *Billing: *Files sent to Netsuite this morning are missing data. We will > resend once Wellsky has provided the Canadian data. > > > > *Payroll:* This should not affect payroll. > > > > I will send out an update when I have more information. Please reach out > to me directly if you have any questions. > > > > Thanks! > > Monica > > > > BCC: Executive team, Regional Directors, Tableau Desktop Users, Payroll > Notifications, Billing Alerts > > > > -- > > *Monica Johnston * > > Director, Data Platform and Services > > johnstonm@thekey.com > > (602) 501-7890 > > *TheKey.com * > > [image: Image removed by sender. TheKey] > > > --=20 Frank Liu * Please note my email has changed: * fliu@thekey.com +1-650-996-9107 TheKey.com [image: TheKey] --00000000000036363b06181dcdea Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable The team is still working on ingesting the Clearcare = data into the warehouse ( Canada data is included in that same dataset).=C2= =A0=C2=A0 Once the data is loaded, the customer in= tegration can be executed again. On Fri, May 10, 2024 at 9:47= =E2=80=AFAM ecla= rk@thekey.com wrote: Good Morning- =C2=A0 It seems this delay has im= pacted Canada NetSuite Integration prep, as some things Alyson was expectin= g to integrate today. If there is anything we can do or request to expedite= resolution, please let us know. =C2=A0 Elizabeth=C2=A0Clark=C2=A0 Director =C2=A0 =C2=A0 =C2=A0 From: Monica Johnston = johnstonm@the= key.com Sent: Friday, May 10, 2024 9:31 AM To: = Dart Team da= rt-team@thekey.com ; Data Engineering dataengineering@thekey.com Subject: Data lake missing Wellsky data from yesterday 5/9/24 =C2=A0 This morning=C2=A0we did not receive any of the Canadian data from Wellsk= y. This also caused an issue with our ability to load the US data into our = reporting tables in the data lake. =C2=A0 What is the Impact? =C2=A0 Analytics Portal / Tableau Reports:=C2=A0 SoC, billed hours, revenue and other metrics= relying on Clearcare data are missing yesterday&#39;s totals.=C2=A0 = ETA to have reports refreshed for US = is 1 hour ETA for Canadian data is 4 hours Billing:=C2=A0 Files sent to Netsuite this morning are missing data. We will res= end once Wellsky has provided the Canadian data. =C2=A0 Payroll: =C2=A0This should not affect payroll. =C2=A0 I will send out an update when I ha= ve more information. Please reach out to me directly if you have any questi= ons. =C2=A0 Thanks! Monica =C2=A0 <span style=3D"font-family:Geor