{"resource_type":{"id":132,"name":"ms_sql_server","schema":"{\n\t\"$schema\": \"https://json-schema.org/draft/2020-12/schema\",\n\t\"order\": [\n\t\t\"host\",\n\t\t\"user\",\n\t\t\"password\",\n\t\t\"aad_token\",\n\t\t\"port\",\n\t\t\"dbname\",\n\t\t\"instance_name\",\n\t\t\"trust_cert\",\n\t\t\"ca_cert\"\n\t],\n\t\"properties\": {\n\t\t\"aad_token\": {\n\t\t\t\"description\": \"AAD token for authentication\",\n\t\t\t\"format\": \"resource-azure_oauth\",\n\t\t\t\"nullable\": true,\n\t\t\t\"type\": \"object\"\n\t\t},\n\t\t\"ca_cert\": {\n\t\t\t\"default\": \"\",\n\t\t\t\"description\": \"CA certificate in PEM format for verifying the server identity. Only needed if the certificate used by the server is not in the workers's trust store.\",\n\t\t\t\"pattern\": \"^(-----BEGIN CERTIFICATE-----\\\\s+([A-Za-z0-9+/=\\\\s]+?)-----END CERTIFICATE-----)?$\",\n\t\t\t\"type\": \"string\"\n\t\t},\n\t\t\"dbname\": {\n\t\t\t\"default\": \"\",\n\t\t\t\"description\": \"\",\n\t\t\t\"type\": \"string\"\n\t\t},\n\t\t\"host\": {\n\t\t\t\"default\": \"\",\n\t\t\t\"description\": \"\",\n\t\t\t\"type\": \"string\"\n\t\t},\n\t\t\"instance_name\": {\n\t\t\t\"default\": \"\",\n\t\t\t\"description\": \"\",\n\t\t\t\"type\": \"string\"\n\t\t},\n\t\t\"password\": {\n\t\t\t\"default\": \"\",\n\t\t\t\"description\": \"\",\n\t\t\t\"type\": \"string\"\n\t\t},\n\t\t\"port\": {\n\t\t\t\"description\": \"\",\n\t\t\t\"type\": \"number\"\n\t\t},\n\t\t\"trust_cert\": {\n\t\t\t\"default\": true,\n\t\t\t\"description\": \"Trust any certificate presented by the server\",\n\t\t\t\"type\": \"boolean\"\n\t\t},\n\t\t\"user\": {\n\t\t\t\"default\": \"\",\n\t\t\t\"description\": \"\",\n\t\t\t\"type\": \"string\"\n\t\t}\n\t},\n\t\"required\": [\n\t\t\"host\",\n\t\t\"dbname\"\n\t],\n\t\"type\": \"object\"\n}","approved":true,"app":"ms_sql_server","description":"Microsoft SQL Server resource. Either user/password or AAD token authentication can be used.","created_by":"hugo697","created_at":"2023-11-10T09:58:45.099Z"}}