Table: godaddy_shopper - Query GoDaddy Shoppers using SQL
GoDaddy is a widely-used domain registrar and web hosting company. The 'Shopper' is a resource in GoDaddy that represents a registered user who has the ability to purchase and manage domains. It provides details about the shopper's profile, including their shopper ID, name, and email.
Table Usage Guide
The godaddy_shopper
table provides insights into registered shoppers within GoDaddy. As a system administrator or a DevOps engineer, you can explore shopper-specific details through this table, including shopper ID, name, and email. Utilize it to uncover information about shoppers, such as their contact details and the status of their accounts.
Important Notes
- You must specify the
shopper_id
in thewhere
clause to query this table.
Examples
Basic info
Discover the segments that include specific customer data to understand their market affiliation and contact details. This can be useful to gain insights into individual customer profiles for personalized marketing or customer service efforts.
select customer_id, market_id, name_first, name_last, email, external_idfrom godaddy_shopperwhere shopper_id = '568421234';
select customer_id, market_id, name_first, name_last, email, external_idfrom godaddy_shopperwhere shopper_id = '568421234';
Schema for godaddy_shopper
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. | |
customer_id | text | Unique identifier for the customer record associated with this shopper record. This is an alternate identifier that some systems use to identify an individual shopper record. | |
text | The email address of the customer. | ||
external_id | bigint | Unique identifier for a shopper provided by the calling application. | |
market_id | text | The market ID for the shopper. | |
name_first | text | The first name of the shopper. | |
name_last | text | The last name of the shopper. | |
shopper_id | text | = | The unique identifier of the shopper. |
title | text | Title of the resource. |
Export
This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.
You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh
script:
/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- godaddy
You can pass the configuration to the command with the --config
argument:
steampipe_export_godaddy --config '<your_config>' godaddy_shopper