delta_sharing_load_shared_table_to_pandas_dataframe.py

1import delta_sharing
2
3# Point to the profile file containing credentials
4# You can use a sample profile provided by the Delta Sharing project
5profile_file = "https://raw.githubusercontent.com/delta-io/delta-sharing/main/examples/open-datasets.share"
6
7# Create a SharingClient
8client = delta_sharing.SharingClient(profile_file)
9
10# List all shared tables
11print(client.list_all_tables())
12
13# Define the table URL (profile_file#share.schema.table)
14table_url = profile_file + "#delta_sharing.default.owid_covid_data"
15
16# Load the table as a pandas DataFrame
17data = delta_sharing.load_as_pandas(table_url)
18
19# Show the first few rows
20print(data.head())