Switching the storage type
-
Open the published workbook. From the Settings menu, select Storage and Provider settings.
-
In the Storage Type Settings box, click the Need to switch the storage type link.
-
In the dialog box, the default storage layer is set to S3. You can switch it to DB. Switching to DB will enable you to use JDBC as a provider, expanding your options. In case you change your mind, you will have the option to easily revert back to S3.
-
Click the Switch button. Your storage type change is initiated, and a link is displayed for tracking the progress.
The Last Mile Pipeline automatically transfers data from S3 to DB. To ensure data integrity, Last Mile Pipelines cannot be edited. You can view both the initial data pipeline and the Last Mile Pipeline in the View Pipelines section, providing transparency into the data flow.