job_templates

Creates, updates, deletes, gets or lists a job_templates resource.

Overview

Name	job_templates
Type	Resource
Id	google.transcoder.job_templates

Fields

The following fields are returned by SELECT queries:

get

Name	Datatype	Description
name	string	The resource name of the job template. Format: projects/{project_number}/locations/{location}/jobTemplates/{job_template}
config	object	The configuration for this template. (id: JobConfig)
labels	object	The labels associated with this job template. You can use these to organize and group your job templates.

list

Name	Datatype	Description
name	string	The resource name of the job template. Format: projects/{project_number}/locations/{location}/jobTemplates/{job_template}
config	object	The configuration for this template. (id: JobConfig)
labels	object	The labels associated with this job template. You can use these to organize and group your job templates.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	projectsId, locationsId, jobTemplatesId		Returns the job template data.
list	select	projectsId, locationsId	filter, orderBy, pageSize, pageToken	Lists job templates in the specified region.
create	insert	projectsId, locationsId	jobTemplateId	Creates a job template in the specified region.
delete	delete	projectsId, locationsId, jobTemplatesId	allowMissing	Deletes a job template.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
jobTemplatesId	string
locationsId	string
projectsId	string
allowMissing	boolean
filter	string
jobTemplateId	string
orderBy	string
pageSize	integer (int32)
pageToken	string

SELECT examples

get

Returns the job template data.

SELECT
name,
config,
labels
FROM google.transcoder.job_templates
WHERE projectsId = '{{ projectsId }}' -- required
AND locationsId = '{{ locationsId }}' -- required
AND jobTemplatesId = '{{ jobTemplatesId }}' -- required
;

list

Lists job templates in the specified region.

SELECT
name,
config,
labels
FROM google.transcoder.job_templates
WHERE projectsId = '{{ projectsId }}' -- required
AND locationsId = '{{ locationsId }}' -- required
AND filter = '{{ filter }}'
AND orderBy = '{{ orderBy }}'
AND pageSize = '{{ pageSize }}'
AND pageToken = '{{ pageToken }}'
;

INSERT examples

create

Creates a job template in the specified region.

INSERT INTO google.transcoder.job_templates (
data__config,
data__labels,
data__name,
projectsId,
locationsId,
jobTemplateId
)
SELECT 
'{{ config }}',
'{{ labels }}',
'{{ name }}',
'{{ projectsId }}',
'{{ locationsId }}',
'{{ jobTemplateId }}'
RETURNING
name,
config,
labels
;

Manifest

