AWS announces session reuse with Amazon Redshift Data API
Today, Amazon Redshift launches session reuse feature in Data API that enables you to access data efficiently from Amazon 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.
Amazon Redshift Data API session reuse is now generally available for both Redshift Provisioned and Amazon 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 Amazon Redshift database developers guide.