Getting Started with Dremio Sonar
This guide will help you get started with Dremio Sonar by helping you to do the following:
Adding a Sonar Project
To start running queries with Sonar, you must first configure your AWS account with Dremio Cloud and create a Sonar project. A project isolates compute, data, and other resources needed by a team for data analysis. An organization may contain multiple projects, and a project must be linked to a single cloud account.
Before you begin, review the Prerequisites for Configuring Cloud Resources.
To create a project, click Add Sonar Project on the Sonar card on the Dremio homepage. In the Add Sonar Project dialog:
On the Create project page, for Project Name, enter a name to identify this project. This name can be changed after project creation.
For AWS Region, select the region in which Dremio will create and manage engines used to execute queries. For a list of supported regions, reference Supported Regions.
For AWS Tags, add the AWS tags to identify the compute resources created for this project.
The CloudFormation template is the recommended method to configure cloud resources. For a breakdown of the resources that will be created and the permissions that will be granted, see the annotated CloudFormation template.
If you would like to create the cloud resources and Sonar project manually, click the link at the bottom of the Add Sonar Project dialog and see Configuring Your Cloud Resources Manually.
- Click Next and follow the steps in the next section to configure cloud resources.
Configuring Cloud Resources
On the Configure resources page, click Launch CloudFormation Template, which will navigate you to the AWS Console for next steps.
On the Create stack page in the AWS Console, for Stack name, enter a name to identify the stack. This name must be unique to your account and cannot include underscores.
For VPC, select a VPC in which the compute resources (EC2 instances) will be created.
For Subnets, select the subnets within the VPC. You can select multiple subnets across different availability zones.
(Optional) For Project Store, a unique name has been generated for the S3 bucket that will be created to store metadata. You can specify a different name here but it must be a unique name across AWS.
(Optional) For Encryption Type, SSE-S3 is selected by default to encrypt the project store S3 bucket. You can select SSE-KMS (AWS Managed Key) or SSE-KMS (Customer Managed Key) if additional encryption is required.
(Optional) If you select SSE-KMS (Customer Managed Key), specify the KMS Key ARN.
Select the checkbox to confirm your acknowledgement that AWS CloudFormation might create IAM resources.
Click Create stack.
Stack creation can take up to four minutes. When stack creation is complete, the required cloud resources have been configured successfully.
You can now return to the Dremio Console to run your first query!
Running Your First Query
When the setup for your first project is complete, you will be automatically navigated to the SQL Runner with a prepopulated query.
All you have to do is to click Run. The results appear under the editor within seconds.
And that’s it! You’ve run your first query on Dremio Cloud by using the Sonar query engine.