Quicksight's asset bundle job : export Dataset that reference a postgres datasource and a File datasource

Q&A
,
1

Hi community,

I believe that it’s not possible to export a dataset that references a postgres datasource aswell as a CSV file for example. Since File type datasources cannot be exported.

in that case what’s the best approache to export such a dataset into another Quicksight accout ?

I’m managing multiple customers in Quicksight through namespaces and i need to migrate them to a new Quicksight account. Those customers have some Excel files.

Thank you for your help !

2

Hi @ilyasse,

Hope everything is well! Not sure if you have already tried based on your title, but I would definitely try to see if the Quick asset bundle API can help you export it for multiple customers. If that is not possible, you may need to try non-native methods such as a Python script.

Hope this helps!

3

Hi @WLS-Luis,

Hope everything is fine !

I found out that Quicksight asset bundle API does not let your export datasources of type ‘File’.

since I’m on testing phase i tried to upload a test file manually to my Quicksight destination with same ID ( but this time from an S3 bucket ) and i’m trying to export a dataset that references a postgres source and a local file and on the import phase i get an error that it doesn’t have a datasource with that ID.

Now my question is :

  1. What can i do in order to export a datasource of type ‘File’
  2. For datasets that references a file data-source, is it possible to create a dumb file that’ll reference it and then on the destination update it with the actual file. If this is possible then, how can i create a datasource of type file since the API does not allow it

Thank you for your help!