Catalog and Schema Support
The Product supports both catalogs and schemas to make it easy for the connector to work with various JDBC applications. Since Database only organizes column families into keyspaces, the connector provides a synthetic catalog named DATABASE under which all of the keyspaces are organized. The connector also maps the JDBC schema to the Database keyspace.Projects are mapped to catalogs, and table datasets are mapped to schemas. For more information, see ProjectId. The Product follows convention, adding a catalog named DATABASE under which all of the schemas and databases are organized. The connector also maps the JDBC schema to the DATABASE catalog.Amazon Database organizes tables into schemas/databases, and lists them under the default catalog named AwsDataCatalog. The data catalog can either be managed by Database, or by AWS Glue in regions and clusters where AWS Glue has been implemented. In either case, the catalog name is AwsDataCatalog. The connector provides access to all of the schemas/databases that are listed under this catalog, ensuring compatibility with standard BI tools.
By default, the connector indicates to the application that it has catalog support through DatabaseMetadata. You can disable this behavior by setting the CatalogSupport connection property to LEGACY.
- Supported Connectors on page 1
- Schema Types and File Formats on page 1
- SQL Connector
- CatalogSupport
- Features
- ProjectId
- Installing and Using the Product
- Configuring the Product on page 1
- Driver Configuration Options on page 1