Skip to main content

workspaces

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

Overview

Nameworkspaces
TypeResource
Idgoogle.dataform.workspaces

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
directoryEntriesarrayList of entries in the directory.
nextPageTokenstringA token, which can be sent as page_token to retrieve the next page. If this field is omitted, there are no subsequent pages.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
query_directory_contentsselectprojectsId, locationsId, repositoriesId, workspacesIdpath, pageToken, pageSize, viewReturns the contents of a given Workspace directory.
getselectprojectsId, locationsId, repositoriesId, workspacesIdFetches a single Workspace.
listselectprojectsId, locationsId, repositoriesIdpageToken, pageSize, orderBy, filterLists Workspaces in a given Repository.
createinsertprojectsId, locationsId, repositoriesIdworkspaceIdCreates a new Workspace in a given Repository.
deletedeleteprojectsId, locationsId, repositoriesId, workspacesIdDeletes a single Workspace.
move_directoryexecprojectsId, locationsId, repositoriesId, workspacesIdMoves a directory (inside a Workspace), and all of its contents, to a new location.
search_filesexecprojectsId, locationsId, repositoriesId, workspacesIdpageSize, filter, pageTokenFinds the contents of a given Workspace directory by filter.
read_fileexecprojectsId, locationsId, repositoriesId, workspacesIdpath, revisionReturns the contents of a file (inside a Workspace).
pushexecprojectsId, locationsId, repositoriesId, workspacesIdPushes Git commits from a Workspace to the Repository's remote.
move_fileexecprojectsId, locationsId, repositoriesId, workspacesIdMoves a file (inside a Workspace) to a new location.
install_npm_packagesexecprojectsId, locationsId, repositoriesId, workspacesIdInstalls dependency NPM packages (inside a Workspace).
remove_fileexecprojectsId, locationsId, repositoriesId, workspacesIdDeletes a file (inside a Workspace).
pullexecprojectsId, locationsId, repositoriesId, workspacesIdPulls Git commits from the Repository's remote into a Workspace.
commitexecprojectsId, locationsId, repositoriesId, workspacesIdApplies a Git commit for uncommitted files in a Workspace.
make_directoryexecprojectsId, locationsId, repositoriesId, workspacesIdCreates a directory inside a Workspace.
write_fileexecprojectsId, locationsId, repositoriesId, workspacesIdWrites to a file (inside a Workspace).
resetexecprojectsId, locationsId, repositoriesId, workspacesIdPerforms a Git reset for uncommitted files in a Workspace.
remove_directoryexecprojectsId, locationsId, repositoriesId, workspacesIdDeletes a directory (inside a Workspace) and all of its contents.

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.

NameDatatypeDescription
locationsIdstring
projectsIdstring
repositoriesIdstring
workspacesIdstring
filterstring
orderBystring
pageSizeinteger (int32)
pageTokenstring
pathstring
revisionstring
viewstring
workspaceIdstring

SELECT examples

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 path = '{{ path }}'
AND pageToken = '{{ pageToken }}'
AND pageSize = '{{ pageSize }}'
AND view = '{{ view }}'
;

INSERT examples

Creates a new Workspace in a given Repository.

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

DELETE examples

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

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=
'{
"newPath": "{{ newPath }}",
"path": "{{ path }}"
}'
;