Azure Table Storage is a service used to store large amounts of NoSQL structured data (data modeled in structures other than tabular relational databases). Kondado's Table Storage to Data Warehouse pipeline gives you access to Table Storage data in your analytics cloud.
Adding the data source
To automate Table Storage ETL with Kondado for your database, follow the steps below:
1) To create a Table Storage access token, first navigate to the account you would like to give access to Kondado, go to “Settings” and click on “Shared access signature”
2) Leave all fields checked and click on “Generate SAS and connection string”
3) Once the token has been generated, you will see it listed
4) In the generated token identify the values of “sv=”, “si=”, “tn=” and “sig=” and copy them to a notepad
6) Name your data source and enter the information from step (4),
Now just save the data source and start integrating your Table Storage data into the Data Lake or Data Warehouse.
Pipelines
Relationship Chart
Tables and Views
- With our pipelines, you will be able to integrate tables as well as views
- If your table has a datetime/timestamp type column that marks when a record was changed/inserted, your integration can be incremental
- It will be necessary to define the primary key, which can be defined by several columns and refers to the column (or set of columns) that define a record as being unique