Skip to main content

address

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

Overview

Nameaddress
TypeResource
Idaws.snowball.address

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
address_idstringThe unique ID for an address. (pattern: <code>ADID[0-9a-f]{8}-[0-9a-f]{4}-[0-9a-f]{4}-[0-9a-f]{4}-[0-9a-f]{12}</code>)
citystringThe city in an address that a Snow device is to be delivered to. (pattern: <code>.*</code>)
companystringThe name of the company to receive a Snow device at an address. (pattern: <code>.*</code>)
countrystringThe country in an address that a Snow device is to be delivered to. (pattern: <code>.*</code>)
is_restrictedbooleanIf the address you are creating is a primary address, then set this option to true. This field is not supported in most regions.
landmarkstringThis field is no longer used and the value is ignored. (pattern: <code>.*</code>)
namestringThe name of a person to receive a Snow device at an address. (pattern: <code>.*</code>)
phone_numberstringThe phone number associated with an address that a Snow device is to be delivered to. (pattern: <code>.*</code>)
postal_codestringThe postal code in an address that a Snow device is to be delivered to. (pattern: <code>.*</code>)
prefecture_or_districtstringThis field is no longer used and the value is ignored. (pattern: <code>.*</code>)
state_or_provincestringThe state or province in an address that a Snow device is to be delivered to. (pattern: <code>.*</code>)
street_1stringThe first line in a street address that a Snow device is to be delivered to. (pattern: <code>.*</code>)
street_2stringThe second line in a street address that a Snow device is to be delivered to. (pattern: <code>.*</code>)
street_3stringThe third line in a street address that a Snow device is to be delivered to. (pattern: <code>.*</code>)
typestringDifferentiates between delivery address and pickup address in the customer account. Provided at job creation. (CUST_PICKUP, AWS_SHIP)

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
describe_addressselectregionTakes an AddressId and returns specific details about that address in the form of an Address object.
create_addressinsertregionCreates an address for a Snow device to be shipped to. In most regions, addresses are validated at the time of creation. The address you provide must be located within the serviceable area of your region. If the address is invalid or unsupported, then an exception is thrown. If providing an address as a JSON file through the cli-input-json option, include the full file path. For example, --cli-input-json file:​//create-address.json.

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

Takes an AddressId and returns specific details about that address in the form of an Address object.

SELECT
address_id,
city,
company,
country,
is_restricted,
landmark,
name,
phone_number,
postal_code,
prefecture_or_district,
state_or_province,
street_1,
street_2,
street_3,
type
FROM aws.snowball.address
WHERE region = '{{ region }}' -- required
;

INSERT examples

Creates an address for a Snow device to be shipped to. In most regions, addresses are validated at the time of creation. The address you provide must be located within the serviceable area of your region. If the address is invalid or unsupported, then an exception is thrown. If providing an address as a JSON file through the cli-input-json option, include the full file path. For example, --cli-input-json file://create-address.json.

INSERT INTO aws.snowball.address (
Address,
region
)
SELECT
'{{ Address }}',
'{{ region }}'
RETURNING
address_id
;