# Description fields are for documentation purposes
- name: job_templates
props:
  - name: projectsId
    value: "{{ projectsId }}"
    description: Required parameter for the job_templates resource.
  - name: locationsId
    value: "{{ locationsId }}"
    description: Required parameter for the job_templates resource.
  - name: config
    description: |
      The configuration for this template.
    value:
      adBreaks:
        - startTimeOffset: "{{ startTimeOffset }}"
      editList:
        - endTimeOffset: "{{ endTimeOffset }}"
          inputs: "{{ inputs }}"
          key: "{{ key }}"
          startTimeOffset: "{{ startTimeOffset }}"
      elementaryStreams:
        - audioStream:
            bitrateBps: {{ bitrateBps }}
            channelCount: {{ channelCount }}
            channelLayout:
              - "{{ channelLayout }}"
            codec: "{{ codec }}"
            displayName: "{{ displayName }}"
            languageCode: "{{ languageCode }}"
            mapping:
              - atomKey: "{{ atomKey }}"
                gainDb: {{ gainDb }}
                inputChannel: {{ inputChannel }}
                inputKey: "{{ inputKey }}"
                inputTrack: {{ inputTrack }}
                outputChannel: {{ outputChannel }}
            sampleRateHertz: {{ sampleRateHertz }}
          key: "{{ key }}"
          textStream:
            codec: "{{ codec }}"
            displayName: "{{ displayName }}"
            languageCode: "{{ languageCode }}"
            mapping:
              - atomKey: "{{ atomKey }}"
                inputKey: "{{ inputKey }}"
                inputTrack: {{ inputTrack }}
          videoStream:
            h264:
              allowOpenGop: {{ allowOpenGop }}
              aqStrength: {{ aqStrength }}
              bFrameCount: {{ bFrameCount }}
              bPyramid: {{ bPyramid }}
              bitrateBps: {{ bitrateBps }}
              crfLevel: {{ crfLevel }}
              enableTwoPass: {{ enableTwoPass }}
              entropyCoder: "{{ entropyCoder }}"
              frameRate: {{ frameRate }}
              frameRateConversionStrategy: "{{ frameRateConversionStrategy }}"
              gopDuration: "{{ gopDuration }}"
              gopFrameCount: {{ gopFrameCount }}
              heightPixels: {{ heightPixels }}
              hlg: "{{ hlg }}"
              pixelFormat: "{{ pixelFormat }}"
              preset: "{{ preset }}"
              profile: "{{ profile }}"
              rateControlMode: "{{ rateControlMode }}"
              sdr: "{{ sdr }}"
              tune: "{{ tune }}"
              vbvFullnessBits: {{ vbvFullnessBits }}
              vbvSizeBits: {{ vbvSizeBits }}
              widthPixels: {{ widthPixels }}
            h265:
              allowOpenGop: {{ allowOpenGop }}
              aqStrength: {{ aqStrength }}
              bFrameCount: {{ bFrameCount }}
              bPyramid: {{ bPyramid }}
              bitrateBps: {{ bitrateBps }}
              crfLevel: {{ crfLevel }}
              enableTwoPass: {{ enableTwoPass }}
              frameRate: {{ frameRate }}
              frameRateConversionStrategy: "{{ frameRateConversionStrategy }}"
              gopDuration: "{{ gopDuration }}"
              gopFrameCount: {{ gopFrameCount }}
              hdr10: "{{ hdr10 }}"
              heightPixels: {{ heightPixels }}
              hlg: "{{ hlg }}"
              pixelFormat: "{{ pixelFormat }}"
              preset: "{{ preset }}"
              profile: "{{ profile }}"
              rateControlMode: "{{ rateControlMode }}"
              sdr: "{{ sdr }}"
              tune: "{{ tune }}"
              vbvFullnessBits: {{ vbvFullnessBits }}
              vbvSizeBits: {{ vbvSizeBits }}
              widthPixels: {{ widthPixels }}
            vp9:
              bitrateBps: {{ bitrateBps }}
              crfLevel: {{ crfLevel }}
              frameRate: {{ frameRate }}
              frameRateConversionStrategy: "{{ frameRateConversionStrategy }}"
              gopDuration: "{{ gopDuration }}"
              gopFrameCount: {{ gopFrameCount }}
              heightPixels: {{ heightPixels }}
              hlg: "{{ hlg }}"
              pixelFormat: "{{ pixelFormat }}"
              profile: "{{ profile }}"
              rateControlMode: "{{ rateControlMode }}"
              sdr: "{{ sdr }}"
              widthPixels: {{ widthPixels }}
      encryptions:
        - aes128: "{{ aes128 }}"
          drmSystems:
            clearkey: "{{ clearkey }}"
            fairplay: "{{ fairplay }}"
            playready: "{{ playready }}"
            widevine: "{{ widevine }}"
          id: "{{ id }}"
          mpegCenc:
            scheme: "{{ scheme }}"
          sampleAes: "{{ sampleAes }}"
          secretManagerKeySource:
            secretVersion: "{{ secretVersion }}"
      inputs:
        - attributes:
            trackDefinitions:
              - detectLanguages: {{ detectLanguages }}
                detectedLanguages: "{{ detectedLanguages }}"
                inputTrack: {{ inputTrack }}
                languages: "{{ languages }}"
          key: "{{ key }}"
          preprocessingConfig:
            audio:
              highBoost: {{ highBoost }}
              lowBoost: {{ lowBoost }}
              lufs: {{ lufs }}
            color:
              brightness: {{ brightness }}
              contrast: {{ contrast }}
              saturation: {{ saturation }}
            crop:
              bottomPixels: {{ bottomPixels }}
              leftPixels: {{ leftPixels }}
              rightPixels: {{ rightPixels }}
              topPixels: {{ topPixels }}
            deblock:
              enabled: {{ enabled }}
              strength: {{ strength }}
            deinterlace:
              bwdif:
                deinterlaceAllFrames: {{ deinterlaceAllFrames }}
                mode: "{{ mode }}"
                parity: "{{ parity }}"
              yadif:
                deinterlaceAllFrames: {{ deinterlaceAllFrames }}
                disableSpatialInterlacing: {{ disableSpatialInterlacing }}
                mode: "{{ mode }}"
                parity: "{{ parity }}"
            denoise:
              strength: {{ strength }}
              tune: "{{ tune }}"
            pad:
              bottomPixels: {{ bottomPixels }}
              leftPixels: {{ leftPixels }}
              rightPixels: {{ rightPixels }}
              topPixels: {{ topPixels }}
          uri: "{{ uri }}"
      manifests:
        - dash:
            segmentReferenceScheme: "{{ segmentReferenceScheme }}"
          fileName: "{{ fileName }}"
          muxStreams: "{{ muxStreams }}"
          type: "{{ type }}"
      muxStreams:
        - container: "{{ container }}"
          elementaryStreams: "{{ elementaryStreams }}"
          encryptionId: "{{ encryptionId }}"
          fileName: "{{ fileName }}"
          fmp4:
            codecTag: "{{ codecTag }}"
          key: "{{ key }}"
          segmentSettings:
            individualSegments: {{ individualSegments }}
            segmentDuration: "{{ segmentDuration }}"
      output:
        uri: "{{ uri }}"
      overlays:
        - animations: "{{ animations }}"
          image:
            alpha: {{ alpha }}
            resolution:
              x: {{ x }}
              y: {{ y }}
            uri: "{{ uri }}"
      pubsubDestination:
        topic: "{{ topic }}"
      spriteSheets:
        - columnCount: {{ columnCount }}
          endTimeOffset: "{{ endTimeOffset }}"
          filePrefix: "{{ filePrefix }}"
          format: "{{ format }}"
          interval: "{{ interval }}"
          quality: {{ quality }}
          rowCount: {{ rowCount }}
          spriteHeightPixels: {{ spriteHeightPixels }}
          spriteWidthPixels: {{ spriteWidthPixels }}
          startTimeOffset: "{{ startTimeOffset }}"
          totalCount: {{ totalCount }}
  - name: labels
    value: "{{ labels }}"
    description: |
      The labels associated with this job template. You can use these to organize and group your job templates.
  - name: name
    value: "{{ name }}"
    description: |
      The resource name of the job template. Format: `projects/{project_number}/locations/{location}/jobTemplates/{job_template}`
  - name: jobTemplateId
    value: "{{ jobTemplateId }}"

DELETE examples

delete

Deletes a job template.

DELETE FROM google.transcoder.job_templates
WHERE projectsId = '{{ projectsId }}' --required
AND locationsId = '{{ locationsId }}' --required
AND jobTemplatesId = '{{ jobTemplatesId }}' --required
AND allowMissing = '{{ allowMissing }}'
;