Google BigQuery and Zite Integration
Demonstration of how apps are integrated in WEXTL workflow builder[4]
Build database workflows between Google BigQuery and Zite on a visual canvas. Set up data fields sync between apps once and let data flow when events come automatically. Integration will work without code and your team will see the workflow inside WEXTL® builder.
- 3-day trial
- Cancel anytime
- Up to 10 minutes quick set up
- GDPR
- Data Encryption
- 2FA
- Local Data Region
Learn about Google BigQuery and Zite
Detailed info you need to know about Google BigQuery and Zite integrations in WEXTL. Explore which modules apps support and how you connect them.
Google BigQuery

Query and manage Google BigQuery datasets, tables, jobs and routines. Run SQL and stream rows.[5]
Zite

App platform with a shared database, backend workflows and a build API.[6]
How to connect Google BigQuery to Zite
Set up your Google BigQuery and Zite integration in 3 simple steps[2]. No coding required. Up to 10 minutes setup.
STEP 1
Connect Google BigQuery and Zite
Save credentials in WEXTL once. We store them encrypted and reuse the authorization across every workflow[3]. No coding or API skills required.
STEP 2
Build a workflow
Paste selected Google BigQuery and Zite nodes onto the canvas[4], or describe what you want and WEXTL wires the flow together with AI Builder.
STEP 3
Map your data
Choose which fields need to sync between Google BigQuery and Zite. Use filters or a JS custom code step in between. Everything is on the canvas.
How does the integration between Google BigQuery and Zite work in WEXTL?
WEXTL exposes actions and triggers for Google BigQuery and Zite that help you connect apps and automate repetitive tasks[1]. A trigger is an event that happens, and an action is a step that performs when the event has occurred.
Google BigQuery triggersZite actions
Google BigQuery modules
- Cancel a Job Stops a BigQuery job that is still running, found by its Job ID in a project. Use Location when the job is in a single region or outside the us and eu multi-regions. Output includes the job Status and Statistics.
- Create a Dataset Creates a dataset named by Dataset ID. Use Location to choose where its data lives and Default Table Expiration Ms to set an expiry for new tables.
- Create a Job Kicks off a BigQuery job of any kind (query, load, copy or extract) from a Configuration without waiting for it to finish. Follow the new job with Get a Job or Watch Jobs.
- Create a Routine Adds a stored function or procedure to a dataset, defined by a Routine ID and Routine Type. Use Definition Body for its code and Arguments to declare its inputs.
- Create a Row Access Policy Restricts which rows of a table certain people can read. Use Filter Predicate for the condition rows must meet and Grantees for who may see them, under a new Policy ID.
- Create a Table Registers a table under a Table ID inside a dataset. Use Schema to define its columns, View to base it on a query, or Time Partitioning and Clustering to organise how rows are stored.
- Delete a Dataset Deletes a dataset from your project. Turn on Delete Contents to remove the tables inside it too, otherwise a dataset that still has tables cannot be deleted.
- Delete a Job Deletes one BigQuery job by its Job ID. Use Location to name the region the job ran in.
- Delete a Model Removes a BigQuery ML model from a dataset by Model ID.
- Delete a Routine Removes a user-defined function or procedure using its Routine ID.
- Delete a Row Access Policy Lifts a row-level restriction on a table by deleting one policy.
- Delete a Table Deletes the table identified by Table ID.
- Delete Row Access Policies in Batch Clears several row access policies from one table in a single call. Use Policy IDs to name them all, and Force to delete a policy even when it is the last one on the table.
- Edit a Dataset Updates the Description, Labels and Default Partition Expiration Ms of a dataset. Use Access to adjust who can reach it.
- Edit a Model Updates the Description, Friendly Name or Labels of a BigQuery ML model.
- Edit a Table Applies a partial change to a table, such as a new Friendly Name, Description, Schema or Labels. Use View to change the query of a saved view.
- Execute a Query Runs a SQL statement and waits for the answer. Turn on Dry Run to validate it without running it, set Use Legacy SQL for old syntax, and pass Query Parameters for parameterised SQL.
- Get a Dataset Shows the settings of one dataset by Dataset ID, including its Access list and default expiry values.
- Get a Job Looks up one job by Job ID to see its Configuration, Status and Statistics. Add Location when the job ran in a specific region.
- Get a Model Opens a BigQuery ML model by Model ID to read its Description, Encryptionconfiguration and the trial it chose as best.
- Get a Routine Reads one stored function or procedure by Routine ID, including its Definitionbody, Arguments and Determinismlevel.
- Get a Routine IAM Policy Shows who holds which roles on a routine, with an Etag and Version. Use Options to request a specific policy version.
- Get a Row Access Policy Fetches the policy behind a Policy ID, showing the Filterpredicate and Grantees it applies.
- Get a Row Access Policy IAM Policy Reads the IAM bindings of a row access policy, with Auditconfigs and an Etag.
- Get a Table Returns the Schema, Clustering and Creationtime of a table via its Table ID.
- Get a Table IAM Policy Lists the roles granted on a table, with Auditconfigs. Use Options to read a specific policy Version.
- Get Query Results Fetches the answer of a query that already ran, using its Job ID. Output includes Rows, Schema and Cachehit, plus a Pagetoken for further pages.
- Get the Service Account Finds the service account BigQuery uses for a project, returned as its Email.
- Insert Rows Streams new rows into a table from Rows in one call. Turn on Skip Invalid Rows to keep going past bad ones. Output includes any Inserterrors.
- List Datasets Lists the datasets in a project. Use Filter to match labels, All to include hidden datasets, and Limit to cut the result short.
- List Jobs Pages through BigQuery jobs, one item per job. Narrow them with State Filter, Min Creation Time, Max Creation Time or Parent Job ID, and include jobs owned by other people through All Users.
- List Models Lists every BigQuery ML model inside a dataset, each as a separate item with its Creationtime and Description. Use Limit to read only a few of them.
- List Projects Finds the Google Cloud projects your credential can open, each with its ID, Friendly Name and Numeric ID.
- List Routines Lists the functions and procedures stored in a dataset, one item each. Use Filter with routineType to show only one kind, and Read Mask to limit which fields are included.
- List Row Access Policies Shows every row access policy attached to a table as separate items with Filterpredicate and Grantees. Use Limit to receive fewer policies.
- List Table Data Reads rows straight from a table without running a query. Use Selected Fields to return only some columns and Limit to take a smaller slice. Output has the row values under F.
- List Tables Finds the tables and views in a dataset, giving the Schema and Creationtime of each. Use Limit to stop after the first few.
- Make an API Call Makes an authorized free-form request to the Google BigQuery REST API with your saved credential.
- Set a Routine IAM Policy Replaces the access policy of a routine from Policy. Add an Update Mask to limit which parts are written.
- Set a Table IAM Policy Writes a new access policy onto a table from Policy. Narrow the change with Update Mask.
- Test IAM Permissions on a Routine Checks which of the listed Permissions the current user holds on a routine. The granted ones are echoed back.
- Test IAM Permissions on a Row Access Policy Tests a list of Permissions against one row access policy. The ones the caller actually holds are returned.
- Test IAM Permissions on a Table Asks BigQuery which of the named Permissions apply to the caller on a table.
- Undelete a Dataset Brings back a dataset that was deleted recently. Set Deletion Time to pick a particular deleted version, otherwise the latest one is restored.
- Update a Dataset Overwrites a dataset with a fresh Friendly Name, Description, Location and Labels. Edit a Dataset covers more settings, including Access.
- Update a Routine Changes a stored routine by its Routine ID. Use Definition Body, Language and Arguments to change its code and inputs, and Return Type to change what it returns.
- Update a Row Access Policy Rewrites a row access policy with a new Filter Predicate and Grantees.
- Update a Table Replaces a table definition: Friendly Name, Description, Schema, View and Labels. Use Edit a Table for a partial change.
- Watch Jobs Checks a project on your schedule and starts the workflow once for each newly created BigQuery job. Use Limit to read fewer jobs on every poll.
Zite modules
- Check a Build Session Runs checks on the apps of a build session. Use App ID to check only one. Reports Diagnostics, Endpoint Errors and any Unchecked Apps.
- Commit Session Changes Saves the work of a build session as a commit with your Commit Message. Reports the Commit Sha and the Changed Apps.
- Create a Database Sets up a Zite database called Name. Add Tables to create tables together with their fields, each given a Table Name and field Type.
- Create a Field Adds a column to a table of a Database, defined by its Name and Type. Use Template (JSON) for settings that belong to one field type.
- Create a Record Inserts one row into a Database table. Fill Fields one by one or pass a whole Record (JSON) object, and turn on Strict to reject values that would be coerced.
- Create a Table Builds a table for a Database from a Name and its Fields, where the first field becomes the primary one.
- Create a Workspace Opens a workspace, which also creates a database with the same Name. Build tools need a paid Zite plan after the 7-day trial.
- Create a Zite from a Prompt Has the Zite agent build an app from a written Prompt of up to 10,000 characters. Attach up to 20 Files and set a Theme or Name to steer it. The Zite ID and a Claim URL are returned.
- Create an App Adds a new app to a build session under a Name. Set Access Mode to make it available to your organization or deploy it to a public subdomain.
- Create Records in Bulk Writes up to 100 Records into a Database table at once. Fill Match On to update rows that already match instead of adding duplicates.
- Delete a Database Removes a whole Zite database from the account.
- Delete a Field Deletes a column from a table.
- Delete a Record Removes a single row from a table by its Record ID.
- Delete a Table Deletes a table of your choice from the Database.
- Delete Records in Bulk Removes up to 100 rows of a table in one request, listed by their Record IDs, and returns the Deleted Count.
- Edit a File Swaps Old Text for New Text inside a file of the session. The old snippet must match exactly once, and the call reports whether it was Replaced.
- Get a Database Pulls a single database with its Tables and Workspace ID.
- Get a Record Reads one row by Record ID. Use Fields to return only some columns.
- Get a Run Fetches a single execution of an app from a Workspace by Run ID, with its Mode and Duration Ms.
- Get a Workspace Returns a workspace along with its Apps. Add a Session ID to read the project overview as well.
- Get an App Looks up one app inside a Workspace. You get its Build Status, any Build Error and its Access Mode.
- Get Records Aggregate Computes an Operation over one Field, such as a sum or average on a number column. Use Group By for one result per value, and Filter (JSON) to count only some rows.
- Get SQL Schema Describes the Tables of a database and its Link Tables, ready for writing queries. Turn off Include Fields for a short outline.
- List Databases Shows the databases of your Zite account, each with its URL and Workspace ID.
- List Fields Returns the columns of one table, with their Type and Order.
- List Files Lists the file paths inside a build session, giving one Path per item.
- List Records Pulls rows from a Database table. Use Filter (JSON) and Sort to shape the result, Fields to keep some columns, and Limit to stop after a set number.
- List Runs Browses executions of an app in a Workspace. Narrow them by Status or Environment, and set Hours Back to look up to one week into the past.
- List Webhooks Shows the webhooks registered on a Database, each with its Events and the Table Ids it covers.
- List Workspace Apps Enumerates the apps that live in a Workspace and flags which ones are Published.
- List Workspaces Fetches every workspace available to you, including its Apps and Overview.
- Make an API Call Makes an authorized free-form request to the Zite REST API with your saved credential.
- Open a Build Session Starts a build session in a Workspace so later steps can read, edit and commit its files. The Session ID those steps need is returned.
- Publish a Deployment Publishes an app from a Workspace. Returns the Snapshot ID, the Commit Sha and the Access Mode of what went out.
- Read a File Opens one file of a build session and returns its Content.
- Run a Command Executes a shell Command in the checkout of a session and reports its Stdout, Stderr and Exit Code.
- Run SQL Query Runs a read-only SELECT statement against a database. Use Bind Values for $1 and $2 placeholders and Statement Timeout (ms) to bound the run time. Flags a Truncated result.
- Search Files Finds a regular expression Pattern across session files. Restrict it to a Path or a Glob, and ask for Context Lines around each match.
- Update a Field Renames a column with Name, changes its Type, or edits its Template (options are merged).
- Update a Record Changes one row by Record ID. Fields you leave out stay as they are, and you can empty chosen ones with Clear Fields.
- Update a Table Renames a table, repositions it with Order, or picks a new Primary Field.
- Update Records in Bulk Edits up to 100 Records at once, each needing its Record ID and the fields to change.
- Upload a CSV File Saves a CSV File in Zite and returns its URL and Storage Key.
- Upload a Large Attachment Handles a File too big for the regular upload and saves it into an attachment field, returning its URL and Size.
- Upload an Attachment Stores a File under its File Name in an attachment column and returns the URL, Size and MIME Type. Bigger files go through Upload a Large Attachment.
- Upload an Excel File Sends a spreadsheet File to Zite storage and returns a link to it.
- Watch Events Fires instantly through a webhook whenever Zite sends an event, passing on the Event, its Timestamp and its Data.
- Write a File Creates or overwrites a file at Path with the full Content. Reports the Bytes written.
Explore alternative integrations
There are other apps[9] supported by WEXTL that can be paired with Google BigQuery and Zite integrations. Pick any from the list below if the current combination isn't the one you need.
Frequently asked questions
Common questions about connecting Google BigQuery and Zite.
References
List of sources used to gather information about the Google BigQuery and Zite integration.
- Google BigQuery and Zite integration source code, module specs and credentials implementation.
- Our Google BigQuery and Zite integration documentation, structured input and output parameters, scopes, and authentication methods.
- Official vendor API documentation for Google BigQuery and Zite, used to verify field meanings, authentication flows, and anything our own specs don't fully capture.
- WEXTL® visual workflow builder, anonymized data from our technical support team.
- Google BigQuery integration information
- Zite integration information
- WEXTL® Scheduling
- WEXTL® Pricing and Trial
- WEXTL® Apps Library
How we write our apps documentation
Explore how WEXTL® crafted Google BigQuery and Zite integration page documentation. Used sources, the role of AI, and how the team validates the result.