logs

Creates, updates, deletes, gets or lists a logs resource.

Overview

Name	logs
Type	Resource
Id	snowflake.service.logs

Fields

The following fields are returned by SELECT queries:

fetch_service_logs

successful

Name	Datatype	Description
system$get_service_logs	string

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
fetch_service_logs	select	database_name, schema_name, name, instanceId, containerName, endpoint	numLines	Fetch the logs for a given service.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
containerName	string	Container name as specified in the service specification file.
database_name	string	Identifier (i.e. name) for the database to which the resource belongs. You can use the /api/v2/databases GET request to get a list of available databases.
endpoint	string	Organization and Account Name (default: orgid-acctid)
instanceId	integer	ID of the service instance, starting with 0.
name	string	Identifier (i.e. name) for the resource.
schema_name	string	Identifier (i.e. name) for the schema to which the resource belongs. You can use the /api/v2/databases/{database}/schemas GET request to get a list of available schemas for the specified database.
numLines	integer	Number of trailing log lines to retrieve.

SELECT examples

fetch_service_logs

Fetch the logs for a given service.

SELECT
system$get_service_logs
FROM snowflake.service.logs
WHERE database_name = '{{ database_name }}' -- required
AND schema_name = '{{ schema_name }}' -- required
AND name = '{{ name }}' -- required
AND instanceId = '{{ instanceId }}' -- required
AND containerName = '{{ containerName }}' -- required
AND endpoint = '{{ endpoint }}' -- required
AND numLines = '{{ numLines }}';