🔀 Create datasource for ms fabric s3 shortcut

bagg3rs commented 5 months ago

User Story

PoC for microsoft fabric shortcut to S3/Athena in sandbox

Value / Purpose

Verify if this could allow data on AP which has been cleared for use on fabric could visualised in PowerBI

Useful Contacts

Rich B

Proposal

Create a test bucket with some public test data e.g. csv
Create some test credentials as described here with IAM Permissions here S3:GetObject S3:GetBucketLocation S3:ListBucket

Definition of Done

[x] Create Bucket (created in sandbox) microsoft-fabric-shortcut-test
[x] Create Bucket Policy microsoft-fabric-shortcut-test
[x] Create IAM user and credentials microsoft-fabric-shortcut-test
[x] S3 shortcut tested successfully
[x] Bucket and permissions cleaned up

github-actions[bot] commented 3 months ago

This issue is being marked as stale because it has been open for 60 days with no activity. Remove stale label or comment to keep the issue open.

github-actions[bot] commented 2 months ago

This issue is being closed because it has been open for a further 7 days with no activity. If this is still a valid issue, please reopen it, Thank you!

bagg3rs commented 2 months ago

Sent over details to Shivani

bagg3rs commented 1 month ago

Testing complete, bucket accessed This is a 'preview' so

Only supports long lived credentials
No Athena Need to clean up resources then close

ministryofjustice / analytical-platform