SYS.ORGANIZATION.BILLING

The sys.organization.billing table contains data about the current organization's billing account.

Syntax

SELECT * 
FROM sys.organization.billing

Example Output

id	account_type	name	email	balance	is_default	created_at	created_by	modified_at	modified_by
b30202dd-68ae-4d60-b6bb-12502a451839	INVOICE_PREPAID	gnarly	gnarly@dremio.com	1000.0	true	1723749396154	22e4186a-d635-4496-a52c-7e6e0b98449d	1724748896246	22e4186a-d635-4496-a52c-7e6e0b98449d

Fields

Field	Data Type	Description
id	varchar	The UUID of the billing account.
account_type	varchar	The type of the billing account.
name	varchar	The name of the billing account.
email	varchar	The email address that receives invoices and transactional emails for the billing account.
balance	double	The balance of the billing account. This value can be negative if the account has charges that have not been paid.
is_default	Boolean	If the billing account is the default billing account for the current organization, true. Otherwise, false.
created_at	integer	The number of milliseconds since UNIX epoch at which the billing account was created.
created_by	varchar	The UUID of the user who created the billing account.
modified_at	integer	The number of milliseconds since UNIX epoch at which the billing account was last modified.
modified_by	varchar	The UUID of the user who last modified the billing account.