Sends a single SQL query to a Quack server and returns the result as a
data.frame. Unlike attach_quack(), this does not attach the remote catalog,
so it is a quick way to pull a result without changing the session state.
Usage
quack_query(
uri,
query,
token = NULL,
disable_ssl = FALSE,
ssl_fingerprint = NULL,
client_id = NULL,
heartbeat_timeout = NULL
)Arguments
- uri
Address of the Quack server, for example
"quack:localhost".- query
A SQL query string to run on the server.
- token
Authentication token expected by the server. If
NULL, a Quack secret is used if one exists.- disable_ssl
Connect over plain HTTP instead of HTTPS (default
FALSE, which leaves the choice to DuckDB: plain HTTP for a local server, HTTPS otherwise).- ssl_fingerprint
Optional SHA-256 fingerprint (64 hex digits) of the server's certificate, for a server with a self-signed certificate; the value
quack_generate_keys()returns on the server side.- client_id
Optional identifier the server records for this client (at least 4 characters), shown by its
quack_active_connections().- heartbeat_timeout
Optional heartbeat lease, in seconds, requested from the server.
