The table below lists features supported by the different destinations that Data Connect syncs to, which are as follows:
Note for VPC users:
Cross-region VPC is not supported. Contentsquare syncs from AWS s3 us-east-1. For more information, see Amazon’s documentation on working with VPC endpoints.
| Redshift | BigQuery | Snowflake | S3 | Databricks | |
| Supported sync frequency | Once every 24 hours | Once every 24 hours | Once every 24 hours | Once every 24 hours | Once every 24 hours |
| Segment syncing | Supported | Not supported | Supported | Not supported | Not supported |
| Defined Properties syncing | Supported | Supported** | Supported | Supported | Not Supported |
| User migrated syncing | Supported | Supported | Supported | Supported | Supported |
| User migration applied on tables | Automatic | Automatic | Automatic | Manually applied* | Automatic |
We don't currently sync Initial User properties downstream in Data Connect (ex: Initial Marketing Channel, Initial Browser).
*Requires manual application of identity resolution queries.
**We do not include defined properties on the built-in pageviews or sessions tables