How to get the files in the zip folder

  • 6Views
  • Last Post 5 days ago
0
votes
Karthika Tekula posted this 5 days ago

Hi Team, 

I am currently evaluating Skyvia to integrate the data from box fiiles to Amazon redshift.

The question i have is how to i get into the files which are zipped in the box folder.

And another question, Is there a way to create a table automatically in destination depending on the source file data structure.

 

Thanks 

0
votes
Mariia Zaharova posted this 5 days ago

Hello Karthika,

 

Thank you for contacting our Skyvia Team!

 

 The question i have is how to i get into the files which are zipped in the box folder.

Skyvia works only with the CSV files.

ZIP archives can be used only for importing binary attachments: https://docs.skyvia.com/data-integration/import/importing-binary-data.html

 

And another question, Is there a way to create a table automatically in destination depending on the source file data structure.

No, there is no way to create target tables via Import packages. Skyvia can create target tables only via Replication packages.

 

Best regards,

Mariia

Close