Package dev.frostlake.functions.table

Class QueryHistoryFunction

java.lang.Object

dev.frostlake.functions.TableFunction

dev.frostlake.functions.table.QueryHistoryFunction

public class QueryHistoryFunction
extends TableFunction

The 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). The column set mirrors Snowflake's (62 columns, captured live); the engine populates the subset its tracker records and leaves the rest NULL. Most recent queries first; RESULT_LIMIT defaults to 100 like Snowflake.

Constructor Summary

Constructors

Constructor	Description
QueryHistoryFunction(QueryHistoryTracker tracker)

Method Summary

Modifier and Type	Method	Description
ResultSet	execute(List<Object> positionalArgs)	Execute the table function with positional arguments.
ResultSet	execute(Map<String,Object> namedArgs)	Execute the table function with named arguments
void	validateArgs(Map<String,Object> namedArgs)	Validate the arguments passed to the function

Methods inherited from class dev.frostlake.functions.TableFunction

getName

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

QueryHistoryFunction

public QueryHistoryFunction(QueryHistoryTracker tracker)

Method Details

validateArgs

public void validateArgs(Map<String,Object> namedArgs)

Description copied from class: TableFunction

Validate the arguments passed to the function

Specified by:

validateArgs in class TableFunction

execute

public ResultSet execute(List<Object> positionalArgs)

Description copied from class: TableFunction

Execute the table function with positional arguments. Override this in user-defined table functions.

Overrides:

execute in class TableFunction

execute

public ResultSet execute(Map<String,Object> namedArgs)

Description copied from class: TableFunction

Execute the table function with named arguments

Specified by:

execute in class TableFunction