Trying to push Vulnerable item(VIT table ) data in csv format and sending the attachment to aws s3 bucket, however using data lake able to transfer complete set of table data but I have a requirement where I need to truncate to limit table data in csv when tried to use export definition option, since reference fields are dot walked it did not work .Also tried to create database view with limited columns but there is known issue where view needs query BR to add filter which did not work as there is top level OR condition. Any suggestions to add limited columns(contains reference fields) and filter to csv file.
Thank you.
