workspaces

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

Overview

Name	workspaces
Type	Resource
Id	google.dataform.workspaces

Fields

The following fields are returned by SELECT queries:

get

Name	Datatype	Description
name	string	Identifier. The workspace's name.
createTime	string (google-datetime)	Output only. The timestamp of when the workspace was created.
dataEncryptionState	object	Output only. A data encryption state of a Git repository if this Workspace is protected by a KMS key. (id: DataEncryptionState)
internalMetadata	string	Output only. All the metadata information that is used internally to serve the resource. For example: timestamps, flags, status fields, etc. The format of this field is a JSON string.
privateResourceMetadata	object	Output only. Metadata indicating whether this resource is user-scoped. For Workspace resources, the user_scoped field is always true. (id: PrivateResourceMetadata)

query_directory_contents

Name	Datatype	Description
directoryEntries	array	List of entries in the directory.
nextPageToken	string	A token, which can be sent as page_token to retrieve the next page. If this field is omitted, there are no subsequent pages.

list

Name	Datatype	Description
name	string	Identifier. The workspace's name.
createTime	string (google-datetime)	Output only. The timestamp of when the workspace was created.
dataEncryptionState	object	Output only. A data encryption state of a Git repository if this Workspace is protected by a KMS key. (id: DataEncryptionState)
internalMetadata	string	Output only. All the metadata information that is used internally to serve the resource. For example: timestamps, flags, status fields, etc. The format of this field is a JSON string.
privateResourceMetadata	object	Output only. Metadata indicating whether this resource is user-scoped. For Workspace resources, the user_scoped field is always true. (id: PrivateResourceMetadata)

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	projectsId, locationsId, repositoriesId, workspacesId		Fetches a single Workspace.
query_directory_contents	select	projectsId, locationsId, repositoriesId, workspacesId	pageToken, path, pageSize	Returns the contents of a given Workspace directory.
list	select	projectsId, locationsId, repositoriesId	pageToken, filter, orderBy, pageSize	Lists Workspaces in a given Repository.
create	insert	projectsId, locationsId, repositoriesId	workspaceId	Creates a new Workspace in a given Repository.
delete	delete	projectsId, locationsId, repositoriesId, workspacesId		Deletes a single Workspace.
reset	exec	projectsId, locationsId, repositoriesId, workspacesId		Performs a Git reset for uncommitted files in a Workspace.
install_npm_packages	exec	projectsId, locationsId, repositoriesId, workspacesId		Installs dependency NPM packages (inside a Workspace).
remove_directory	exec	projectsId, locationsId, repositoriesId, workspacesId		Deletes a directory (inside a Workspace) and all of its contents.
remove_file	exec	projectsId, locationsId, repositoriesId, workspacesId		Deletes a file (inside a Workspace).
make_directory	exec	projectsId, locationsId, repositoriesId, workspacesId		Creates a directory inside a Workspace.
write_file	exec	projectsId, locationsId, repositoriesId, workspacesId		Writes to a file (inside a Workspace).
search_files	exec	projectsId, locationsId, repositoriesId, workspacesId	pageToken, filter, pageSize	Finds the contents of a given Workspace directory by filter.
move_directory	exec	projectsId, locationsId, repositoriesId, workspacesId		Moves a directory (inside a Workspace), and all of its contents, to a new location.
move_file	exec	projectsId, locationsId, repositoriesId, workspacesId		Moves a file (inside a Workspace) to a new location.
read_file	exec	projectsId, locationsId, repositoriesId, workspacesId	revision, path	Returns the contents of a file (inside a Workspace).
push	exec	projectsId, locationsId, repositoriesId, workspacesId		Pushes Git commits from a Workspace to the Repository's remote.
pull	exec	projectsId, locationsId, repositoriesId, workspacesId		Pulls Git commits from the Repository's remote into a Workspace.
commit	exec	projectsId, locationsId, repositoriesId, workspacesId		Applies a Git commit for uncommitted files in a Workspace.

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
locationsId	string
projectsId	string
repositoriesId	string
workspacesId	string
filter	string
orderBy	string
pageSize	integer (int32)
pageToken	string
path	string
revision	string
workspaceId	string

SELECT examples

