Introduction to Lessons

The following lessons when performed in the listed order can jump start development of a large application using Trillo Workbench.

Lesson	Description	How to exercise
New class using the workbench UI	Create a few entity classes using Trillo Workbench UI (WB UI). Trillo Workbench creates tables for them. These tables are used in the following exercise.	WB UI
Save many records into a table using the workbench UI	Guides you to populate tables created above. The JSON files for the parameters are provided.	WB UI
Simple function using the workbench UI	This walks you through how to create functions using Trillo Workbench. Learning these simple steps will be helpful in deploying a function on the cloud.	WB UI
Paginated List	Shows how to read data from a large table using pagination.	IDE
Pagination using SQL Query	Show how to read a page of large result set created using multiple tables (using join)	IDE
DataIterator	While iterating through a large list for processing each record, you can hide pagination within a higher level abstraction. This class lets you achieve that.	IDE
Read file from cloud storage bucket	You will come across several use cases when a file has to be read from a cloud storage bucket (for example for uploading into BigQuery, processing using cloud services such as Document AI. This lesson walks you through steps to achieve it using Trillo Workbench APIs.	IDE
Generating signed URL for an upload and download	In order to provide secure access to a file on a cloud storage bucket to a client, a signed URL is used. This lesson shows how to create a signed URL to a file using Trillo Workbench APIs.	IDE
Import a CSV file from bucket into BigQuery	This is a very common use case, You receive several CSV (or ndjson or parquet) files. Thes indeed to be imported in the BigQuery. This lesson shows how easy it is to do it using Trillo Workbench APIs.	IDE
Query a dataset of BigQuery	Accessing data from multiple BigQuery tables using a query for further analysis is a common use case. This lesson demonstrates it.	IDE
Using a Document AI Processor	This lesson teaches how to use Trillo Workbench APIs to process an invoice and extract entities out of it.	IDE
Chat using Gen Ai	This example shows how to implement generative AI use cases using GCP GenAI apis.	IDE
Function calling another function	This example shows how a function calls another function. This is useful to write modular and reusable code.	IDE
Accessing Runtime Context	This example shows how to access runtime context of the function such as user id, email, taskId, etc.	IDE
Write a workflow (pipeline for data processing)