AWS announces session reuse with HAQM Redshift Data API
Today, HAQM Redshift launches session reuse feature in Data API that enables you to access data efficiently from HAQM Redshift data warehouses by eliminating the need to manage database drivers, connections, network configurations, data buffering, and more. Data API session reuse allows you to retain the context of a session from one query execution to another, which reduces connection setup latency on repeated queries to the same data warehouse.
With session reuse, you can utilize session context on objects like variables or temporary tables, which you create once and use multiple times for various queries. This reduces the overall execution time for your queries. To reuse sessions, you must specify in seconds how long a session should be kept for after a query finishes and any subsequent queries can reference this session until the time expires, or it’s extended.
HAQM Redshift Data API session reuse is now generally available for both Redshift Provisioned and HAQM Redshift Serverless data warehouses in all AWS commercial and the AWS GovCloud (US) Regions which support Data API. To get started and learn more, visit HAQM Redshift database developers guide.