Write Data to AWS S3/Parquet file (9.4m7)

[MRDM]

Hi, we've got a split economy with our infrastructure. A lot of our data is processed via SAS and loaded into SQL DB's, we also have a lot of users/data on AWS/Databricks. I've been tasked with seeing if we can get our SAS Environment to also load the data into our AWS Environment ideally as par.

I've done some research and found Proc S3 but that seems to do flat files, can it do parquet files? There's also CASLIB too but that looks to do temp tables (SAS tables?). I've found some info but a lot seems to be for VIYA rather than 9.4(M7) that we're running.

Thanks

[SASKiwi · Accepted solution]

Does this library article help? Accessing Azure Databricks from SAS 9.4