# SYSTEMPROVIDERSAMPLEQUERIES: Data Dictionary Provider Sample Queries Sample queries per registered and licensed provider. - Catalog: `DataDictionary` - Schema: `Invantive` - Alias: `psy` - Label: Provider Sample Queries This is a read-only view. The Data Dictionary API may not support changing the data or the Invantive UniversalSQL driver for Data Dictionary does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Data Dictionary API. ## View Columns The columns of the view `SYSTEMPROVIDERSAMPLEQUERIES` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `PROVIDER_COMMUNITY_EDITION` | `char` | Is Community Edition | ☑ | Is application software offered for free? | | `PROVIDER_DATA_CONTAINER_ALIAS` | `varchar2`(4000) | Data Container Alias | ☐ | Data container alias. | | `PROVIDER_DATA_CONTAINER_ID` | `varchar2`(4000) | Data Container ID | ☐ | Data container ID. | | `PROVIDER_DESCRIPTION` | `varchar2`(16000) | Provider Description | ☑ | Provider description. | | `PROVIDER_DOCUMENTATION_URL` | `varchar2`(4000) | Documentation (URL) | ☐ | Documentation URL. | | `PROVIDER_DOWNLOAD_IMPLEMENTATION_URL` | `varchar2`(4000) | Download Implementation URL | ☐ | Download URL for implementation. | | `PROVIDER_FUNCTIONAL_DOCUMENTATION_URL` | `varchar2`(4000) | | ☐ | Functional documentation URL. | | `PROVIDER_FUNCTIONAL_SUPPORT_DISCORD_COMMUNITY` | `varchar2`(60) | | ☐ | Functional support discourse community. | | `PROVIDER_FUNCTIONAL_SUPPORT_EMAIL_ADDRESS` | `varchar2`(60) | | ☐ | Functional support email address. | | `PROVIDER_FUNCTIONAL_SUPPORT_PHONE_NUMBER` | `varchar2`(60) | | ☐ | Functional support phone number. | | `PROVIDER_FUNCTIONAL_SUPPORT_URL` | `varchar2`(240) | | ☐ | Functional support URL. | | `PROVIDER_INFLUENCES_MAXIMUM_NUMBER_JOINS` | `char` | Influences Maximum Number of Joins | ☑ | Influences maximum number of joins? | | `PROVIDER_MARKETPLACE_URL` | `varchar2`(4000) | | ☐ | URL of the marketplace containing integrations and add-ons. | | `PROVIDER_NAME` | `varchar2`(240) | Provider Name | ☑ | Name of the provider. | | `PROVIDER_PRODUCTION_USE_ALLOWED` | `char` | Production Use Allowed | ☑ | Is production use allowed? | | `PROVIDER_PUBLIC_DATA` | `char` | Is Public Data? | ☑ | Is the data offered publicly? | | `PROVIDER_SHORT_NAME` | `varchar2`(240) | Provider Short Name | ☑ | Provider short name. | | `PROVIDER_TECHNICAL_DOCUMENTATION_URL` | `varchar2`(4000) | Technical Documentation (URL) | ☐ | Technical documentation URL. | | `PROVIDER_TECHNICAL_SUPPORT_DISCORD_COMMUNITY` | `varchar2`(60) | | ☐ | Technical support discourse community. | | `PROVIDER_TECHNICAL_SUPPORT_EMAIL_ADDRESS` | `varchar2`(60) | | ☐ | Technical support email address. | | `PROVIDER_TECHNICAL_SUPPORT_PHONE_NUMBER` | `varchar2`(60) | | ☐ | Technical support phone number. | | `PROVIDER_TECHNICAL_SUPPORT_URL` | `varchar2`(240) | | ☐ | Technical support URL. | | `PROVIDER_UID` | `guid` | Provider UID | ☑ | Unique ID of the provider. | | `SQL_STATEMENT` | `varchar2` | Sample SQL Statement | ☐ | Sample SQL statement. |