After creating the table, you can query it using either of the following two methods:
Method 1: Create a New Query on Redshift or Snowflake (Recommended)
Method 2: Trigger as Linked Dataset (Knowi Elastic Store)
Note: From here on, it is assumed that your original datasource is Knowi Elastic Store, on which you have enabled the Custom Store with Amazon Redshift as your Destination Datasource.
It is recommended to use Method 1 because your Query will execute directly on Redshift or Snowflake, and if you have defined any filters in this Query, then they will be applied on Redshift or Snowflake, and the results will populate accordingly. In contrast, in the second method, all the data is loaded first, and then the filtering is done on memory in the server, which might consume a lot of time.
Create a New Query on Redshift or Snowflake (Recommended)
This is the recommended method by which you create the new Query on top of the destination Datasource i.e., Amazon Redshift or Snowflake, and select the table (created while configuring the Custom Store in the original Datasource) from the dropdown list.
You can click on Preview and analyze the results of your Query in the table.
Trigger as Linked Dataset (Knowi Elastic Store)
Alternatively, you can add the linked dataset to the original Datasource (i.e. Knowi Elastic Store) to Query the table.
You can click on Preview and analyze the results of your Query in the table.