Method CreateMaterializedView

backend/store/model/database.go:697–717

CreateMaterializedView creates a new materialized view in the schema. Returns an error if the materialized view already exists.

(viewName string, definition string)

// CreateMaterializedView creates a new materialized view in the schema.
// Returns an error if the materialized view already exists.
func (s *SchemaMetadata) CreateMaterializedView(viewName string, definition string) (*storepb.MaterializedViewMetadata, error) {
	// Check if materialized view already exists
	if s.GetMaterializedView(viewName) != nil {
		return nil, errors.Errorf("materialized view %q already exists in schema %q", viewName, s.proto.Name)
	}

	// Create new materialized view proto
	newViewProto := &storepb.MaterializedViewMetadata{
		Name:       viewName,
		Definition: definition,
	}

	// Add to proto's materialized view list
	s.proto.MaterializedViews = append(s.proto.MaterializedViews, newViewProto)

	// Add to internal map
	viewID := normalizeNameByCaseSensitivity(viewName, s.isObjectCaseSensitive)
	s.internalMaterializedView[viewID] = newViewProto

	return newViewProto, nil
}

// DropMaterializedView drops a materialized view from the schema.
// Returns an error if the materialized view does not exist.