Skip to content

aws.sagemaker_geospatial.get_earth_observation_job

Example SQL Queries

SELECT * FROM
aws.sagemaker_geospatial.get_earth_observation_job
WHERE
"arn" = 'VALUE';

Description

Get the details for a previously initiated Earth Observation job.

Table Definition

Column NameColumn Data Type
arn Required Input Column

The Amazon Resource Name (ARN) of the Earth Observation job.

VARCHAR
_aws_profile Input Column

The AWS profile defines the AWS identity used. It can be defined via credentials or by assuming a IAM role.

STRUCT(
"type" VARCHAR,
"name" VARCHAR,
"account_id" VARCHAR,
"via_profile_name" VARCHAR,
"assumed_role_arn" VARCHAR,
"organization" STRUCT(
"account_name" VARCHAR,
"id" VARCHAR,
"tags" STRUCT(
"key" VARCHAR,
"value" VARCHAR
)[],
"master_account" STRUCT(
"id" VARCHAR,
"email" VARCHAR
),
"parents" STRUCT(
"type" VARCHAR,
"id" VARCHAR,
"name" VARCHAR,
"tags" STRUCT(
"key" VARCHAR,
"value" VARCHAR
)[]
)[]
)
)
Show child fields
_aws_profile.account_id

The AWS account id

_aws_profile.assumed_role_arn

The ARN of the assumed role

_aws_profile.name

The unique name of the profile.

_aws_profile.organization

Information about this profile's membership in the AWS organization.

Show child fields
_aws_profile.organization.account_name

The name of account speciifed by the organization

_aws_profile.organization.id

The organization id

_aws_profile.organization.master_account
Show child fields
_aws_profile.organization.master_account.email

The organization master account email address

_aws_profile.organization.master_account.id

The organization master account id

_aws_profile.organization.parents[]
Show child fields
_aws_profile.organization.parents[].id

The id of the parent

_aws_profile.organization.parents[].name

The name of the parent

_aws_profile.organization.parents[].tags[]
Show child fields
_aws_profile.organization.parents[].tags[].key
_aws_profile.organization.parents[].tags[].value
_aws_profile.organization.parents[].type

The type of parent can be an organization unit or a root

_aws_profile.organization.tags[]
Show child fields
_aws_profile.organization.tags[].key
_aws_profile.organization.tags[].value
_aws_profile.type

The type of profile, either 'credentials' or 'assumed_role'

_aws_profile.via_profile_name

This IAM role for this profile is assumed by first utilizing another profile with this name to obtain credentials.

_aws_region Input Column

The AWS region to use.

VARCHAR
creation_time

The creation time of the initiated Earth Observation job.

TIMESTAMP_S
duration_in_seconds

The duration of Earth Observation job, in seconds.

BIGINT
error_details

Details about the errors generated during the Earth Observation job.

STRUCT(
"message" VARCHAR,
"type" VARCHAR
)
Show child fields
error_details.message

A detailed message describing the error in an Earth Observation job.

error_details.type

The type of error in an Earth Observation job.

execution_role_arn

The Amazon Resource Name (ARN) of the IAM role that you specified for the job.

VARCHAR
export_error_details

Details about the errors generated during ExportEarthObservationJob.

STRUCT(
"export_results" STRUCT(
"message" VARCHAR,
"type" VARCHAR
),
"export_source_images" STRUCT(
"message" VARCHAR,
"type" VARCHAR
)
)
Show child fields
export_error_details.export_results

The structure for returning the export error details while exporting results of an Earth Observation job.

Show child fields
export_error_details.export_results.message

A detailed message describing the error in an export EarthObservationJob operation.

export_error_details.export_results.type

The type of error in an export EarthObservationJob operation.

export_error_details.export_source_images

The structure for returning the export error details while exporting the source images of an Earth Observation job.

Show child fields
export_error_details.export_source_images.message

A detailed message describing the error in an export EarthObservationJob operation.

export_error_details.export_source_images.type

The type of error in an export EarthObservationJob operation.

export_status

The status of the Earth Observation job.

VARCHAR
input_config

Input data for the Earth Observation job.

