beekeeper-studio/beekeeper-studio · info

DynamoDB does not support materialized views

Error message

DynamoDB does not support materialized views

What it means

DynamoDBClient.getMaterializedViewCreateScript() always throws. Materialized views are a SQL/warehouse concept (e.g. Postgres, Redshift) with no DynamoDB equivalent, so the method is an explicit unsupported stub.

Source

Thrown at apps/studio/src-commercial/backend/lib/db/clients/dynamodb.ts:883

  async createDatabase(): Promise<string> {
    throw new Error('DynamoDB does not support creating databases');
  }

  async createDatabaseSQL(): Promise<string> {
    throw new Error('DynamoDB does not support generating SQL');
  }

  async getTableCreateScript(): Promise<string> {
    throw new Error('DynamoDB does not expose CREATE TABLE SQL');
  }

  async getViewCreateScript(): Promise<string[]> {
    throw new Error('DynamoDB does not support views');
  }

  async getMaterializedViewCreateScript(): Promise<string[]> {
    throw new Error('DynamoDB does not support materialized views');
  }

  async getRoutineCreateScript(): Promise<string[]> {
    throw new Error('DynamoDB does not support routines');
  }

  async setElementName(): Promise<void> {
    throw new Error('DynamoDB does not support renaming tables');
  }

  async setElementNameSql(): Promise<string> {
    throw new Error('DynamoDB does not support renaming tables');
  }

  async setTableDescription(): Promise<string> {
    throw new Error('DynamoDB does not support table descriptions');
  }

View on GitHub (pinned to 4e3e03e322)

Solutions

1. Skip materialized-view handling entirely for DynamoDB connections
2. Check client capabilities before offering the action
3. Catch and display 'materialized views are not supported on DynamoDB'

const supportsMatViews = !isDynamoDBClient(client);
if (!supportsMatViews) return null;

const supportsMatViews = (c: unknown): c is Exclude<typeof c, DynamoDBClient> => !(c instanceof DynamoDBClient);

try {
  return await client.getMaterializedViewCreateScript(name);
} catch (e) {
  if (e.message.includes('materialized views')) return null;
  throw e;
}

When it happens

Trigger: Calling DynamoDBClient.getMaterializedViewCreateScript(name), typically from a 'copy materialized view definition' flow.

Common situations: Tools that generically enumerate materialized views across all supported databases.

Related errors

• Copy to SQL is not supported for DynamoDB connections.
• DynamoDB does not support creating databases
• DynamoDB does not support generating SQL
• DynamoDB does not expose CREATE TABLE SQL
• DynamoDB does not support views

AI-assisted analysis of beekeeper-studio/beekeeper-studio@4e3e03e322 (2026-08-31). Data as JSON: /api/errors/cb3d791887e0134e. Report an issue: GitHub.