Trillo Workbench Lessons
  • Introduction
    • Sample Application
  • Introduction to Lessons
    • IDE Lessons
    • Annotated Directory Structure
  • New classes using workbench UI
  • Save many records into tables using the workbench UI
  • New function using Workbench UI
  • Introduction to Code Lessons
    • Anatomy of Trillo Function
  • Begin Code Lessons
    • Paginated list
    • Pagination using SQL Query
    • DataIterator
    • Read file from cloud storage bucket
    • Generating signed URL for a file download
    • Import a CSV file from bucket into BigQuery
    • Query a dataset of BigQuery
    • Using an Document AI Processor
    • Chat using GenAI
    • Function calling another function
    • Accessing Runtime Context
    • Write a workflow (pipeline for data processing)
  • Appendixes
    • ServerlessFunction
    • Map, List and Tree
    • Logs and Audit Logs
    • DataRequest Class
    • DataResponse Class
    • DataIterator Class
    • Result
Powered by GitBook
On this page
  1. Begin Code Lessons

Query a dataset of BigQuery

In this example, the function code accepts the query as input parameters. It executed the query and fetched the data from BigQuery.

Code: /lessons/Query_a_dataset_of_BigQuery

Steps

  1. Create a new function called QueryDatasetBigQuery.java.

  2. Set parameters as the query.

  3. Call BigQueryApi.getPage function and pass query, start, and size.

  4. Return the data fetched from BigQuery after running the query.

PreviousImport a CSV file from bucket into BigQueryNextUsing an Document AI Processor

Last updated 1 year ago