Address

Generates a random address-like string.

You can indicate which part of an address string that the column contains. For example, the column might contain only the street address or the city, or it might contain the full address.

Characteristics

Consistency	Yes, can be made self-consistent or consistent with another column.
Linking	Yes, can be linked.
Differential privacy	Yes, if consistency is not enabled.
Data-free	Yes, if consistency is not enabled.
Allowed for primary keys	No
Allowed for unique columns	No
Uses format-preserving encryption (FPE)	No
Privacy ranking	1 if not consistent 4 if consistent
Generator ID (for the API)	AddressGenerator

How to configure

To configure the generator:

1. From the Link To dropdown list, select the columns to link this column to. You can link columns that use the Address generator to mask one of the following address components:

   • City

   • City State

   • Country

   • Country Code

   • State

   • State Abbreviation

   • Zip Code

   • Latitude

   • Longitude

   Note that when linked to another address column, a country or country code is always the United States.

2. From the address component dropdown list, select the address component that this column contains. The available options are:

   • Building Number

   • Cardinal Direction (North, South, East, West)

   • City

   • City Prefix (Examples: North, South, East, West, Port, New)

   • City Suffix (Examples: land, ville, furt, town)

   • City with State (Example: Spokane, Washington)

   • City with State Abbr (Example: Houston, TX)

   • Country (Examples: Spain, Canada)

   • Country Code (Uses the 2-character country code. Examples: ES, CA)

   • County

   • Direction (Examples: North, Northeast, Southwest, East)

   • Full Address

   • Latitude (Examples: 33.51, 41.32)

   • Longitude (Examples: -84.05, -74.21)

   • Ordinal Direction (Examples: Northeast, Southwest)

   • Secondary Address (Examples: Apt 123, Suite 530)

   • State (Examples: Alabama, Wisconsin)

   • State Abbr (Examples: AL, WI)

   • Street Address (Example: 123 Main Street)

   • Street Name (Examples: Broad, Elm)

   • Street Suffix (Examples: Way, Hill, Drive)

   • US Address

   • US Address with Country

   • Zip Code (Example: 12345)

3. Toggle the Consistency setting to indicate whether to make the column consistent. By default, the consistency is disabled.

4. If consistency is enabled, then by default, the generator is self-consistent. To make the generator consistent with another column, from the Consistent to dropdown list, select the column. When the Address generator is consistent with itself, then the same value in the source database is always mapped to the same destination value. For example, for a column that contains a state name, Alabama is always mapped to Illinois. When the Address generator is consistent with another column, then the same value in the other column always results in the same destination value for the address column. For example, if the address column is consistent with a name column, then every instance of John Smith in the name column in the source database has the same address value in the destination database.

5. If Structural data encryption is enabled, then to use it for this column, toggle Use data encryption process to the on position.

Spark supported address parts

For the Address generator, Spark workspaces (Amazon EMR, Databricks, and self-managed Spark clusters) only support the following address parts:

• Building Number

• City

• Country

• Country Code

• Full Address

• Latitude

• Longitude

• State

• State Abbr

• Street Address

• Street Name

• Street Suffix

• US Address

• US Address with Country

• Zip Code