STRUCT(
"previous_earth_observation_job_arn" VARCHAR,
"raster_data_collection_query" STRUCT(
"area_of_interest" STRUCT(
"area_of_interest_geometry" STRUCT(
"multi_polygon_geometry" STRUCT(
"coordinates" DOUBLE[][][][]
),
"polygon_geometry" STRUCT(
"coordinates" DOUBLE[][][]
)
)
),
"property_filters" STRUCT(
"logical_operator" VARCHAR,
"properties" STRUCT(
"property" STRUCT(
"eo_cloud_cover" STRUCT(
"lower_bound" DOUBLE,
"upper_bound" DOUBLE
),
"landsat_cloud_cover_land" STRUCT(
"lower_bound" DOUBLE,
"upper_bound" DOUBLE
),
"platform" STRUCT(
"comparison_operator" VARCHAR,
"value" VARCHAR
),
"view_off_nadir" STRUCT(
"lower_bound" DOUBLE,
"upper_bound" DOUBLE
),
"view_sun_azimuth" STRUCT(
"lower_bound" DOUBLE,
"upper_bound" DOUBLE
),
"view_sun_elevation" STRUCT(
"lower_bound" DOUBLE,
"upper_bound" DOUBLE
)
)
)[]
),
"raster_data_collection_arn" VARCHAR,
"raster_data_collection_name" VARCHAR,
"time_range_filter" STRUCT(
"end_time" TIMESTAMP_S,
"start_time" TIMESTAMP_S
)
)
)
Show child fields
input_config.previous_earth_observation_job_arn

The Amazon Resource Name (ARN) of the previous Earth Observation job.

input_config.raster_data_collection_query

The structure representing the RasterDataCollection Query consisting of the Area of Interest, RasterDataCollectionArn, RasterDataCollectionName, TimeRange, and Property Filters.

Show child fields
input_config.raster_data_collection_query.area_of_interest

The Area of Interest used in the search.

Show child fields
input_config.raster_data_collection_query.area_of_interest.area_of_interest_geometry

A GeoJSON object representing the geographic extent in the coordinate space.

Show child fields
input_config.raster_data_collection_query.area_of_interest.area_of_interest_geometry.multi_polygon_geometry

The structure representing the MultiPolygon Geometry.

Show child fields
input_config.raster_data_collection_query.area_of_interest.area_of_interest_geometry.multi_polygon_geometry.coordinates[][][][]
input_config.raster_data_collection_query.area_of_interest.area_of_interest_geometry.polygon_geometry

The structure representing Polygon Geometry.

Show child fields
input_config.raster_data_collection_query.area_of_interest.area_of_interest_geometry.polygon_geometry.coordinates[][][]
input_config.raster_data_collection_query.property_filters

Property filters used in the search.

Show child fields
input_config.raster_data_collection_query.property_filters.logical_operator

The Logical Operator used to combine the Property Filters.

input_config.raster_data_collection_query.property_filters.properties[]
Show child fields
input_config.raster_data_collection_query.property_filters.properties[].property

Represents a single property to match with when searching a raster data collection.

Show child fields
input_config.raster_data_collection_query.property_filters.properties[].property.eo_cloud_cover

The structure representing EoCloudCover property filter containing a lower bound and upper bound.

Show child fields
input_config.raster_data_collection_query.property_filters.properties[].property.eo_cloud_cover.lower_bound

Lower bound for EoCloudCover.

input_config.raster_data_collection_query.property_filters.properties[].property.eo_cloud_cover.upper_bound

Upper bound for EoCloudCover.

input_config.raster_data_collection_query.property_filters.properties[].property.landsat_cloud_cover_land

The structure representing Land Cloud Cover property filter for Landsat collection containing a lower bound and upper bound.

Show child fields
input_config.raster_data_collection_query.property_filters.properties[].property.landsat_cloud_cover_land.lower_bound

The minimum value for Land Cloud Cover property filter. This will filter items having Land Cloud Cover greater than or equal to this value.

input_config.raster_data_collection_query.property_filters.properties[].property.landsat_cloud_cover_land.upper_bound

The maximum value for Land Cloud Cover property filter. This will filter items having Land Cloud Cover less than or equal to this value.

input_config.raster_data_collection_query.property_filters.properties[].property.platform

The structure representing Platform property filter consisting of value and comparison operator.

Show child fields
input_config.raster_data_collection_query.property_filters.properties[].property.platform.comparison_operator

The ComparisonOperator to use with PlatformInput.

