CoreLMI (US) - Snowflake - Removing deprecated US LMI tables from the PUBLIC schema

The maintenance is now complete. Thanks for your patience.

The scheduled maintenance is now underway. We'll keep you updated on our progress.

We are moving this to February 20.

We plan to remove legacy datarun US LMI views from schema PUBLIC on February 15, 2024. For more information and migration guidance, please reach out to your Lightcast representative.

This does not impact you if you are only using schema PUBLIC for Canada LMI. Please note that CORELMI_US_V2 and CORELMI_CA are the most up to date and should be the schemas used, since CORELMI_US and Canada LMI in PUBLIC will eventually be removed (date yet to be announced).

The views to be removed as part of this maintenance are as follows:

• PUBLIC.COLI

• PUBLIC.DAT_COMPLETIONS_DISTANCE

• PUBLIC.DAT_CRIME

• PUBLIC.DAT_DEMOG

• PUBLIC.DAT_EDATT

• PUBLIC.DAT_EDATT_AGE

• PUBLIC.DAT_ENROLLMENTS

• PUBLIC.DAT_ENROLLMENTS_DISTANCE

• PUBLIC.DAT_GRP

• PUBLIC.DAT_IND

• PUBLIC.DAT_IND_GENDER_AGE

• PUBLIC.DAT_IND_MONTH

• PUBLIC.DAT_LABOR_FORCE

• PUBLIC.DAT_MINIMUM_WAGE

• PUBLIC.DAT_OCC

• PUBLIC.DAT_OCC_EARN

• PUBLIC.DAT_OCC_GENDER_AGE

• PUBLIC.DAT_OCC_HIRES_SEPS

• PUBLIC.DAT_OCC_RACE_ETHN

• PUBLIC.DAT_STAFFING

• PUBLIC.DAT_UNEMP_IND

• PUBLIC.DAT_UNEMP_OCC

• PUBLIC.MAP_COUNTY_ZIP

• PUBLIC.US_DAT_MHI