Creating Mappings to IMaps

To run a SQL query against data in an IMap on a Hazelcast Cloud cluster, you need to create a mapping. The easiest way to do this is to use the connector wizard.

Creating a New Mapping

You can only create a single mapping to any IMap. If a mapping for a specific IMap already appears in the Data Explorer of the SQL browser, you cannot create another mapping to it.

  1. Sign into the Cloud console.

  2. Select the cluster where the IMap data has been written.

  3. In the left navigation, select SQL to open the SQL browser.

  4. In the Data Explorer, click Connector Wizard and select the Hazelcast Map connector.

  5. In Choose Resources, select the IMap that you want to query.

  6. Click Generate Mapping Command to generate the SQL required to create the new mapping. You’re ready to start querying your data.