EXTERNAL TABLE

Creating a high available multi-region datalake with 2 Oracle databases and 2 replicated object storage buckets for purposes such as reporting, ML or AI | Part two (final)

IT by javier mugueta3 June, 20218 June, 2021

Creating a high available multi-region datalake with 2 Oracle databases and 2 replicated object storage buckets for purposes such as reporting, ML or AI | PART ONE

IT by javier mugueta27 May, 20213 June, 2021

Experiment Machine Learning with COVID-19 data and Oracle Autonomous Database Notebooks

IT by javier mugueta14 April, 20209 July, 2020

IT by javier mugueta18 November, 201918 November, 2019

Offloading Oracle Data to Object Storage and Loading as External Table in an Autonomous Database | Part 3: Oracle OCI Object Storage

Following up the posts here and here, we are explaining today how to make same thing using Oracle OCI Object Storage. The procedure and steps are quite similar so, let’s go and try! Steps Create a bucket Upload file to bucket Create an Auth Token for your user as follows: In a sql editor, execute […]

IT by javier mugueta12 November, 201912 November, 2019

Offloading Oracle Data to Object Storage and Mounting as External Table in an Autonomous Database | Part Two: AWS S3

Following up the previous post, we are explaining today how to make same thing using Amazon S3. The procedure and steps are quite similar, let’s go and try! Amazon side setup Create a S3 bucket with no public access: Upload datafile: Grab the object URL for later: Create a user in IAM: Grant access to […]