[source-amazon-seller-partner] GET_FLAT_FILE_RETURNS_DATA_BY_RETURN_DATE schema validation errors about airbyte

[marcosmarxm]

Thanks for reporting the issue @zerobearing2 probably it will need to implement a transformer operation to this report update the datetime format for that field. Something similar to:

airbyte/airbyte-integrations/connectors/source-amazon-seller-partner/source_amazon_seller_partner/streams.py

Lines 717 to 727 in c7ecc41

	def get_transform_function():
	def transform_function(original_value: Any, field_schema: Dict[str, Any]) -> Any:
	if original_value and field_schema.get("format") == "date":
	try:
	transformed_value = pendulum.from_format(original_value, "MMM D[,] YYYY").to_date_string()
	return transformed_value
	except ValueError:
	pass
	return original_value
	return transform_function

[zerobearing2]

it will need to implement a transformer operation to this report update the datetime format for that field

@marcosmarxm, any chance you have possible ETA on fix? This is actually blocking us atm. We had to implement workaround by extracting to S3, then creating separate source/destination to get files loaded to Bigquery to avoid the schema issues during loads.