US Profiles in Snowflake - New go forward schema and views Pt 2: Removal of old views on Feb 15

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.

Updated

The old profiles views being removed:

  • US.PROFILES_INTERNAL

  • US.PROFILES_EDUCATIONS_INTERNAL

  • US.PROFILES_JOBS_INTERNAL

  • US.PROFILES_SKILLS_INTERNAL

  • US.PROFILES_META

The new profiles views:

Scheduled

US profiles data in Snowflake has a new home - schema US_PROFILES_ANONYMIZED. View names, field names, and field datatypes are now consistent with our postings data to make it easier to work across the Lightcast data products you use. The profiles views within schema US will receive their last update on/around Dec 15. However the views themselves will remain (albeit with static data) until February 15 to allow for your migration to the new schema. The new schema and views have been shared with our US Profiles customers. If you would like migration guidance (including field name adjustments) or are not seeing the new schema and views, please reach out to your Lightcast representative.

Began at:

Affected components
  • Snowflake
    • Profiles US