input_config.raster_data_collection_query.property_filters.properties[].property.platform.value

The value of the platform.

input_config.raster_data_collection_query.property_filters.properties[].property.view_off_nadir

The structure representing ViewOffNadir property filter containing a lower bound and upper bound.

Show child fields
input_config.raster_data_collection_query.property_filters.properties[].property.view_off_nadir.lower_bound

The minimum value for ViewOffNadir property filter. This filters items having ViewOffNadir greater than or equal to this value.

input_config.raster_data_collection_query.property_filters.properties[].property.view_off_nadir.upper_bound

The maximum value for ViewOffNadir property filter. This filters items having ViewOffNadir lesser than or equal to this value.

input_config.raster_data_collection_query.property_filters.properties[].property.view_sun_azimuth

The structure representing ViewSunAzimuth property filter containing a lower bound and upper bound.

Show child fields
input_config.raster_data_collection_query.property_filters.properties[].property.view_sun_azimuth.lower_bound

The minimum value for ViewSunAzimuth property filter. This filters items having ViewSunAzimuth greater than or equal to this value.

input_config.raster_data_collection_query.property_filters.properties[].property.view_sun_azimuth.upper_bound

The maximum value for ViewSunAzimuth property filter. This filters items having ViewSunAzimuth lesser than or equal to this value.

input_config.raster_data_collection_query.property_filters.properties[].property.view_sun_elevation

The structure representing ViewSunElevation property filter containing a lower bound and upper bound.

Show child fields
input_config.raster_data_collection_query.property_filters.properties[].property.view_sun_elevation.lower_bound

The lower bound to view the sun elevation.

input_config.raster_data_collection_query.property_filters.properties[].property.view_sun_elevation.upper_bound

The upper bound to view the sun elevation.

input_config.raster_data_collection_query.raster_data_collection_arn

The ARN of the Raster Data Collection against which the search is done.

input_config.raster_data_collection_query.raster_data_collection_name

The name of the raster data collection.

input_config.raster_data_collection_query.time_range_filter

The TimeRange filter used in the search.

Show child fields
input_config.raster_data_collection_query.time_range_filter.end_time

The ending time for the time range filter.

input_config.raster_data_collection_query.time_range_filter.start_time

The starting time for the time range filter.

job_config

An object containing information about the job configuration.

STRUCT(
"band_math_config" STRUCT(
"custom_indices" STRUCT(
"operations" STRUCT(
"equation" VARCHAR,
"name" VARCHAR,
"output_type" VARCHAR
)[]
),
"predefined_indices" VARCHAR[]
),
"cloud_masking_config" BOOLEAN,
"cloud_removal_config" STRUCT(
"algorithm_name" VARCHAR,
"interpolation_value" VARCHAR,
"target_bands" VARCHAR[]
),
"geo_mosaic_config" STRUCT(
"algorithm_name" VARCHAR,
"target_bands" VARCHAR[]
),
"land_cover_segmentation_config" BOOLEAN,
"resampling_config" STRUCT(
"algorithm_name" VARCHAR,
"output_resolution" STRUCT(
"user_defined" STRUCT(
"unit" VARCHAR,
"value" DOUBLE
)
),
"target_bands" VARCHAR[]
),
"stack_config" STRUCT(
"output_resolution" STRUCT(
"predefined" VARCHAR,
"user_defined" STRUCT(
"unit" VARCHAR,
"value" DOUBLE
)
),
"target_bands" VARCHAR[]
),
"temporal_statistics_config" STRUCT(
"group_by" VARCHAR,
"statistics" VARCHAR[],
"target_bands" VARCHAR[]
),
"zonal_statistics_config" STRUCT(
"statistics" VARCHAR[],
"target_bands" VARCHAR[],
"zone_s3_path" VARCHAR,
"zone_s3_path_kms_key_id" VARCHAR
)
)
Show child fields
job_config.band_math_config

An object containing information about the job configuration for BandMath.

Show child fields
job_config.band_math_config.custom_indices

CustomIndices that are computed.

Show child fields
job_config.band_math_config.custom_indices.operations[]
Show child fields
job_config.band_math_config.custom_indices.operations[].equation

Textual representation of the math operation; Equation used to compute the spectral index.

job_config.band_math_config.custom_indices.operations[].name

The name of the operation.

job_config.band_math_config.custom_indices.operations[].output_type

