SHOW OFFERS¶

Provides information about all offers added to a listing.

Syntax¶

SHOW OFFERS [ LIKE '<pattern>' ] IN LISTING <listing>

Copy

Parameters¶

LIKE 'pattern'

Optionally filters the command output by object name. The filter uses case-insensitive pattern matching, with support for SQL wildcard characters (% and _).

For example, the following patterns return the same results:

... LIKE '%testing%' ...

... LIKE '%TESTING%' ...

. Default: No value (no filtering is applied to the output).

IN LISTING listing: The listing associated with the offer you want shown.

Output¶

The command output provides offer properties and metadata in the following columns:

Column	Description
`name`	The offer name.
`state`	Offer status, one of: DRAFT PUBLISHED WITHDRAWN
`state_updated_on`	The date and time the offer state was last updated.
`access_start_date_preference`	The preferred date for consumer listing access, one of: OFFER_ACCEPTED_DATE SPECIFIC_DATE
`comment`	Comments about the offer added by the provider.
`contract_value`	The total contract value.
`contract_type`	The contract type, one of: SUBSCRIPTION LIMITED_TIME PAY_AS_YOU_GO
`contract_duration_months`	The contract duration in months.
`invoice_start_date_preference`	The preferred invoicing start date, one of: OFFER_ACCEPTED_DATE SPECIFIC_DATE FIRST_DAY_NEXT_MONTH
`invoice_start_time`	The date and time invoicing started.
`is_default`	Specifies a default offer is included with the pricing plan, one of: TRUE FALSE (default)
`display_name`	The offer name visible to consumers.
`expiration_time`	The date and time the offer expires.
`payment_terms`	Additional pricing plan parameters, one of: PAYMENT_TYPE INSTALLMENT_SCHEDULE ALLOWED_PAYMENT_METHODS
`pricing_plan_name`	The pricing plan associated with the offer.
`access_end_time`	The date and time consumers lose access to the listing.
`access_start_time`	The date and time consumers can access the listing.
`discount`	The offer discount.
`target_consumer`	The consumer the offer targets.
`terms_of_service`	The terms of service associated with the offer.
`additional_information`	Additional information about the offer.
`updated_on`	The date the offer was last updated.

Access control requirements¶

Privilege	Object	Notes
CREATE LISTING	Account	Only the ACCOUNTADMIN role has this privilege by default. The privilege can be granted to additional roles as needed.

For instructions on creating a custom role with a specified set of privileges, see Creating custom roles.

For general information about roles and privilege grants for performing SQL actions on securable objects, see Overview of Access Control.

Usage notes¶

To show an offer, you must have a role that includes the CREATE DATA EXCHANGE LISTING privilege on the offer.

To post-process the output of this command, you can use the pipe operator (->>) or the RESULT_SCAN function. Both constructs treat the output as a result set that you can query.

The output column names for this command are generated in lowercase. If you consume a result set from this command with the pipe operator or the RESULT_SCAN function, use double-quoted identifiers for the column names in the query to ensure that they match the column names in the output that was scanned. For example, if the name of an output column is type, then specify "type" for the identifier.

Examples¶

Show all the offers with names that start with myoffer in mylisting:

SHOW OFFERS LIKE 'MYOFFER%' IN LISTING MYLISTING;

Copy