Addition of new column in d_product

Introduction – Product table is typically used to manage and organize information related to the products being handled. This table can include various attributes to track products throughout the supply chain.

 

The product table is joined with  other tables such as orders, suppliers, and inventory levels for comprehensive supply chain management.

 

Analyzing data from the product table can help in forecasting demand, managing inventory effectively, and optimizing the supply chain.

 

 Requirement: Generate Databricks SQL  to add new column ‘source_country ‘ to the ‘d_product’ table and in its dependent view in unity catalog. Hardcode the new column as ‘NL’ .

 

Table Definition: The table name is d_product

 

Prerequisite:

 

1. Drop the table d_product_clone, d_product_vw_clone if exist.
2. Perform the requirement in replica of d_product table in d_product_clone, d_product_vw table in d_product_vw_clone.

 

 

 

Unity Catalog Information: d_product