SHOW RESOURCES

The SHOW RESOURCES statement displays a list of all resources, along with their data types, that are accessible via a named data connection. These are the resources for which you can create a mapping. Each type of data connection has a unique set of resources. For example:

  • A JDBC data connection returns a list of tables and views.

  • A Kafka data connection returns a list of topics.

  • A MongoDB data connection returns a list of collections.

Syntax Summary

SHOW RESOURCES FOR data_connection_name;

Parameters

The SHOW RESOURCES statement requires the data_connection_name parameter.

Parameter Description

data_connection_name

The unique name of an existing data connection.