Connecting to a GeminiDB Influx Instance on the DAS Console

Prerequisites

A GeminiDB Influx instance has been created and is running properly.

Precautions

• SELECT query commands are supported.
• INSERT commands for writing data are supported.
• Commands for database operations (including creating, deleting, and displaying databases) are supported.
• Commands for user operations (including creating, deleting, displaying, and authorizing users, and changing user passwords) are supported.
• Commands of retention policies (including creating, deleting, displaying, and modifying retention policies) are supported.
• CONTINUOUS QUERY commands (including CREATE CONTINUOUS QUERY, DROP CONTINUOUS QUERY, and SHOW CONTINUOUS QUERY) are supported.

Procedure

1. Log in to the GeminiDB console.
2. In the service list, choose Databases > GeminiDB Influx API.
3. In the instance list, locate a target instance and click Log In in the Operation column.
   Figure 1 Connecting to a GeminiDB Influx Instance
   

   Alternatively, click the instance name to go to the Basic Information page. Click Log In in the upper right corner of the page.

   Figure 2 Connecting to a GeminiDB Influx Instance
   

4. Enter the password for logging in to the instance.

   You need to enter the password only when you log in to a GeminiDB Influx instance first time or after you set the password.

   Figure 3 Logging in to the GeminiDB Influx instance
   

5. Manage relevant databases.
   Figure 4 Instance homepage
   
   • Save commands to executed commands.

     This function is enabled by default to save the recently executed commands for your later query.

     Then you can click the Executed Commands tab on the lower page to view historical commands.

     

     Commands with passwords are not displayed on the Executed Commands tab page.

     Figure 5 Executed commands
     

     If this function is disabled, the commands executed subsequently are not displayed any longer. You can click next to Save Executed SQL Statements in the upper right corner to disable this function.

   • Execute a command.

     You can enter a command in the command window and click Execute or F8.

     Figure 6 Execute a command.
     

     After a command is executed, you can view the execution result on the Results page.

   • Save a command.

     You can save a command to all instances or the current instance. Then you can view details in My Commands.

     

     Commands with passwords cannot be saved to My Commands.

     Figure 7 Save a command.
     
   • View my commands.

     Common commands are displayed the My Commands page.

     You can set a filter to narrow the scope of commands. If you select All, all commands saved in the current account are displayed.

     Figure 8 Filtering commands
     

     Alternatively, you can enter a command title or statement in the search box to search for the corresponding command.

     Figure 9 Searching for a command
     

     On the My Commands page, you can also create, edit, and delete a command or copy it to the Execute window.

     Figure 10 Managing a command
     
   • Clear commands.

     You can also press F10 to clear the command in the execution window.