Skip to content

This is an end-to-end onboarding sample for SAP HANA Cloud, relational data lake. It shows how to create schema, load data, and execute queries.

License

Notifications You must be signed in to change notification settings

JCurrie27/hana-cloud-relational-data-lake-onboarding

 
 

Repository files navigation

Description

This project is for SAP HANA Cloud, data lake users who are reading the Quick Start Tutorial for Data Lake (HANA DB-Managed) [Microsoft Azure], Quick Start Tutorial for Data Lake (HANA DB-Managed) [Amazon Web Services], or Quick Start Tutorial for Data Lake on SAP Help Portal.

This project contains three sample files required by the Quick Start tutorials:

  • event_samp.CSV
  • gkg_samp.CSV
  • mentions_samp.CSV

Download these three CSV files to your local file system as described in the Download and Analyze Sample GDELT Data topic in Quick Start Tutorial for Data Lake (HANA DB-Managed) [Microsoft Azure], Quick Start Tutorial for Data Lake (HANA DB-Managed) [Amazon Web Services], or Quick Start Tutorial for Data Lake.

This project contains two code snippets containing CREATE TABLE statements:

  • Create_EVENT_GKG_MENTIONS_Tables.txt
  • Create_CAMEOCODES_Table.txt

Copy and paste these CREATE TABLE commands when instructed by the documentation.

Requirements

On the SAP Help Portal, you are currently following the Quick Start tutorials for SAP HANA Cloud, data lake. Either:

You've read the Prerequisites section on the first page of the above tutorial(s).

You've read the Tutorial Scope section on the first page of the above tutorial(s).

Download and Installation

The Download and Analyze Sample GDELT Data topic in the Quick Start Tutorials asks you to download these three CSV files:

  • event_samp.CSV
  • gkg_samp.CSV
  • mentions_samp.CSV

Download the three CSV files from this GitHub repository to your local file system, and continue reading the Quick Start tutorial.

The Create Physical and Virtual Tables topic in the Quick Start Tutorials asks you to copy and paste CREATE TABLE commands from these code snippets:

  • Create_EVENT_GKG_MENTIONS_Tables.txt
  • Create_CAMEOCODES_Table.txt

Execute the commands as instructed in the Quick Start tutorial, and continue reading the tutorial.

Known Issues

None.

How to obtain support

Are you experiencing difficulties loading sample data into SAP HANA Cloud, data lake?

License

Copyright © 2020 SAP SE or an SAP affiliate company. All rights reserved. This project is licensed under the Apache Software License, version 2.0 except as noted otherwise in the LICENSE file.

About

This is an end-to-end onboarding sample for SAP HANA Cloud, relational data lake. It shows how to create schema, load data, and execute queries.

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published