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!

4

Hi again,

Anyideas around migrating datasources of type ‘File’ or datasets that have a datasource of type ‘File’

Thanks

5

Hi @ilyasse,

Apologies for the delay in response. I think utilizing the S3 bucket is the right idea, but instead of uploading file manually to destination, I would recommend creating an S3 data source. To do so, I would follow the directions in this documentation. Once that is properly set up, this should allow you to export, as it is recognized as an S3 datasource instead of simply a file.

Let me know if this workaround helps!

6

Hi @WLS-Luis,

Thank you for your response,

It is still problematic for me since i need to migrate all of my client’s assets, the S3 workaround isn’t great since in the destination,i cannot switch to client’s file agai. so the client will always have that S3 available…

I just wanna know if there is a possibility to extract the columns of that datasource of type ‘File‘ and try to create an ‘empty‘ datasource with those columns? or any workaround like that maybe?

Thank you for your time ^^

7

Hi @ilyasse,

Other than utilizing S3 to contain it in some fashion, I do not think this functionality is available in Quick. You would most likely have to use some other outside method most likely (such as a Python script for example) to export a dataset with Postgres reference.

However, I would also definitely recommend creating a support ticket with AWS Support, as they might be able to better guide you on your use case.

Thank you!

8

Hi @ilyasse

It’s been a while since we last heard from you. If you have any further questions, please let us know how we can assist you.

If we don’t hear back within the next 3 business days, we’ll proceed with close/archive this topic.

Thank you!

9

Hi @ilyasse

Since we have not heard back from you, I’ll go ahead and close/archive this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information.

Thank you!