On this page

    Getting Started with Dremio Sonar

    To get started with Dremio Sonar, you will need to set up a project and configure cloud resources. After completing the setup for your first project, you can then start running queries. To learn more about projects, see Sonar Projects.


    Before you begin, review the Prerequisites for Configuring Cloud Resources.

    Creating Your First Project

    To create a project, click Add Sonar Project on the Sonar card on the Dremio homepage and complete the following sections in the Add Sonar Project dialog.

    Set Up a Project

    In the Set Up Project section, complete the following steps:

    1. For Project Name, enter a name to identify this project. This name can be changed after project creation.

    2. 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.

    3. (Optional) For AWS Tags, add the AWS tags to identify the compute resources created for this project.

    4. Click Next.

    Configure Resources

    In the Configure Resources section, complete the following steps:


    If you encounter an issue during the configuration, see Troubleshooting Cloud Resource Configuration.

    1. Click Launch CloudFormation Template, which will navigate you to the AWS Console for next steps.


    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.

    1. On the Quick 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.

    2. For VPC, select a VPC in which the compute resources (EC2 instances) will be created.

    3. For Subnets, select the subnets within the VPC. You can select multiple subnets across different availability zones.

    4. (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.

    5. (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.

    6. (Optional) If you select SSE-KMS (Customer Managed Key), specify the KMS Key ARN.

    7. Select I acknowledge that AWS CloudFormation might create IAM resources.

    8. 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 SQL editor within seconds.

    And that’s it! You’ve run your first query on Dremio Cloud by using the Sonar query engine.

    Wrap-up and Next Steps