Aident logoAident logo centerAident Loadout
Use CasesPricingDocs
ENStart Now
AppsGoogle BigQuery ToolsGooglebigquery Create Routine
Google BigQuery Tools

Googlebigquery Create Routine

Tool to create a new user-defined routine (function or procedure) in a BigQuery dataset. Use when you need to define SQL, JavaScript, Python, Java, or Scala functions/procedures for reusable logic, data transformations, or custom masking. Supports scalar functions, table-valued…

Write actionRisk level 2 of 5OAuth connection
Use Googlebigquery Create Routine

Pricing and limits

Aident logo

Product

Aident LoadoutAident Playbook EditorOpen-CUAK

About

AppsSkillsUse CasesDocsBlogPricingDownloadsPrivacy PolicyTerms of Service

Alternatives

vs Composiovs Zapier
llms.txtGet an AI summary of Aident LoadoutSummarize with ChatGPTSummarize with ClaudeSummarize with GeminiSummarize with Perplexity

© Aident Labs, 2024-2026

Pricing
Free
Unified payment
Not currently supported

Inputs

  • languagestring
    Programming language of the routine.
  • argumentsarray
    Optional. Input/output arguments for the routine.
  • dataset_idstring
    Required
    Required. Dataset ID where the routine will be created. Used in the URL path.
  • project_idstring
    Required
    Required. Project ID where the routine will be created. Used in the URL path.
  • returnTypeobject
    Data type of a BigQuery field or function argument. Supports simple types like INT64, and complex types like ARRAY and STRUCT.
  • strictModeboolean
    Optional. If TRUE (default), the procedure body is checked for errors like non-existent tables. Set to FALSE for recursive procedures to avoid validation errors.
  • descriptionstring
    Optional. A description of the routine.
  • routineTypestring
    Required
    Required. The type of routine: SCALAR_FUNCTION, PROCEDURE, TABLE_VALUED_FUNCTION, or AGGREGATE_FUNCTION.
  • securityModestring
    Security mode of the routine.
  • sparkOptionsobject
    Options for user-defined Spark routines.
  • definitionBodystring
    Required
    Required. The body of the routine. For SQL functions, this is the expression in the AS clause (excluding parentheses). For JavaScript, it's the evaluated string in the AS clause.
  • returnTableTypeobject
    A table type for table-valued functions.

Observable output

  • data
    Required
    Data from the action execution
  • errorstring
    Error if any occurred during the execution of the action
  • successfulboolean
    Required
    Whether or not the action execution was successful or not

Skills that use this Action

Related use cases

No verified related use cases are linked yet.

Official source

Provider source

Skills that use this Action

No published Skills explicitly reference this Action yet.