Incorrect query syntax + s3 handling in SageMaker ipynb

[hack-r]

1. This code in the ipynb throws a syntax error:

query = """
DESCRIBE {}.{}
""".format(DB_NAME, TABLE_NAME)

it should be

query = """
DESCRIBE "{}"."{}"
""".format(DB_NAME, TABLE_NAME)

2. When following the instructions associated with this notebook, you correctly create a SageMaker IAM role with access to TimeStream and s3, however the bucket "ts-sagemaker" is not created in anyway that's reflected in your S3 console and the included code throws a false permission error. If you try to create a bucket with that name S3 says the bucket exists, yet S3 says you have no buckets and the ipynb code returns a permission error even with full S3 access granted to the SageMaker execution role. A solution is to create your own bucket manually (e.g. "ts-sagemaker-1") and update the ipynb accordingly.

[forestmvey]

@hack-r

Thanks for posting the issue. I was unable to re-create your syntax error. Testing with Anaconda locally and with an S3 bucket I could successfully execute this query in Timestream_SageMaker_Demo notebook.ipynb. You are correct about the missing step for S3 bucket creation. I will try to get the documentation updated. If you have anymore information on why your query throws a Syntax error I can try to re-create, otherwise I think this issue should be closed.

[hack-r]

OK, thanks. That was like 2 years ago, so if you need me to reproduce then I will need a day or 2.

[forestmvey]

That would be much appreciated.