SHOW PRICING PLANS

Lists visible and hidden pricing plans.

Syntax

SHOW PRICING PLANS [ LIKE '<pattern>' ] IN LISTING <listing>

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 pricing plan you want shown.

Output

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

ColumnDescription
nameThe pricing plan display name.
state

Pricing plan status, one of:

  • DRAFT
  • PUBLISHED
  • RETIRED
display_nameThe pricing plan name visible to providers.
currencyThe pricing plan currency code.
pricing_model

The pricing plan pricing model, one of:

  • FLAT_FEE
  • USAGE_BASED
usage_detailsThe pricing plan usage details.
base_feeThe pricing plan base fee.
billing_duration_monthsThe pricing plan billing duration in months.
sales_motion

The pricing plan sales method, one of:

  • SELF_SERVE
  • TALK_TO_SALES
commentComments about the pricing plan added by the provider.
metadataThe pricing plan metadata added by the provider.
visibility

The pricing plan visibility, one of:

  • VISIBLE
  • HIDDEN
contract_type

The pricing plan contract type, one of:

  • SUBSCRIPTION
  • LIMITED_TIME
contract_duration_monthsThe pricing plan duration in months.
updated_onThe date and time the pricing plan was last updated.

Usage notes

  • You can show a pricing plan only if the listing exists and has a DRAFT or PUBLISHED status.
  • You can show a pricing plan only if you use a role that has the Global CREATE LISTING privilege.

Examples

Show all the pricing plans with names that start with mypricingplan in listing mylisting:

SHOW PRICING PLANS LIKE 'MYPRICINGPLAN%' IN LISTING 'MYLISTING';