SHOW AVAILABLE OFFERS¶

Lists the offers that are available to the user who runs the command.

Syntax¶

SHOW AVAILABLE 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
`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
`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 offer information.
`pricing_plan`	The pricing plan associated with the offer.
`updated_on`	The date and time the offer was last updated.

Access control requirements¶

Privilege	Object	Notes
`PURCHASE_DATA_EXCHANGE_LISTING`	Global	This privilege grants the ability to purchase a paid listing. If you don’t have a role with this privilege, contact your account administrator.

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 available offers, you need the PURCHASE 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 available offers with names that start with myoffer in mylisting:

SHOW AVAILABLE OFFERS LIKE 'MYOFFER%' IN LISTING MYLISTING;

Copy