We now use case-sensitive collation for string columns so that JOINs handle case correctly.
We now create column store indexes for all tables in Azure SQL Database. If column store indexing fails, you will be automatically notified that you need to upgrade the resource class of the user.
Azure recommends using Parquet files instead of CSVs, because they don’t interpret CSVs reliably. Fivetran will write your data to a Parquet file and upload it to Azure Blob Storage.
PostgreSQL on Azure Database is a managed relational cloud database service that can handle mission-critical workloads with predictable performance, security, high availability, and dynamic scalability.