Cloudsviewer
  • Home
  • Google Cloud
  • AWS Amazon
  • Azure
No Result
View All Result
  • Home
  • Google Cloud
  • AWS Amazon
  • Azure
No Result
View All Result
cloudsviewer.com
No Result
View All Result
Home AWS Amazon

Introducing Amazon Redshift Query Editor V2, a Free Web-based Query Authoring Tool for Data Analysts

October 9, 2021
New – Fully Serverless Batch Computing with AWS Batch Support for AWS Fargate
Share on FacebookShare on Twitter


With regards to manipulating and analyzing relational information, Structured Question Language (SQL) has been a world customary since 1986, a few years earlier than I used to be born. And but, it typically takes hours to get entry to a brand new database or information warehouse, configure credentials or single sign-on, obtain and set up a number of desktop libraries or drivers, and get acquainted with the brand new schema—all this earlier than you even run a question. To not point out the problem of sharing queries, outcomes, and analyses securely between members of the identical workforce or throughout groups.

At the moment, I’m glad to announce the overall availability of Amazon Redshift Question Editor V2, a web-based device that you should utilize to discover, analyze, and share information utilizing SQL. It means that you can discover, analyze, share, and collaborate on information saved on Amazon Redshift. It helps information warehouses on Amazon Redshift and information lakes by way of Amazon Redshift Spectrum.

Amazon Redshift Question Editor V2 offers a free serverless internet interface that reduces the operational prices of managing question instruments and infrastructure. As a result of it’s a managed SQL editor in your browser and it’s built-in together with your single sign-on supplier, the Question Editor V2 reduces the variety of steps to the primary question so that you achieve insights quicker. You additionally get in-place visible evaluation of question outcomes (no information obtain required), multi functional place. As an extra workforce productiveness enhance, it improves collaboration with saved queries and the power to share outcomes and analyses between customers.

From a safety standpoint, analysts can entry Question Editor V2 with out requiring any admin privileges on the Amazon Redshift cluster, utilizing an IAM position for READ, WRITE, or ADMIN entry. Take a look at the documentation for extra particulars.

Connection Setup for Amazon Redshift Question Editor V2
First, you’ll have to configure the connection to your Amazon Redshift cluster.

After you could have configured the connection, you’ll be able to reuse it for future classes. And, after all, you’ll be able to edit or delete a connection at any time.

Merely click on on a cluster to attach with Question Editor V2.

Amazon Redshift Question Editor V2 in Motion
The online interface means that you can browse schemas, tables, views, capabilities, and saved procedures. You may also preview a desk’s columns with one click on and create or delete schemas, tables, or capabilities.

The interface is intuitive for newcomers and professional customers alike. You possibly can resize panels, create tabs, and configure your editor preferences.

Operating or explaining a question is sort of simple: You merely write (or paste) the question and select Run. You possibly can visualize and work together with the end result set within the backside pane. For instance, you may need to change the row ordering or seek for a selected phrase. Though Amazon Redshift Question Editor V2 is a browser-based device, the information motion between your browser and the Amazon Redshift cluster is optimized, so your browser doesn’t have to obtain any uncooked information. Quite a lot of the filtering and reordering occurs straight within the browser, with none wait time.

To export a end result set as a JSON or CSV file in your native machine, merely right-click it.

To this point so good! Operating queries is the minimal you’d count on from a Question Editor. Let’s take a look at a few of the extra attention-grabbing options.

Crew Collaboration with Amazon Redshift Question Editor V2
Amazon Redshift Question Editor V2 means that you can handle the permissions of your workforce members based mostly on their IAM roles, so as to simply share queries and cluster entry in a safe method.

For instance, you should utilize IAM managed insurance policies reminiscent of AmazonRedshiftQueryEditorV2FullAccess, AmazonRedshiftQueryEditorV2ReadSharing, or AmazonRedshiftQueryEditorV2ReadWriteSharing. Additionally, don’t overlook to incorporate the redshift:GetClusterCredentials permission.

After you’ve arrange the IAM roles in your workforce, select Save to save lots of a question.

The Untitled tab will present the question title. To any extent further, you edit this saved question to make updates after which select Save once more.

Particular person customers with WRITE entry can run, edit, and delete shared queries, whereas customers with READ entry can solely run shared queries.

For those who work on a number of tasks and collaborate with many various groups, it could be tough to recollect question names and even discover them in a protracted record. In Amazon Redshift Question Editor V2, saved and shared queries can be found from the left navigation in Queries. You possibly can maintain your queries organized into folders. Even nested folders are supported.

Final however not least, every saved question is versioned and the model historical past is all the time obtainable. That’s fairly helpful when you should restore an older model.

Plot Your Queries with Amazon Redshift Question Editor V2
Sharing queries with teammates is nice, however wouldn’t it even higher when you might visualize a end result set, export it as PNG or JPEG, and save the chart for later? Amazon Redshift Question Editor V2 means that you can carry out in-place visualizations of your outcomes. Whenever you’re proud of the feel and appear of your chart, it can save you it for later and manage all of your saved charts into folders. This lets you merely select a saved chart, rerun the corresponding question, and export the brand new picture. No have to configure the plot from scratch or keep in mind the configuration of lots of of charts and queries throughout totally different tasks.

Obtainable At the moment
Amazon Redshift Question Editor V2 is on the market right this moment in all business AWS Areas, besides AP-Northeast-Three areas. It requires no license and it’s free, apart from the associated fee in your Amazon Redshift cluster.

You possibly can work together with the service utilizing the Amazon Redshift console. It doesn’t require any driver or software program in your native machine.

For extra info, see the Amazon Redshift Question Editor V2 technical documentation or check out this video:

We stay up for your suggestions.

— Alex





Source link

Guest

Guest

Next Post
Five Behaviors for Digital Diffusion in EMEA

Using the Cloud Spanner Emulator in CI/CD pipelines

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Recommended.

Google Cloud Apigee’s 2020 API Management Innovations

Google Cloud Apigee’s 2020 API Management Innovations

January 10, 2021
Advancing Azure Virtual Machine availability transparency | Azure Blog and Updates

Microsoft named a Leader in The Forrester Wave™: Streaming Analytics, Q2 2021 | Azure Blog and Updates

August 24, 2021

Trending.

How to Accelerate Performance and Availability of Multi-region Applications with Amazon S3 Multi-Region Access Points

How to Accelerate Performance and Availability of Multi-region Applications with Amazon S3 Multi-Region Access Points

September 21, 2021
New for App Runner – VPC Support

New for App Runner – VPC Support

February 9, 2022
New – Additional Checksum Algorithms for Amazon S3

New – Additional Checksum Algorithms for Amazon S3

February 27, 2022
A cloud services cheat sheet for AWS, Azure and Google Cloud

A cloud services cheat sheet for AWS, Azure and Google Cloud

October 10, 2020
New – Sustainability Pillar for AWS Well-Architected Framework

New – Sustainability Pillar for AWS Well-Architected Framework

December 7, 2021
  • Advertise
  • Privacy & Policy

© 2022 Cloudsviewer - Cloud computing news. Quick and easy.

No Result
View All Result
  • Home

© 2022 Cloudsviewer - Cloud computing news. Quick and easy.