Skip to main content

account_activities

Creates, updates, deletes, gets or lists an account_activities resource.

Overview

Nameaccount_activities
TypeResource
Idaws.freetier.account_activities

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
activity_idstringA unique identifier that identifies the activity. (pattern: <code>[a-zA-Z0-9]+</code>)
completed_atstring (date-time)The timestamp when the activity is completed. This field appears only for activities in the COMPLETED state.
descriptionstringProvides detailed information about the activity and its expected outcomes. (pattern: <code>[\S\s]*</code>)
estimated_time_to_complete_in_minutesintegerThe estimated time to complete the activity. This is the duration in minutes.
expires_atstring (date-time)The time by which the activity must be completed to receive a reward.
instructions_urlstringThe URL resource that provides guidance on activity requirements and completion. (pattern: <code>[\S\s]*</code>)
rewardobjectA reward granted upon activity completion.
started_atstring (date-time)The timestamp when the activity started. This field appears only for activities in the IN_PROGRESS or COMPLETED states.
statusstringThe current activity status. (NOT_STARTED, IN_PROGRESS, COMPLETED, EXPIRING)
title_stringA short activity title. (pattern: <code>[\S\s]*</code>)

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
get_account_activityselectregionReturns a specific activity record that is available to the customer.
list_account_activitiesselectregionReturns a list of activities that are available. This operation supports pagination and filtering by status.

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
regionstringAWS region (default: us-east-1)

SELECT examples

Returns a specific activity record that is available to the customer.

SELECT
activity_id,
completed_at,
description,
estimated_time_to_complete_in_minutes,
expires_at,
instructions_url,
reward,
started_at,
status,
title_
FROM aws.freetier.account_activities
WHERE region = '{{ region }}' -- required
;