Support for parquet files with BI CC data dumps from SaaS
Organization Name (: Gemeente Rotterdam / City of Rotterdam
Description (Required): We have an external datawarehouse and need to export the data from SaaS to that datawarehouse. We currently use the BI CC programs to export the data in csv (zipped) to file storage and use dbms_cloud to read the files from there. However, BI CC only supports zip (not supported by dbms_cloud) and gzip.
We can use the gzip, but we would like the files to be parquet so we do not have to specify the schema in the create external table command.
Use Case and Business Need (Required):
Tagged:
2