You can use the information_schema.organization view to return information about your organization.

You can use a SELECT query to return information about your organization, as shown in the example below.

SELECT
  *
FROM
  information_schema.organization;

Read more about organizations here.

Columns in information_schema.organization

Each row has the following columns with information about the organization.

Column NameData TypeDescription
organization_nameTEXTThe name of the organization.
editionTEXTThe Firebolt edition used by the organization.
is_payment_registeredBOOLEANSpecifies if payment is registered for the organization.
billing_profile_nameTEXTThe name of the billing profile for the organization.
ssoTEXTJSON configuration for single sign-on (SSO).
network_policy_nameTEXTThe name of the network policy applied at the organization level.
payment_method_nameTEXTThe name of the current payment method for the organization.
next_payment_method_nameTEXTThe name of the next payment method for the organization.
credits_remainingDECIMAL(38, 9)The remaining credit balance (in US dollars) available to the organization.
createdTIMESTAMPTZTime (UTC) that the organization was created.
organization_ownerTEXTThe name of the identity that owns this organization.
last_alteredTIMESTAMPTZTime (UTC) that the organization was last edited.
last_altered_byTEXTName of the identity that last edited the organization.