Which datatypes are supported?
Here's the list of data types supported.
Notes:
- REPEATED columns are marked as multivalued fields in Syncari
- Datatypes that are not in this table are treated as strings
| BigQuery Data Type | Syncari Data type | Notes |
| BOOL | boolean | null values are not translated and returned as null |
| INT64 | integer | |
| FLOAT64 | number | Numbers in Syncari accommodate double values |
| FLOAT | number | |
| NUMERIC | number | |
| TIMESTAMP | timestamp | |
| DATE | date | |
| ARRAY | list | |
| STRING | string |
What does Syncari require to access data in tables?
To sync with database tables, Syncari needs to be able to identify each individual record and know if that record was modified since the last sync. To ensure that happens, every database table that you connect to Syncari must include:
- A primary key that uniquely identifies each record. The primary key must be required for each record.
- A DATETIME or TIMESTAMP field that identifies when the record was created or updated. Syncari uses the field as a watermark to identify when the record was last updated. This must be populated upon creation and must be populated at the current date and time of modification.
Why am I getting errors that UPDATE and DELETE would affect rows in the streaming buffer?
Recent row additions within the last 90 minutes cannot be modified with UPDATE, DELETE, or MERGE statements. All other rows in the table remain modifiable by using UPDATE, DELETE, or MERGE statements. See more in the BigQuery documentation.
We suggest scheduling the sync cycle for no less than 90 minute intervals. For more information, see Sync Scheduling.
Are spaces in my Table or Column names supported?
Although BigQuery allows for creating Tables/Columns with spaces included in their names, this is not supported for use with Syncari. Please rename your Tables/Columns and exclude the use of spaces.
Related to