What does removing the data of a connection do?
Every connection fills a set of tables in your warehouse. Remove data… deletes every row the connection has written and lets the connection start from scratch on its next run. The connection, its credentials, its schedule and its Insights stay.
Use it when the synced data is wrong and you want a clean reload. You may have fixed a setup problem in the source system, for example. It also helps after a sync that was stopped mid-way.
Should I use Fetch again, Remove data or Delete connection?
Three actions on a connection sound alike and do very different things.
Fetch again: Keeps everything. Indicate only forgets how far it has read one table, or every table with Fetch everything again. The next run then loads that table from the beginning and replaces what is there. Use it first, because it is the gentlest option. See Sync and activity.
Remove data…: Deletes every row the connection has written, right now. The connection stays and loads everything again on its next run. Every Insight built on the connection shows no data until that run is through.
Delete connection: Removes the connection for good, and optionally its Insights and its data. See Delete a Source Connection.
What happens when I remove the data of a connection?
The dialog Remove all data from this connection lists it under Before you continue:
Every row this connection has written is permanently deleted.
The connection starts from scratch on its next run.
Every Insight built on this connection is affected. Widgets show no data until the reload has run.
The credentials, the schedule, the activity history, the Insights and their shares are not touched.
How do I remove the data of a connection?
You remove the data on the Settings tab of the connection. You need the Admin role.
The rows are gone the moment you confirm. The next sync loads them again only as far back as the source still delivers them. Some sources deliver no history at all or only a limited period, such as the last 90 days. For these sources, Indicate holds the only copy of older data, and removing it deletes that history for good.
Open
Data sources→Connectionsand open the connection.Click the Settings tab and scroll to the Danger zone.
Click Remove data…. The dialog Remove all data from this connection opens and lists what happens.
Next to Connection name, click Copy, then paste the name into Type the connection name to confirm.
Optional: Turn on Start fetching again straight away if the reload should begin now. Otherwise the connection waits for its next scheduled run. This is part of the Pro plan and not available while the sync is paused, running or failing.
Click Remove data.
A toast confirms Data removed., or Data removed. A fresh sync starts shortly. if you turned the switch on. Watch the reload on the Activity tab.
Troubleshooting
Why is Remove data locked?
- The buttons in the Danger zone need the Admin role. Hover over the button: Admin only means you have to ask a space admin.
Why does Remove data stay greyed out?
- The name in the field does not match. Click Copy next to Connection name and paste it.
Why are my dashboards empty after removing the data?
- That is expected until the next run has loaded the tables again. Check the Activity tab for Succeeded rows. On the Pro plan, click Options, then Sync now to start the run.
Why did old data not come back?
- Some sources only deliver a limited lookback, for example the last 90 days. Rows older than that are gone after a reload. If you only want to refresh recent data, use Fetch again on the affected table next time.
How do I remove the connection too?
- Removing data keeps the connection. To remove it, see Delete a Source Connection.
How do I reload only one table?
- Use Fetch again on that table under Synced data on the Overview tab. The rows stay until the run replaces them. See Sync and activity.