Google Dataform
Service to develop, version control, and operationalize SQL pipelines in BigQuery (Google OAuth2).
OCNORA ships 9 typed Google Dataform operations. Each node has a schema-driven form, input and output tables beside its settings, and is pre-flighted by Workflow Health before your first real run.
Before you connect Google Dataform
- Authentication
- OAuth 2.0
- Credential
- {"client_id", "client_secret", "refresh_token"}
- Connection test
- Available: the stored credential can be checked against the provider when you add it. This is not a record that a test was run or passed.
What you can do with Google Dataform
Operations, grouped by what they do to your data.
Create and send 2
Update 1
Delete and cancel 1
Other operations 1
A sample Google Dataform workflow
- 1A core triggerStart the run from a chat, form, manual, schedule, webhook, workflow trigger — no Google Dataform trigger is needed.
- 2Get Compilation Resultdataform.get_compilation_resultFetches a single CompilationResult.
- 3Commit Repositorydataform.commit_repositoryApplies a Git commit to a Repository. The Repository must not have a value for git_remote_settings.url.
An outline built from this provider’s node contracts, not a recorded run. Each step’s output fields are available to the next in the field picker.
Every node below has a reference page: what it does, the connection it needs, its config fields with types, constraints and examples, and the shapes it emits.
Operations 9
- Commit RepositoryApplies a Git commit to a Repository. The Repository must not have a value for git_remote_settings.url.dataform.commit_repository
- Create Compilation ResultCreates a new CompilationResult in a given project and location.dataform.create_compilation_result
- Create RepositoryCreates a new Repository in a given project and location.dataform.create_repository
- Delete RepositoryDeletes a single Repository.dataform.delete_repository
- Get Compilation ResultFetches a single CompilationResult.dataform.get_compilation_result
- Get RepositoryFetches a single Repository.dataform.get_repository
- List Compilation ResultsLists CompilationResults in a given Repository.dataform.list_compilation_results
- List RepositoriesLists Repositories in a given project and location.dataform.list_repositories
- Update RepositoryUpdates a single Repository.dataform.update_repository
Google Dataform questions
- How does OCNORA authenticate with Google Dataform?
- With a stored OAuth 2.0 credential, shaped {"client_id", "client_secret", "refresh_token"}. A connection test can check it when you add it.
- What can I automate with Google Dataform?
- 9 typed operations, each with a reference page listing its config fields and the shapes it emits.
- What if the Google Dataform operation I need is not listed?
- Where Google Dataform has an HTTP API, call it from the HTTP node with the same credential, or describe the step to the AI builder, which asks our team for a typed node when one is missing.
- Are there templates that use Google Dataform?
- Not yet. Start from a blank workflow, or describe the workflow to Build with AI.
- How are Google Dataform calls controlled?
- Every call and every run step is audited, runs count against the execution budget, and Workflow Health pre-flights the workflow when you save it.
See your first Google Dataform workflow run.
Book a technical demo. We add the connection, pick a template or describe the workflow to Build with AI, and Workflow Health checks it before it runs.