Skip to content

[Feature]: Finish filling USDA table (schema changes, and etl code) #4

@mglbleta

Description

@mglbleta

Pre-flight checklist

  • I have searched the existing issues

Problem to solve

usda_commodity

    1. add rest of the commodities to make a comprehensive mapping tool
    1. Add parent_commodity_id, USDA_source

resource_usda_commodity_map

  1. etl_run_id or lineage_group_id
  2. primary_ag_product_id (check if we map resource --> primary_ag_product_id elsewhere, making this redundant data and a column that should be DROPped)

resources

  1. created_at

parameter

  1. created_at, updated_at, etl_run_id, lineage_group_id
  2. Maybe standard_unit system
  3. Calculated = FALSE for USDA import

data_source

  1. etl_run_id, lineage_group_id
  2. the rest of the info fields

Proposed solution or API

No response

Alternatives considered

No response

Additional context

No response

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or request

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions