Differences in GraphQL schema between local environment and Azure in a static web app

[cwineman-roadid]

We are having an issue using GraphQL with data-api-builder on a static web app. The issue is that the data types for what is returned from introspection do not match between the what runs locally using the CLI and what's hosted in Azure. The result is that a mutation query that works in our local environement doesn't work in Azure.

The main data type difference seems to be that locally UUID works, but in the Azure hosted app, everything that is marked as UUID! locally comes up as a String! in Azure. There are likely other differences as well.

I'm not sure of the best way to trouble-shoot this. Below I'll provide the response to both our local and Azure-hosted app for a schema introspection query:

query IntrospectionQuery {
  __schema {
    types {
      name
      description
      kind
      fields {
        name
        description
        type {
          name
          kind
        }
      }
    }
  }
}

Snippets from the schema introspection query on our local environment.

Parameter definition:

//Other stuff above....
},
{
	"name": "ProfileID",
	"description": null,
	"type": {
		"name": "UUID",
		"kind": "SCALAR"
	}
},
//Other stuff below....

Scalar Types:

//Other stuff above....
				},
				{
					"name": "ByteArray",
					"description": null,
					"kind": "SCALAR",
					"fields": null
				},
				{
					"name": "LocalTime",
					"description": "LocalTime is an immutable struct representing a time of day, with no reference to a particular calendar, time zone or date.",
					"kind": "SCALAR",
					"fields": null
				},
				{
					"name": "UUID",
					"description": null,
					"kind": "SCALAR",
					"fields": null
				}
			]
		}
	}
}
//EOF

Snippets from the schema introspection query on our Azure environment.

Parameter definition: note that UUID has been changed to String

//Other stuff above....
},
{
	"name": "ProfileID",
	"description": null,
	"type": {
		"name": "String",
		"kind": "SCALAR"
	}
},
//Other stuff below....

Scalar Types: note that both LocalTime and UUID are missing

//Other stuff above....
				},
				{
					"name": "ByteArray",
					"description": null,
					"kind": "SCALAR",
					"fields": null
				}
			]
		}
	}
}
//EOF

staticwebapp.database.config.json

Below is what I think are the relevant portions of our staticwebapp.database.config.json file. As best I can tell, the file up in Azure is the same as what is being used locally.

{
  "$schema": "https://github.com/Azure/data-api-builder/releases/latest/download/dab.draft.schema.json",
  "data-source": {
    "database-type": "mssql",
    "options": {
      "set-session-context": true
    },
    "connection-string": "@env('OURPROJECT_SQL_CONNECTION_STRING')"
  },
  "runtime": {
    "rest": {
      "enabled": true,
      "path": "/rest"
    },
    "graphql": {
      "allow-introspection": true,
      "enabled": true,
      "path": "/graphql"
    },
    "host": {
      "mode": "production",
      "cors": {
        "origins": [
          "http://localhost:4280",
          "https://azure-created-name-preview.eastus2.3.azurestaticapps.net",
          "https://dev.ourproject.com"
        ],
        "allow-credentials": false
      },
      "authentication": {
        "provider": "StaticWebApps"
      }
    }
  },
  "entities": {....
  // Other stuff below

If anyone could help me understand why this is happening it would be appreciated.

-Corey