[secrets]
deteam = arn:aws:secretsmanager:us-east-1:209656230012:secret:DEteam_Access_keys-Shm8fc
slackwebhook = arn:aws:secretsmanager:us-east-1:209656230012:secret:Slack_Webhook-5ovHW5


[email_secret]
username = username@example.com
password = ***************

[bungee]
DEteam = arn:aws:secretsmanager:us-east-1:209656230012:secret:DEteam_Access_keys-Shm8fc
retailscape-aurora = arn:aws:secretsmanager:us-east-1:209656230012:secret:retailscape_rds-L2gmG1

[petco_snowflake]
source_secret = arn:aws:secretsmanager:us-east-1:209656230012:secret:snowflake_credentials-F4TtLj
warehouse = COMPUTE
schema = BUNGEE
database = PETCO_BUNGEE_SHARE_INT
table = CUSTOMER_CATALOG


[petco_transformation]
category= product_category_level1 
subcategory=product_category_level2 
sub_subcategory= product_category_level3
upc = upc
sku = product_id 
ean =CAST(null AS string) 
isbn= CAST(null AS string) 
product_url=product_url
image_url= product_fullimage 
brand =product_purchase_brand 
product_description =product_name 
pack_size =concat(product_weight, ' ', product_weight_uom)
product_title =product_description
parent_sku =parent_product_part_double 
is_active =true 
is_discontinued =CASE WHEN COALESCE(CAST(product_discontinued_flag AS string), '__a__') != '__a__' THEN true ELSE false END
size=product_size 
source= 'petco'
store_name = 'petco'


[prod_d]
table = bungeedatawarehouse.bungee_global_prod_d



[dq_dw]
brand_length_min= 2
brand_length_max=50
product_title_min=10
product_description_min = 50
sku_min = 3
upc_min= 5
upc_max= 25
product_url_max=300
product_url_min=10
pack_size = 2
invalids = '','…','-','_','.','null','none','all','undefined','●','?','¿','0','1','na','n/a','nan','upc_','http://none','https://none'
category_max = 60
category_min = 2
subcategory_min = 2
subcategory_max = 60
subcategory_min = 2
subcategory_max = 60
product_url_start = 'http','www'
ml_dq = product_title_min,invalids,product_description_min
assortment_dq = product_title_min, brand_length_max, brand_length_min