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 |
boolean |
Is Community Edition |
☑ |
Is application software offered for free? |
PROVIDER_DATA_CONTAINER_ALIAS |
string(4000) |
Data Container Alias |
☐ |
Data container alias. |
PROVIDER_DATA_CONTAINER_ID |
string(4000) |
Data Container ID |
☐ |
Data container ID. |
PROVIDER_DESCRIPTION |
string(16000) |
Provider Description |
☑ |
Provider description. |
PROVIDER_DOCUMENTATION_URL |
string(4000) |
Documentation (URL) |
☐ |
Documentation URL. |
PROVIDER_DOWNLOAD_IMPLEMENTATION_URL |
string(4000) |
Download Implementation URL |
☐ |
Download URL for implementation. |
PROVIDER_INFLUENCES_MAXIMUM_NUMBER_JOINS |
boolean |
Influences Maximum Number of Joins |
☑ |
Influences maximum number of joins? |
PROVIDER_NAME |
string(240) |
Provider Name |
☑ |
Name of the provider. |
PROVIDER_PRODUCTION_USE_ALLOWED |
boolean |
Production Use Allowed |
☑ |
Is production use allowed? |
PROVIDER_PUBLIC_DATA |
boolean |
Is Public Data? |
☑ |
Is the data offered publicly? |
PROVIDER_SHORT_NAME |
string(240) |
Provider Short Name |
☑ |
Provider short name. |
PROVIDER_TECHNICAL_DOCUMENTATION_URL |
string(4000) |
Technical Documentation (URL) |
☐ |
Technical documentation URL. |
PROVIDER_UID |
guid |
Provider UID |
☑ |
Unique ID of the provider. |
SQL_STATEMENT |
string |
Sample SQL Statement |
☐ |
Sample SQL statement. |
18-10-2024 06:49 Version 24.0.345-PROD+4945