Hi prefect community We ve created a flow which creates and

Question

Hi prefect community We ve created a flow which creates and saves an excel workbook We re trying to upload that workbook into our S3 bucket and we ve provided the necessary credentials The problem is that the bucket fills up with ` prefect result` files instead of a workbook How can we fix that This is the code snippet ```flow result = S3Result bucket=bucket ```

Fina Silva-Santisteban · Answer

We used to run Prefect API using `prefect local agent` and a `LocalResult ` and that had worked fine Now we re using `prefect docker agent` and docker storage that s why we need to be able to upload the file

Zanie · Answer

Hi Fina I would recommend writing your workbook directly from your task rather than using the prefect task results as those will be serialized into this format

Zanie · Answer

You could also consider defining a custom serializer to write your data as workbooks <https docs prefect io api latest engine serializers html serializer>

Zanie · Answer

Fina Silva-Santisteban · Answer

< Zanie> very helpful thanks so much I managed to create and save a dummy textfile yay tada so saving the workbook shouldn t be that hard anymore

Chris White · Answer

< Marvin> archive Best practice for writing workbook to S3 bucket using Prefect Results

Marvin · Answer