Which of the following approaches can be used to ingest data directly from cloud-based object storage?
Which of the following approaches can be used to ingest data directly from cloud-based object storage?
To directly ingest data from cloud-based object storage, you can create an external table while specifying the object storage path to LOCATION. The LOCATION parameter allows you to point to an external storage location, such as AWS S3, where the data resides. This approach integrates external data with your database system, making it accessible for query and analysis without copying the data into the database's internal storage.
Agree with e
Create an external table while specifying the object storage path to LOCATION. While creating the external table we need to specify the location outside the managed storage location wherein data is stored. Below syntax is used to create external table assuming here cloud-based object storage as AWS S3. CREATE TABLE table1 LOCATION 's3://<bucket_path>/<table_directory>