get

Fetches a single Workspace.

SELECT
name,
createTime,
dataEncryptionState,
internalMetadata,
privateResourceMetadata
FROM google.dataform.workspaces
WHERE projectsId = '{{ projectsId }}' -- required
AND locationsId = '{{ locationsId }}' -- required
AND repositoriesId = '{{ repositoriesId }}' -- required
AND workspacesId = '{{ workspacesId }}' -- required
;

query_directory_contents

Returns the contents of a given Workspace directory.

SELECT
directoryEntries,
nextPageToken
FROM google.dataform.workspaces
WHERE projectsId = '{{ projectsId }}' -- required
AND locationsId = '{{ locationsId }}' -- required
AND repositoriesId = '{{ repositoriesId }}' -- required
AND workspacesId = '{{ workspacesId }}' -- required
AND pageToken = '{{ pageToken }}'
AND path = '{{ path }}'
AND pageSize = '{{ pageSize }}'
;

list

Lists Workspaces in a given Repository.

SELECT
name,
createTime,
dataEncryptionState,
internalMetadata,
privateResourceMetadata
FROM google.dataform.workspaces
WHERE projectsId = '{{ projectsId }}' -- required
AND locationsId = '{{ locationsId }}' -- required
AND repositoriesId = '{{ repositoriesId }}' -- required
AND pageToken = '{{ pageToken }}'
AND filter = '{{ filter }}'
AND orderBy = '{{ orderBy }}'
AND pageSize = '{{ pageSize }}'
;

INSERT examples

create

Creates a new Workspace in a given Repository.

INSERT INTO google.dataform.workspaces (
data__name,
projectsId,
locationsId,
repositoriesId,
workspaceId
)
SELECT 
'{{ name }}',
'{{ projectsId }}',
'{{ locationsId }}',
'{{ repositoriesId }}',
'{{ workspaceId }}'
RETURNING
name,
createTime,
dataEncryptionState,
internalMetadata,
privateResourceMetadata
;

Manifest

# Description fields are for documentation purposes
- name: workspaces
  props:
    - name: projectsId
      value: string
      description: Required parameter for the workspaces resource.
    - name: locationsId
      value: string
      description: Required parameter for the workspaces resource.
    - name: repositoriesId
      value: string
      description: Required parameter for the workspaces resource.
    - name: name
      value: string
      description: >
        Identifier. The workspace's name.
        
    - name: workspaceId
      value: string

DELETE examples

delete

Deletes a single Workspace.

DELETE FROM google.dataform.workspaces
WHERE projectsId = '{{ projectsId }}' --required
AND locationsId = '{{ locationsId }}' --required
AND repositoriesId = '{{ repositoriesId }}' --required
AND workspacesId = '{{ workspacesId }}' --required
;

Lifecycle Methods

reset

Performs a Git reset for uncommitted files in a Workspace.

EXEC google.dataform.workspaces.reset 
@projectsId='{{ projectsId }}' --required, 
@locationsId='{{ locationsId }}' --required, 
@repositoriesId='{{ repositoriesId }}' --required, 
@workspacesId='{{ workspacesId }}' --required 
@@json=
'{
"paths": "{{ paths }}", 
"clean": {{ clean }}
}'
;

install_npm_packages

Installs dependency NPM packages (inside a Workspace).

EXEC google.dataform.workspaces.install_npm_packages 
@projectsId='{{ projectsId }}' --required, 
@locationsId='{{ locationsId }}' --required, 
@repositoriesId='{{ repositoriesId }}' --required, 
@workspacesId='{{ workspacesId }}' --required
;

remove_directory

Deletes a directory (inside a Workspace) and all of its contents.

EXEC google.dataform.workspaces.remove_directory 
@projectsId='{{ projectsId }}' --required, 
@locationsId='{{ locationsId }}' --required, 
@repositoriesId='{{ repositoriesId }}' --required, 
@workspacesId='{{ workspacesId }}' --required 
@@json=
'{
"path": "{{ path }}"
}'
;

remove_file

Deletes a file (inside a Workspace).

