Taxonomy Schema - Snowflake - Removing version-specific views in favor of the evergreen views

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.

Scheduled

If you are already only using the evergreen views, then this does not impact you. If you do not have access to any taxonomy views but are interested, then please contact your Lightcast representative.

The following evergreen taxonomy views are replacing the listed version-specific views.

  • TAXONOMY.COMPANY replaces

    • TAXONOMY.COMPANIES_V2_14_0
    • TAXONOMY.COMPANIES_V2_15_0
    • TAXONOMY.COMPANIES_V2_16_0
    • TAXONOMY.COMPANIES_V2_19_0
    • TAXONOMY.COMPANIES_V2_20_0
    • TAXONOMY.COMPANIES_V2_22_0
  • TAXONOMY.SKILL_0_CATEGORY replaces

    • TAXONOMY.SKILLS_CATEGORIES_V8_7_0
  • TAXONOMY.SKILL_1_SUBCATEGORY replaces

    • TAXONOMY.SKILLS_SUBCATEGORIES_V8_7_0
  • TAXONOMY.SKILL_2_SKILL replaces

    • TAXONOMY.SKILLS_V8_7_0

Please switch to using the evergreen views. These views include a VERSION field that indicates which version that record belongs to, as well as a LATEST_VERSION field that indicates which taxonomy version is the most recent, relative to the taxonomy itself (vs a dataset using the taxonomy). To know which taxonomy version a dataset is using, please see that dataset's meta (US.POSTINGS_META, for example).

Began at:

Affected components
  • Snowflake
    • Taxonomy Schema