import_data_files

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

Overview

Name	import_data_files
Type	Resource
Id	google.migrationcenter.import_data_files

Fields

Name	Datatype	Description
name	string	Output only. The name of the file.
createTime	string	Output only. The timestamp when the file was created.
displayName	string	User-friendly display name. Maximum length is 63 characters.
format	string	Required. The payload format.
state	string	Output only. The state of the import data file.
uploadFileInfo	object	A resource that contains a URI to which a data file can be uploaded.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	importDataFilesId, importJobsId, locationsId, projectsId	Gets an import data file.
list	SELECT	importJobsId, locationsId, projectsId	List import data files.
create	INSERT	importJobsId, locationsId, projectsId	Creates an import data file.
delete	DELETE	importDataFilesId, importJobsId, locationsId, projectsId	Delete an import data file.

SELECT examples

List import data files.

SELECT
name,
createTime,
displayName,
format,
state,
uploadFileInfo
FROM google.migrationcenter.import_data_files
WHERE importJobsId = '{{ importJobsId }}'
AND locationsId = '{{ locationsId }}'
AND projectsId = '{{ projectsId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO google.migrationcenter.import_data_files (
importJobsId,
locationsId,
projectsId,
displayName,
format,
uploadFileInfo
)
SELECT 
'{{ importJobsId }}',
'{{ locationsId }}',
'{{ projectsId }}',
'{{ displayName }}',
'{{ format }}',
'{{ uploadFileInfo }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: name
      value: string
    - name: displayName
      value: string
    - name: format
      value: string
    - name: createTime
      value: string
    - name: state
      value: string
    - name: uploadFileInfo
      value:
        - name: signedUri
          value: string
        - name: headers
          value: object
        - name: uriExpirationTime
          value: string

DELETE example

Deletes the specified import_data_files resource.

/*+ delete */
DELETE FROM google.migrationcenter.import_data_files
WHERE importDataFilesId = '{{ importDataFilesId }}'
AND importJobsId = '{{ importJobsId }}'
AND locationsId = '{{ locationsId }}'
AND projectsId = '{{ projectsId }}';