Package dev.frostlake.functions.scalar.context

package dev.frostlake.functions.scalar.context
  • Classes
    Class
    Description
    AggregationConstraint
    AGGREGATION_CONSTRAINT(MIN_GROUP_SIZE => n) — the minimum group size an AGGREGATION POLICY imposes.
    CurrentAccount
    CURRENT_ACCOUNT() function - returns the account identifier The account ID can be configured in the frostlake.properties file with the key 'account.id'
    CurrentAccountName
    CURRENT_ACCOUNT_NAME() — the account's NAME, configured through account.name.
    CurrentAvailableRoles
    CURRENT_AVAILABLE_ROLES() — a JSON array (as text) of every role the session can use: the active roles, the roles granted to the current user, and the closure of roles granted to those roles.
    CurrentClient
    CURRENT_CLIENT() — the identifier of the client library the session is connecting through.
    CurrentDatabase
     
    CurrentDate
     
    CurrentIpAddress
    CURRENT_IP_ADDRESS() — the client IP address (loopback for the embedded engine).
    CurrentOrganizationName
    CURRENT_ORGANIZATION_NAME() — the organization the account belongs to, configured through organization.name.
    CurrentRegion
     
    CurrentRole
     
    CurrentRoleType
    CURRENT_ROLE_TYPE() — the current role type (always an account-level ROLE here).
    CurrentSchema
     
    CurrentSchemas
    CURRENT_SCHEMAS() — the active search path as a JSON array of the current schema.
    CurrentSecondaryRoles
    CURRENT_SECONDARY_ROLES() — the active secondary roles (none in the embedded engine).
    CurrentSession
     
    CurrentStatement
    CURRENT_STATEMENT() — the text of the statement being executed, from the session.
    CurrentTime
     
    CurrentTimestamp
     
    CurrentTransaction
    CURRENT_TRANSACTION() — the open transaction id (ids are not exposed; NULL, as Snowflake returns outside a transaction).
    CurrentUser
     
    CurrentVersion
    CURRENT_VERSION() — the version of the running engine, taken from BuildInfo.version() so it tracks the built artifact.
    CurrentWarehouse
     
    GetDdl
    GET_DDL('<object_type>', '<object_name>' [, <use_fully_qualified_names>]) — reconstructs a CREATE OR REPLACE statement for an object from the catalog.
    InvokerRole
    INVOKER_ROLE() — the invoking role (the current role in the embedded engine).
    IsRoleInSession
    IS_ROLE_IN_SESSION(name) — TRUE when the named role is the session's current role.
    JoinConstraint
    JOIN_CONSTRAINT(JOIN_REQUIRED => <boolean>) — what a JOIN POLICY's body returns.
    LastQueryId
    LAST_QUERY_ID() function - returns the query ID of the last executed query
    LastTransaction
    LAST_TRANSACTION() — the last transaction id (ids are not exposed; NULL).
    NextVal
    NEXTVAL function - gets the next value from a sequence Usage: NEXTVAL('sequence_name') or sequence_name.NEXTVAL
    NoAggregationConstraint
    NO_AGGREGATION_CONSTRAINT() — the AGGREGATION POLICY body that imposes nothing.
    PolicyBodyScope
    Marks the thread as evaluating a POLICY BODY, for the functions that live only there.
    ProjectionConstraint
    PROJECTION_CONSTRAINT(ALLOW => <boolean>) — what a PROJECTION POLICY's body returns.
    SeqFn
    SEQ1 / SEQ2 / SEQ4 / SEQ8 — the row's 0-based ordinal, wrapped to the function's integer width.
    UuidString
    UUID_STRING() — a random version-4 UUID, and UUID_STRING(namespace, name) — the RFC 4122 version-5 name-based form, which is bit-exact with Snowflake.