Creating a View for Partitioned Data

Create a view that uses one or more partition keys to limit the data that can be queried or visualized by users.

If you have created an object group that uses partition keys, you can create views that reference those partition keys as ways to limit the data that can be shown in visualizations and analytics.

To create a view with partition keys:

  1. Follow the standard instructions to create a view. Go to Refinery and then click Create View.
  2. Select the object group in the left frame, then click Next.
  1. In the Schema Transformation window, scroll to the cs_partition_key_0 field and click the filter icon on the right.
  1. The Configure Filter window opens. You can specify a partition key by using one of two methods:
  • You can type a partition value defined in the object group into the Insert Filter field and click Create.
  • You can select Enable treat field as partition key and the system displays a list of the available partition keys. (The field name changes to Disable treat field*.) Select the partition that you want to use for the view, and then click Create** to save the setting.

NOTE: You can repeat tis step to select additional partition keys for a view if desired.

  1. The Schema Transformation window updates to show the selected partition key value(s) for the ca_partition_key_0 field, as in the following example:
  1. Click the gear icon to the right of the cs_partition_key_0 field to display the Schema Transformation window.
  1. In the Select Transform field, click the Materialize with Regex value to display a list of options, and select Treated as Partition Key.

The window updates to show the following information. Make sure that the cs_partition_key_0 field number matches the Key Part value (both are usually 0).

  1. Click Save Transform in the top right to save and close the window.
  2. Click Next in the Schema Transformation window and complete the view creation using the standard steps.

Users who have access to the view see only the indexed data related to the partition key(s) that you specified. A sample Kibana Discover window for a view that shows the ap-northeast-1 partition data follows:

Did this page help you?