Data lake missing Wellsky data from yesterday 5/9/24

From
Monica Johnston <johnstonm@thekey.com>
To
Dart Team <dart-team@thekey.com>, Data Engineering <dataengineering@thekey.com>
Date
Fri, 10 May 2024 09:31:11 -0700
Folder
INBOX
--0000000000006a50d706181c1236 Content-Type: text/plain; charset="UTF-8" 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: TheKey] --0000000000006a50d706181c1236 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable This morning=C2=A0we did not receive any of the Canadian data f= rom 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:=C2=A0 SoC, billed hours, revenue and other metrics rel= ying on Clearcare data are missing yesterday&#39;s totals.=C2=A0 = ETA to have reports refreshed for US is 1 hour ETA for Cana= dian data is 4 hours Billing:=C2=A0 Files sent to= Netsuite this morning are missing data. We will resend once Wellsky has pr= ovided the Canadian data. Payroll: =C2=A0Thi= s should not affect payroll. I will send out an up= date when I have more information. Please reach out to me directly if you h= ave 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 <a href=3D"https://www.thekey.com/" rel=3D"noopener noreferrer" style= =3D"color:rgb(77,77,79)!important;background-color:transparent!im

Thread (50)