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 real-time and historical metrics, including:

Metric	Description
CPU usage (%)	Current and historical CPU utilization
Memory usage (GB)	RAM consumption of your deployment
Storage (GB)	Compressed data size stored
Egress Traffic (GB)	Data transferred out from EMQX Tables
WCU (Write Capacity Unit)	One WCU can handle one standard insert request (up to 1 KB in size) per second. This metric helps evaluate ingestion performance.
RCU (Read Capacity Unit)	Measures read throughput. Like WCU, it reflects operational performance

You can view data over various time ranges: 1 Hour, 1 Day, 3 Days, 7 Days, 1 Month, and 3 Months.

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.