EXEC google.dataform.workspaces.remove_file 
@projectsId='{{ projectsId }}' --required, 
@locationsId='{{ locationsId }}' --required, 
@repositoriesId='{{ repositoriesId }}' --required, 
@workspacesId='{{ workspacesId }}' --required 
@@json=
'{
"path": "{{ path }}"
}'
;

make_directory

Creates a directory inside a Workspace.

EXEC google.dataform.workspaces.make_directory 
@projectsId='{{ projectsId }}' --required, 
@locationsId='{{ locationsId }}' --required, 
@repositoriesId='{{ repositoriesId }}' --required, 
@workspacesId='{{ workspacesId }}' --required 
@@json=
'{
"path": "{{ path }}"
}'
;

write_file

Writes to a file (inside a Workspace).

EXEC google.dataform.workspaces.write_file 
@projectsId='{{ projectsId }}' --required, 
@locationsId='{{ locationsId }}' --required, 
@repositoriesId='{{ repositoriesId }}' --required, 
@workspacesId='{{ workspacesId }}' --required 
@@json=
'{
"path": "{{ path }}", 
"contents": "{{ contents }}"
}'
;

search_files

Finds the contents of a given Workspace directory by filter.

EXEC google.dataform.workspaces.search_files 
@projectsId='{{ projectsId }}' --required, 
@locationsId='{{ locationsId }}' --required, 
@repositoriesId='{{ repositoriesId }}' --required, 
@workspacesId='{{ workspacesId }}' --required, 
@pageToken='{{ pageToken }}', 
@filter='{{ filter }}', 
@pageSize='{{ pageSize }}'
;

move_directory

Moves a directory (inside a Workspace), and all of its contents, to a new location.

EXEC google.dataform.workspaces.move_directory 
@projectsId='{{ projectsId }}' --required, 
@locationsId='{{ locationsId }}' --required, 
@repositoriesId='{{ repositoriesId }}' --required, 
@workspacesId='{{ workspacesId }}' --required 
@@json=
'{
"path": "{{ path }}", 
"newPath": "{{ newPath }}"
}'
;

move_file

Moves a file (inside a Workspace) to a new location.

EXEC google.dataform.workspaces.move_file 
@projectsId='{{ projectsId }}' --required, 
@locationsId='{{ locationsId }}' --required, 
@repositoriesId='{{ repositoriesId }}' --required, 
@workspacesId='{{ workspacesId }}' --required 
@@json=
'{
"newPath": "{{ newPath }}", 
"path": "{{ path }}"
}'
;

read_file

Returns the contents of a file (inside a Workspace).

EXEC google.dataform.workspaces.read_file 
@projectsId='{{ projectsId }}' --required, 
@locationsId='{{ locationsId }}' --required, 
@repositoriesId='{{ repositoriesId }}' --required, 
@workspacesId='{{ workspacesId }}' --required, 
@revision='{{ revision }}', 
@path='{{ path }}'
;

push

Pushes Git commits from a Workspace to the Repository's remote.

EXEC google.dataform.workspaces.push 
@projectsId='{{ projectsId }}' --required, 
@locationsId='{{ locationsId }}' --required, 
@repositoriesId='{{ repositoriesId }}' --required, 
@workspacesId='{{ workspacesId }}' --required 
@@json=
'{
"remoteBranch": "{{ remoteBranch }}"
}'
;

pull

Pulls Git commits from the Repository's remote into a Workspace.

EXEC google.dataform.workspaces.pull 
@projectsId='{{ projectsId }}' --required, 
@locationsId='{{ locationsId }}' --required, 
@repositoriesId='{{ repositoriesId }}' --required, 
@workspacesId='{{ workspacesId }}' --required 
@@json=
'{
"author": "{{ author }}", 
"remoteBranch": "{{ remoteBranch }}"
}'
;

commit

Applies a Git commit for uncommitted files in a Workspace.

EXEC google.dataform.workspaces.commit 
@projectsId='{{ projectsId }}' --required, 
@locationsId='{{ locationsId }}' --required, 
@repositoriesId='{{ repositoriesId }}' --required, 
@workspacesId='{{ workspacesId }}' --required 
@@json=
'{
"paths": "{{ paths }}", 
"author": "{{ author }}", 
"commitMessage": "{{ commitMessage }}"
}'
;