Typical Workflow for Using Autonomous Data Warehouse

Describes the steps to start using Autonomous Data Warehouse.

Task Description More Information

Create and log in to your cloud account

Provide your information and sign up for an Oracle Cloud Service.

Getting Started with Oracle Cloud

Provision Autonomous Data Warehouse

Create an Autonomous Data Warehouse instance.

Autonomous Database Quickstart

Start the data warehouse

Start and verify that an Autonomous Data Warehouse instance is up and running.

Start Autonomous Data Warehouse

Create database users and obtain security credentials

Create accounts for your users and assign them appropriate privileges. Assign the necessary Autonomous Data Warehouse roles.

Create Users with Autonomous Data Warehouse

Connect to your data warehouse using SQL Developer

Download SQL Developer or another database client tool. Obtain security credentials and connect to your Autonomous Data Warehouse.

Connect to Autonomous Data Warehouse Using Oracle Database Tools

Connect to your data warehouse using a database client

Download a database client. Obtain security credentials and connect to your Autonomous Data Warehouse instance.

Connecting to Autonomous Data Warehouse

Scale the data warehouse

Use the Oracle Cloud Infrastructure Console to scale an instance to add or remove CPU or storage resources.

Starting, Stopping, and Scaling Autonomous Data Warehouse

Load data into the data warehouse

Use the available tools to load data into the data warehouse.

Loading Data with Autonomous Data Warehouse

Migrate data from Amazon Redshift

Migrate data from an existing Amazon Redshift data warehouse.

Migrating Amazon Redshift to Autonomous Data Warehouse

Monitor the data warehouse

Check on the health and performance of the data warehouse.

Managing and Monitoring Performance of Autonomous Data Warehouse

Manage the data warehouse

Check on the day-to-day operation of your service, monitor performance, and review important notifications.

All aspects of the database lifecycle are simplified by the service, including patching and upgrading the database. You can obtain service information including the service and database version from the service console.

Backing Up and Restoring Autonomous Data Warehouse

Clone the data warehouse

Use the Oracle Cloud Infrastructure console to clone a database. You can choose to clone either the full database or only the database metadata.

Cloning, Moving, or Upgrading an Autonomous Data Warehouse Database