Re: 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>, Donny Deshotels <donny.deshotels@thekey.com>
Date
2024-05-10 16:09:31
Folder
INBOX
--000000000000f41248061821a2f8 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable > > *Update as of 4 pm Pacific:* > > Wellsky is still working on the issue. There is no ETA at this time. > > *Billing: *Since we will not have Canadian data available in the data > lake today, we are sending the US data to Netsuite now. > > Thanks, > Monica > > On Fri, May 10, 2024 at 12:19=E2=80=AFPM Monica Johnston > wrote: > >> *Update as of noon Pacific:* >> >> - Analytics Portal reports have been refreshed with up to date US dat= a >> - We have been notified by Wellsky that it will take them an >> additional 2 hours to provide the Canadian data. >> >> >> On Fri, May 10, 2024 at 9:31=E2=80=AFAM Monica Johnston >> wrote: >> >>> 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 ou= t >>> 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] >>> >> --000000000000f41248061821a2f8 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Update as of 4 pm Pacific: Wellsky is still working on the issue. There is no ETA at this t= ime. Billing:=C2=A0 Since we will not have Cana= dian data available in the data lake today, we are sending the US data to N= etsuite now. Thanks, Monica On Fri, May 10, 2024 at 12:19=E2=80=AFPM Monica J= ohnston &lt; johns= tonm@thekey.com &gt; wrote: Update as of noon Pacific: =C2=A0 Analytics Portal reports have been refreshe= d with up to date US data We have been notified by Wellsky that it = will take them an additional 2 hours to provide the Canadian data. On Fri, May 10, 2024 at 9:31=E2=80=AFAM Monica Johnston &lt;<a href

Thread (3)