PRINT ENTITY fully_qualified_entity_name[IN STORE store_name][WITH (streaming_print_parameter = value [, ...])];
Description
This command retrieves the latest data for an Entity in a Store. You can only print leaf-level Entities like Snowflake Tables or Kafka topics.
Entities can only be printed if the current role has USAGE privileges on the Store.
Arguments
fully_qualified_entity_name
The full name of the Entity to print records from.
IN STORE store_name
Optionally, sample an Entity from a specific Store. For case-sensitive names, the name must be wrapped in double quotes; otherwise, the lowercase name will be used.
WITH (streaming_print_parameter = value [, ...])
Optionally, use Streaming Print Parameters to change the behavior of each printing session for the streaming Stores.
Streaming Print Parameters
Parameter Name
Description
from.beginning
A flag that indicates the operation will start reading the Entity from the earliest available records. This property does not accept a value.
Required: No
Default value: Unset
Type: Flag
from.timestamp
Specifies the timestamp to use to print records. The timestamp value is in epoch-milliseconds, which is measured as the number of milliseconds since January 1, 1970 00:00:00.000 GMT. Cannot be set with the from.beginning flag.
Required: No
Default value: None
Type: Integer
Valid values: [1,...]
message.rate
Specifies the number of records per second that should be printed.
Required: No
Default value: 5
Type: Integer
Valid values: [1,...,10]
Examples
Print a Entity with defaults
The following prints from the pageviews Entity using the current Store and default parameter values.
The following prints from the CaseSensitivePageviews Entity using a specified Store. Note that since the Entity is case-sensitive, we wrap the Entity name in quotes.
