How can I view the contents of a table in Couchbase?

2 years ago
William Carter
1 minute

Couchbase is a distributed NoSQL database that stores data in the form of documents. To view table contents, you can execute queries using Couchbase’s query language N1QL (Non-first Normal Form Query Language).

Here are the steps to view the contents of a table using N1QL query statement:

  1. Open the Couchbase Web Console, log in, and select the bucket you want to query.
  2. Retrieve all data from the bucket named `bucket_name`.
  3. name of the bucket
  4. Click the run button or press the Enter key on the keyboard to execute the query.
  5. The search results will be displayed in the console’s results panel, shown in JSON format. You can view the content of each document.

Before using N1QL queries, make sure to properly create indexes to improve query performance. Without indexes, you may not see any results or experience very slow query execution. Indexes can be created in the indexes panel of the Couchbase Web console.

bannerAds