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 the where 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_id
from
  godaddy_shopper
where
  shopper_id = '568421234';

select
  customer_id,
  market_id,
  name_first,
  name_last,
  email,
  external_id
from
  godaddy_shopper
where
  shopper_id = '568421234';

Schema for godaddy_shopper

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
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.
email	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.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
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