-
Notifications
You must be signed in to change notification settings - Fork 24
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Example of Loading external, publicly available CSV to a table in Oracle Autonomous Database #3
Comments
Hi Luca This is something I haven't done in an Autonomous DB - so I cannot really help you. I guess, you'll have to first import the CSV into an object store and then use DBMS_CLOUD.COPY_DATA to import the CSV into the table. Best / Rene |
Dear Rene, I have some kind of progress which I describe here https://stackoverflow.com/a/76151972/17733194 but it triggers a follow up question. |
Dear @ReneNyffenegger by the help of a generous supporter I've learned that
works.
woudn't. |
@lucaboesch, thanks for the feedback, it is greatly appreciated! Is it possible that your CSV does not work because the column names (as per header) contain spaces? Best Rene |
Wow, they were supposed to have underscores instead of whitespace.
it wouldn't work. |
Hi René
I know that might be asked too much but I was wondering if you had an example on how to achieve to load an publicly available external CSV (think for example https://www.web.statistik.zh.ch/ogd/daten/ressourcen/KTZH_00002063_00004104.csv) into a table that is inside a Oracle Autonomous Database.
Searching for hours. Seems well covered with tutorials when it's about Oracle cloud storage, Amazon S3, Azure Blob or GitHub, but not when it's about a simple CSV in a publicly available URL, strangely.
Best,
Luca
The text was updated successfully, but these errors were encountered: