Skip to main content

Creating Your First Project

This tutorial walks you through setting up your first Dremio Cloud project.

Prerequisites​

Before you begin, sign up for Dremio Cloud and verify that you meet the prerequisites. After you’ve signed up, you’ll be logged into your organization and navigated to your organization homepage.

This is a screenshot showing the organization homepage.

You can now get started with adding a Sonar project.

Add a Sonar Project​

note

This tutorial uses the CloudFormation template for connecting an AWS account, which is the recommended method for configuring project resources. For more information on the resources being created and the permissions granted to Dremio, see the annotated CloudFormation Template.

If you want to manually create cloud and project resources for AWS instead, see Configuring Your Cloud Resources Manually.

After addressing the prerequisites, follow these steps to create your first Sonar project:

  1. On your organization homepage, click Add Sonar Project on the Sonar card.

  2. In the Add Sonar Project dialog, for Project name, specify a name to identify your project. You can change the name of the project after creation.

  3. For Arctic catalog name, specify a name to identify the primary catalog in your project. The name cannot be changed once the catalog has been created.

  4. Select a cloud provider.

  5. Select the region in which compute resources and the project store will be created. For a list of supported regions, see Supported Regions.

  6. (Optional) Add one or more tags to help you identify compute resources for this project in your cloud provider account.

  7. Click Next.

To continue the configuration, follow the steps for your cloud provider.

  1. Click Launch CloudFormation Template, which will open the AWS console in a new browser tab.

  2. 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 AWS account and cannot include underscores.

  3. For VPC, select the VPC in which compute resources will be created.

  4. For Subnets, select one or more subnets where compute resources will be created.

  5. For Project Store, a unique name has been generated for the S3 bucket that will be created in your AWS account as the metadata store for your project. You can specify a different name here but it must be unique across AWS.

  6. For Encryption Type, SSE-S3 is the default encryption mechanism for the project store S3 bucket. You can select SSE-KMS (AWS Managed Key) or SSE-KMS (Customer Managed Key) for additional encryption. If you select SSE-KMS (Customer Managed Key), specify the KMS Key ARN.

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

  8. Click Create stack.

    It will take about 5 minutes to create the required storage and compute resources for the project.


When stack creation has completed in the AWS Console, return to the Dremio Console to start querying sample data and creating your first table.

note

If you encounter errors during resource creation for AWS, see Dremio Cloud Troubleshooting for AWS.

Wrap-up & Next Steps​

You're done setting up your Dremio Cloud account! Learn more about how you can quickly create a semantic layer and optimize your queries with the Getting Started with Dremio tutorial.

You can also preview going from natural language to SQL with a single click with the Analyze Data Using Text-to-SQL tutorial.

Have Questions?​

If you have questions about the concepts in this tutorial or other Dremio features, reach out to us using the chat feature This is the icon that represents the Intercom chat. in the bottom-right corner of the Dremio application.