Create a datasource connection
POST {{baseUrl}}/api/datasources/connections
Create a datasource connection.
Request Params
| Key | Datatype | Required | Description |
|---|---|---|---|
fields | string | Comma-separated, top-level field whitelist that allows the client to selectively retrieve part of the response model. If specified, extra filtering is applied, and for top-level object (if root model is an array, each array element), only the listed fields are kept in the response. For example, "id,elements" keeps only the "id" field and whole "elements" array field, omitting all other fields in the top-level response model. |
Request Body
{"name"=>"Test_Snow_Connection", "description"=>"", "executionMode"=>"synchronous", "maxCancelAttemptTime"=>60, "maxQueryExeTime"=>0, "maxConnectionAttemptTime"=>60, "connectionLifetime"=>36000, "connectionIdleTimeout"=>60000, "charEncodingWindows"=>"multibyte", "charEncodingUnix"=>"utf8", "tablePrefix"=>"", "connectionString"=>"DSN=SNOWFLAKE_DSN", "parameterizedQueries"=>true, "extendedFetch"=>false, "database"=>{"login"=>{"id"=>"{{rd_datasourceLoginId}}", "name"=>"Test_snow_login"}, "type"=>"snow_flake", "version"=>"snowflake_1x"}, "driverType"=>"odbc", "oauthParameter"=>""}
HEADERS
| Key | Datatype | Required | Description |
|---|---|---|---|
X-MSTR-AuthToken | string | (Required) Authorization token | |
Content-Type | string |