Optima - Datahub

Connection string: "HOST=ds04334.eu-west-1.snowflakecomputing.com;ACCOUNT=ds04334.eu-west-1;USER=RegH;PASSWORD=Wednesday20!;DB=OPTIMA;WAREHOUSE=DWH;",

DSN:

DSN’en skulle DWH stå i Warehouse og ikke i Database

SQL examples:

TARGET

SELECT * FROM "DATA_SHARE_DB"."OPTIMA_MANAGED"."NOTEGROUP"

Filter by date

select * from IDENTIFIER('"DATA_SHARE_DB"."OPTIMA_MANAGED"."HOURSASSIGNMENT"') WHERE VALIDDATE BETWEEN '2021-01-01' AND '2022-01-01'

Filter by ASSIGNMENTNUMBER

SELECT * FROM DATA_SHARE_DB.OPTIMA_MANAGED.UNAVAILABILITY where ASSIGNMENTNUMBER = 01674

Filter by PAYFLAGNAME

SELECT DISTINCT

   ha."VALIDDATE", 
   ha."ASSIGNMENTNUMBER", 
   hapf."DUTYID" AS "hapf_DUTYID",
   hapf."PAYFLAGNAME", 
   ha."FORENAMES", 
   ha."SURNAME",
   ha."OWNING_UNITCODE", 
   ha."OWNING_UNITSHORTNAME",

FROM

   "OPTIMA"."OPTIMA_MANAGED"."HOURSASSIGNMENT" ha

JOIN

   "OPTIMA"."OPTIMA_MANAGED"."HOURSASSIGNMENTPAYFLAG" hapf
   ON ha."DUTYID" = hapf."DUTYID"

WHERE

   ha."VALIDDATE" BETWEEN '2023-09-01' AND '2025-03-27'

AND (hapf."PAYFLAGNAME" = 'Vend aftentillæg til udbetaling 170' OR hapf."PAYFLAGNAME" = 'Vend nattillæg til udbetaling 178') ORDER BY

   ha."ASSIGNMENTNUMBER";

Release mail:

"Mark Reckendorff" <mark.reckendorff@regionh.dk>; "Anders Jørgen Rasmussen" <anders.r@rn.dk>; "Jesper Lyngholm Lysgaard" <jesper.lysgaard@herning.dk>; "Ole Jørgensen" <joeo@kolding.dk>; "Thomas Peder Nørgaard Iversen" <ithp@aarhus.dk>; "Ulrik Rievers Buhl" <ulrik.rievers.buhl@regionh.dk>; "Emil Nørgaard Rasmussen" <emil.noergaard.rasmussen@regionh.dk>; "Jakob Mandrup" <jaman@eg.dk>;

"Hej,

Der kommer ny release til Optima Datahub version X.X.X d. XX/XX/XXXX i tidsrummet kl. 14:00-15:00.

Det anbefales ikke at benytte Optima Datahub i det nævnte tidsrum, selvom opdateringen ikke forventer at være forbundet med nedetid.

Vedhæftet er release note.

Ved spørgsmål eller tvivl, må I endelig rette henvendelse til os."