# tBigtableInput

Extracts data from Google Bigtable and sends the data to the component that follows.

## tBigtableInput Standard properties

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

The Standard tBigtableInput component belongs to the Cloud family.

The component in this framework is available in all Talend products.

## Basic settings

| Properties | Description |
| --- | --- |
| Property Type | Select the way the connection details<br>will be set.<br><br><ul> <li> <p> <span>Built-In</span>: The connection details will be set                          locally for this component. You need to specify the values for all                          related connection properties manually.</p> </li> <li> <p> <span>Repository</span>: The connection details stored                              centrally in <span><span>Repository</span><abbr> &gt; </abbr><span>Metadata</span></span> will be reused by this component.</p> <p>You need to click                              the <span>[...]</span> button next to it and in the pop-up                              <span>Repository Content</span> dialog box, select the                              connection details to be reused, and all related connection                              properties will be automatically filled in.</p> </li> </ul><br><br>This option is not available when you select the Use an existing<br>connection option and select a component from the<br>Component List dropdown list. |
| Use an existing<br>connection | Select this check box and in the Component<br>List drop-down list, select the desired connection component to<br>reuse the connection details you already defined. |
| Project name | Enter the unique identifier of your Google Cloud Platform<br>project. This information is available on the Dashboard page of your<br>Google Cloud console. |
| Instance ID | Enter the permanent identifier of the Bigtable instance. |
| Authentication method | Select the mode to be used to authenticate to your project.<br><br><ul> <li> <span>Service account key</span>: authenticate using a Google                        account that is associated with your Google Cloud Platform project. When                        selecting this mode, the parameter to be defined is <span>Google                           credentials</span>.</li> <li> <span>Application Default Credentials</span>: authenticate using                        the Application Default Credentials. When selecting this mode, no additional                        parameters need to be defined as credentials are automatically found based                        on the application environment.</li> </ul><br><br>To know more about the Google Cloud authentication process, read [the Google Cloud documentation](https://cloud.google.com/docs/authentication/). |
| Google credentials | Paste the content of the JSON file that contains your service account key.<br><br>This property is only available when you authenticate using Service<br>account key. |
| Table name | Enter the name of the Bigtable table. |
| Schema | A schema is a row description. It defines the number of fields<br>(columns) to be processed and passed on to the next component. When you create a Spark<br>Job, avoid the reserved word line when naming the<br>fields.<br><br><ul> <li> <p> <span>Built-In</span>: You create and store the schema locally for this component                only.</p> </li> <li> <p> <span>Repository</span>: You have already created the schema and stored it in the                Repository. You can reuse it in various projects and Job designs.</p> </li> </ul> |
| Edit schema | Click Edit schema to make changes to<br>the schema. If you make changes, the schema automatically becomes built-in. |
| Guess schema | Click Guess schema to retrieve the schema from<br>the table. |
| Filter type | Select a filter to limit the results from the drop-down list:<br><br><ul> <li> <span>Row key</span>: display rows that contain a specific value                        in their row key that you specify in the <span>Row key                           value</span> parameter.</li> <li> <span>Range</span>: display rows from one or several ranges that                        you specify in the <span>Ranges</span> table.</li> <li> <span>Prefix</span>: displays rows that contain a specific prefix                        value that you specify in the <span>Starts with</span>                        parameter.</li> </ul><br><br>If you do not want to apply a filter, you can leave the drop-down list as<br>is with the None value. |
| Cells per column | Enter a number of cells per column. |

## Advanced settings

| Properties | Description |
| --- | --- |
| tStatCatcher Statistics | Select this check box to gather the Job processing metadata<br>at the Job level as well as at each component level. |

## Global Variables

| Variables | Description |
| --- | --- |
| ERROR\_MESSAGE | The error message generated by the component when an error<br>occurs. This is an After variable and it returns a string. |
| NB\_LINE | The number of rows processed. This is an After variable and<br>it returns an integer. |

## Usage

| Usage guidance | Description |
| --- | --- |
| **Usage rule** | As a start component, tBigtableInput allows you to retrieve data from Google<br>Bigtable and transfers them to the following component. |