Can sql-developer read/import and export using Parquet, AVRO or ORC format?

User_4NH2K

I read that the cloud autonomous db can do that. Is that avail from within SQL-Developer and can the target db be an on-premise Oracle?

Would be interesting if i could then i can future proof my data engineering pipeline or part of and skill up for when we do migrate to cloud. Things like reading from excels or csv --> converting to Parquet/ORC/AVRO or vice-versa and/or directly reading and extracting using parquet etc. These can then be ready for cloud big data engines like those Spark/AI clusters (Oracle. AWS, Azure or DataBricks).

Philipp Salvisberg

I'm not aware of a SQLDev or SQLcl feature that can read/write these data formats.

However, I guess you are referring to external table feature via the DBMS_CLOUD package. It's part of the 19c database. Hence I guess you can use it also for on-premises databases. Maybe that's an option.

thatJeffSmith-Oracle

SQL Developer Web can, SQL Developer cannot...unless you do it via what DBMS_CLOUD provides as Philipp indicated.

Philipp Salvisberg

I'm not aware of a SQLDev or SQLcl feature that can read/write these data formats.

However, I guess you are referring to external table feature via the DBMS_CLOUD package. It's part of the 19c database. Hence I guess you can use it also for on-premises databases. Maybe that's an option.

thatJeffSmith-Oracle

SQL Developer Web can, SQL Developer cannot...unless you do it via what DBMS_CLOUD provides as Philipp indicated.