Today, Amazon Redshift announced the launch of three new SQL features for zero-ETL integrations: QUERY_ALL_STATES, TRUNCATECOLUMNS, and ACCEPTINVCHARS. Zero-ETL integrations enable you to break down data silos in your organization and run timely analytics and machine learning (ML) on the data from your databases. With the launch of these new features, Amazon Redshift further enhances the functionality and reliability of zero-ETL integrations, allowing customers to work more efficiently with their data while maintaining data integrity.
The new SQL features provide significant benefits and further enhance the experience of using zero-ETL integrations. QUERY_ALL_STATES allows you to query tables in all states, including during updates, ensuring continuous data availability. TRUNCATECOLUMNS automatically truncates VARCHAR data that exceeds Amazon Redshift’s length limit, preventing replication errors and ensuring smoother data ingestion. ACCEPTINVCHARS enables you to replace invalid UTF-8 characters with a specified character of your choice, which is particularly useful when dealing with data from various sources that may contain non-standard characters. You can modify the existing integrations or create new ones using these features.
To learn more and get started with zero-ETL integration, visit the getting started guides for Amazon Redshift
. To learn more about these features, see the documentation
.