Solved
API Endpoint for a List of Connections
Hi SiSense Community, Is there a REST API endpoint that will list down all the connections along with their oid? For some reason, 'api/v1/connection' endpoint doesn't show the Snowflake connection ...
Forum Discussion
Hi DRay
It's a live connection to Snowflake, and I have successfully published it.
The reason for this is that I'm currently working with multiple instances (say, instance A and instance B) that have the same:
- project_name
- branch_name
- datamodel (which also has the same schema and live connection name)
When I move from instance A to instance B, I have to manually reconfigure the datamodel connection (as its connection oid for different instances is not the same) in the SiSense app for the datamodel to work. Checking to see if I can change the datamodel's connection via. REST API (per this instruction) which might require the connection metadata.
Regards
Hi DRay,
Thanks for referring me to the PATCH /datamodels/{datamodelId}/schema/datasets/{datasetId} endpoint.
With that endpoint, can we switch the connection of the datamodel to the existing one?
When using the following body payload, the endpoint created a new connection named SnowflakeJDBC -Snowflake..., and the datamodel is connecting to it instead of the existing connection named Snowflake (as shown in the attached screenshot).
{ "name": "Snowflake", "type": "live", "connection": { "provider": "SnowflakeJDBC", "parameters": {}, "schema": "null", "fileName": "null", "uiParams": {}, "globalTableConfigOptions": {} } }There is an easier way to manage the connections. You can turn on connection management through Admin/feature management (https://docs.sisense.com/main/SisenseLinux/about-connecting-sisense-with-data-sources.htm).
Once connection management is turned on (wait about 10 minutes the first time for the system to upgrade the existing connections) you can then use the v2 connection-rest-controller API methods. This feature has been available since L2023.7Attached is a screen shot of the API methods
