Package dev.frostlake.metastore.model
package dev.frostlake.metastore.model
-
ClassDescriptionSnowflake AGGREGATION POLICY — attached to a TABLE, it forbids reading individual rows: a query must aggregate, may not use the aggregates that would leak a single value (MIN, MAX, MEDIAN, MODE, ANY_VALUE, VARIANCE, LISTAGG, ARRAY_AGG, PERCENTILE_*), and sees groups smaller than the policy's minimum folded into one remainder group.Change type enum - represents the type of DML operationA CHECK constraint: a boolean expression every written row must not make FALSE.An account-level compute pool.A compute pool's lifecycle state as SHOW COMPUTE POOLS spells it.Names for constraints declared without an explicit
CONSTRAINT <name>clause.Snowflake CONTACT — a schema-level object naming who to reach about an object, attached to tables (and other objects) for a PURPOSE withALTER TABLE … SET CONTACT <purpose> = <contact>.The parent container a CREATE authorization check targets — the scope that must grant the CREATE privilege.A Cortex search service: a named, indexed view over one text column of a query's result, queried back throughSNOWFLAKE.CORTEX.SEARCH_PREVIEW.One DATA METRIC FUNCTION attached to a table, over the columns it measures — or over none, for the table-level metrics (ROW_COUNT, FRESHNESS and their kind).A columnDEFAULTwhose value is a non-literal expression (arithmetic, string concatenation, a function call, CASE, …) rather than a stored constant.Represents a Snowflake DYNAMIC TABLE — a table whose contents are automatically refreshed from a query, with a configurable target lag.A stored procedure's caller-rights mode:ExecuteAs.OWNER(the default — runs with the owner's privileges) orExecuteAs.CALLER(runs with the caller's privileges).A named file format object (CREATE FILE FORMAT) — a reusable set of parsing/formatting options (TYPE plus format-specific options like FIELD_DELIMITER, SKIP_HEADER) that COPY statements reference via FORMAT_NAME.Represents a FOREIGN KEY constraint (final not enforced, final metadata only)Whether a dynamic table populates when it is created or waits for its first scheduled refresh.The relations a join's merged relation is assembled from, and which of them an outer join extends with NULLs: what the account's planner knows of a joined column's nullability beside its table's statistics.Snowflake JOIN POLICY — attached to a TABLE, it refuses to let that table be read on its own: the query must INNER join it to a DIFFERENT table on an equality between their columns.Snowflake MASKING POLICY — transforms a column value based on the querying user's role.A UDF's NULL-handling behavior:NullHandling.CALLED_ON_NULL_INPUT(the default — the body runs even for NULL arguments) orNullHandling.RETURNS_NULL_ON_NULL_INPUT(short-circuits to NULL;STRICTis its synonym).Represents a Snowflake PIPE for continuous data loadingPrivilege types in Snowflake Based on: https://docs.snowflake.com/en/sql-reference/sql/grant-privilegeSnowflake PROJECTION POLICY — attached to a COLUMN, it decides whether that column may appear in a query's select list at all.A foreign-key referential action (ON DELETE/ON UPDATE).How a dynamic table refreshes: AUTO lets the account choose, and the CONFIGURED mode is not always the RESOLVED one — a definition AUTO cannot refresh incrementally resolves to FULL.The kinds that share one name space inside a schema.Represents a Snowflake-compatible roleSnowflake ROW ACCESS POLICY — a SQL boolean predicate that filters rows.Scaling policy enum - represents the warehouse scaling behaviorTask schedule type enum - represents the type of scheduleOne configured SEARCH OPTIMIZATION expression — a METHOD over a column, asDESCRIBE SEARCH OPTIMIZATION ON <table>reports it.The kind of catalog object an authorization check targets — the "securable object" in Snowflake terms.Represents a database SEQUENCE objectRepresents a Snowflake STAGE - a named location for staging data files.Represents a file in a stageStage type enum - represents whether a stage is internal or externalThe scheduling state of a dynamic table's refresh.Represents a Snowflake Stream - Change Data Capture (CDC) mechanism Streams record DML changes (INSERT, UPDATE, DELETE) made to a tableOne logical row's accumulated (net) change while consolidating a stream window:oldValuesis the row's image at the stream offset (null when the row was born inside the window) andnewValuesits current image (null when the row no longer exists).Represents the type of source object for a StreamStream type enum - represents the type of changes tracked by a streamRepresents a Snowflake TAG - used for object categorization and metadata management Tags can be applied to databases, schemas, tables, and other objects for governance and organizationRepresents a Snowflake Task - Scheduled SQL executionThe outcome of a singleTaskExecutionrun —TaskExecutionState.SUCCEEDEDorTaskExecutionState.FAILED.Task state enum - represents whether a task is running or suspendedThe implementation language (runtime) of a UDF or stored procedure, as declared byLANGUAGE ….One UNIQUE constraint, spanning one or more columns.Represents a Snowflake-compatible userA UDF's volatility:Volatility.VOLATILE(the default — may return different results across calls) orVolatility.IMMUTABLE(a pure function of its arguments).Represents a Snowflake Compute Warehouse Warehouses provide compute resources for query executionWarehouse size enum - represents the compute capacity of a warehouseWarehouse state enum - represents the operational state of a warehouse