Updated October 31, 2023
This section describes the requirements, access privileges, and other features of Fivetran Local Data Processing when using SingleStore (formerly MemSQL) for replication.
For information about compatibility and supported versions of SingleStore with Local Data Processing platforms, see Supported Platforms.
For information about the supported data types and mapping of data types in source DBMS to the corresponding data types in target DBMS or file format, see Data Type Mapping.
For the character encodings supported by Local Data Processing on SingleStore, see the Character Encodings page.
SingleStore Server Time Zonelink
To use the timestamp data type in SingleStore database, the SingleStore server's time zone must be set to UTC or +00:00 using the default_time_zone configuration parameter. For more information about setting the time zone, refer to Setting the Time Zone in SingleStore documentation.
For example, to set the time zone to UTC on a host, run the command:
sdb-admin update-config --key default_time_zone --value "+00:00" --allcontent_copy
While updating a time zone on a host, it is required to update it identically on all hosts in the cluster and then the cluster must be restarted.