4 Querying External Data with Autonomous Database

Describes packages and tools to query and validate data with Autonomous Database.

External data is not managed by the database; however, you can use DBMS_CLOUD procedures to query your external data. Although queries on external data will not be as fast as queries on database tables, you can use this approach to quickly start running queries on your external source files and external data. Depending on the type of external table, you can validate external data using the DBMS_CLOUD validation procedures. The data validation procedures let you validate the source files for an external table so that you can identify problems and either correct the data in the external table or exclude invalid data before you use the data.

Note:

If you are not using ADMIN user, ensure the user has the necessary privileges for the operations the user needs to perform. See Manage User Privileges on Autonomous Database - Connecting with a Client Tool for more information.

Topics

• Query External Data

• Query External Data with ORC, Parquet, or Avro Source Files

• Query External Partitioned Data

• Query Hybrid Partitioned Data

• Query External Data Pump Dump Files

• Query Big Data Service Hadoop (HDFS) Data from Autonomous Database

• Validate External Data

• Validate External Partitioned Data

• Validate Hybrid Partitioned Data

• View Logs for Data Validation