Hello, community friends, long time no see! CloudQuery V1.4.0 is finally available after more than a month of work.

New features in V1.4.0 include the scheduling center module, Database Tools Service (DTS) data export, visual query builder, and Hive data source.

Normally, version updates start with new features. Today we come to something different, first talk about the front end students proud query Tab page interaction optimization ~

Query Tab optimization

1. When opening the library table query, the Tab Tab will display the connection icon and the current library name, and you will know which workspace you want to use by looking at the Tab

2. The Tab page moves with the database. The Tab content is changed synchronously when the database is cut

2. Add Hive data sources

1. Connect to Hive data source version 2.3.3

2. Hive database menu functions: ① Supports database elements: table and view ② Supports Hive right-click menu, including opening tables, viewing table structures, deleting tables, adding tables, truncating tables, designing tables, and renaming tables

3. Include permission control and audit analysis for Hive data sources

3. Added the “Scheduling Center” module

In V1.4 planning, we introduced the concept of Database Tools Service (DTS) and added the scheduling center module. V1.4.0 supports MySQL mysqlDump and Oracle EXP data export tools.

1. Dump database object support range: ① MySQL database dump, same database dump

② Oracle database DMP export, same database/different database DMP export

2. Customize export parameters

3. Task list Displays the running status and time consumption of tasks

4. Terminates running tasks

5. You can view real-time logs in task details and download the exported logs

6. In MySQL/Oracle connection management, configure the DTS tool permission for the connection

Visual query builder

1. Create table query by drag and drop, one drag, one select, quickly generate query statement 2. Supports SELECT, FROM, WHERE, GROUP BY, HAVING, and ORDER BY. Live SQL preview, add charts, edit table models, statement changes 4. Support aggregation functions and other details 5. Generate a good statement to fill in the editor, you can further edit 6. Currently, only Oracle is supported

Five, installation mode adjustment

Online: You only need to download a script and run the online installation. 2. Offline: The offline download is migrated to the Cloud storage system to speed up the download

Fix and optimize

Fixed:

  • Fixed an issue where result set columns with English periods could not be displayed
  • Fixed a magic issue where the actual number of exported rows becomes 1.5 times when the number of exported rows in a result set exceeds 50,000
  • Fixed bug Mc-117517 – Execute button flashes without follow-up or prompt when executing long statements
  • Fixed failure to export more than 65535 audit records
  • Fixed an issue in the organizational structure where departments could not create groups with the same name
  • Fixed an issue where PostgreSQL could not add tables
  • Fixed a variety of data source design table function anomalies
  • Fixed an issue where the result set failed to render twice

Optimization:

  • New interaction: SDT double-click the database hierarchy and create a new query. Now, the query window TAB name reflects the connection type and the library currently in use
  • Double-click to open the table, and all data sources increase the limit of 1000 rows
  • An established database connection is now automatically disconnected when the user exits
  • The file name of the download center list must be the same as that of the download center list
  • Provide a clear and understandable reason for the export failure
  • Error messages related to password change are more friendly
  • The organization can now change the group name
  • Adjusted the visual scale of the page and fixed some style bugs
  • Optimized log output to no longer produce server log files measured in G
  • Other page styles and interaction optimizations

Special thanks to

Thanks @rafeng and @Dreambeer for your feedback! CloudQuery is still growing, and we value every user’s experience. We encourage you to contribute your questions and suggestions to help build CloudQuery!

Community public announcement

We encourage students who have tried the new version to fill out the experience report on the official website. CloudQuery will adjust the iteration plan based on your suggestions. If you dare to write, we dare to do!

New version experience Report Address:Cloudquery. Club/questionnai…

And that’s all for this update.

At the end

CloudQuery download update address: CloudQuery. Club /download

CloudQuery online trial: cloudQuery.club /

In addition, we will20:00 on July 6Live on Motianren. We will share our vision for a new generation of database management platforms and detail the new CloudQuery V1.4 features.Participants will also have a chance to get CloudQuery gifts and red envelopes!Welcome to watch ~