Table: vercel_user - Query Vercel User using SQL

Vercel User is a fundamental entity within the Vercel platform that represents an individual user account. Each user has a unique username and email, along with additional personal details. Vercel User is the primary entity for authentication and authorization within the Vercel platform.

Table Usage Guide

The vercel_user table provides insights into individual user accounts within the Vercel platform. As a DevOps engineer or a security analyst, explore user-specific details through this table, including email, username, and other personal details. Utilize it to uncover information about user accounts, such as their creation date, bio, and the verification of their email.

Examples

Get user information

Explore the user profiles within your Vercel account to better manage and understand your user base. This can be particularly useful for auditing user access and permissions within your account.

select
  *
from
  vercel_user;

select
  *
from
  vercel_user;

Schema for vercel_user

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
billing	jsonb
bio	text
date	timestamp with time zone		Date when the user was created.
email	text		Email address of the user.
has_trial_available	boolean
import_flow_git_namespace	text
import_flow_git_namespace_id	text
import_flow_git_provider	text
name	text		Name of the user.
platform_version	bigint
profiles	jsonb
remote_caching	jsonb
resource_config	jsonb
soft_block	jsonb
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
staging_prefix	text		Username of the user.
uid	text		Unique identifier of the user.
user_uid	text	=, !=, ~~, ~~, !~~, !~~	Unique identifier of the user.
username	text		Username of the user.
website	text

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)" -- vercel

You can pass the configuration to the command with the --config argument:

steampipe_export_vercel --config '<your_config>' vercel_user