Data Storages
  • 1 Minute to read
  • Dark

Data Storages

  • Dark

Article Summary

Dataddo supports data delivery to various data storage technologies inluding SQL server, MariaDB, PostgreSQL, AWS S3, AWS Redshift, Google BigQuery or even SFTP.

Add a New Data Storage

New data storage can be added by navigating to Destinations and clicking on Create Destination. Similarly to data sources, if the database or dashboarding app was connected without an issue, it will be marked with a GREEN badge. In this tab, you can also see when your destination was created and when it was last used.

Read more about how to connect a destination here.

For destinations that require OAuth 2.0 authorization (Google Sheets or Google BigQuery), authorize your account first before adding a new destination. Navigate to Authorizers and click on Add new Service in the top right corner.

Testing and Debugging

If your destination is broken (marked with a RED badge), you can click on the three dots next to it and select Test Connection. A connection log will show up to give more details regarding what the issue is.

Editing a Destination

To edit your destination, navigate to Destinations. Click on the destination, or the three dots next to it to select Edit. Depending on the destination type, you will be able to edit the fields accordingly.

Usually, apart from configuration details, it is also possible to change the destination name. If you need to update your account connected to your destination, you can do so in the Authorizers tab.

Deleting a Destination

You can delete a destination by navigating to Destinations and clicking on the bin icon. You will be able to delete the destination only after you delete all the flows connected to it.

Supported Services and Storages

Dataddo supports the following storage platforms with off-the-shelf data writers.

Write modes

Write modes define the way the data is being written into a database, as such they are available only for data warehouses.

You can choose from four available write modes when creating your data flow:

  • Insert
  • Insert Ignore
  • Truncate Insert
  • Upsert
  • Delete

For more information on each write mode, please refer to this page.

Need assistance?

Feel free to contact us and we will help you with the setup. To speed the process of resolving your issue, make sure you provide us with sufficient information.

Was this article helpful?