: The debut of DolphinGemma
As I mentioned in my blog last year, the SQL on Files capability in SAP HANA Cloud has unlocked new potential by providing direct read-only SQL access to files stored in SAP HANA Cloud, data lake Files since SAP HANA Cloud QRC 03/2024.
Starting with SAP HANA Cloud QRC 04/2024, this capability has been further extended to support direct access to the most common external object storages listed below, in addition to SAP HANA Cloud, data lake Files.
Amazon S3Azure Blob Storage or Azure Data Lake Storage (ADLS) Gen2Google Cloud Storage (GCS)
Although the method for creating a remote source varies by cloud service provider, the process for creating virtual tables, the supported file formats, and the read-only access remain the same as when using SQL on Files with SAP HANA Cloud, data lake Files. Since these aspects are already explained in my previous blog, let me focus on the differences in this one.
Additionally, as you may have already noticed from the above diagram, read-only access to external Delta Sharing is also supported from SAP HANA Cloud QRC 04/2024 with a dedicated Delta Sharing adapter.
And when it comes to CSV formats, two new options are now included to provide better flexibility and reduce the effort required when reading files in CSV format, starting with SAP HANA Cloud QRC 04/2024.
Another piece of good news is that the existing limitation on Delta tables, which currently supports only reader version 1 for both direct file access and Delta sharing, has been lifted starting with SAP HANA Cloud QRC 01/2025.
As I mentioned in my blog last year, the SQL on Files capability in SAP HANA Cloud has unlocked new potential by providing direct read-only SQL access to files stored in SAP HANA Cloud, data lake Files since SAP HANA Cloud QRC 03/2024.Starting with SAP HANA Cloud QRC 04/2024, this capability has been further extended to support direct access to the most common external object storages listed below, in addition to SAP HANA Cloud, data lake Files.Amazon S3Azure Blob Storage or Azure Data Lake Storage (ADLS) Gen2Google Cloud Storage (GCS)Although the method for creating a remote source varies by cloud service provider, the process for creating virtual tables, the supported file formats, and the read-only access remain the same as when using SQL on Files with SAP HANA Cloud, data lake Files. Since these aspects are already explained in my previous blog, let me focus on the differences in this one.Additionally, as you may have already noticed from the above diagram, read-only access to external Delta Sharing is also supported from SAP HANA Cloud QRC 04/2024 with a dedicated Delta Sharing adapter.And when it comes to CSV formats, two new options are now included to provide better flexibility and reduce the effort required when reading files in CSV format, starting with SAP HANA Cloud QRC 04/2024.Another piece of good news is that the existing limitation on Delta tables, which currently supports only reader version 1 for both direct file access and Delta sharing, has been lifted starting with SAP HANA Cloud QRC 01/2025. Read More Technology Blogs by SAP articles
#SAP
#SAPTechnologyblog
