tGoogleAddressRow Standard properties

Google address standardization

author
Talend Documentation Team
EnrichVersion
6.5
EnrichProdName
Talend Data Management Platform
Talend MDM Platform
Talend Data Fabric
Talend Real-Time Big Data Platform
Talend Big Data Platform
Talend Data Services Platform
task
Data Governance > Third-party systems > Data Quality components > Standardization components > Address standardization components > Google address standardization components
Data Quality and Preparation > Third-party systems > Data Quality components > Standardization components > Address standardization components > Google address standardization components
Design and Development > Third-party systems > Data Quality components > Standardization components > Address standardization components > Google address standardization components
EnrichPlatform
Talend Studio

These properties are used to configure tGoogleAddressRow running in the Standard Job framework.

The Standard tGoogleAddressRow component belongs to the Data Quality family.

This component is available in the Palette of the Studio only if you have subscribed to one of the Talend Platform products.

Basic settings

Pause(in 1/10 seconds)

Time break between http requests for geographic information record. By default, the value for this field is 1.

Schema and Edit Schema

A schema is a row description, it defines the number of fields to be processed and passed on to the next component. The schema is either Built-in or stored remotely in the Repository.

 Address column

From this list, select a parameter to be used in sending request to Google Places API. Parameters in this list are predefined in the schema of input data.

API key

Enter your API key in this field.

For more information about how to get an API key, see https://developers.google.com/places/web-service/get-api-key.

Note:

Jobs migrated from releases older than 5.6 will need a key to run. Generate a key and set it in tGoogleAddressRow basic settings before running the Job.

The component currently works with the Google Places API and not the Google Geocoding API as it was the case in releases older than 5.6. As a result, when you run the migrated Jobs in the current studio, you will have geographic information different from what you had in older studios. For example, the Location_type column outputs ROOFTOP in older releases, while it outputs street_address now. You can find the list of location types at Place Types.

Die on error

This check box is selected by default.

Clear the check box to skip any rows on error and complete the process for error-free rows. When errors are skipped, you can collect the rows on error using a Row > Reject link.

Advanced settings

tStatCatcher Statistics

Select this check box to collect log data at the component level.

Global Variables

Global Variables

ERROR_MESSAGE: the error message generated by the component when an error occurs. This is an After variable and it returns a string. This variable functions only if the Die on error check box is cleared, if the component has this check box.

A Flow variable functions during the execution of a component while an After variable functions after the execution of the component.

To fill up a field or expression with a variable, press Ctrl + Space to access the variable list and choose the variable to use from it.

For further information about variables, see Talend Studio User Guide.

Usage

Usage rule

This component is usually used as an intermediate component, and it requires an input component and an output component.