Swap data model sources

View as MarkdownOpen in Claude
Swap the data sources used by a data model. You can swap from one connection to another, and/or from one dataset or table to another. ### Usage notes - Retrieve the **dataModelId** by calling the [/v2/dataModels](https://help.sigmacomputing.com/reference/list-data-models) endpoint. - Retrieve the **connectionId** by calling the [/v2/connections](https://help.sigmacomputing.com/reference/list-connections) endpoint. - To map the sources of a specific element, you can use the table or dataset ID: - List sources of data model by calling the [/v2/dataModels/{dataModelId}/sources](https://help.sigmacomputing.com/reference/list-data-model-sources) endpoint. - Retrieve table and dataset IDs by calling the [/v2/files](https://help.sigmacomputing.com/reference/list-files) endpoint. Use the `typeFilters` option to filter for table and dataset files. Use `id` field in the response as the `fromId` or `toId`, as relevant. - To swap all tables in a connection, set the `swapTables` option to `true`. - Use the `paths` option to specify the connection paths to swap. The connection path is a list of strings that represents the path to the table in the cloud data warehouse. For example, `["database", "schema", "table"]`. - If the table schema is the same in both connections, leave the `paths` option empty to swap all tables in the connection. You can also pass a partial path to swap between databases, catalogs, or schemas. - If `sourceMapping` is provided, those mappings take precedence over the connection swaps. - If `swapTables` is not set to `true`, only Custom SQL elements have their connections changed. ### Usage scenarios - **Data model development**: Use a test data source while developing a data model, then swap the source to a production database when ready to share the data model for production use.

Authentication

AuthorizationBearer

OAuth authentication of the form <token>.

Path parameters

dataModelIdstringRequired

Request

The request body.
sourceMappinglist of objectsOptional
connectionMappinglist of objectsOptional
copyInputTableDatabooleanOptional

Response

The response body.
unswappedSourceslist of strings
IDs of sources in the workbook that were not swapped.
unswappedConnectionslist of strings
IDs of custom SQL connections in the workbook that were not swapped.