Manage EMQX Tables Deployments

This guide covers how to manage your EMQX Tables deployments in the EMQX Console, including:

• User Management
• Network Management
• Ports Management
• Importing data
• Monitoring resource usage
• Deployment Settings

Prerequisite

You must have an active EMQX Tables deployment created in your project. See Create an EMQX Tables Deployment for setup instructions.

User Management

EMQX Tables deployments support custom users and permission configuration. You can create, edit, and delete users from the User Management page, assign privileges such as SqlSelect and SqlInsert, and configure database-level or table-pattern-level access control.

For details, see User Management.

Network Management

For current EMQX Tables deployments, the Network Management page provides VPC Peering Connection settings. Use VPC peering when you want your VPC to access EMQX Tables through an internal network.

For setup steps, see AWS VPC Peering Connection or VPC Network Peering Connection with GCP, depending on the cloud provider of your deployment.

To configure VPC peering:

1. Click Network Management from the left menu in your EMQX Tables deployment.
2. Click + VPC Peering Connection.
3. Follow the instructions on the page to create and verify the VPC peering connection.

Ports Management

For Starter deployments, EMQX Tables provides the Ports Management dialog on the deployment overview page. You can use it to view the status of access ports and disable ports that are not required by your applications.

For details, see Ports Management.

For Pro deployments, use the ports shown in Connection Info.

Import Data

Use the Import Data page to write time-series data into EMQX Tables with InfluxDB Line Protocol. Select the target Database Name, choose the timestamp Precision, enter Line Protocol data in the editor, and click Write.

You can also upload .txt or .lp files from the editor. Make sure the measurement name, tags, fields, and timestamp precision match the data model you want to create or update.

Monitor Resource Usage

To monitor the resource usage and performance of your EMQX Tables deployment:

1. Enter your EMQX Tables deployment from the Console Overview page, or from your project page.
2. In the left menu of the EMQX Tables deployment, click Monitor.

The Monitor page displays metric charts for the selected time range. The available charts depend on the deployment and selected time range.

Metric	Description
CPU (%)	CPU utilization of the deployment.
Memory (GB)	Memory used by the deployment.
Storage (GB)	Compressed data stored in the deployment.
Egress Traffic (KB)	Data transferred out from EMQX Tables. This chart is not displayed for the 1 Hour range. Select 1 Day or a longer range to view it.
WCU (Write Capacity Unit)	Write throughput. For data sizes up to 1 KB, one WCU represents the capacity to complete one standard insert request per second. This chart is displayed only when supported by the deployment.
RCU (Read Capacity Unit)	Memory consumed by query requests. For a query that loads up to 1 MB of data into memory, one RCU represents the capacity to complete one standard query request per second. This chart is displayed only when supported by the deployment.

You can select 1 Hour, 1 Day, 3 Days, 7 Days, 1 Month, or 3 Months. When you select another time range or refresh the metrics, the Console reloads the data and updates the chart list. Existing charts remain visible while the data is loading.

If a metric is unavailable for the deployment or selected time range, its chart is not displayed. If no valid metric data is available, the page displays an empty state.

Deployment Settings

Use Deployment Settings to view deployment-level settings and delete the deployment.

Delete a Deployment

To remove an EMQX Tables deployment:

1. Go to Deployment Settings in the left menu.
2. Click Delete Deployment.
3. Confirm the operation in the prompt.

Warning

Deletion is permanent. All data and credentials will be lost.