Skip to content
This repository has been archived by the owner on Oct 4, 2024. It is now read-only.

Additional issues in sample notebook mda_demos #56

Open
pgjohns opened this issue Aug 25, 2022 · 0 comments
Open

Additional issues in sample notebook mda_demos #56

pgjohns opened this issue Aug 25, 2022 · 0 comments

Comments

@pgjohns
Copy link

pgjohns commented Aug 25, 2022

I resolved the pyathena dependency mentioned in Issue #55 with the following command:
!pip install pyathena

  1. I ran into some issues in the cell following header "Get forecast from pre-calculation result, can be one or many meters"
    a. Sagemaker execution role needs permissions to start an Athena query.
    b. variable "athena-output-bucket" needs to be updated to match the output bucket in S3.
    c. in the query, the schema and table need to be updated, however I did not find a table named "forecast".

  2. The cell under the header Get Outage failed with the error below:

KeyError Traceback (most recent call last)
in
13 data = json.loads(resp)
14
---> 15 if data['Items']:
16 df = pd.DataFrame(data['Items'])
17 df_result = df[['meter_id', 'error_value', 'lat', 'long']].drop_duplicates()

KeyError: 'Items'

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant