PRINT ENTITY

Syntax

PRINT ENTITY fully_qualified_entity_name [IN STORE store_name];

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.

Examples

Print a Snowflake table

demodb.public/snowflake_store# PRINT ENTITY "DELTA_STREAMING"."PUBLIC".pageviews;
  VIEWTIME       |  USERID  |  PAGEID  
-----------------+----------+-----------
  1694124853651  |  User_4  |  Page_29  
  1694124856731  |  User_1  |  Page_59  
  1694124857732  |  User_1  |  Page_63  

Print a Databricks table

db.public/kafka_store# PRINT ENTITY cat1.schema1.pageviews IN STORE databricks_store;
       viewtime      | userid | pageid
---------------------+--------+----------
  1.695069562981e+12 | User_9 | Page_37
  1.69506956402e+12  | User_7 | Page_52
  1.695069565022e+12 | User_5 | Page_83
  1.69506956604e+12  | User_3 | Page_85
  1.69506956708e+12  | User_9 | Page_87
  1.69506956816e+12  | User_6 | Page_67
  1.695069569162e+12 | User_9 | Page_48
  1.695069570163e+12 | User_7 | Page_35
  1.695069571164e+12 | User_6 | Page_11
  1.695069572165e+12 | User_8 | Page_91