create view datamart.sales_country_current AS 
SELECT 
 sales_country.country_id,
 sales_country."valid$from",
 sales_country."valid$to",
 sales_country.country_name,
 sales_country.region_name,
 sales_country.iso_3166_2_code,
 sales_country.iso_3166_3_code,
 sales_country.centercoordinate,
 sales_country.source_system,
 sales_country.owner_id,
 sales_country.country_id_expereo,
 sales_country.currency 
FROM ods.sales_country 
WHERE (sales_country."valid$to" IS NULL);.
 
 
create view datamart.proc_seller_current AS 
SELECT proc_seller.seller_id,
 proc_seller.country_id,
 proc_seller."valid$from",
 proc_seller."valid$to",
 proc_seller.name, 
 proc_seller.parent_name, 
 proc_seller.legal_name, 
 proc_seller.industry, 
 proc_seller.website, 
 proc_seller.linkedin, 
 proc_seller.twitter, 
 proc_seller.facebook, 
 proc_seller.comments, 
 proc_seller.source_system, 
 proc_seller.seller_stage, 
 proc_seller.billing_group_id, 
 proc_seller.seller_msa_id, 
 proc_seller.owner_id, 
 proc_seller.seller_id_expereo 
FROM ods.proc_seller 
WHERE (proc_seller."valid$to" IS NULL);