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.
-
Sign into the Cloud console.
-
Select the cluster where the IMap data has been written.
-
In the left navigation, select SQL to open the SQL browser.
-
In the Data Explorer, click Connector Wizard and select the Hazelcast Map connector.
-
In Choose Resources, select the IMap that you want to query.
-
Click Generate Mapping Command to generate the SQL required to create the new mapping. You’re ready to start querying your data.
