Inspecting Your Materialized View

Here you can see the definition of your Materialized View, data samples of your view and experience the API query via the Api Playground.

Schema

In the Schema tab you will see your materialized view's definition as you created it.

Data Sample

In the Data Sample tab you will see a small sample of the data available in you r materialized view.

If you would like a larger sample of the data you can click Download Sample which will download a CSV sample file of the last 10,000 rows in the last hour of your materialized view.

API Playground

In the API Playground tab you can get the endpoint information to query your materialized view. Additionally, you can execute queries directly from the UI to experience the API and test your data.

To run a query:

  1. In the request text-box edit the value in the get parameter named key. For example, if you would like to query for the row with the key abc you would change the text like so: https://indexer-us-east-1-prod.upsolver.com/query/?apitoken=YOUR_API_TOKEN&key=abc
  2. Click Send and you will see the result of the query in the Response text-box.
  3. If you don't have a particular key in mind you can click I'm Feeling Lucky and you will get a random row from your materialized view in the Response text-box.

For more advanced querying please see the Serving API documentation.

results matching ""

    No results matching ""