Ok, I think I figured some of it out, in the expression builder, this works
"select * from c where c._ts > 1710423660"
I create a parameter and map it to various variables, they all give errors
"select * from c where c._ts > $parameter1"
This validates in as an expression, but when I try and import the schema I get this:
{"innerErrorMessage":"null","cosmosDiagnostics":{"userAgent":"azsdk-java-cosmos/4.42.0-snapshot.1 Linux/4.15.0-1175-azure JRE/1.8.0_402 SparkConnector/azure-cosmos-spark_3-1_2-12/4.17.2|SYN|dfdebugpool-canadacentral|debugpool-8Cores-General-21|7976@vm-f5485468","activityId":"1ee27087-c5cb-4931-93e5-ce231024b910","requestLatencyInMs":223,"requestStartTimeUTC":"2024-04-30T16:36:27.452Z","requestEndTimeUTC":"2024-04-30T16:36:27.675Z","responseStatisticsList":[{"storeResult":{"storePhysicalAddress":"rntbd://cdb-ms-prod-australiacentral1-be12.documents.azure.com:14010/apps/4b626f38-121e-41de-8eb7-a0288e0c953e/services/84750cb0-bc12-4ef2-91b9-2355e93c3b91/partitions/3fae389f-7b54-4971-a5df-ab213506095c/replicas/133579598729731764s/","lsn":10520,"globalCommittedLsn":10519,"partitionKeyRangeId":"0","isValid":true,"statusCode":400,"subStatusCode":0,"isGone":false,"isNotFound":false,"isInvalidPartition":false,"isThroughputControlRequestRateTooLarge":false,"requestCharge":1.0,"itemLSN":-1,"sessionToken":"0:-1#10520","backendLatencyInMs":19.502,"retryAfterInMs":null,"exceptionMessage":"null","exceptionResponseHeaders":"{x-ms-last-state-change-utc=Fri, 19 Apr 2024 00:24:38.699 GMT, x-ms-request-duration-ms=19.502, x-ms-session-token=0:-1#10520, lsn=10520, x-ms-request-charge=1.00, x-ms-schemaversion=1.17, x-ms-transport-request-id=10, x-ms-number-of-read-regions=0, x-ms-resource-usage=documentSize=0;documentsSize=210;documentsCount=3;collectionSize=210;, x-ms-resource-quota=documentSize=51200;documentsSize=52428800;documentsCount=-1;collectionSize=52428800;, x-ms-activity-id=1ee27087-c5cb-4931-93e5-ce231024b910, x-ms-xp-role=2, x-ms-global-Committed-lsn=10519, x-ms-documentdb-partitionkeyrangeid=0, x-ms-cosmos-llsn=10520, x-ms-serviceversion= version=2.14.0.0}","replicaStatusList":["14010:Connected","14303:Connected","14011:Connected","14320:Connected"],"transportRequestTimeline":[{"eventName":"created","startTimeUTC":"2024-04-30T16:36:27.454Z","durationInMilliSecs":0.0},{"eventName":"queued","startTimeUTC":"2024-04-30T16:36:27.454Z","durationInMilliSecs":0.0},{"eventName":"channelAcquisitionStarted","startTimeUTC":"2024-04-30T16:36:27.454Z","durationInMilliSecs":1.0},{"eventName":"pipelined","startTimeUTC":"2024-04-30T16:36:27.455Z","durationInMilliSecs":2.0},{"eventName":"transitTime","startTimeUTC":"2024-04-30T16:36:27.457Z","durationInMilliSecs":217.0},{"eventName":"decodeTime","startTimeUTC":"2024-04-30T16:36:27.674Z","durationInMilliSecs":1.0},{"eventName":"received","startTimeUTC":"2024-04-30T16:36:27.675Z","durationInMilliSecs":0.0},{"eventName":"completed","startTimeUTC":"2024-04-30T16:36:27.675Z","durationInMilliSecs":0.0}],"rntbdRequestLengthInBytes":547,"rntbdResponseLengthInBytes":472,"requestPayloadLengthInBytes":89,"responsePayloadLengthInBytes":472,"channelStatistics":{"channelId":"c590194e","channelTaskQueueSize":0,"pendingRequestsCount":0,"lastReadTime":"2024-04-30T16:33:45.566Z","waitForConnectionInit":false},"serviceEndpointStatistics":{"availableChannels":1,"acquiredChannels":0,"executorTaskQueueSize":0,"inflightRequests":1,"lastSuccessfulRequestTime":"2024-04-30T16:26:53.159Z","lastRequestTime":"2024-04-30T16:33:45.346Z","createdTime":"2024-04-30T16:23:34.126Z","isClosed":false,"cerMetrics":{}}},"requestResponseTimeUTC":"2024-04-30T16:36:27.675Z","requestStartTimeUTC":"2024-04-30T16:36:27.454Z","requestResourceType":"Document","requestOperationType":"Query","requestSessionToken":null,"e2ePolicyCfg":null,"excludedRegions":null}],"supplementalResponseStatisticsList":[],"addressResolutionStatistics":{},"regionsContacted":["australia central"],"retryContext":{"statusAndSubStatusCodes":null,"retryLatency":0,"retryCount":0},"metadataDiagnosticsContext":{"metadataDiagnosticList":null},"serializationDiagnosticsContext":{"serializationDiagnosticsList":null},"gatewayStatisticsList":[],"samplingRateSnapshot":1.0,"systemInformation":{"usedMemory":"1224928 KB","availableMemory":"18348832 KB","systemCpuLoad":"(2024-04-30T16:35:58.925Z 10.8%), (2024-04-30T16:36:03.925Z 22.7%), (2024-04-30T16:36:08.925Z 10.2%), (2024-04-30T16:36:13.925Z 7.7%), (2024-04-30T16:36:18.925Z 15.1%), (2024-04-30T16:36:23.925Z 16.4%)","availableProcessors":4},"clientCfgs":{"id":1,"machineId":"uuid:32e35acb-c22a-4d70-b093-ddc8ef216862","connectionMode":"DIRECT","numberOfClients":1,"excrgns":"[]","clientEndpoints":{"https://cnx-cosmosdb-aus-dev.documents.azure.com:443/":2},"connCfg":{"rntbd":"(cto:PT10S, nrto:PT10S, icto:PT0S, ieto:PT1H, mcpe:130, mrpc:30, cer:true)","gw":"(cps:1000, nrto:PT1M, icto:PT1M, p:false)","other":"(ed: true, cs: false, rv: true)"},"consistencyCfg":"(consistency: Eventual, mm: true, prgns: [])","proactiveInitCfg":"","e2ePolicyCfg":"","sessionRetryCfg":""}}}