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. File connector
| Field | Control | Required | Beschrijving |
|---|---|---|---|
type=file | fixed | Yes | Connector type voor geuploade bronbestanden. |
files | upload list | Praktisch yes | Metadata van geuploade bestanden. De editor vult dit via uploadacties; je beheert deze lijst normaal niet handmatig in JSON. |
bucket | text/implicit | No | Override van de GCS bucket voor uploads. Standaard gebruikt Dashview de tenant file bucket. |
fileFormat | select | No | auto, csv, tsv, psv, json, ndjson, parquet, logfmt, apache_common, apache_combined of lines. |
encoding | text | No | Tekstencoding, standaard utf-8. |
delimiter | text | No | Delimiter override voor delimited bestanden. Vooral nuttig wanneer auto-detect niet betrouwbaar genoeg is. |
header | toggle | No | Geeft aan of delimited bestanden een header row hebben. |
recordsPath | text | No | Pad naar de records-array in JSON payloads. |
wrapField | text | No | Fallback veldnaam voor non-object JSON/NDJSON waarden. |
includeFileMetadataColumns | toggle | No | Voegt helperkolommen toe zoals __file_id, __file_name, __file_path en __file_format. |
- Upload gebeurt pas nadat de datasource zelf is opgeslagen; je maakt dus eerst de datasource-doc en daarna de bestandsset.
- Meerdere uploads worden samengevoegd tot één datasource-resultaat. Kolommen mogen dus per bestand verschillen.
- Gebruik na wijzigingen aan de uploadset opnieuw Refresh schema en indien nodig Parquet refresh.
7. 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. |
8. 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. |