dimension_explore.sql

-- dimension exploration

print('distinct columns like DISTINCT Country,Category,Products')

-- all countries from customers come
select DISTINCT country from gold.dim_customers

print('will return Germany , United States , United Kingdom , Canada , France , Unknown')

-- all products categories
select DISTINCT category ,subcategory , product_name from gold.dim_products
order by 1,2,3;
print( 'will return Accessories , Bikes , Clothin , Components & their subcategories ' )
print('295 total products')

/*
							Accessories (4)
								|
					-------------------------
					|		subcatg(36)		|
				Helmets					Lights
				|							|
		------------------   products(295)  ----------------------
		|                |				   |					  |
Sports-100       Sports-100				 Dual Bim			Weather protection
Black			 Red

*/