Integrating Amazon Redshift data sharing with business intelligence tools - Amazon Redshift

Integrating Amazon Redshift data sharing with business intelligence tools

To integrate data sharing with business intelligence (BI) tools, we recommend that you use the Amazon Redshift JDBC or ODBC drivers. You can also query the following system metadata views to view information about Amazon Redshift database objects.

  • These views include objects from the Amazon Redshift database that you are currently connected to. They also include objects from all the other databases that you have access to on the cluster, including the databases created from the datashares.

  • In addition, these views include external objects that you can query using Amazon Redshift Spectrum and federated queries as part of their respective databases. To see the full list of local cluster and consumer databases that Amazon Redshift uses to navigate these objects, use the SVV_REDSHIFT_DATABASES view.

  • You can also use the SVV_DATASHARE* system views to view metadata for datashares on any cluster. If you have explicitly created EXTERNAL SCHEMA references to schemas in other databases, Amazon Redshift also returns the objects in SVV_EXTERNAL* system views.

Amazon Redshift JDBC and ODBC drivers support the GetCatalogs API operation in the drivers, which returns the list of all databases including those created from datashares. The drivers also support downstream operations, such as GetSchemas, GetTables, and so on, that return data from all the databases that GetCatalogs returns. The drivers provide this support even when the catalog isn't explicitly specified in the call. For more information about JDBC or ODBC drivers, see Configuring connections in Amazon Redshift in the Amazon Redshift Management Guide.

You can't connect to consumer databases created from datashares directly. Connect to local databases on your cluster. If you have a connection switching user interface in your tool, the list of databases should include only the local cluster databases. The list should exclude consumer databases created from datashares to provide the best experience. You can use an option in the SVV_REDSHIFT_DATABASES view to filter databases.