Scalar types define the basic data types used for individual fields or arguments in a GraphQL schema.
Data Connect Generated
scalar BasicTable_KeyOutput
✨ BasicTable_KeyOutput
returns the primary key fields of table type BasicTable
.
It has the same format as BasicTable_Key
, but is only used as mutation return value.
scalar JoinTable_KeyOutput
✨ JoinTable_KeyOutput
returns the primary key fields of table type JoinTable
.
It has the same format as JoinTable_Key
, but is only used as mutation return value.
scalar LeftTable_KeyOutput
✨ LeftTable_KeyOutput
returns the primary key fields of table type LeftTable
.
It has the same format as LeftTable_Key
, but is only used as mutation return value.
scalar ManyTable_KeyOutput
✨ ManyTable_KeyOutput
returns the primary key fields of table type ManyTable
.
It has the same format as ManyTable_Key
, but is only used as mutation return value.
scalar MaybeTable_KeyOutput
✨ MaybeTable_KeyOutput
returns the primary key fields of table type MaybeTable
.
It has the same format as MaybeTable_Key
, but is only used as mutation return value.
scalar OneTable_KeyOutput
✨ OneTable_KeyOutput
returns the primary key fields of table type OneTable
.
It has the same format as OneTable_Key
, but is only used as mutation return value.
scalar RightTable_KeyOutput
✨ RightTable_KeyOutput
returns the primary key fields of table type RightTable
.
It has the same format as RightTable_Key
, but is only used as mutation return value.
Data Connect Defined
scalar Any
The Any
scalar represents any valid JSON value.
It can be an object, array, string, number, or boolean. Caution: JSON doesn't distinguish Int and Float.
In the PostgreSQL table, it's stored as jsonb
.
scalar Any_Expr
A Common Expression Language (CEL) expression whose return type is unspecified.
Limitation: Only a limited set of expressions are currently supported for each
type. For the type XXX
, refer to the @fdc_example
directives on XXX_Expr
for the complete list of supported expressions.
scalar Any_SQL
A PostgreSQL value expression whose return type is unspecified.
scalar Boolean_Expr
A Common Expression Language (CEL) expression that returns a boolean at runtime.
This expression can reference the auth
variable, which is null when Firebase
Auth is not used. When Firebase Auth is used, the following fields are available:
- `auth.uid`: The current user ID.
- `auth.token`: A map containing all token fields (e.g., claims).
scalar Date
Date is a string in the YYYY-MM-DD format representing a local-only date.
See the description for Timestamp for range and limitations.
As a FDC-specific extension, inputs that includes time portions (as specified by the Timestamp scalar) are accepted but only the date portion is used. In other words, only the part before "T" is used and the rest discarded. This effectively truncates it to the local date in the specified time-zone.
Outputs will always be in the canonical YYYY-MM-DD format.
In the PostgreSQL table, it's stored as date
.
scalar Date_Expr
A Common Expression Language (CEL) expression that returns a Timestamp at runtime, which is then truncated to UTC date only. The time-of-day parts are discarded.
Limitation: Right now, only a few expressions are supported. Those are listed using the @fdc_example directive on this scalar.
scalar Int64
Int64
is a scalar that represents a 64-bit signed integer.
In the PostgreSQL table, it's stored as bigint
.
On the wire, it's encoded as string because 64-bit integer exceeds the range of JSON number.
scalar String_Expr
A Common Expression Language (CEL) expression that returns a string at runtime.
Limitation: Currently, only a limited set of expressions are supported. These are
listed with the @fdc_example
directive on this scalar.
scalar Timestamp
Timestamp is a RFC 3339 string that represents an exact point in time.
The serialization format follows https://scalars.graphql.org/andimarek/date-time except the "Non-optional exact milliseconds" Section. As a FDC-specific extension, inputs and outputs may contain 0, 3, 6, or 9 fractional digits.
Specifically, output precision varies by server-side factors such as data source support and clients must not rely on an exact number of digits. Clients may truncate extra digits as fit, with the caveat that there may be information loss if the truncated value is subsequently sent back to the server.
FDC only supports year 1583 to 9999 (inclusive) and uses the ISO-8601 calendar system for all date-time calculations. Notably, the expanded year representation (+/-YYYYY) is rejected and Year 1582 and before may either be rejected or cause undefined behavior.
In the PostgreSQL table, it's stored as timestamptz
.
scalar Timestamp_Expr
A Common Expression Language (CEL) expression that returns a Timestamp at runtime.
Limitation: Right now, only a few expressions are supported. Those are listed using the @fdc_example directive on this scalar.
scalar True
The True
scalar type only accepts the boolean value true
.
An optional field/argument typed as True
may either be set
to true
or omitted(not provided at all). The values false
or null
are not
accepted.
scalar UUID
UUID
is a string of hexadecimal digits representing an RFC4122-compliant UUID.
UUIDs are always output as 32 lowercase hexadecimal digits without delimiters or curly braces. Inputs in the following formats are also accepted (case insensitive):
`xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx`
`urn:uuid:xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx`
`{xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx}`
In the PostgreSQL table, it's stored as uuid
.
scalar UUID_Expr
A Common Expression Language (CEL) expression that returns a UUID string at runtime.
Limitation: Currently, only a limited set of expressions are supported. These are
listed using the @fdc_example
directive on this scalar.
scalar Vector
Vector is an array of single-precision floating-point numbers, serialized as a JSON array. All elements must be finite (no NaN, Infinity or -Infinity).
Example: [1.1, 2, 3.3]
scalar Vector_Embed_Model
The Vertex AI model version that is required in input Vector_Embed
.
It is recommended to use the latest stable model version: textembedding-gecko@003
.
Other available models include:
textembedding-gecko@001
text-embedding-004
View all supported Vertex AI Text embeddings APIs.
scalar Void
The Void
scalar type represents the absence of any value. It is typically used
in operations where no value is expected in return.
Built In
scalar Boolean
The Boolean
scalar type represents true
or false
.
scalar Float
The Float
scalar type represents signed double-precision fractional values as specified by IEEE 754.
scalar ID
The ID
scalar type represents a unique identifier, often used to refetch an object or as key for a cache. The ID type appears in a JSON response as a String; however, it is not intended to be human-readable. When expected as an input type, any string (such as "4"
) or integer (such as 4
) input value will be accepted as an ID.
scalar Int
The Int
scalar type represents non-fractional signed whole numeric values. Int can represent values between -(2^31) and 2^31 - 1.
scalar String
The String
scalar type represents textual data, represented as UTF-8 character sequences. The String type is most often used by GraphQL to represent free-form human-readable text.