Connecting External Tools to the SaaS Cloud Data Warehouse MaxCompute Actual Combat-Database Management Tools

Introduction to will mainly share some connection demonstrations of MaxCompute query acceleration functions, database management tools DBeaver, DataGrip, and SQL Workbench/J.

Author Mu Yi Alibaba Cloud Intelligent Product Manager

For the live video, please click Live watch.

This sharing will explain from four aspects.

01 Last section review

02 Overview of database management tools

03 Practical demonstration

04 Query acceleration

1. Review of the previous section

In the first lecture, we mainly talked about the MaxCompute , focusing on commercial BI tools, including Tableau, FineReport, FineBI, Quick BI, Yonghong Desktop BI tools, connection principles and practical demonstrations. This article focuses on database management tools, mainly DataGrip, DBeaver, SQL Workbench/J in the development management part.

.jpg")

2. Overview of database management tools

Database management tools, namely database graphical tools, are one of the necessary tools for database personnel. MaxCompute supports connections with DBeaver, DataGrip and SQL Workbench/J through JDBC drivers, and can visualize and quickly list databases, lists, and view Table structure, query table data, create table, write table, create view, query view and other related operations.

Connection method

JDBC

JDBC (Java DataBase Connectivity) is a Java API used to execute SQL statements, which can provide unified access to a variety of relational databases. It consists of a set of classes and interfaces written in Java language. Simply put, it is to use the Java language to send SQL statements to the database to manipulate the database.

MaxCompute JDBC driver

The MaxCompute JDBC driver is a JDBC interface provided by MaxCompute that can access MaxCompute. You can execute distributed computing queries of massive data based on MaxCompute through the standard JDBC interface. The MaxCompute JDBC driver can also be used to connect to MaxCompute and tools that support JDBC.

MaxCompute related basic parameter information

•URL：jdbc:odps:<MaxCompute\_endpoint\>?project=<MaxCompute\_project\_name\>

• : Required. The Endpoint of the region to which the MaxCompute project belongs.
• : Required. The name of the target MaxCompute project to be connected. Here is the name of the MaxCompute project, not the name of the workspace.

•User: AccessKey ID with permission to access the specified project.

•Password: AccessKey Secret corresponding to the AccessKey ID.

Three, practical display

DBeaver Practical Show

Please click video view the actual operation part

Other practical documents

DataGrip connects to MaxCompute

SQL Workbench/J to connect to MaxCompute

Fourth, query acceleration

MaxCompute query acceleration query job with high real-time requirements, the full link speeds up the execution of MaxCompute queries

• uses MaxComputeSQL syntax and engine , optimized for near real-time scenarios

• The system automatically selects for query optimization, and supports the user to choose the execution mode of delay priority or throughput priority

• Use different resource scheduling strategies for near real-time scenarios: latencybased

• Conduct scenario for low-latency requirements full link optimization : independent execution resource pool ; multi-level data and Meta Caching ; interactive protocol optimization

QuickBI query acceleration

Other tool query acceleration-&interactiveMode=true

• interactiveMode : Optional. Query the acceleration function switch. If you need to enable query acceleration, add &interactiveMode=true configuration after the URL. For more information about query acceleration, please refer to Query Acceleration .

Whether to start the query acceleration function, query speed comparison

Use Davinci test comparison

query volume data	not use the query acceleration	using query acceleration
1W	10s	3S
5W	12S	7S

#### Contrast practical video Please click video view the actual operation part > Copyright Notice: content of this article is contributed spontaneously by Alibaba Cloud real-name registered users, and the copyright belongs to the original author. The Alibaba Cloud Developer Community does not own its copyright and does not assume corresponding legal responsibilities. For specific rules, please refer to the "Alibaba Cloud Developer Community User Service Agreement" and the "Alibaba Cloud Developer Community Intellectual Property Protection Guidelines". If you find suspected plagiarism in this community, fill in the infringement complaint form to report it. Once verified, the community will immediately delete the suspected infringing content.