I have a .zip file (305MB) that has a single compressed CSV file (5GB uncompressed) that I'd like to use as a data source for an External Table in my ATP Free Tier (19c) database.
The file is in an OCI (Free Tier) Object Bucket.
I can get dbms_cloud to create External Tables for uncompressed files in a Bucket. It's the compressed version I'm wondering about
Options
- If the database was local (eg 23.3c FREE), I'd use a PreProcessor. (I don't think this is available on ATP)
- Docs state that
dbms_cloud supports gzip compressed file and it specifically states “ZIP archiving format is not supported.”
- 5GB is well under 20GB limit for Free Tier. (physical table is an option of last resort)
QUESTIONS
- Am I missing any available technologies to create an ET out of this zip file?
- Should I convert to gzip? or just load the data directly into a physical table?
I'm looking for the least amount of processing steps that allows automating (ie script) in the future which consumes the least amount of my 20GB ATP limit.