Run commands to define and use a database in your data warehouse (original) (raw)

Both Redshift Serverless data warehouses and Amazon Redshift provisoned data warehouses contain databases. After you have launched your data warehouse, you can manage most database actions using SQL commands. With few exceptions, the functionality and syntax of SQL is the same for all Amazon Redshift databases. For details of SQL commands available with Amazon Redshift, seeSQL commands in the Amazon Redshift Database Developer Guide.

When you create your data warehouse, in most scenarios, Amazon Redshift also creates the default dev database. After you connect to the dev database, you can create another database.

The following sections walk through common database tasks when working with Amazon Redshift databases. The tasks begin with creating a database and if you continue to the last task you can delete all the resources you create by dropping the database.

The examples in this section assume the following:

• You have created an Amazon Redshift data warehouse.
• You have established a connection to the data warehouse from your SQL client tool, such as the Amazon Redshift query editor v2. For more information about query editor v2, see Querying a database using the Amazon Redshift query editor v2 in the Amazon Redshift Management Guide.

Topics

• Connecting to Amazon Redshift data warehouses
• Create a database
• Create a user
• Create a schema
• Create a table
• Load data
• Query the system tables and views
• Cancel a query

Connecting to Amazon Redshift data warehouses

To connect to Amazon Redshift clusters, from the Amazon Redshift console Clusters page, expand Connect to Amazon Redshift clusters and do one of the following:

• Choose Query data to use the query editor v2 to run queries on databases hosted by your Amazon Redshift cluster. After creating your cluster, you can immediately run queries by using the query editor v2.
  For more information, see Querying a database using the Amazon Redshift query editor v2 in the Amazon Redshift Management Guide.
• In Work with your client tools, choose your cluster and connect to Amazon Redshift from your client tools using JDBC or ODBC drivers by copying the JDBC or ODBC driver URL. Use this URL from your client computer or instance. Code your applications to use JDBC or ODBC data access API operations, or use SQL client tools that support either JDBC or ODBC.
  For more information on how to find your cluster connection string, see Finding your cluster connection string.
• If your SQL client tool requires a driver, you can Choose your JDBC or ODBC driver to download an operating system-specific driver to connect to Amazon Redshift from your client tools.
  For more information on how to install the appropriate driver for your SQL client, see Configuring a JDBC driver version 2.0 connection.
  For more information on how to configure an ODBC connection, see Configuring an ODBC connection.

To connect to Redshift Serverless data warehouse, from the Amazon Redshift console Serverless dashboard page, do one of the following:

• Use the Amazon Redshift query editor v2 to run queries on databases hosted by your Redshift Serverless data warehouse. After creating your data warehouse, you can immediately run queries by using the query editor v2.
  For more information, see Querying a database using the Amazon Redshift query editor v2.
• Connect to Amazon Redshift from your client tools using JDBC or ODBC drivers by copying the JDBC or ODBC driver URL.
  To work with data in your data warehouse, you need JDBC or ODBC drivers for connectivity from your client computer or instance. Code your applications to use JDBC or ODBC data access API operations, or use SQL client tools that support either JDBC or ODBC.
  For more information on how to find your connection string, see Connecting to Redshift Serverless in the Amazon Redshift Management Guide.