Gemeenschappelijke queryvelden
query(required bij SQL connectors).maxRowsoptioneel.parameters(typed keyvalue).includeRequestParams/allowedRequestParams/requestParamMap.
Datasource reference
Connector field reference (per type)
Volledige connectorvelden zoals ze in de admin editor beschikbaar zijn. Gebruik deze pagina als technische referentie naast Datasources hub.
1. BigQuery
| Field | Control | Required | Beschrijving |
|---|---|---|---|
description | text | No | Human-friendly omschrijving. |
serviceAccountKey | textarea(JSON) | No | Service account key override. |
projectId | text | No | Project override voor querycontext. |
billingProject | text | No | Billing project voor kostenallocatie. |
query | textarea | Yes | SQL query. |
defaultDataset | text | No | Dataset voor onvolledig gekwalificeerde tabellen. |
location | text | No | BigQuery locatie. |
maximumBytesBilled | number | No | Kostenlimiet per job. |
priority | select | No | INTERACTIVE of BATCH. |
useLegacySql | toggle | No | Legacy SQL mode. |
dryRun | toggle | No | Alleen valideren, niet uitvoeren. |
labels | keyvalue | No | Job labels. |
2. Firestore
| Field | Control | Required | Beschrijving |
|---|---|---|---|
description | text | No | Omschrijving. |
projectId | text | No | Project override. |
databaseId | text | No | Firestore database id. |
serviceAccountKey | textarea(JSON) | No | Service account key override. |
documentPath | text | No | Single document target. |
collectionPath | text | No | Collection list target. |
includeDocumentId | toggle | No | Doc ID opnemen in output. |
select | list | No | Te selecteren velden. |
filters | textarea(JSON) | No | Statische filterarray. |
requestFilters | textarea(JSON) | No | Mapping van request params naar Firestore filters. |
orderBy | textarea(JSON) | No | Sortering definitie. |
limit | number | No | Max aantal records. |
offset | number | No | Offset. |
3. MongoDB
| Field | Control | Required | Beschrijving |
|---|---|---|---|
description | text | No | Omschrijving. |
uri | text | Yes | Connection URI. |
database | text | Yes | Database naam. |
collection | text | Yes | Collection naam. |
clientOptions | textarea(JSON) | No | Extra Mongo client opties. |
query | textarea(JSON) | No | find() filter. |
projection | textarea(JSON) | No | Kolomprojectie. |
sort | textarea(JSON) | No | Sortering. |
skip, limit | number | No | Paginering. |
maxTimeMs | number | No | Query timeout. |
requestFilters | textarea(JSON) | No | Dynamische filters op request params. |
pipeline | textarea(JSON) | No | Aggregatie pipeline. |
requestStages | textarea(JSON) | No | Aanvullende stages op basis van request. |
4. SQL connectorfamilie
MySQL, Postgres, SQL Server, Firebird en Snowflake volgen hetzelfde patroon: connection + query + parameters + optionele session settings.
Session/advanced velden
- MySQL:
maxExecutionTimeMs. - Postgres:
role,searchPath,statementTimeoutMs,sessionSettings. - Snowflake:
sessionParametersen connectie-specifieke auth velden. - SQL Server:
timeoutSeconds,queryTimeoutSeconds,tdsVersion,useMars.
| Connector | Belangrijkste connection fields | Specifieke aanvullingen |
|---|---|---|
| Firebird | connection.dsn of host/port/database/user/password | connection.role, connection.charset, connection.timeoutSeconds. |
| MySQL | connection.host, connection.port, connection.user, connection.database | connection.charset, connection.unixSocket, connection.connectTimeoutSeconds. |
| Postgres | connection.connectionString of host/port/user/password/database | connection.sslmode, applicationName, targetSessionAttrs. |
| SQL Server | connection.connectionString of host/port/database/user/password | connection.applicationName, connection.tdsVersion, connection.useMars. |
| Snowflake | connection.account, connection.user, connection.password | authenticator, private key settings, warehouse/schema/role, keep alive, session parameters. |
5. HTTP API connector
| Field | Control | Required | Beschrijving |
|---|---|---|---|
description | text | No | Omschrijving. |
timeoutSeconds | number | No | Connector-brede timeout. |
verifySsl | toggle | No | SSL certificaatcontrole. |
request.method | select | Yes | HTTP method. |
request.url | text | Yes | Endpoint URL. |
request.headers | keyvalue | No | Statische request headers. |
request.query | keyvalue(typed) | No | Statische query params. |
request.includeRequestQueryParams | toggle | No | Forward dashboard query params. |
request.allowedQueryParams | list | No | Allowlist forwarded params. |
request.requestQueryParamMap | keyvalue | No | Rename forwarded params. |
request.json | textarea(JSON) | No | JSON request body. |
request.data | textarea(JSON) | No | Form/multipart payload expressed as JSON. |
request.timeoutSeconds | number | No | Request-level timeout override. |
request.allowRedirects | toggle | No | Follow redirects. |
request.clientCert | textarea(JSON) | No | Client cert config. |
request.httpVersion | text | No | e.g. http1/http2. |
oauth.* | mixed | No | Token URL, grantType, client credentials, scope/audience/resource, header overrides en extra params. |
response.type | select | Yes | json of csv. |
response.recordsPath | text | No | Pad naar records-array in JSON response. |
response.wrapField | text | No | Wrapper voor non-object responsen. |
response.delimiter | text | No | CSV delimiter. |
6. Element connector
| Field | Control | Required | Beschrijving |
|---|---|---|---|
description | text | No | Omschrijving. |
elementId | text | Yes | Doel element ID. |
elementVersion | text | No | Leeg = latest published versie. |
elementEntrypoint | text | No | Functienaam, meestal run. |
elementTimeoutSeconds | number | No | Execution timeout. |
elementParams | keyvalue(typed) | No | Statische params per run. |
includeRequestQueryParams | toggle | No | Forward dashboard params naar element. |
allowedRequestParams | list | No | Allowlist forwarded params. |
requestParamMap | keyvalue | No | Rename inkomende params voor element call. |
7. Uplink connector
| Field | Control | Required | Beschrijving |
|---|---|---|---|
description | text | No | Omschrijving. |
type=uplink | fixed | Yes | Connector type voor Uplink parquet views. |
dataFormat=parquet-remote-view | default | Auto | Standaard formaat voor Uplink. |