Data Connections
Push your Wusool data to the tools your team already uses: scheduled syncs to Google BigQuery, plus on-demand CSV downloads.
What you can export
| Data type | What it contains |
|---|---|
| Dimensions | Your master lists, such as Region, Product, Cost Centre, or any dimension you have created — Simple or Combined. |
| Workbooks | Governed data entry tables, including all current rows (not just the last published version). |
Supported destinations
| Destination | Status |
|---|---|
| CSV download | Available |
| Google BigQuery | Available |
| Snowflake | Coming soon |
| Amazon S3 | Coming soon |
| Google Cloud Storage | Coming soon |
| Microsoft Azure Blob Storage | Coming soon |
| SFTP | Coming soon |
Setting this up is two separate steps: connect a destination once under Data Connections, then create one or more Exports that say what to send there and on what schedule.
Step 1: Connect BigQuery
Open Data Connections
Go to Admin → Data Connections. You’ll see a destination picker — Google BigQuery is the only one that’s clickable today; the rest show as Coming soon.
Connect your Google account
Click Google BigQuery, then connect via Google OAuth. One BigQuery connection is supported per organization.
Point it at a dataset
Pick the GCP project and BigQuery dataset Wusool should write to. The dataset must already exist in the BigQuery console — Wusool never creates datasets for you — and its region is whatever you chose there.
CSV download needs no connection step — it’s chosen directly when you create an export.
Step 2: Create an export
Open Exports
Go to Exports → New export and give it a name.
Choose what to export
Pick Dimensions or Workbooks. Dimensions use a multi-select with an All dimensions option (each item labeled Simple or Combined); Workbooks use a multi-select with All Workbooks plus per-workbook column checklists. BigQuery allows mixing Simple and Combined dimensions in one export; CSV requires one kind only.
Choose a destination
CSV Download or Google BigQuery (other destinations are coming soon). A CSV export skips the schedule and notification steps below — it only runs on demand.
Set the table layout (BigQuery only)
Shared tables (default) writes one dimensions table, one combined_dimensions table, and one workbooks table across everything you selected. One table per dimension/workbook instead writes a separate table per item. An optional table name prefix namespaces every table the export writes, so multiple exports can share a dataset without overwriting each other.
Set a schedule (BigQuery only)
Choose on change (the default), or build a recurrence: daily, selected weekdays, or specific days of the month (including “last day of month”), each at up to four UTC times per day. A plain-language summary (for example, “Runs Mon–Fri at 06:00 and 18:00 UTC”) shows under the controls.
Configure notifications (BigQuery only)
Turn on failure notifications and optionally set a recipient list; otherwise workspace Admins are notified by email when a scheduled run fails.
Save
Click Save. A BigQuery export runs on its schedule (or you can trigger it manually); a CSV export waits for you to run it.
Managing exports
Every export card in the Exports list has a ⋯ menu with Run now (disabled while paused), Edit, Pause/Resume, and Delete. Pause/Resume is also available as a header button on the export’s overview page and its Edit page, with a Paused badge shown wherever the export appears. Deleting an export removes its definition and run history — data already delivered elsewhere (BigQuery tables, downloaded CSVs) is untouched.
BigQuery loads always fully replace the target table (WRITE_TRUNCATE) rather than appending. See Destinations for the exact table schemas.
Need a destination not listed here? Contact support at support@wusool.app.