1  [secrets]
   2  deteam = arn:aws:secretsmanager:us-east-1:209656230012:secret:DEteam_Access_keys-Shm8fc
   3  slackwebhook = arn:aws:secretsmanager:us-east-1:209656230012:secret:Slack_Webhook-5ovHW5
   4  
   5  
   6  [email_secret]
   7  username = username@example.com
   8  password = ***************
   9  
  10  [bungee]
  11  DEteam = arn:aws:secretsmanager:us-east-1:209656230012:secret:DEteam_Access_keys-Shm8fc
  12  retailscape-aurora = arn:aws:secretsmanager:us-east-1:209656230012:secret:retailscape_rds-L2gmG1
  13  
  14  [petco_snowflake]
  15  source_secret = arn:aws:secretsmanager:us-east-1:209656230012:secret:snowflake_credentials-F4TtLj
  16  warehouse = COMPUTE
  17  schema = BUNGEE
  18  database = PETCO_BUNGEE_SHARE_INT
  19  table = CUSTOMER_CATALOG
  20  
  21  
  22  [petco_transformation]
  23  category= product_category_level1 
  24  subcategory=product_category_level2 
  25  sub_subcategory= product_category_level3
  26  upc = upc
  27  sku = product_id 
  28  ean =CAST(null AS string) 
  29  isbn= CAST(null AS string) 
  30  product_url=product_url
  31  image_url= product_fullimage 
  32  brand =product_purchase_brand 
  33  product_description =product_name 
  34  pack_size =concat(product_weight, ' ', product_weight_uom)
  35  product_title =product_description
  36  parent_sku =parent_product_part_double 
  37  is_active =true 
  38  is_discontinued =CASE WHEN COALESCE(CAST(product_discontinued_flag AS string), '__a__') != '__a__' THEN true ELSE false END
  39  size=product_size 
  40  source= 'petco'
  41  store_name = 'petco'
  42  
  43  
  44  [prod_d]
  45  table = bungeedatawarehouse.bungee_global_prod_d
  46  
  47  
  48  
  49  [dq_dw]
  50  brand_length_min= 2
  51  brand_length_max=50
  52  product_title_min=10
  53  product_description_min = 50
  54  sku_min = 3
  55  upc_min= 5
  56  upc_max= 25
  57  product_url_max=300
  58  product_url_min=10
  59  pack_size = 2
  60  invalids = '','…','-','_','.','null','none','all','undefined','●','?','¿','0','1','na','n/a','nan','upc_','http://none','https://none'
  61  category_max = 60
  62  category_min = 2
  63  subcategory_min = 2
  64  subcategory_max = 60
  65  subcategory_min = 2
  66  subcategory_max = 60
  67  product_url_start = 'http','www'
  68  ml_dq = product_title_min,invalids,product_description_min
  69  assortment_dq = product_title_min, brand_length_max, brand_length_min
  70  
  71