Hi All ,
I am sharing my new knowledge on Data Lake - exploring all the way how we can interact with data lake directly.
Pre-requisites: https://developers.sap.com/tutorials/hana-cloud-dl-clients-overview.html Create your own data lake instance under managed or stand alone both are fine.
Here is my DL Instance up and running.
Install SAP IQ Client - Make sure you pick the latest version from SAP Software downloads.
Also you can follow the above tutorials for understanding data lake & SAP HANA Cloud instance. Data lake is one of the best way to store different kind of data from different source at one place and importantly at a very low-cost.
there are already few posts which can let you start easily on this topic , I am sharing my own learning So here we go .
Install PYODBC
Import Packages and provide connection details.
import pyodbc cnxn = pyodbc.connect('DSN=HDLSA;UID=HDLADMIN;PWD=abc1234@123A')
Open cursor and execute some select statements.
cur = cnxn.cursor() cur.execute('SELECT * FROM HOTEL.HOTEL')
Hotel Table under HOTEL Schema is already created , follow data lake tutorials.
Fetch Data
rows = cur.fetchall() rows
Print Records.
So here comes to and end of connecting data lake from Python , In next part , we will be uploading the data from CSV to Data Lake.
Keep learning Keep querying 🙂
Thanks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
38 | |
19 | |
13 | |
13 | |
11 | |
10 | |
10 | |
10 | |
8 | |
8 |