Enum TableVersion 

pub enum TableVersion {
    ForSystemTimeAsOf(Expr),
    TimestampAsOf(Expr),
    VersionAsOf(Expr),
    Function(Expr),
    Changes {
        changes: Expr,
        at: Expr,
        end: Option<Expr>,
    },
}

Specifies a table version selection, e.g. FOR SYSTEM_TIME AS OF or AT(...).

Variants

ForSystemTimeAsOf(Expr)

When the table version is defined using FOR SYSTEM_TIME AS OF. For example: SELECT * FROM tbl FOR SYSTEM_TIME AS OF TIMESTAMP_SUB(CURRENT_TIMESTAMP(), INTERVAL 1 HOUR)

TimestampAsOf(Expr)

When the table version is defined using TIMESTAMP AS OF. Databricks supports this syntax. For example: SELECT * FROM tbl TIMESTAMP AS OF CURRENT_TIMESTAMP() - INTERVAL 1 HOUR

VersionAsOf(Expr)

When the table version is defined using VERSION AS OF. Databricks supports this syntax. For example: SELECT * FROM tbl VERSION AS OF 2

Function(Expr)

When the table version is defined using a function. For example: SELECT * FROM tbl AT(TIMESTAMP => '2020-08-14 09:30:00')

Changes

Snowflake CHANGES clause for change tracking queries. For example:

SELECT * FROM t
  CHANGES(INFORMATION => DEFAULT)
  AT(TIMESTAMP => TO_TIMESTAMP_TZ('...'))
  END(TIMESTAMP => TO_TIMESTAMP_TZ('...'))

https://docs.snowflake.com/en/sql-reference/constructs/changes

Fields

changes: Expr

The CHANGES(INFORMATION => ...) function-call expression.

at: Expr

The AT(TIMESTAMP => ...) function-call expression.

end: Option<Expr>

The optional END(TIMESTAMP => ...) function-call expression.

Trait Implementations

impl Clone for TableVersion

fn clone(&self) -> TableVersion

Returns a duplicate of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl Debug for TableVersion

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.

impl Display for TableVersion

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.

impl Eq for TableVersion

impl Hash for TableVersion

fn hash<__H: Hasher>(&self, state: &mut __H)

Feeds this value into the given Hasher.

fn hash_slice<H>(data: &[Self], state: &mut H)

where H: Hasher, Self: Sized,

Feeds a slice of this type into the given Hasher.

impl Ord for TableVersion

fn cmp(&self, other: &TableVersion) -> Ordering

This method returns an Ordering between self and other.

fn max(self, other: Self) -> Self

where Self: Sized,

Compares and returns the maximum of two values.

fn min(self, other: Self) -> Self

where Self: Sized,

Compares and returns the minimum of two values.

fn clamp(self, min: Self, max: Self) -> Self

where Self: Sized,

Restrict a value to a certain interval.

impl PartialEq for TableVersion

fn eq(&self, other: &TableVersion) -> bool

Equality operator ==.

fn ne(&self, other: &Rhs) -> bool

Inequality operator !=.

impl PartialOrd for TableVersion

fn partial_cmp(&self, other: &TableVersion) -> Option<Ordering>

This method returns an ordering between self and other values if one exists.

fn lt(&self, other: &Rhs) -> bool

Tests less than (for self and other) and is used by the < operator.

fn le(&self, other: &Rhs) -> bool

Tests less than or equal to (for self and other) and is used by the <= operator.

fn gt(&self, other: &Rhs) -> bool

Tests greater than (for self and other) and is used by the > operator.

fn ge(&self, other: &Rhs) -> bool

Tests greater than or equal to (for self and other) and is used by the >= operator.

impl StructuralPartialEq for TableVersion