WORKING WITH DATA WAREHOUSES IN GIGASHEET ENTERPRISE

Gigasheet Enterprise supports two integration modes for working with data from your data warehouse: Managed Mode and Live Query Mode.

Managed Mode

In Managed Mode, a view or table from your warehouse is replicated into Gigasheet on either an ad-hoc or scheduled basis. The data appears as a standard Gigasheet sheet, with full platform functionality available—including editing, enrichment, and advanced analysis.

All compute and storage operations occur on Gigasheet's infrastructure, which can help reduce load and costs on your data warehouse. However, because Gigasheet Managed Mode works on a snapshot of the data, any changes in the warehouse won't be reflected until the next sync.

Live Query Mode

Live Query Mode connects Gigasheet directly to your data warehouse, allowing users to interact with real-time data without moving or storing it in Gigasheet. The Gigasheet interface is applied on top of your warehouse, and all access adheres to your existing permissions.

Note that some capabilities—like editing data or creating new rows/columns—may be limited in Live Query Mode due to its read-only nature.

Recommendation: Use Live Query Mode whenever possible to maintain real-time access and ensure alignment with your existing data governance policies.

RECOMMENDED SECURITY PRACTICES FOR LIVE QUERY CONNECTIONS

Whenever possible, we recommend aligning Gigasheet access with your existing data warehouse governance policies. The most secure approach is for each user to connect to the data warehouse using their own credentials. This ensures users see only the data they’re authorized to access—mirroring their permissions in the data warehouse.

If direct access is not feasible, administrators can create Live Query connections and share them with other users via Gigasheet’s built-in sharing features. In this setup, the named account administrator establishes the connection and selectively shares it with approved Gigasheet accounts.

For security reasons, sharing Live Query connections are disabled by default. To enable this feature, please contact Gigasheet Support.

EDITORS AND ANALYSTS IN GIGASHEET

Gigasheet Business and Enterprise plans allow organizations to designate users as either Editors or Analysts, each with distinct capabilities. This document outlines the key differences between these roles.

Editors

Editors have full control over data within Gigasheet, including the ability to add, edit, and delete data.

Adding Data

Editors can import data into Gigasheet by:

• Setting up connections to new databases.

• Uploading files from their local system.

• Syncing data from cloud storage services such as Google Drive and Microsoft OneDrive.

Editing Data

Editors can modify and manage data by:

• Editing existing cells directly.

• Adding new columns using Lookups or Formulas.

• Combining files to add new rows.

• Deleting specific cells, rows, columns, entire sheets, or folders.

Analysts

Analysts have read-only access to data but can interact with it through various analytical tools. Their role is primarily focused on filtering, sorting, grouping, pivoting, aggregating, and visualizing data.

Key Capabilities

• Analysts work with data that has been shared with them by Editors.

• They can apply filters, sorts, groups, and aggregations to analyze data within the team workspace.

• Analysts can generate charts and other visualizations.

Exporting Data

The ability for Analysts to export full sheets or filtered/grouped data can be enabled or disabled at the account level during setup.