Snowflake · Schema

PointOfTime

Point of time.

Data LakesData SharingData WarehousingDatabaseSQL

Properties

Name Type Description
point_of_time_type string Type of the point of time. Possible values include: - `timestamp`: Exact time using the standard timezone format. Example: `2023-09-15 10:59:43`. - `offset`: Interval relative to 'now.' Example: `1 da
reference string Relation to the point of time. Currently, the API supports `at` and `before`.
View JSON Schema on GitHub

JSON Schema

common-point-of-time-schema.json Raw ↑ 
{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "title": "PointOfTime",
  "type": "object",
  "description": "Point of time.",
  "properties": {
    "point_of_time_type": {
      "type": "string",
      "description": "Type of the point of time. Possible values include:\n- `timestamp`: Exact time using the standard timezone format. Example: `2023-09-15 10:59:43`. - `offset`: Interval relative to 'now.' Example: `1 day`. - `statement`: ID of a query statement to use as the reference point for <a href=https://docs.snowflake.com/en/sql-reference/sql/create-clone#time-travel-parameters>Time Travel</a>.\nFor more information, see https://docs.snowflake.com/en/sql-reference/data-types-datetime."
    },
    "reference": {
      "type": "string",
      "description": "Relation to the point of time. Currently, the API supports `at` and `before`."
    }
  }
}