Configuring the components - Cloud - 8.0

Couchbase
Version
Cloud
8.0
Language
English
Product
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Data Governance > Third-party systems > NoSQL components > Couchbase components
Data Quality and Preparation > Third-party systems > NoSQL components > Couchbase components
Design and Development > Third-party systems > NoSQL components > Couchbase components
Last publication date
2024-03-28

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.