📄️ About workbook
Workbooks provide a versatile solution, empowering you to organize, analyze, and visualize your data with ease. Whether you are building dynamic reports or managing critical datasets, understanding the capabilities of workbooks is key to unlocking your data's full potential.
📄️ Creating a Workbook
You can create a workbook in any of the following methods:
📄️ Creating a blank workbook
To create a blank workbook, do the following:
📄️ Creating workbook with file upload
1. On the Home page, from the left navigation panel, click Workspace, and from the list of workspaces, open a workspace.
📄️ Publishing workbook from playground
Refer to Publishing workbook from playground.
📄️ Viewing the column dependency graph
A column dependency graph visualizes how columns are connected through formulas—showing chains where one formula-based column depends on another. It helps identify which columns are safe to delete and allows you to inspect dependencies for any specific column.
📄️ Accessing workbook pipeline information
1. On the Home page, from the left navigation panel, click Workspace, and from the list of workspaces, open the workspace where the workbook that you want to edit is located.
🗃️ Configure workbooks
3 items
📄️ Downloading data from workbooks
There are two primary ways to download data from your workbooks, each with distinct behaviors:
📄️ Extracting data from documents
What is data extraction?
📄️ Downloading raw CSV for workbooks
To download raw CSV for workbooks, do the following:
📄️ Downloading raw Excel for workbooks
To download raw Excel for workbook, do the following:
📄️ Copying cURL for workbook API interaction
You can copy the cURL command to interact with the workbook using API requests. This command includes the necessary method, headers, and parameters for easy integration.
📄️ Switching the storage provider
Ensure your workbook has been published with the copy option. Typically, when a workbook is initially published via the copy option, it gets stored in the warehouse, and the default data provider is Spark.
📄️ Switching the storage type
1. Open the published workbook. From the Settings menu, select Storage and Provider settings.
📄️ Enabling delete protection
Enabling delete protection is highly recommended if your workbook is used in embedded analytics or as an API by another service. This ensures that critical data and configurations remain intact and prevents accidental or unauthorized deletions.
📄️ Disable delete protection
To disable delete protection for workbooks, do the following:
📄️ Refreshing cache
To access the most current data, you must initiate a cache refresh operation. Otherwise, the system will serve data from the existing cache. The timestamp of the last successful data synchronization is displayed in the upper right corner of the interface. This visual indicator provides you with immediate insight into the recency of the presented information.
📄️ Deleting a workbook
Ensure that the workbook is not delete-protected before deleting it. If it is, you must first remove the delete protection status. Refer to Disable delete protection for workbooks for instructions.
📄️ Viewing workbook lineage
The workbook Lineage view offers a visual representation of how data flows from raw sources through pipelines into workbooks, helping users trace, audit, and understand column-level transformations.
📄️ Email campaign
You can now create email campaigns from Workbooks by selecting a view (master or filtered) and a recipient column (email or user). The view filters the recipients, sending the email only to a subset of members in the email or user column, rather than all of them.
📄️ Data grouping
Grouping workbook data against a chosen column offers a powerful way to reorganize and understand your information from different angles. Instead of just seeing a flat list of entries, you can create a hierarchical view where rows with the same value in your selected column are brought together. This aggregation allows you to analyze trends, summaries, and patterns specific to those groups.
📄️ Filtering workbook data
When you have a large dataset in a workbook, it can be challenging to identify specific trends, patterns, or insights. Filtering allows you to temporarily hide certain rows of data based on criteria you define for one or more columns. This leaves you with only the subset of data that meets your specific needs for analysis.
📄️ Viewing and editing row details in a form
Each row in a workbook can be expanded to view its full data in a form-like layout. All you need to do is select a row and click the expand or edit record icon. This supports contextual collaboration, allowing team members to discuss, clarify, or flag records directly within the workbook. You also have the option to keep this in View-Only mode, which prevents any other users from making edits.
📄️ Workbook columns
Workbooks offer a rich set of column types designed to capture and manage your data effectively. By strategically choosing these column types, you can structure your data precisely to meet your specific requirements, ensuring accuracy, consistency, and enhanced functionality within your workbooks. The following column types are included in workbooks:
📄️ Workbook API reference
Overview
📄️ Append or replace data in workbooks
You can append new data to existing workbooks or replace entire sheets with revised data. If you need to do any of the following, then appending the workbook with the required data or replacing the entire workbook is a good solution:
📄️ Creating links and joins in dynamic tables
If you want to connect to specific records from another workbook in DataGOL, you create a Link. A Link is a direct relationship created between two different tables or workbooks. This is done by adding a specific column to a workbook and then manually or automatically connecting it to records in another workbook. Links are about connecting records and viewing related data within an existing workbook. They add a column to your current table.