Help Center/ GaussDB/ Developer Guide(Centralized_V2.0-8.x)/ Schemas/ DB4AI Schema/ DB4AI.SAMPLE_SNAPSHOT
Updated on 2025-08-19 GMT+08:00
View PDF

DB4AI.SAMPLE_SNAPSHOT

SAMPLE_SNAPSHOT is a function that samples basic data to generate snapshots for the DB4AI feature, as described in Table 1. You can call this function by using the SAMPLE SNAPSHOT syntax.

Table 1 DB4AI.SAMPLE_SNAPSHOT input parameters and return values

Parameter

Type

Description

i_schema

IN NAME

Name of the schema storing snapshots.

i_parent

IN NAME

Parent snapshot name.

i_sample_infixes

IN NAME[]

Sample snapshot name infix.

i_sample_ratios

IN NUMBER[]

Size of each sample, which is used as the sample set ratio.

i_stratify

IN NAME[]

Layering strategy.

i_sample_comments

IN TEXT[]

Sample snapshot description.

res

OUT db4ai.snapshot_name

Result.
Parent topic: DB4AI Schema