Syncing Schema and Data

Who can use this feature?

👤  Available on all plans.

If you make any changes to your schema or data, such as adding new tables or fields, this will not appear immediately in Stacker. Run a manual schema sync directly in Stacker to see the changes.

Run Schema Sync

Stacker automatically syncs the schema structure every 24 hours, you can manually run a schema sync as an admin whenever you need in order to see changes reflected straight away.

  1. Click   App Settings
  2. In Data Sources click Schema button

schema.gif

 

We do not automatically enable new fields or tables in your app in order to ensure you are in control of the data your users can access. In order to reveal new fields and tables to your users, you will have to enable them. The only structural changes that will be automatically visible to users are the removal of fields or tables.

Run Data sync

When you or your users make changes to your data in Stacker, those changes are reflected immediately in your data source.

When updates are made directly in your external data source - i.e. Google Sheets - they will be visible in Stacker in up to 15 minutes. This is because we re-cache the data every 15 minutes.

If you are using Airtable as a data source and have upgraded your connection, you will see your records from Airtable in Real Time. 

  1. Click   App Settings
  2. In Data Sources click Data button

data.gif

You can also run a Schema and Data sync in  Manage fields and data.

Related articles

Enabling Tables and Fields Importing Data: Google Sheets

Importing Data: Airtable

Stacker Tables