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

23 hours and 59 minutes
Complete
Complete

The maintenance is now complete. Thanks for your patience.

Underway

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

Updated

We are moving this to February 20.

Scheduled

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

Began at:

Affected components
  • Snowflake
    • Core LMI US