snowflake_node
Keeps track of all the current snowflake nodes in use
Primary Key:Checks:snowflake_node_check-((node_id >= 0) AND (node_id <= 1023))
| Column | Data Type | Nullable | Indexed | Description |
|---|---|---|---|---|
node_id | integer | No | Yes | node_id is used in the snowflake ID format to prevent collisions with multiple nodes (also known as workers). |
start_time | timestamp with time zone | Yes | No | start_time is the time when the node_id was acquired. |
last_updated_time | timestamp with time zone | Yes | No | last_updated_time should be updated every 30s while a node_id is being used by a worker. The node is considered stale after 30 minutes of no updates and the entry is evicted, ideally this is never used. 30m is double the expected possible idle period of 15m on Google Cloud stated here: https://cloud.google.com/run/docs/about-instance-autoscaling#:~:text=Cloud%20Run%20does%20not%20immediately,of%20a%20sudden%20traffic%20spike |