Azure Table Storage Tutorial - Python Azure Tables SDK with NBA Stats API
Scenario:
The NBA playoffs start on 15 April following the conclusion of the Play-In Tournament on 14 April. In this tutorial, we use the nba_api Python API Client for NBA.com to fetch NBA teams stats and then run the Python Azure Tables SDK to create Azure table and entries. Finally, with Azure Storage Explorer we can easily build search query and visualize the results.
Objective:
To illustrate Azure Tables Python SDK usage using NBA API, followed by querying Azure Table Storage with Azure Storage Explorer's Query Builder.
Pre-requisites:
For this example, you would need:
- An Azure Table Storage
Steps:
- Install nba_api
- Install Azure Tables client library for Python
- Python code to retrieve data, create table, and insert entries
- Run nba.py
- Visualize the NBA table (with Azure Storage Explorer)
- Sample query (with Azure Storage Explorer)
[STEP 1]: Install nba_api
[STEP 2]: Install Azure Tables client library for Python
[STEP 3]: Python code to retrieve data, create table, and insert entries
Note:
- replace STORAGE_CONNECTION_STRING with your storage connection string.
- I use "state" as PartitionKey and "abbreviation" as RowKey.
- This article describes best practice when choosing partition & row key for entities.
- The response from calling teams.get_teams() is like the following:
nba.py
[STEP 4]: Run nba.py
[STEP 5]: Visualize the NBA table (with Azure Storage Explorer)
The NBA table contains data of the 30 NBA teams with the following info:
- ID
- City Name
- State Name
- Nickname
- Full Name
- Year Founded
- Abbreviation
[STEP 6]: Sample query (with Azure Storage Explorer)
Query Example: To find out all NBA teams that are based in California and were founded in 1948.
1. Click the "Query" button on the upper-left corner of the table.
2. Use Query Builder to build the query. Then click ▶ to execute.
3. Result is Lakers (LAL) & Kings (SAC).
Conclusion:
This example shows how to use the nba_api to retrieve NBA teams stats and the Azure Tables Python SDK to work with Azure Table storage. The Azure Tables client library for Python provides a simple and intuitive API for working with Azure Table Storage, with methods for creating and managing table clients, table operations, and entities.
References:
- https://pypi.org/project/nba-api/
- https://learn.microsoft.com/en-us/azure/storage/tables/table-storage-overview
- https://learn.microsoft.com/en-us/python/api/overview/azure/data-tables-readme?view=azure-python
- https://learn.microsoft.com/en-us/python/api/azure-data-tables/azure.data.tables?view=azure-python
Published on:
Learn moreRelated posts
Selecting the Optimal Container for Azure AI: Docker, ACI, or AKS?
Deploying Azure AI services in containers like Docker, Azure Container Instances (ACI), or Azure Kubernetes Service (...
Azure Elastic SAN for Azure VMware Solution: now Generally Available
Have you been looking to expand your storage on Azure VMware Solution (AVS), but do not need the extra compute performance and the associated ...
Introducing Pull Request Annotation for CodeQL and Dependency Scanning in GitHub Advanced Security for Azure DevOps
In the world of software development, security is paramount. As developers, we strive to write clean, efficient, and most importantly, secure ...
Accelerate metadata heavy workloads with Metadata Caching preview for Azure Premium Files SMB & REST
Azure Files previously announced the limited preview of Metadata caching highlighting improvements on the metadata latency (up to 55...
How to Choose the Right Models for Your Apps | Azure AI
With more than 1700 models to choose from on Azure, selecting the right one is key to enabling the right capabilities, at the right price poin...
MMR Call Redirection for Azure Virtual Desktop, Windows 365 now available
Today, I am pleased to share the launch of Multimedia Redirection (MMR) Call Redirection for Azure Virtual Desktop and Windows 365. Call Redir...
Liquid Cooling in Air Cooled Data Centers on Microsoft Azure
With the advent of artificial intelligence and machine learning (AI/ML), hyperscale datacenters are increasingly accommodating AI accelerators...
Introducing Azure Product Retirement Livestreams
The Azure Retirements team, in collaboration with key partner groups, is excited t...
Azure Developer CLI (azd) – October 2024
This post announces the October release of the Azure Developer CLI (`azd`), including configurable api-version for ACA. The post Azure Develop...