Beta feature - This feature is currently in beta. If you’d like to use it, please ask us on live chat.
How It Works
- Once a day. New data is synced to your warehouse once a day by default. Owners and admins can also click Sync now on the Data export page.
- You own the destination. Data is written into a Snowflake account or an Amazon S3 bucket in your own cloud account.
- One export per account. The export is set up once for the whole account, not per store. Every table carries the store, so you can report per store or across the whole group.
What Is Exported
The export has these datasets, in this order on the Data export page:
Customer records and the browsing events described in Event Tracking are not exported.
Treat the exported tables with the same access controls you apply to storekit itself; see the Security Policy for how storekit handles this data on its side.
Supported Destinations
The list is fixed:- Snowflake
- Amazon S3
Getting Set Up
Data export is a beta feature that storekit turns on per account. Once it is on, Data export appears under Integrations. Only account owners and admins can change its settings; other members see the page read-only.1
Open Data export
In the sidebar, click Integrations, then Data export.
2
Choose your warehouse
Under Connect your warehouse, pick Snowflake or Amazon S3 as the Warehouse, then enter your Snowflake account host (for example
ABCDEFG-XY12345.snowflakecomputing.com) or your S3 bucket name.3
Enable the export
Click Enable data export. A connection link from Prequel appears on the page and is also emailed to you. The link can be used once.
4
Connect your warehouse
Open the link and follow Prequel’s steps to give it access to your warehouse. The Connection status changes from Link sent, waiting for connection to Connected.
Once connected, the page shows the export’s Health, Schedule, Datasets, Last transfer and Where to find your data. In Snowflake, your database and schema appear after the first sync.
Frequently Asked Questions
How fresh is the data?
How fresh is the data?
Syncs run once a day rather than in real time. If you need to react to an order the moment it happens, for example to trigger a kitchen workflow, use webhooks instead and keep the warehouse for reporting.
Does this replace the reports in the dashboard?
Does this replace the reports in the dashboard?
No. The dashboard reports stay as they are. The export is for teams who want to combine storekit data with other sources, build their own dashboards, or keep a long-term archive under their own control.
Can I sync data from my warehouse back into storekit?
Can I sync data from my warehouse back into storekit?
No. Data warehouse export is one-way, from storekit to your warehouse. To change menus, stock or store settings, use the dashboard or the API.
What happens if the connection breaks?
What happens if the connection breaks?
The Connection status changes to Disconnected, for example after you rotate the warehouse credentials. Click Generate a new link and connect again. Last transfer says whether a failure came from your warehouse, from storekit or from Prequel.
How do I stop the export?
How do I stop the export?
Click Disable data export. Daily syncs stop, and data already exported stays in your warehouse. You can enable the export again later.
Is there an extra charge?
Is there an extra charge?
Contact our team for pricing for your account.