datasets

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

Overview

Name	datasets
Type	Resource
Id	google.translate.datasets

Fields

Name	Datatype	Description
name	string	The resource name of the dataset, in form of projects/{project-number-or-id}/locations/{location_id}/datasets/{dataset_id}
createTime	string	Output only. Timestamp when this dataset was created.
displayName	string	The name of the dataset to show in the interface. The name can be up to 32 characters long and can consist only of ASCII Latin letters A-Z and a-z, underscores (_), and ASCII digits 0-9.
exampleCount	integer	Output only. The number of examples in the dataset.
sourceLanguageCode	string	The BCP-47 language code of the source language.
targetLanguageCode	string	The BCP-47 language code of the target language.
testExampleCount	integer	Output only. Number of test examples (sentence pairs).
trainExampleCount	integer	Output only. Number of training examples (sentence pairs).
updateTime	string	Output only. Timestamp when this dataset was last updated.
validateExampleCount	integer	Output only. Number of validation examples (sentence pairs).

Methods

Name	Accessible by	Required Params	Description
projects_locations_datasets_get	SELECT	datasetsId, locationsId, projectsId	Gets a Dataset.
projects_locations_datasets_list	SELECT	locationsId, projectsId	Lists datasets.
projects_locations_datasets_create	INSERT	locationsId, projectsId	Creates a Dataset.
projects_locations_datasets_delete	DELETE	datasetsId, locationsId, projectsId	Deletes a dataset and all of its contents.
projects_locations_datasets_export_data	EXEC	datasetsId, locationsId, projectsId	Exports dataset's data to the provided output location.
projects_locations_datasets_import_data	EXEC	datasetsId, locationsId, projectsId	Import sentence pairs into translation Dataset.

SELECT examples

Lists datasets.

SELECT
name,
createTime,
displayName,
exampleCount,
sourceLanguageCode,
targetLanguageCode,
testExampleCount,
trainExampleCount,
updateTime,
validateExampleCount
FROM google.translate.datasets
WHERE locationsId = '{{ locationsId }}'
AND projectsId = '{{ projectsId }}';

INSERT example

Use the following StackQL query and manifest file to create a new datasets resource.

All Properties

/*+ create */
INSERT INTO google.translate.datasets (
locationsId,
projectsId,
name,
displayName,
sourceLanguageCode,
targetLanguageCode
)
SELECT 
'{{ locationsId }}',
'{{ projectsId }}',
'{{ name }}',
'{{ displayName }}',
'{{ sourceLanguageCode }}',
'{{ targetLanguageCode }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: name
      value: string
    - name: displayName
      value: string
    - name: sourceLanguageCode
      value: string
    - name: targetLanguageCode
      value: string
    - name: exampleCount
      value: integer
    - name: trainExampleCount
      value: integer
    - name: validateExampleCount
      value: integer
    - name: testExampleCount
      value: integer
    - name: createTime
      value: string
    - name: updateTime
      value: string

DELETE example

Deletes the specified datasets resource.

/*+ delete */
DELETE FROM google.translate.datasets
WHERE datasetsId = '{{ datasetsId }}'
AND locationsId = '{{ locationsId }}'
AND projectsId = '{{ projectsId }}';