Publish Microstrategy MTDI Super Cube from S3 Parquet file - mstrio Python API
We need a Python IDE to run this. Currently, some of the Python packages (ex: boto3) are not supported in Microstrategy workstation scripts. So, we can't run this in Microstrategy workstation scripts. Logic: Install necessary python packages Import packages (boto3, mstrio, pandas) Establish connection to S3 bucket and read the parquet file Establish connection to Microstrategy Rest server (Library) Create cube We can achieve the same using MSTR Data Import UI. But, in order to connect it to S3 Bucket in MSTR UI, you need "list all buckets" access. In API, we can specify the particular bucket name and parquet file to create this cube. Sample Script: # Install boto3 and mstrio packages. boto3 package is to read files from S3 bucket. mstrio package to connect and create objects in Microstrategy #pip install boto3 #pip install mstrio #Import necessary packages from mstrio.connection import Connection from mstrio.project_objects.datasets.super_cube import SuperCube, list_s...