The type of the operation.

job_config.band_math_config.predefined_indices[]
job_config.cloud_masking_config

An object containing information about the job configuration for cloud masking.

job_config.cloud_removal_config

An object containing information about the job configuration for cloud removal.

Show child fields
job_config.cloud_removal_config.algorithm_name

The name of the algorithm used for cloud removal.

job_config.cloud_removal_config.interpolation_value

The interpolation value you provide for cloud removal.

job_config.cloud_removal_config.target_bands[]
job_config.geo_mosaic_config

An object containing information about the job configuration for geomosaic.

Show child fields
job_config.geo_mosaic_config.algorithm_name

The name of the algorithm being used for geomosaic.

job_config.geo_mosaic_config.target_bands[]
job_config.land_cover_segmentation_config

An object containing information about the job configuration for land cover segmentation.

job_config.resampling_config

An object containing information about the job configuration for resampling.

Show child fields
job_config.resampling_config.algorithm_name

The name of the algorithm used for resampling.

job_config.resampling_config.output_resolution

The structure representing output resolution (in target georeferenced units) of the result of resampling operation.

Show child fields
job_config.resampling_config.output_resolution.user_defined

User Defined Resolution for the output of Resampling operation defined by value and unit.

Show child fields
job_config.resampling_config.output_resolution.user_defined.unit

The units for output resolution of the result.

job_config.resampling_config.output_resolution.user_defined.value

The value for output resolution of the result.

job_config.resampling_config.target_bands[]
job_config.stack_config

An object containing information about the job configuration for a Stacking Earth Observation job.

Show child fields
job_config.stack_config.output_resolution

The structure representing output resolution (in target georeferenced units) of the result of stacking operation.

Show child fields
job_config.stack_config.output_resolution.predefined

A string value representing Predefined Output Resolution for a stacking operation. Allowed values are HIGHEST, LOWEST, and AVERAGE.

job_config.stack_config.output_resolution.user_defined

The structure representing User Output Resolution for a Stacking operation defined as a value and unit.

Show child fields
job_config.stack_config.output_resolution.user_defined.unit

The units for output resolution of the result.

job_config.stack_config.output_resolution.user_defined.value

The value for output resolution of the result.

job_config.stack_config.target_bands[]
job_config.temporal_statistics_config

An object containing information about the job configuration for temporal statistics.

Show child fields
job_config.temporal_statistics_config.group_by

The input for the temporal statistics grouping by time frequency option.

job_config.temporal_statistics_config.statistics[]
job_config.temporal_statistics_config.target_bands[]
job_config.zonal_statistics_config

An object containing information about the job configuration for zonal statistics.

Show child fields
job_config.zonal_statistics_config.statistics[]
job_config.zonal_statistics_config.target_bands[]
job_config.zonal_statistics_config.zone_s3_path

The Amazon S3 path pointing to the GeoJSON containing the polygonal zones.

job_config.zonal_statistics_config.zone_s3_path_kms_key_id

The Amazon Resource Name (ARN) or an ID of a Amazon Web Services Key Management Service (Amazon Web Services KMS) key that Amazon SageMaker uses to decrypt your output artifacts with Amazon S3 server-side encryption. The SageMaker execution role must have kms:GenerateDataKey permission.

The KmsKeyId can be any of the following formats:

  • // KMS Key ID

    "1234abcd-12ab-34cd-56ef-1234567890ab"

  • // Amazon Resource Name (ARN) of a KMS Key

    "arn:aws:kms:<region>:<account>:key/<key-id-12ab-34cd-56ef-1234567890ab>"

For more information about key identifiers, see Key identifiers (KeyID) in the Amazon Web Services Key Management Service (Amazon Web Services KMS) documentation.

kms_key_id

The Key Management Service key ID for server-side encryption.

VARCHAR
name

The name of the Earth Observation job.

VARCHAR
output_bands

Bands available in the output of an operation.

STRUCT(
"band_name" VARCHAR,
"output_data_type" VARCHAR
)[]
Show child fields
output_bands[]
Show child fields
output_bands[].band_name

The name of the band.

output_bands[].output_data_type

The datatype of the output band.

status

The status of a previously initiated Earth Observation job.

VARCHAR
tags

Each tag consists of a key and a value.

MAP(VARCHAR, VARCHAR)