Api fabric to create cloud snowflake connection

[sandrabg]

I need create a connection cloud with snowflake but at the json configuration I need to put "creationMethod": but i don't know possible values.

{
"connectivityType": "ShareableCloud",
"displayName": "prueba_conex_snow_api_create",
"connectionDetails": {
"type": "Snowflake",
"creationMethod": "Snowflake",
"parameters": [
{
"dataType": "Text",
"name": "server",
"value": "xxxxxx.snowflakecomputing.com"
},
{
"dataType": "Text",
"name": "Almacen",
"value": "warehouse_xxx"
}
]
},
"privacyLevel": "Organizational",
"credentialDetails": {
"singleSignOnType": "None",
"connectionEncryption": "NotEncrypted",
"skipTestConnection": false,
"credentials": {
"credentialType": "Basic",
"username": "user",
"password": "xxxx"
}
}
}

I have the next error:

{
  "requestId": "73746291-9e58-41ef-ad27-2186a8bee0db",
  "errorCode": "InvalidConnectionDetails",
  "moreDetails": [
    {
      "errorCode": "DM_ErrorDetailNameCode_UnderlyingErrorMessage",
      "message": "No function found matching 'Snowflake' for Kind: 'Snowflake'."
    }
  ],
  "message": "The ConnectionDetails input provided is not valid"
}

[FabianSchut · Accepted solution]

There is another API call that shows all the connection specification methods available. You can find that API call here:
https://learn.microsoft.com/en-us/rest/api/fabric/core/connections/list-supported-connection-types?t.... The response I get for snowflake is as follows, which makes me think that you should use Snowflake.Databases as the creationMethod:

{
      "type": "Snowflake",
      "creationMethods": [
        {
          "name": "Snowflake.Databases",
          "parameters": [
            {
              "name": "server",
              "dataType": "Text",
              "required": true,
              "allowedValues": null
            },
            {
              "name": "warehouse",
              "dataType": "Text",
              "required": true,
              "allowedValues": null
            },
            {
              "name": "Role",
              "dataType": "Text",
              "required": false,
              "allowedValues": null
            },
            {
              "name": "CreateNavigationProperties",
              "dataType": "Boolean",
              "required": false,
              "allowedValues": null
            },
            {
              "name": "ConnectionTimeout",
              "dataType": "Number",
              "required": false,
              "allowedValues": null
            },
            {
              "name": "CommandTimeout",
              "dataType": "Number",
              "required": false,
              "allowedValues": null
            }
          ]
        }
      ],
      "supportedCredentialTypes": [
        "Basic",
        "OAuth2"
      ],
      "supportedConnectionEncryptionTypes": [
        "NotEncrypted"
      ],
      "supportsSkipTestConnection": false
    },