Workgroup

Source: src/AWS/RedshiftServerless/Workgroup.ts

An Amazon Redshift Serverless workgroup — the compute half of a serverless data warehouse.

A workgroup provides on-demand compute (measured in RPUs) against a Namespace’s data. Creating a workgroup is asynchronous and takes roughly 2-5 minutes; the provider waits (bounded) for it to become AVAILABLE. Because a running workgroup bills against its RPU floor, tear it down promptly when you are done.

Creating a Workgroup

const namespace = yield* RedshiftServerless.Namespace("Analytics", {
  adminUsername: "admin",
  manageAdminPassword: true,
});
const workgroup = yield* RedshiftServerless.Workgroup("AnalyticsWg", {
  namespaceName: namespace.namespaceName,
  baseCapacity: 8,
});
// workgroup.endpointAddress -> "<wg>.<account>.<region>.redshift-serverless.amazonaws.com"

Networking

const workgroup = yield* RedshiftServerless.Workgroup("AnalyticsWg", {
  namespaceName: namespace.namespaceName,
  baseCapacity: 8,
  publiclyAccessible: true,
  subnetIds: [subnetA.subnetId, subnetB.subnetId, subnetC.subnetId],
  securityGroupIds: [securityGroup.groupId],
  enhancedVpcRouting: false,
});