A list of enterprises that the user belongs to.

View-Specific Information

Select

The connector uses the GitHub API to process WHERE clause conditions built with the below columns and operators. The connector processes other filters client-side within the connector.

• Slug supports the '=' comparison operator.
• MembershipType supports the '=' comparison operator.
• Login supports the '=' comparison operator.

For example, the following queries are processed server side:

SELECT * FROM [Information].[Enterprises] WHERE [Information].[Enterprises].[Slug] = 'test-enterprise'
SELECT * FROM [Information].[Enterprises] WHERE [Information].[Enterprises].[MembershipType] = 'ADMIN'
SELECT * FROM [Information].[Enterprises] WHERE [Information].[Enterprises].[Login] = 'test'

Columns

Name	Type	References	OrderBySupport	Description
Id [KEY]	String			The ID of the Enterprise object.
UserId	String			The ID of the User object.
Location	String			The location of the enterprise.
Name	String			The name of the enterprise.
DatabaseId	Int			Identifies the primary key from the database.
Announcement	String			The text of the announcement.
AnnouncementExpiresAt	Datetime			The expiration date of the announcement, if any.
AnnouncementUserDismissible	Bool			Whether the announcement can be dismissed by the user.
BillingEmail	String			The enterprise's billing email.
BillingInfoAllLicensableUsersCount	Int			The number of licenseable users/emails across the enterprise.
BillingInfoAssetPacks	Int			The number of data packs used by all organizations owned by the enterprise.
BillingInfoBandwidthQuota	Double			The bandwidth quota in GB for all organizations owned by the enterprise.
BillingInfoBandwidthUsage	Double			The bandwidth usage in GB for all organizations owned by the enterprise.
BillingInfoBandwidthUsagePercentage	Int			The bandwidth usage as a percentage of the bandwidth quota.
BillingInfoStorageQuota	Double			The storage quota in GB for all organizations owned by the enterprise.
BillingInfoStorageUsage	Double			The storage usage in GB for all organizations owned by the enterprise.
BillingInfoStorageUsagePercentage	Int			The storage usage as a percentage of the storage quota.
BillingInfoTotalAvailableLicenses	Int			The number of available licenses across all owned organizations based on the unique number of billable users.
BillingInfoTotalLicenses	Int			The total number of licenses allocated.
CreatedAt	Datetime			Identifies the date and time when the object was created.
Description	String			The description of the enterprise.
DescriptionHTML	String			The description of the enterprise as HTML.
OwnerInfoOidcProviderId	String			The ID of the OIDCProvider object
OwnerInfoOidcProviderTenantId	String			The ID of the tenant this provider is attached to.
OwnerInfoSamlIdentityProviderId	String			The ID of the EnterpriseIdentityProvider object.
ResourcePath	String			The HTTP path for this enterprise.
Slug	String			The URL-friendly identifier for the enterprise.
Url	String			The HTTP URL for this enterprise.
ViewerIsAdmin	Bool			Is the current viewer an admin of this enterprise?
WebsiteUrl	String			The URL of the enterprise website.
MembershipType	String			Filter enterprises returned based on the user's membership type.
Login	String			The user's login.