SYSTEMPROVIDERSAMPLEQUERIES: Data Dictionary Provider Sample Queries
read only
- Catalog:
DataDictionary - Schema:
Invantive - Label: Provider Sample Queries
Sample queries per registered and licensed provider.
Can only retrieve data.
Table Columns
The columns of the table SYSTEMPROVIDERSAMPLEQUERIES are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
PROVIDER_ |
char |
Is Community Edition | Is application software offered for free? | ||
PROVIDER_ |
varchar2 |
Data Container Alias | Data container alias. | ||
PROVIDER_ |
varchar2 |
Data Container ID | Data container ID. | ||
PROVIDER_ |
varchar2 |
Provider Description | Provider description. | ||
PROVIDER_ |
varchar2 |
Documentation (URL) | Documentation URL. | ||
PROVIDER_ |
varchar2 |
Download Implementation URL | Download URL for implementation. | ||
PROVIDER_ |
varchar2 |
Functional Documentation URL | Functional documentation URL. | ||
PROVIDER_ |
varchar2 |
Functional Support Discord Community | Functional support discourse community. | ||
PROVIDER_ |
varchar2 |
Functional Support Email Address | Functional support email address. | ||
PROVIDER_ |
varchar2 |
Functional Support Phone Number | Functional support phone number. | ||
PROVIDER_ |
varchar2 |
Functional Support URL | Functional support URL. | ||
PROVIDER_ |
char |
Influences Maximum Number of Joins | Influences maximum number of joins? | ||
PROVIDER_ |
varchar2 |
Marketplace URL | URL of the marketplace containing integrations and add-ons. | ||
PROVIDER_ |
varchar2 |
Provider Name | Name of the provider. | ||
PROVIDER_ |
char |
Production Use Allowed | Is production use allowed? | ||
PROVIDER_ |
char |
Is Public Data? | Is the data offered publicly? | ||
PROVIDER_ |
varchar2 |
Provider Short Name | Provider short name. | ||
PROVIDER_ |
varchar2 |
Technical Documentation (URL) | Technical documentation URL. | ||
PROVIDER_ |
varchar2 |
Technical Support Discord Community | Technical support discourse community. | ||
PROVIDER_ |
varchar2 |
Technical Support Email Address | Technical support email address. | ||
PROVIDER_ |
varchar2 |
Technical Support Phone Number | Technical support phone number. | ||
PROVIDER_ |
varchar2 |
Technical Support URL | Technical support URL. | ||
PROVIDER_ |
guid |
Provider UID | Unique ID of the provider. | ||
SQL_ |
varchar2 |
Sample SQL Statement | Sample SQL statement. |
Keys
| Key | Column | Refers to | Kind | Description |
|---|---|---|---|---|
SYSTEMPROVIDERSAMPLEQUERIES_ |
PROVIDER_ |
SYSTEMPROVIDERS.NAME |
Key |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: