Uses of Class
dev.frostlake.functions.TableFunction
Packages that use TableFunction
Package
Description
-
Uses of TableFunction in dev.frostlake.executor.operators
Constructors in dev.frostlake.executor.operators with parameters of type TableFunctionModifierConstructorDescriptionTableFunctionOperator(String functionName, TableFunction tableFunction, List<Object> positionalArguments) Create a table function operator with positional arguments.TableFunctionOperator(String functionName, TableFunction tableFunction, Map<String, Object> namedArguments) Create a table function operator with named arguments. -
Uses of TableFunction in dev.frostlake.functions
Methods in dev.frostlake.functions that return TableFunctionMethods in dev.frostlake.functions that return types with arguments of type TableFunctionMethods in dev.frostlake.functions with parameters of type TableFunctionModifier and TypeMethodDescriptionvoidFunctionRegistry.registerTableFunction(TableFunction function) -
Uses of TableFunction in dev.frostlake.functions.table
Subclasses of TableFunction in dev.frostlake.functions.tableModifier and TypeClassDescriptionclassINFORMATION_SCHEMA.DATA_METRIC_FUNCTION_REFERENCES— the DATA METRIC FUNCTIONS attached to an object, or the objects one metric is attached to.classFLATTEN — expands semi-structured data into one row per element.classGENERATOR table function - generates rows with sequential numbers Supports: - ROWCOUNT => n (generates n rows) - TIMELIMIT => seconds (generates rows for specified time period)classINFORMATION_SCHEMA.POLICY_REFERENCES— every policy attached to one object, or every object one policy is attached to.classThe INFORMATION_SCHEMA.QUERY_HISTORY() TABLE FUNCTION — Snowflake exposes query history ONLY this way (SELECT … FROM TABLE(INFORMATION_SCHEMA.QUERY_HISTORY(RESULT_LIMIT => n)); the bare object form is "does not exist", live-verified).classRESULT_SCAN table function - retrieves cached query results by query ID.classSPLIT_TO_TABLE — splits a string into one row per part, as SEQ, INDEX and VALUE.classThe INFORMATION_SCHEMA.TAG_REFERENCES(object_name, object_domain) TABLE FUNCTION — the tags attached to one object, asSELECT … FROM TABLE(INFORMATION_SCHEMA.TAG_REFERENCES('db.schema.t', 'TABLE')).classINFORMATION_SCHEMA.TASK_HISTORY() table function Syntax: SELECT * FROM TABLE(INFORMATION_SCHEMA.TASK_HISTORY()) SELECT * FROM TABLE(INFORMATION_SCHEMA.TASK_HISTORY(TASK_NAME => 'my_task')) SELECT * FROM TABLE(INFORMATION_SCHEMA.TASK_HISTORY(RESULT_LIMIT => 100))classTO_QUERY table function — compiles a SQL text into a query and returns its result set:SELECT * FROM TABLE(TO_QUERY('SELECT ...')).classSYSTEM$USER_TASK_CANCEL_ONGOING_EXECUTIONS('task_name')— cancels the runs of a task that are in flight and returns a one-columnstatusrow describing what happened.