LISTINGS view¶
This Information Schema view displays all listings for which the current role has been granted access privileges. This view provides real time information with no latency of data.
Columns¶
| Column | Data type | Description |
|---|---|---|
| GLOBAL_NAME | VARCHAR | The global name of the listing. |
| NAME | VARCHAR | The name of the listing. |
| OWNER | VARCHAR | The name of the role that owns the listing. |
| CREATED_ON | TIMESTAMP_LTZ | The timestamp when the listing was created. |
| UPDATED_ON | TIMESTAMP_LTZ | The timestamp when the listing was last updated. |
| PUBLISHED_ON | TIMESTAMP_LTZ | The timestamp when the listing was published. |
| TITLE | VARCHAR | The title of the listing. |
| SUBTITLE | VARCHAR | The subtitle of the listing. |
| DESCRIPTION | VARCHAR | The description of the listing. |
| LISTING_TERMS | VARCHAR | The terms of service associated with the listing. |
| STATE | VARCHAR | The current state of the listing. |
| SHARE | VARCHAR | The name of the share associated with the listing. |
| APPLICATION_PACKAGE | VARCHAR | The name of the application package associated with the listing. |
| DATA_ATTRIBUTES | VARCHAR | Data attributes associated with the listing. |
| CATEGORIES | VARCHAR | Categories associated with the listing. |
| PROFILE | VARCHAR | The profile attached to the external listing. |
| CUSTOMIZED_CONTACT_INFO | VARCHAR | Customized contact information associated with the listing. |
| COMMENT | VARCHAR | Comment associated with the listing, if any. |
| TARGETS | VARCHAR | The targets consolidating external/organization listings with regions. |
| AUTO_FULFILLMENT | VARCHAR | Auto-fulfillment information associated with the listing. |
| IS_SHARE | BOOLEAN | Indicates whether this is a data share listing. |
| IS_APPLICATION | BOOLEAN | Indicates whether this is an application listing. |
| DISTRIBUTION | VARCHAR | The distribution of the listing. Possible values are |
| IS_MOUNTLESS_QUERYABLE | BOOLEAN | Indicates whether the listing is mountless queryable. |
| ORGANIZATION_PROFILE_NAME | VARCHAR | The organization profile attached to the listing, if any. |
| UNIFORM_LISTING_LOCATOR | VARCHAR | The uniform listing locator (ULL) of the listing. |
| APPROVER_CONTACT | VARCHAR | The approver contact information associated with the listing. |
| SUPPORT_CONTACT | VARCHAR | The support contact information associated with the listing. |
| RESHARING | VARCHAR | Resharing configuration of the listing. |
Usage notes¶
The view doesn’t capture deleted listings.
Examples¶
Retrieve all listings in the current account: