ZenotiHelp

Analytics β€” Amazon S3 FAQ

ZTZenoti Docs Team Updated October 27, 2026 6 min readFAQ

Find answers to common questions about the Analytics β€” Amazon S3 product.

Before you begin

No prerequisites are required to read this FAQ. For hands-on setup steps, see Get started with Analytics β€” Amazon S3.

Licensing and access

What license do I need to use Analytics β€” Amazon S3?

You need an Analytics Plus subscription with the S3 Data Share add-on. Contact your Zenoti account representative to confirm your current entitlements or to add the S3 Data Share feature to your plan.

Data freshness

How often is data refreshed?

Data is typically refreshed every 1 to 2 hours. This cadence is approximate and may vary depending on data volume and system load.

How do I know when new data is available?

New data arrives as a new GroupID folder in your S3 bucket (e.g., 3/). When a new GroupID folder is present without a _processing suffix, it is ready to consume.

You can automate detection by monitoring your S3 bucket for new folder creation events using AWS S3 Event Notifications or by polling for new prefixes on a scheduled basis.

File format and structure

What format are the data files?

All data files are delivered as CSV with the following characteristics:

  • UTF-8 encoded.
  • Comma-delimited.
  • No column headers β€” the first row is data.
  • Column order matches the schema definition in the SchemaFull folder.

Where do I find column definitions?

Column definitions are in the SchemaFull folder of your S3 bucket (<your-bucket>/SchemaFull/). Each table has its own schema definition file (.txt format) that lists all column names, data types, and column order.

For schema changes introduced in newer releases, also check the SchemaUpgrades folder.

Data model

What is the void column?

The void column appears in all tables and indicates whether a record is active. Its meaning differs between fact tables and dimension tables:

Fact tables

In fact tables, void controls incremental data sync using a delete-insert pattern:

void value Meaning
0 Current, active record β€” insert into your warehouse
1 Deleted or updated record β€” remove from your warehouse

Always filter void = 0 in queries to return only current records. During incremental loads, delete rows matching void = 1 keys and insert rows with void = 0.

To pull only records added since your last sync, filter on etlcreateddate > <your last sync timestamp>.

Dimension tables

In dimension tables, void is a soft-delete flag:

void value Meaning
0 Active record
1 Soft-deleted record β€” the source record has been deleted in Zenoti

Soft-deleted dimension records are retained in the warehouse so that fact records that reference them remain joinable.

What are consolidated tables?

Consolidated tables are pre-joined tables that combine fact and dimension data into a single flat structure. They are designed for simpler queries that do not require writing JOIN statements.

Examples: Sales_Fact_Consolidated, appointment_fact_consolidated, membership_fact_consolidated.

Consolidated tables contain the same data as the corresponding star schema tables β€” they are a convenience layer, not a separate data set.

What is a WID column?

WID stands for Warehouse ID. It is a surrogate key (an internally generated integer) used to join dimension tables to fact tables. For example, Bi_FactInvoiceItem.centerwid joins to Bi_DimCenter.centerwid.

WID columns are not the same as the natural business keys (such as a center code or employee ID). When building JOIN conditions, always use the WID columns.

What tables are available?

Your S3 bucket includes dimension tables and fact tables organized by business domain, covering areas such as centers, employees, services, guests, products, appointments, invoices, commissions, memberships, packages, gift cards, campaigns, and inventory. In addition, consolidated tables provide pre-joined versions of the most commonly used subject areas.

For the full catalog organized by domain, see Understand the star schema and data model.

Why are some tables empty for my organization?

Some tables hold data for a specific Zenoti feature, such as the HyperConnect tables and the challenge tables. They contain rows only for organizations and centers that use that feature. If your organization does not use the feature, the table is still defined in the schema scripts (SchemaFull), so you can create it, but no data is delivered for it.

S3 bucket access

Can I write data back to the S3 bucket?

No. The S3 bucket provided by Zenoti is read-only. You can read and download data, but you cannot upload, modify, or delete files.

What BI tools can I use?

Any tool that can read CSV files from S3 or connect to a downstream data warehouse is compatible. Common options include:

  • Amazon Athena β€” query S3 directly with SQL.
  • Snowflake β€” load from external stage.
  • Databricks β€” read CSV with Spark.
  • Google BigQuery β€” load from S3 via transfer or external table.
  • Tableau β€” connect to your data warehouse or use an S3 connector.
  • Power BI β€” connect to your data warehouse.
  • Python (pandas + boto3) β€” download and analyze programmatically.

See Query S3 data with external BI tools for setup guidance.

GroupIDs and folder structure

What is a GroupID?

GroupID is a serial number assigned to each data load cycle. It is used to organize incremental data in your S3 bucket:

GroupID Content
Smallest GroupID in your bucket Full load β€” all historical data for your subscription
Each subsequent GroupID Incremental load β€” only records that changed since the previous load

Higher GroupID numbers represent newer data. Always process GroupIDs in ascending order.

What does _processing mean in folder names?

A folder with a _processing suffix (e.g., 5_processing/) means a data load is currently in progress. The data in this folder is incomplete and must not be queried or loaded.

Wait until the _processing suffix is removed before consuming data from that GroupID.

Scope and filtering

How do I get data for a specific center only?

This depends on your subscription scope:

  • Center-level subscription: Your S3 bucket contains data only for the subscribed center. No filtering is needed.
  • Zone or org-level subscription: Your S3 bucket contains data for all centers in your zone or organization. Filter by centerid (or join to Bi_DimCenter and filter by centername) to isolate data for a specific center.

Contact your Zenoti Implementation team if you are unsure of your subscription scope.

Schema management

How do I handle schema changes after a Zenoti release?

  1. Check the SchemaUpgrades folder in your S3 bucket for new version subfolders.
  2. Review the upgrade files to understand what changed (new columns, new tables, etc.).
  3. Apply the changes to your data warehouse (e.g., ALTER TABLE... ADD COLUMN).
  4. Resume loading incremental data.

See Handle schema changes and upgrades for step-by-step guidance.

Troubleshooting

My data seems stale β€” what should I check?

Try the following steps:

  1. Look for recent GroupID folders in your S3 bucket. If the newest GroupID was created several hours ago, data may genuinely be delayed.
  2. Check whether any recent GroupID folders have a _processing suffix, which indicates a load is in progress.
  3. Query the etlcreateddate or EtlLastUpdatedOn columns in your warehouse tables to find the most recent load timestamp.
  4. If no new GroupID has appeared beyond the typical 1–2 hour cadence, contact Zenoti Support for investigation.
Was this article helpful?
Your feedback helps us improve our documentation.