Feedback

Feedback

Did this article resolve your question/issue?

   

Article

Redshift ODBC driver support for Redshift Spectrum tables

Printable View

Information

 
TitleRedshift ODBC driver support for Redshift Spectrum tables
URL NameRedshift-ODBC-driver-support-for-Redshift-Spectrum-tables
Article Number000109996
EnvironmentProduct: Progress DataDirect for ODBC for Amazon Redshift driver
Version: 7.1, 8.0
OS: All supported platforms
Database Amazon Redshift Spectrum
Application: All ODBC applications
Question/Problem Description
Redshift ODBC driver support for Redshift Spectrum tables
Request to support external tables created through Redshift Spectrum with the DataDirect Redshift ODBC driver
Are there plans to support showing Redshift Spectrum tables through the SQLTables result set from the Redshift ODBC driver?  
Are there any limitations around support for Redshift Spectrum?
Steps to Reproduce
Clarifying Information
External tables created via Redshift Spectrum do not show up in the SQLTables call using the DataDirect Redshift ODBC driver 
Error Message
Defect NumberEnhancement
Enhancement Number
Cause
Resolution
The enhancement has been implemented. Upgrade to hot fix 07.16.0178 (B0480, U0335) and 08.00.0256 (B0492, U0342).

Refer to  "Progress DataDirect for ODBC hot fix download and install instructions" for instructions to download and install the hot fix.

Users have to link the clusters to the Spectrum service and create external tables for that service.
Once tables are created, these objects are treated as external tables. For the SQLTables(), the driver checks with the backend for any external schemas attached to this cluster (backend) , and if found, will retrieve those details as well along with regular tables.

There does not seem to be any limitations around the support for this feature. Please contact Progress DataDirect Technical Support to report any issues.
 
Workaround
Notes
References to other documentation:

Enhance SQLTables for Redshift ODBC driver to return information about Redshift Spectrum external tables. - DataDirect Connect - Products Enhancements - Progress Community
https://community.progress.com/community_groups/products_enhancements/i/datadirect_connect/enhance_sqltables_for_redshift_odbc_driver_to_return_information_about_redshift_spectrum_external_tables

Progress Article(s):
How to contact Progress DataDirect Technical support
 
Last Modified Date11/20/2020 6:58 AM
Files
Disclaimer The origins of the information on this site may be internal or external to Progress Software Corporation (“Progress”). Progress Software Corporation makes all reasonable efforts to verify this information. However, the information provided is for your information only. Progress Software Corporation makes no explicit or implied claims to the validity of this information.

Any sample code provided on this site is not supported under any Progress support program or service. The sample code is provided on an "AS IS" basis. Progress makes no warranties, express or implied, and disclaims all implied warranties including, without limitation, the implied warranties of merchantability or of fitness for a particular purpose. The entire risk arising out of the use or performance of the sample code is borne by the user. In no event shall Progress, its employees, or anyone else involved in the creation, production, or delivery of the code be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the sample code, even if Progress has been advised of the possibility of such damages.


Copyright © 2022 Progress Software Corporation and/or its subsidiaries or affiliates.
All Rights Reserved.

Progress, Telerik, Ipswitch, Chef, Kemp, Flowmon and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks for appropriate markings.

Terms of Use Privacy Center Security Center Trademarks License Agreements Code of Conduct Careers Offices
Do Not Sell My Personal Information