Configuring the components - 7.3

Couchbase

author
Talend Documentation Team
EnrichVersion
Cloud
7.3
EnrichProdName
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Open Studio for Big Data
Talend Real-Time Big Data Platform
task
Data Governance > Third-party systems > Database components > Couchbase components
Data Quality and Preparation > Third-party systems > Database components > Couchbase components
Design and Development > Third-party systems > Database components > Couchbase components
EnrichPlatform
Talend Studio

Procedure

  1. Double-click tCouchbaseConnection to open its Basic settings view.
  2. Click the Edit schema button to open the schema editor. Define the following columns:
    • callsign of type String
    • country of type String
    • iata of type String
    • icao of type String
    • id of type Integer
    • name of type String
    • type of type String

    Make sure the column names are propagated to the Db column.

  3. Click OK to save the schema.
  4. In the Bucket field, enter the name of the bucket to query: travel-sample.
  5. Select the Use N1QL query check box to define a complex query.
  6. In the Query field, enter the following query: SELECT callsign, country, iata, icao, id, name, type FROM `travel-sample` WHERE country = "United States" and type = "airline" LIMIT 5;
  7. Double-click tLogRow to open its Basic settings view.
  8. Next to Edit schema, click Sync columns.
  9. In the Mode section, select Table (print values in cells of a table) to make the results easier to read in the console.