aws.personalize.describe_batch_inference_job

Example SQL Queries

SELECT * FROM
aws.personalize.describe_batch_inference_job
WHERE
"batch_inference_job_arn" = 'VALUE';

Description

Gets the properties of a batch inference job including name, Amazon Resource Name (ARN), status, input and output configurations, and the ARN of the solution version used to generate the recommendations.

• View All Personalize Tables
• Boto3 Reference

Table Definition

Column Name	Column Data Type
batch_inference_job_arn Required Input Column The ARN of the batch inference job to describe.	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
batch_inference_job Information on the specified batch inference job.	STRUCT( "job_name" VARCHAR, "batch_inference_job_arn" VARCHAR, "filter_arn" VARCHAR, "failure_reason" VARCHAR, "solution_version_arn" VARCHAR, "num_results" BIGINT, "job_input" STRUCT( "s3_data_source" STRUCT( "path" VARCHAR, "kms_key_arn" VARCHAR ) ), "job_output" STRUCT( "s3_data_destination" STRUCT( "path" VARCHAR, "kms_key_arn" VARCHAR ) ), "batch_inference_job_config" STRUCT( "item_exploration_config" MAP(VARCHAR, VARCHAR) ), "role_arn" VARCHAR, "batch_inference_job_mode" VARCHAR, "theme_generation_config" STRUCT( "fields_for_theme_generation" STRUCT( "item_name" VARCHAR ) ), "status" VARCHAR, "creation_date_time" TIMESTAMP_S, "last_updated_date_time" TIMESTAMP_S )
Show child fields batch_inference_job.batch_inference_job_arn The Amazon Resource Name (ARN) of the batch inference job. batch_inference_job.batch_inference_job_config A string to string map of the configuration details of a batch inference job. Show child fields batch_inference_job.batch_inference_job_config.item_exploration_config A string to string map specifying the exploration configuration hyperparameters, including explorationWeight and explorationItemAgeCutOff, you want to use to configure the amount of item exploration Amazon Personalize uses when recommending items. See User-Personalization. batch_inference_job.batch_inference_job_mode The job's mode. batch_inference_job.creation_date_time The time at which the batch inference job was created. batch_inference_job.failure_reason If the batch inference job failed, the reason for the failure. batch_inference_job.filter_arn The ARN of the filter used on the batch inference job. batch_inference_job.job_input The Amazon S3 path that leads to the input data used to generate the batch inference job. Show child fields batch_inference_job.job_input.s3_data_source The URI of the Amazon S3 location that contains your input data. The Amazon S3 bucket must be in the same region as the API endpoint you are calling. Show child fields batch_inference_job.job_input.s3_data_source.kms_key_arn The Amazon Resource Name (ARN) of the Key Management Service (KMS) key that Amazon Personalize uses to encrypt or decrypt the input and output files. batch_inference_job.job_input.s3_data_source.path The file path of the Amazon S3 bucket. batch_inference_job.job_name The name of the batch inference job. batch_inference_job.job_output The Amazon S3 bucket that contains the output data generated by the batch inference job. Show child fields batch_inference_job.job_output.s3_data_destination Information on the Amazon S3 bucket in which the batch inference job's output is stored. Show child fields batch_inference_job.job_output.s3_data_destination.kms_key_arn The Amazon Resource Name (ARN) of the Key Management Service (KMS) key that Amazon Personalize uses to encrypt or decrypt the input and output files. batch_inference_job.job_output.s3_data_destination.path The file path of the Amazon S3 bucket. batch_inference_job.last_updated_date_time The time at which the batch inference job was last updated. batch_inference_job.num_results The number of recommendations generated by the batch inference job. This number includes the error messages generated for failed input records. batch_inference_job.role_arn The ARN of the Amazon Identity and Access Management (IAM) role that requested the batch inference job. batch_inference_job.solution_version_arn The Amazon Resource Name (ARN) of the solution version from which the batch inference job was created. batch_inference_job.status The status of the batch inference job. The status is one of the following values: PENDING IN PROGRESS ACTIVE CREATE FAILED batch_inference_job.theme_generation_config The job's theme generation settings. Show child fields batch_inference_job.theme_generation_config.fields_for_theme_generation Fields used to generate descriptive themes for a batch inference job. Show child fields batch_inference_job.theme_generation_config.fields_for_theme_generation.item_name The name of the Items dataset column that stores the name of each item in the dataset.

Note

Tables may require input columns to have values specified before the table can return it’s rows. The values for input parameters are set in the where clause of the query typically using = or IN.