Integrated query editor
Amazon Aurora DSQL now provides an integrated query editor in the AWS Management Console. With this launch, customers can securely connect to their Aurora DSQL clusters and run SQL queries directly from the AWS Management Console, without installing or configuring external clients. This capability helps developers, analysts, and data engineers start querying within seconds of cluster creation, accelerating time-to-value and simplifying database interactions.
Let's see how it works. First of all, we navigate to the Query Editor on the Aurora DSQL service page, in the us-east-1 region, it's this link. Then you need to select the cluster you want to connect to and the database role to use: admin or custom role (which you need to select):
After having connected, we can look into the internals of our database cluster (cluster->postgres). In the public schema, we see both tables orders and order_items, and see their schema with columns, their types, primary keys, and indexes. In the sys schema we see system tables like iam_auth_member, iam_identity, job and others:
Now we can perform some SQL statements and see their results:
The integrated query editor doesn't have auto-completion and the feature set is very limited compared to DBeaver or pgAdmin, but if you would like to quickly execute the SQL statement, perform Explain Analyze and don't want to bother yourself with generating a short-lived authentication token each time, this is a good way to go:
We'll cover the Explain Analyze Verbose in more depth in our next article, where we explain how to understand DPUs.
For more information on the integrated query editor, please read the article Get started with the Aurora DSQL Query Editor.
Please also check out my website for more technical content and upcoming public speaking activities.
Top comments (0)