search

starschema / COVID-19-data

Unpivoted and cleaned data sets on the COVID-19 pandemic
https://starschema.github.io/COVID-19-data
BSD 3-Clause "New" or "Revised" License
85 stars 19 forks source link

Data quality issue: Missing Vaccination Data #336

Closed mswanson-nmdp closed 3 years ago

mswanson-nmdp commented 3 years ago

Describe the bug PUBLIC.JHU_VACCINES is missing from the COVID dataset - this data was available until recently - wondering if it was removed in error or if it is something that i can find elsewhere?

tfoldi commented 3 years ago

It should be there, seems like a sharing issue. What is your snowflake region?

mswanson-nmdp commented 3 years ago

i'm in us-east-1

tfoldi commented 3 years ago

Yes, several tables were missing from that region. I re-added them manually, now it should work.

We are in the process to switch to replicate not just the data, but the share itself between regions too. My guess that this is the root cause, but I will double check.

mswanson-nmdp commented 3 years ago

thank you - we greatly appreciate the fast response on this! -- enjoy the day

mswanson-nmdp commented 3 years ago

how long will this change take to appear on our share? i'm still not seeing the vaccine table in the lake we have set up

tfoldi commented 3 years ago

It should be available immediately. If the issue still persist please send a note to support@starschema.com with your snowflake account id. thank you!

chrisvoncsefalvay commented 3 years ago

Hi @mswanson-nmdp – has this resolved for you?

chrisvoncsefalvay commented 3 years ago

Hi @mswanson-nmdp – I'm closing this down. If you still have issues, please feel free to request for the issue to be reopened. Thank you!